Upgrading Oracle Database from 10.2.0.1.0 to 10.2.0.5.0 on Windows Server (32- bit)

Hi, 

I've upgraded the Database 10.2.0.1.0 to 10.2.0.5.0.Below are the steps with screenshots for our reference.I have downloaded the PATCH SET 10.2.0.5.0 and applying it to my current Database release 10.2.0.1.0. 

Step 1: I’m doing this upgrade by Checking the version initially (10.2.0.1.0). Steps are shown below:

Start --> run-->cmd

• set ORACLE_SID=orcl
• set ORACLE_HOME=E:\oracle\product\10.2.0\db_1
• sqlplus "/as sysdba"

SQL>select name from v$database; 

SQL>select *from v$version; 

=>Database version is 10.2.0.1.0 as seen in below screenshot.

Step 2: Login to your MY ORACLE SUPPORT account =>Click on PATCHES & UPDATES for downloading your patch for Windows 32-bit Operating system(Refer the below screenshot) In PATCHES & UPDATES =>enter patch number 8202632 

                                         

                                        

Step 3: Move the downloaded patch to a directory, But for my reference I copied here "D:\Software\p8202632_10205_WINNT".

Step 4: Shutdown the oracle Database. Click on the Read Me tab and save the Read me file so that you can refer this later while doing patch installation.When you are doing this upgrade fro RAC Database the steps may vary which is given in this Read me file. Refer the below screenshot.

Step 5: Stop all the Orcale services now My service name is ORCL. So I will be stopping the services as given below: 

• E:\oracle\product\10.2.0\db_1\BIN>net stop OracleDBConsoleorcl 

             The OracleDBConsoleorcl service is stopping........ 

             The OracleDBConsoleorcl service was stopped successfully.

• E:\oracle\product\10.2.0\db_1\BIN>net stop OracleServiceORCL

            The OracleServiceORCL service is stopping.

            The OracleServiceORCL service was stopped successfully.

• E:\oracle\product\10.2.0\db_1\BIN>lsnrctl stop

Refer the below screenshot:

Step 6: Backup your database. As a precaution or Primary responsibility of DBA and also Oracle recommends that you create a backup of the Oracle 10g installation before you install the patch set. 

Step 7: Check Tablespace Sizes and Set Parameter Values if require Review the following sections before upgrading a database. 

Step 8: Now Launch your setup by going to the path where this patch is copied cd "D:\Software\p8202632_10205_WINNT"

d: D:\Software\p8202632_10205_WINNT>setup.exe

Specify the location of your Oracle home by Browse: E:\oracle\product\10.2.0\db_1 and click install.

Below are the screenshots for reference:

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

Start all services Go to Control panel=>Administrative tools =>Services=>Start all oracle services as given below or In Start=>run=>services.msc 

Refer the below screenshot:

Step 10: To Upgrade your dictionary follow the below steps:

Start --> run-->cmd

• set ORACLE_SID=orcl
• set ORACLE_HOME=E:\oracle\product\10.2.0\db_1

cd $ORACLE_HOME/rdbms/admin

sqlplus "/as sysdba"

SQL>startup upgrade;

SQL>@catupgrd.sql

SQL>shutdown immediate;

SQL>startup;

SQL>@utlrp.sql

This script provides a direct upgrade path from these releases to the new Oracle release. 

Note 1: For running catupgrd.sql you have to start your Database by using STARTUP UPGRDADE command.

Note 2: Catupgrd.sql script should be run by going into the above path of ORACLE_HOME/rdbms/admin Once this script is executed successfully you will see the screen as given below

Step 11: Bounce(restart) your Database for changes to take effect: 

 SQL> SHUTDOWN

 SQL> STARTUP 

Step 12: Now check the Oracle Version

 SQL> select * from v$version; 

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Prod

PL/SQL Release 10.2.0.5.0 - Production

CORE    10.2.0.5.0      Production

TNS for 32-bit Windows: Version 10.2.0.5.0 - Production

NLSRTL Version 10.2.0.5.0 - Production

                       

We are done with the upgradation!!!!

 Hope it helps . 

 Best Regards,

 Madhusudan Reddy K