on 09-02-2010 12:08 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.