Oracle upgrade from 10.2.0.2.0 to 10.2.0.4

[former_member363995]

Dear Gurus,

I need to upgrade oracle from 10.2.0.2.0 to 10.2.0.4.

System Details : Win NT/64bit/Oracle 10.2.0.2.0

Please let me know which are the steps to be followed. It would be great if you can provide some pdfs or link to SMP.

Regards

Paul

[Former Member]

Hi,

You can install the Oracle patch 10.2.0.4.0 just by executing the setup.exe available in the path ..\WINDOWS_X86_64\..\Disk1\.

After installing the patch 10.2.0.4.0, proceed as follows.

Enter the following SQL*Plus commands:

SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\catupgrd.sql
SQL> SPOOL OFF
Review the patch.log file for errors and inspect the list of components that is displayed at the end of catupgrd.sql script.

This list provides the version and status of each SERVER component in the database.

If necessary, rerun the catupgrd.sql script after correcting any problems.

Restart the database:

SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP

Hope this helps.

Regards,

Varadharajan M

[Former Member]

Hi ,

Kindly check the below for Oracle patch 10.2.0.2 to 10.2.0.4.

[;

let me know any issues.

Regards

[Former Member]

Hi,

First Go throught SAP Note 871735.

Then Apply Oracle 10.2.0.4 patch to your existing Oracle 10.2.0.2.0 using runInstaller.

After applying patch, you have to carry on dbua to upgrade database to 10.2.0.4.

Best Regards,

Sriram.S

[Former Member]

You get the upgrade guides from below link

http://service.sap.com/instguides --> oracle

Regards,

Mahendra