on 04-24-2009 10:31 AM
Hi!
I am about to copy a SAP ERP system on Windows and ORA.
The original Oracle version from SAP CD is 10.2.0.2
A) As I know this version should be updated to the version 10.2.0.4
B) After this the Interim patches should be applied.
Question:
Where can I find the appropriate documentation how to apply the both steps described above (A and B)?
Which Interim pathes do I need to apply?
Thank you very much!
regards
Edited by: Jgen Pfeiffer on Apr 24, 2009 11:31 AM
Hi
Note 839187 - Oracle 10.2.0: Applying patch set/patches/patch collection
Regards
Uday
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The interim patches downloaded from service.sap.com are cumulative in Windows (patchset), not in Unix.
For the upgrade instructions from 10.2.0.2 to 10.2.0.4 the package you download from service.sap.com/swdc after it is uncompressed, there is a readme file that you need to follow to do the upgrade.
you need to install patch 10.2.0.4
then, upgrade opatch.
then, upgrade to mini patch 8 or above,
here's my personal doc to upgrade:
disable antivirus
stop SAP
sqlplus /@%ORACLE_SID% as sysdba
shutdown immediate;
exit;
net stop "Distributed Transaction Coordinator"
net stop Oracleservice%ORACLE_SID%
net stop Oracle%ORACLE_SID%102TNSLISTENER
E:\10204_64\Patchset_10204_win64\Disk1\setup.exe
e:
cd E:\10204_64\opatch
d:
cd D:\oracle\%ORACLE_SID%\102\opatch
xcopy e: . /s/e/v/y
d:
cd D:\oracle\%ORACLE_SID%\102\opatch
e:
cd E:\10204_64\10204_64_p8\7313130
d:opatch apply
copy D:\oracle\%ORACLE_SID%\102\network\admin\tnsnames.ora tnsnames.ora.orig
net start Oracle%ORACLE_SID%102TNSLISTENER
D:\oracle\%ORACLE_SID%\102\BIN\launch.exe d:\oracle\%ORACLE_SID%\102\assistants\dbua dbua.cl
notepad D:\oracle\%ORACLE_SID%\102\network\admin\tnsnames.ora
sqlplus /@%ORACLE_SID% as sysdba
shutdown immediate;
exit;
ren D:\oracle\%ORACLE_SID%\102\database\SPFILE%ORACLE_SID%.ORA SPFILE%ORACLE_SID%.ORA.10204
notepad %ORACLE_HOME%\database\init%ORACLE_SID%.ora
adapt as per SAP note 830576
net start service Oracle%ORACLE_SID%102TNSLISTENER
d:
cd %ORACLE_HOME%\BUNDLE\Patch8
sqlplus /nolog
CONNECT / AS SYSDBA
startup
@catcpu.sql
exit;
cd %ORACLE_HOME%\rdbms\admin
sqlplus /nolog
CONNECT / AS SYSDBA
@utlprp.sql 0
SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS = 'INVALID';
exit;
Start SAP
sqlplus / as sysdba
exec dbms_scheduler.disable('ORACLE_OCM.MGMT_CONFIG_JOB');
exec dbms_scheduler.disable('ORACLE_OCM.MGMT_STATS_CONFIG_JOB');
@?/rdbms/admin/prvtbpw.plb
@?/rdbms/admin/catdph.sql
@?/rdbms/admin/catdpb.sql
@?/rdbms/admin/prvtstat.plb
exit
d:
cd %ORACLE_HOME%
rename .patch_storage .patch_storage.10202.SV
mkdir .patch_storage
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Check this [Link|http://sappandit.wordpress.com/category/oracle-upgrade-10202-to-10204oem/]
btw what is your OS
Regards
Uday
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.