install the oracle patch with OPatch

[Former Member]

Hi:

the error "ORA 3106" happened when the BW system was drawing out the

data from the CRM system . I found the note "1005758 - ORA 3106 in

Oracle 10.2.0.2",so I downloaded the oracle patch p5092134 and p6646850. I upgraded the opatch version to 10.2.0.2.5 and executed the

command "opatch apply " in the patch "6646850" folder, but the process

stopped at the phase "Backing up files affected by the patch '6646850'

for rollback. This might take a while...", why?

[Former Member]

HI:

There is the same problem where I was installing another oracle patch with the opatch. The log and my steps is :

1. su - orasm0

epdev:orasm0 1> pwd

/data/oracle/SM0

epdev:orasm0 2> cd /oracle

epdev:orasm0 3> cd SM0

epdev:orasm0 4> cd 1*

epdev:orasm0 5> cd 5099990

epdev:orasm0 6> ls

README.txt etc files

epdev:orasm0 7> /oracle/SM0/102_64/OPatch/opatch apply

Invoking OPatch 10.2.0.2.0

Oracle interim Patch Installer version 10.2.0.2.0

Copyright (c) 2005, Oracle Corporation. All rights reserved..

Oracle Home : /oracle/SM0/102_64

Central Inventory : /oracle/oraInventory

from : /oracle/SM0/102_64/oraInst.loc

OPatch version : 10.2.0.2.0

OUI version : 10.2.0.2.0

OUI location : /oracle/SM0/102_64/oui

Log file location : /oracle/SM0/102_64/cfgtoollogs/opatch/opatch-00_Jun_24_14-10

-33-GMT+08_Tue.log

ApplySession applying interim patch '5099990' to OH '/oracle/SM0/102_64'

Invoking fuser to check for active processes.

Invoking fuser on "/oracle/SM0/102_64/bin/oracle"

OPatch detected non-cluster Oracle Home from the inventory and will patch the lo

cal system only.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local sy

stem.

(Oracle Home = '/oracle/SM0/102_64')

Is the local system ready for patching?

Do you want to proceed? [y|n]

y

User Responded with: Y

Backing up files and inventory (not for auto-rollback) for the Oracle Home

Backing up files affected by the patch '5099990' for restore. This might take a

while...

Backing up files affected by the patch '5099990' for rollback. This might take a

while...

[Former Member]

i got the exactly same issue with you beside that i got the issue on Ecc5 instead of BW system.

I resolved the issue by the command below gave by OSS msg.

opatch apply -jdk <java path> <patchID> -verbose

try the command above and see if it solve ur problem, it worked perfectly for me

[Former Member]

Hi:

I had done with what you said,but .............,the log displayed:

epdev:orasm0 12> cd 6646850

epdev:orasm0 13> pwd

/data/oracle/SM0/102_64/6646850

epdev:orasm0 14> ls

README.html README.txt custom etc files patchmd.xml

epdev:orasm0 15> opatch apply

opatch: Command not found.

epdev:orasm0 16> ../OPatch/opatch apply

Invoking OPatch 10.2.0.2.5

Oracle Interim Patch Installer version 10.2.0.2.5

Copyright (c) 2007, Oracle Corporation. All rights reserved.

Oracle Home : /oracle/SM0/102_64

Central Inventory : /oracle/oraInventory

from : /etc/oraInst.loc

OPatch version : 10.2.0.2.5

OUI version : 10.2.0.2.0

OUI location : /oracle/SM0/102_64/oui

Log file location : /oracle/SM0/102_64/cfgtoollogs/opatch/opatch2008-06-17_16-05

ApplySession applying interim patch '6646850' to OH '/oracle/SM0/102_64'

Running prerequisite checks...

Patch 6646850: Optional component(s) missing : [ oracle.sdo.companion, 10.2.0.2.on, 10.2.0.2.0 ] , [ oracle.isearch.server, 10.2.0.2.0 ]

OPatch detected non-cluster Oracle Home from the inventory and will patch the lo

Please shutdown Oracle instances running out of this ORACLE_HOME on the local sy

(Oracle Home = '/oracle/SM0/102_64')

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files and inventory (not for auto-rollback) for the Oracle Home

Backing up files affected by the patch '6646850' for restore. This might take a while...

The Oracle Configuration Manager is already installed. OPatch does nothing.

Do you wish to configure OCM at this time? (y/n)

n

User Responded with: N

Returning to CPU apply.

Backing up files affected by the patch '6646850' for rollback. This might take a while...

^CKilled

epdev:orasm0 17> pwd

/data/oracle/SM0/102_64/6646850

epdev:orasm0 18> ../OPatch/opatch apply

Invoking OPatch 10.2.0.2.5

Oracle Interim Patch Installer version 10.2.0.2.5

Copyright (c) 2007, Oracle Corporation. All rights reserved.

Oracle Home : /oracle/SM0/102_64

Central Inventory : /oracle/oraInventory

from : /etc/oraInst.loc

OPatch version : 10.2.0.2.5

OUI version : 10.2.0.2.0

OUI location : /oracle/SM0/102_64/oui

Log file location : /oracle/SM0/102_64/cfgtoollogs/opatch/opatch2008-06-17_16-16-01PM.log

ApplySession applying interim patch '6646850' to OH '/oracle/SM0/102_64'

Running prerequisite checks...

Patch 6646850: Optional component(s) missing : [ oracle.sdo.companion, 10.2.0.2.0 ] , [ oracle.isearch.client, 10.2.0.2.0 ] , [ oracle.isearch.is_common, 10.2.0.2.0 ] , [ oracle.isearch.server, 10.2.0.2.0 ]

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/oracle/SM0/102_64')

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files and inventory (not for auto-rollback) for the Oracle Home

Backing up files affected by the patch '6646850' for restore. This might take a while...

The Oracle Configuration Manager is already installed. OPatch does nothing.

Do you wish to configure OCM at this time? (y/n)

n

User Responded with: N

Returning to CPU apply.

Backing up files affected by the patch '6646850' for rollback. This might take a while...

/oracle/SM0/102_64/jdk/bin/java[3]: 8941768 Killed

OPatch failed with error code 137

epdev:orasm0 19> epdev:orasm0 19> epdev:orasm0 19>

epdev:orasm0 19>

epdev:orasm0 19> ../OPatch/opatch apply -force -silent

Invoking OPatch 10.2.0.2.5

Oracle Interim Patch Installer version 10.2.0.2.5

Copyright (c) 2007, Oracle Corporation. All rights reserved.

Oracle Home : /oracle/SM0/102_64

Central Inventory : /oracle/oraInventory

from : /etc/oraInst.loc

OPatch version : 10.2.0.2.5

OUI version : 10.2.0.2.0

OUI location : /oracle/SM0/102_64/oui

Log file location : /oracle/SM0/102_64/cfgtoollogs/opatch/opatch2008-06-17_16-25

-39PM.log

ApplySession applying interim patch '6646850' to OH '/oracle/SM0/102_64'

Running prerequisite checks...

Patch 6646850: Optional component(s) missing : [ oracle.sdo.companion, 10.2.0.2.

0 ] , [ oracle.isearch.client, 10.2.0.2.0 ] , [ oracle.isearch.is_common, 10.2.0

.2.0 ] , [ oracle.isearch.server, 10.2.0.2.0 ]

OPatch detected non-cluster Oracle Home from the inventory and will patch the lo

cal system only.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local sy

stem.

(Oracle Home = '/oracle/SM0/102_64')

Is the local system ready for patching? [y|n]

Y (auto-answered by -silent)

User Responded with: Y

Backing up files and inventory (not for auto-rollback) for the Oracle Home

Backing up files affected by the patch '6646850' for restore. This might take a

The Oracle Configuration Manager is already installed. OPatch does nothing.

*****************************************************************

The Oracle Configuration Manager has been installed as part of

the CPU installation. Prior to contacting Oracle Support, please

refer to http://www.oracle.com/technology/documentation/ocm.html

for answers to your questions.

Please complete the configuration of the Software by

invoking the command:

/oracle/SM0/102_64/ccr/bin/setupCCR

*****************************************************************

Backing up files affected by the patch '6646850' for rollback. This might take a

[markus_doehr2]

Are you trying to install a CPU patch? You know about the implications?

Markus

[Former Member]

Hello YuanChong,

To apply this patch, you must shutdown all instances and listeners associated to the ORACLE_HOME being updated.

Set your current directory to the directory where the patch is located and then run OPatch

So, you past where you want the patch, just run $ORACLE_HOME/opatch/opatch apply when you're into this directory.

I strongly advise you to read the doc which provide with the patch.

Regards,

Pratap

[Former Member]

Hi:

after I had stopped the opatch process, I deleted the directory "lock" in the inventory directory and the directory ".patch_storage".

When I restarted the opatch there was the same problem.

[Former Member]

Hi:

I tried again and there is a same problem and I saw the notes and have no help.

[markus_doehr2]

There´s a brand new note:

1178339 - Universal Installer / OPatch tools are Hanging and / or Fail

Is that relevant for you?

Markus

[Former Member]

Hi:

I shutdwn the instance and can you tell me what the developer tools is and how to install?

sap envirmenrt: AIX 5.3 + ORACLE 10.2.0.2.0.

[Former Member]

Hi,

check SAP Note 839182 - Oracle database 10g: OPatch

regards,

kaushal

[markus_doehr2]

I think the system was waiting for the Oracle process to be stopped.

Try to apply the patch again.

Markus

[markus_doehr2]

Did you shut down the instance? What platform are you on? Did you install the developer tools for your platform?

Markus