Oracle Patch Mopatch and Optach (Bundle Patch)

[Former Member]

Dear Experts.

Cuuld you please help me know as what Mopatch and Opatch is used. in my SAP system oracle patch is 10.2.0.4 i have to apply 10.2.0.5. I can see MOPATCHP and OPATCHP in os independent section and under -- Linux on X86_64 64bit i see SAP Bundle Patch 10.2.0.5.12 the latest one - I want to apply  oracle 10.2.0.5 patch please let me know the relevent patch to be download and procedure to apply the patch.

Thanks in advance.

Regards

Hakeem Khan 

[janos_mucsi-besze]

Hi.

Just follow the README of the Bundle Patch and so the required Opatch and Mopatch tools gets uncompressed.

The required steps are documented under point "2.1 Executing Pre-Installation Instructions":

-----

Extract OPatch and MOPatch and install them in the Oracle Home:

unzip -qd $ORACLE_HOME/sapbundle SAP10205P_1308-10010771.ZIP 'SBP_1020512_201308/OPatch/*'

mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch-pre-SBP_1020512_201308

mv $ORACLE_HOME/sapbundle/SBP_1020512_201308/OPatch $ORACLE_HOME/OPatch

unzip -qd $ORACLE_HOME/sapbundle SAP10205P_1308-10010771.ZIP 'SBP_1020512_201308/MOPatch/*'

test -d $ORACLE_HOME/MOPatch && mv $ORACLE_HOME/MOPatch $ORACLE_HOME/MOPatch-pre-SBP_1020512_201308

mv $ORACLE_HOME/sapbundle/SBP_1020512_201308/MOPatch $ORACLE_HOME/MOPatch

-----

Regards,

János

[Reagan]

Use the MOPatch and OPatch that comes with the bundle patch (SBP).

Regards

RB

[Former Member]

In addition to other techies comments:

Why don't you plan for Database upgrade from 10G to 11gR2 as it takes same time (even faster than normal patching 10.2.0.4>10.2.0.5). Oracle 10G is out of support!

Regards,

Nick Loy

[Former Member]

Dear ALL.

Thanks for your valuable responses. Nick i thought as my DB size nearly 2 TB approx. Upgrading DB from 10g to 11g would be time consuming so i didnt go for DB upgrade, can i get the proper doc or link for the same except the upgrade doc available in SMP, i mean any other more easier document.

Please help and i request if you could add some more light on patching & upgradation.

Thanks & Regards

Mohd

[former_member188883]

Hi Mohd,

Database size may not have huge impact your runtime for Oracle upgrade.

As mentioned in above responses preferred would be to upgrade to 11g to have full stream support from SAP.

Best and recommended method to perform Oracle upgrade would be to follow guide available on SMP.

Else you may perform google to get some blogs related to such upgrades.

Example : Upgrade 10g -> 11g http://samadhandba.wordpress.com/2011/02/24/step-by-step-upgrading-oracle-10g-to-oracle-11g/

Regards,

Deepak Kori

[Former Member]

Size od tablespaces with application data has no influence on Oracle upgrade runtime.

Difference between sources and target Oracle version has, so i.e. upgrade from Oracle 9i to Oracle 11g runs longer than upgrade from Oracle 10g to 11g.

[Former Member]

may he's still running SAP R/3 4.6C or older on that DB?

[former_member186228]

Dear Mohd,

MOPatch is a tool to apply oracle patches, Using this tool we can install multiple oracle patches at single run. It will automate the oracle patching process.

OPatch is tools Comes with oracle, which is used to install patches.

Regards.

Jithin M

[former_member188883]

Hi Mohd,

Please download the 10.2.0.5 patch DVD from the link

Oracle" Database" ORACLE 64-BIT" ORACLE 10.2 64-BIT

Relevant DVD #

ZIP

51041676_2

ORACLE RDBMS Patch 10.2.0.5 Linux on x86_64 64bit

Then download the SBP from the link below

Oracle" Database Patches" ORACLE PATCHES" ORACLE PATCHES 10.2.0.5

From OS Independent download latest OPatch and MOPatch.

For updating from 10.2.0.4 -> 10.2.0.5 please refer to Oracle database upgrade guide available on SAP service marketplace for the relevant steps..

Hope this helps.

Regards,

Deepak Kori