Oracle Update from 10.2.0.2 to 10.2.0.4

[Former Member]

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

[Former Member · Accepted solution]

Hi

Note 839187 - Oracle 10.2.0: Applying patch set/patches/patch collection

Regards

Uday

[Former Member · Accepted solution]

Hi!

Many thanks!

Which Interim patch version do I need? Are these kumulative or should I install each of them?

Thank's!

[Former Member · Accepted solution]

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.

[debasissahoo · Accepted solution]

Hello Jgen,

The latest patch for 10.2.0.4 is 11. try to find out all the necessary information from

service.sap.com/notes

Notes will give you all details and prerequisites that you have to take care of.

Regards, Debasis.

[Former Member · Accepted solution]

Hi!

Many thanks!

What is the approach for applying of Opatch?

(e.g. central SAP Note, or SAP documentation)

Is a installed PERL a required prerequisite for applying the Opatch for Oracle?

Which other prerequisites should be met for Opatch?

Thank you very much!

regards

Jürgen

[debasissahoo · Accepted solution]

Hi,

OPatch version 10.2.0.2.2 is Java based and does not require the use of Perl or for Perl to be installed.

Go thorough the readme.html file that comes along with the database patch. it will give you all the details.

Regards,

Debasis.

[former_member204746]

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

[Former Member]

Hi

Adding more you can also check this [Link|;

Regards

Uday

[Former Member]

Hi

Check this [Link|http://sappandit.wordpress.com/category/oracle-upgrade-10202-to-10204oem/]

btw what is your OS

Regards

Uday