APPSINFODB – Information Technology Group

Finding Solutions for DBA's to smile…….!!!!!!! DBA its just not Administration, its core of customer’s data integrity

  • Blog Stats

    • 34,994 hits
  • Visitors

    free counters
  • Vistors Access

  • Calendar

    March 2009
    M T W T F S S
    « Feb   Apr »
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  
  • Archives

  • Authors

Oracle Upgrade 9.2.0.6 to 10.2.0.4

Posted by appsinfo on March 3, 2009

Install Oracle 10g Database (10.2.0.2)

 

  1. Log on as a member of the Administrators group to the computer on which you are going to install Oracle 10g Software. 
  2. Start Oracle Universal Installer located in the unzipped area of the patch set. For example, Oracle_patch\setup.exe. 
  3. On the Welcome screen, click Next. 
  4. Select the Installation Method as Advance Installation and click next. 
  5. Here you need to select the Installation Type, select Enterprise Edition. 
  6. In the Specify Home Details Screen, select the name of the Oracle home that you want to update, or select the Path that you want to update from the list, then click Next. 
  7. The installer will perform Product-Specific Prerequisite Check, if every thing succeeded, Click Next. 
  8. On this screen you will be asked whether you need to perform Upgrade to an Existing Database, select No. 
  9. Select the Configuration Option as Install database Software only. 
  10. On the Summary screen, click Install

 Installing the Oracle Database 10g Patch Set (10.2.0.4) Interactively

 

To install the Oracle Database 10g patch set interactively:

 

  1. Log on as a member of the Administrators group to the computer on which you are going to install Oracle components. If you are installing on a Primary Domain Controller or a Backup Domain Controller, log on as a member of the Domain Administrators group. 
  2. Start Oracle Universal Installer located in the unzipped area of the patch set. For example, Oracle_patch\setup.exe. 
  3. On the Welcome screen, click Next. 
  4. In the Specify Home Details Screen, select the name of the Oracle home that you want to update, or select the Path that you want to update from the list, then click Next. 
  5. If you are installing the patch set on an Oracle RAC cluster, click Next when the Selected Nodes screen appears. 
  6. On the Summary screen, click Install.

  When the installation is complete, the End of Installation screen appears

 

  1. On the End of Installation screen, click Exit, then click Yes to exit from Oracle Universal Installer.

 Upgrading a Release 10.2 Database using Oracle Database Upgrade Assistant

 

After you install the patch set, you must perform the following steps on every database associated with the upgraded Oracle home:

 

1.      Log in with administrator privileges.

2.      Set the values for the environment variables ORACLE_HOME, ORACLE_SID, and PATH.

3.      For single-instance installations, if you are using Automatic Storage Management, start the Automatic Storage Management instance.

4.      For Oracle single-instance installations, start the listener as follows:

                  C:\> lsnrctl start

 

5.      Run Oracle Database Upgrade Assistant either in the interactive or noninteractive mode, in this post we will see interactive mode.

 

Interactive mode:

 

Start the Oracle Database Upgrade Assistant:

From the Start menu, select Programs, then Oracle – HOME_NAME, then Configuration and Migration Tools and then Database Upgrade Assistant to start the Oracle Database Upgrade Assistant.

Complete the following steps displayed in the Oracle Database Upgrade Assistant screen:

 

1.      On the Welcome screen, click Next.

2.      On the Databases Screen, select the name of the Oracle database that you want to  update, then click Next.

3.      On the Recompile invalid objects screen, select the Recompile the invalid objects at the end of upgrade option, then click Next.

4.      If you have not taken the back up of the database earlier, on the Backup screen, select the I would like to take this tool to backup the database option, mention the Path, then click Next.

5.      On the Summary screen, check the summary, then click Finish.

6.      On the End of upgradation screen, click Exit, then click Yes to exit from Oracle Database Upgrade Assistant.

One Response to “Oracle Upgrade 9.2.0.6 to 10.2.0.4”

  1. Everything is very open with a precise clarification of the challenges.
    It was definitely informative. Your site is useful.
    Thank you for sharing!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: