Steps to upgrade Oracle 10.2.0.1 to Oracle 10.2.0.2

[Former Member]

Hi Gurus,

I am confused and need help on the above. I am currently on ECC6 with Oracle 10.2.0.1 on Linux. I want to upgrade to Oracle 10.2.0.2.

This is what I plan to do.Please let me know if the below steps are incorrect :

1) Download patch set Oracle 10.2.0.2 and install using OUI 10.2.0.2. My current OUI is on Oracle 10.2.0.1.

Patch set downloaded from SAP Note 871735.

2) Install Oracle 10.2.0.2 patch using Opatch. Patch based on SAP Note 871096.

Appreciate your advice. Thanks in advance.

Thanks,

IA

[Former Member]

Hi ,

Before Oracle patch upgarde , u have to check below steps ,

#su - orasid

orasid 1> cd /oracle/SID/102_64/OPatch

orasid 2> pwd

/oracle/SID/102_64/OPatch

orasid 3> ./opatch lsinventory or ./opatch lsinventory -detail

let me know the output of above command

Regards

[Former Member]

Hi ,

pls check below activity prior oracle patch upgrade .

#su - sidadm

[YOU HAVE NEW MAIL]

sidadm 1> echo $ORACLE_HOME

/oracle/SID/102_64

SAPDEVQA:sidadm 2> echo $ORACLE_BASE

/oracle

SAPDEVQA:sidadm 3> echo $ORACLE_SID

IRD

SAPDEVQA:sidadm 4> echo $TNS_ADMIN

/usr/sap/IRD/SYS/profile/oracle

so u can conform u have properly set the environment variable .

Regards

[Former Member]

Hi ,

Before Upgrade u have check the enough Space in the following dirctory .

Space Requirement:

/oracle

/oracle/SID/102_64

/tmp .

=====

Installation steps :

su u2013 orasid

Sqlplus

/ as sysdba

Shutdown immediate;

lsnrctl stop

./runInstaller

execute Configuration scripts in root user (root.sh)

script location --> /oracle/SID/102_64/root.sh

To execute the configuration scripts :

1 ,open a terminal window

2 ,log in as root

3 ,Run the scripts

4, Return to this window and click OK to continue.

Post Installation :

su - orasid

sql>startup upgrade;

sql>@/rdbms/admin/utlu102i.sql

sql>shutdown immediate;

sql>startup

sql>@?/rdbms/admin/utlrp.sql

lsnrctl start

then start all the SAP Application

Regards

[Former Member]

Hi All,

Thanks for your feedback. I have managed to patch it to 10.2.0.2

Thanks,

IA

[Former Member]

Hi ,

Instead of upgrade Oracle 10.2.0.1 --> 10.2.0.2 , you can upgrade 10.2.0.4 .

pls read the readme txt file for 10.2.0.4 and before oracle patch upgrade u have to full backup or OraInventory and set xclock and then continue Oracle pacth upgrade .

Regards

[Former Member]

Hi intanazir

Nice to see that you already know the way to go.

Awsome. Go ahead and let us know if you face any issue.

Best of Luck

Cheers!!!

ElNino

[Former Member]

Hi,

Install Oracle 10.2.0.2 patch using Opatch. Patch based on SAP Note 871096.

You can install the patch 10.2.0.2.0 but executing the RUNINSTALLER.

It is better to go with 10.2.0.4.0 instaed of 10.2.0.2.0

Regards,

Varadharajan M