Oracle patch upgrade from 10.2.0.4 to 10.2.0.5 in SAP

[Former Member]

Hi,

We have to perform patch upgrade from 10.2.0.4 to 10.2.0.5 on the following SAP servers:

ECC 6.0 on Unix

PI 7.0 on Unix

I have obtained the downloads from service market place. Can some one provide the pre-requisites before this patch application. It wouldbe helpful if any one has got the step-by-step documentation created for the same.

BB

[Former Member · Accepted solution]

Hi Bijoy,

there are no of steps are there i mentioning here some them: -

Before Start - Make Sure

1) Current Release Screenshot have been taken

2) Backup of /oracle/<SID>/102_64 have taken

3) Backup of init<SID>.ora & listner.ora have taken

4) Online Consistent Backup of whole database has complete.

5) All the supported files are copied on their position.

6) Take a backup of the catrelod.sql file and admin folder in 10.2.0.5 Oracle home directory:

7) take a space for oracle home of 5 gb for 10.2 ( not recommended, its depend on you)

$ ORACLE_HOME/rdbms/admin/catrelod.sql

$ ORACLE_HOME/network/admin

and some more: -

Set the ORACLE_HOME and ORACLE_SID Environment Variables

% setenv ORACLE_HOME Oracle_home (your oracle home)

% setenv ORACLE_SID <SID>

% setenv PATH $ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH

hope this will help you....

Regds

Abhijeet

[Former Member · Accepted solution]

Hello Abhijeet,

Thanks for your reply.This will help in building a plan for the upgrade.

BIJOY

[Former Member · Accepted solution]

Welcome bijoy and we will be happy if u confirm us that u did the upgradtion or any help needed then tell us.

[janos_mucsi-besze]

Dear Bijoy,

All steps and prerequisites are mentioned in the corresponding README file, which can be located on marketplace in the same folder where you found the patch.

Upgrading the Database to 11.2 is strongly recommended as 10.2 is out os support now.

Regards,

János

[Former Member]

Hi Biyoj,

You can find the detailed information on the readme file, in the patch.

I strongly recommend that you upgrade to Oracle 11G instead of 10.2.0.5, because of it is in the extended maintenance.

Note 1654734 - Ext Support contract required for 10.2.0.5 PSU, SBP & Client

Best regards,

Orkun Gedik