Opatch apply on Windows 2003 server on oralce 10.2.0.4

[former_member285859]

Dear All,

We are trying to apply Opatch SAP Note :- 1165319 Optimizer merge fix for Oracle 10.2.0.4.

I have loged with a domain user with full rigths, and my folder of Opatch and sub folders have got full permission.

This is the command i am executing to apply the patch.

E:\oracle\product\10.2.0\db_1\OPatch\9358800>opatch apply ( this is the following error message i am getting)

Exception in thread "main" java.lang.NoClassDefFoundError: oracle/opatch/OPatch

OPatch failed with error code = 1

My system variable PATH is set to

E:\oracle\product\10.2.0\db_1\bin;C:\j2sdk1.4.2_19-x64\bin;C:\Program Files\HP\NCU;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem.

Would like to have some sugesstions

Regards

JUDE.

[former_member285859 · Accepted solution]

Dear Rajesh Narkhede,

Oracle Home is set correctly, and now i have set my JAVA_HOME.

again i tried to apply the patchs,

with the following command :-

E:\oracle\product\10.2.0\db_1\OPatch\9358800>E:\oracle\product\10.2.0\db_1\opatch\opatch apply.

My out put was :-

E:\oracle\product\10.2.0\db_1\OPatch\9358800>E:\oracle\product\10.2.0\db_1\opatc

h\opatch apply

Invoking OPatch 10.2.0.4.3

Oracle Interim Patch Installer version 10.2.0.4.3

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

Oracle Home : E:\oracle\product\10.2.0\db_1

Central Inventory : C:\Program Files\Oracle\Inventory

from : n/a

OPatch version : 10.2.0.4.3

OUI version : 10.2.0.4.0

OUI location : E:\oracle\product\10.2.0\db_1\oui

Log file location : E:\oracle\product\10.2.0\db_1\cfgtoollogs\opatch\opatch2010-

07-06_14-51-13PM.log

ApplySession applying interim patch '9358800' to OH 'E:\oracle\product\10.2.0\db

_1'

Running prerequisite checks...

Prerequisite check "CheckActiveFilesAndExecutables" failed.

The details are:

Following files are active :

E:\oracle\product\10.2.0\db_1\bin\oraclient10.dll

E:\oracle\product\10.2.0\db_1\bin\orapls10.dll

E:\oracle\product\10.2.0\db_1\bin\oracommon10.dll

E:\oracle\product\10.2.0\db_1\bin\orageneric10.dll

E:\oracle\product\10.2.0\db_1\rdbms\admin\oraclient10.sym

E:\oracle\product\10.2.0\db_1\rdbms\admin\orapls10.sym

E:\oracle\product\10.2.0\db_1\rdbms\admin\oracommon10.sym

E:\oracle\product\10.2.0\db_1\rdbms\admin\orageneric10.sym

E:\oracle\product\10.2.0\db_1\rdbms\jlib\qsma.jar

E:\oracle\product\10.2.0\db_1\rdbms\jlib\qsma.jar

E:\oracle\product\10.2.0\db_1\rdbms\jlib\qsma.jar

E:\oracle\product\10.2.0\db_1\bin\oraimr10.dll

E:\oracle\product\10.2.0\db_1\bin\oraplp10.dll

E:\oracle\product\10.2.0\db_1\rdbms\admin\oraplp10.sym

E:\oracle\product\10.2.0\db_1\bin\oracle.exe

E:\oracle\product\10.2.0\db_1\rdbms\admin\oracle.sym

E:\oracle\product\10.2.0\db_1\bin\orajox10.dll

E:\oracle\product\10.2.0\db_1\bin\oranls10.dll

E:\oracle\product\10.2.0\db_1\rdbms\admin\oranls10.sym

E:\oracle\product\10.2.0\db_1\bin\oraunls10.dll

E:\oracle\product\10.2.0\db_1\rdbms\admin\oraunls10.sym

E:\oracle\product\10.2.0\db_1\bin\orasnls10.dll

E:\oracle\product\10.2.0\db_1\rdbms\admin\orasnls10.sym

E:\oracle\product\10.2.0\db_1\bin\oranro10.dll

E:\oracle\product\10.2.0\db_1\bin\oran10.dll

E:\oracle\product\10.2.0\db_1\bin\oranl10.dll

E:\oracle\product\10.2.0\db_1\bin\oranbeq10.dll

E:\oracle\product\10.2.0\db_1\bin\orannzsbb10.dll

E:\oracle\product\10.2.0\db_1\bin\oracore10.dll

E:\oracle\product\10.2.0\db_1\rdbms\admin\oracore10.sym

E:\oracle\product\10.2.0\db_1\sysman\jlib\emDB.jar

E:\oracle\product\10.2.0\db_1\sysman\jlib\emDB.jar

E:\oracle\product\10.2.0\db_1\sysman\jlib\emDB.jar

E:\oracle\product\10.2.0\db_1\sysman\jlib\emDB.jar

E:\oracle\product\10.2.0\db_1\sysman\jlib\emDB.jar

E:\oracle\product\10.2.0\db_1\sysman\jlib\emDB.jar

E:\oracle\product\10.2.0\db_1\sysman\jlib\emDB.jar

E:\oracle\product\10.2.0\db_1\sysman\jlib\emjsp.jar

E:\oracle\product\10.2.0\db_1\sysman\jlib\emjsp.jar

E:\oracle\product\10.2.0\db_1\sysman\jlib\emjsp.jar

E:\oracle\product\10.2.0\db_1\sysman\jlib\emjsp.jar

E:\oracle\product\10.2.0\db_1\bin\orahasgen10.dll

E:\oracle\product\10.2.0\db_1\bin\orahasgen10.dll

E:\oracle\product\10.2.0\db_1\rdbms\admin\orahasgen10.sym

E:\oracle\product\10.2.0\db_1\bin\oraocr10.dll

E:\oracle\product\10.2.0\db_1\rdbms\admin\oraocr10.sym

E:\oracle\product\10.2.0\db_1\bin\oraocrb10.dll

E:\oracle\product\10.2.0\db_1\rdbms\admin\oraocrb10.sym

E:\oracle\product\10.2.0\db_1\bin\oraocrutl10.dll

E:\oracle\product\10.2.0\db_1\bin\isqlplussvc.exe

E:\oracle\product\10.2.0\db_1\bin\oraocrutl10.dll

E:\oracle\product\10.2.0\db_1\bin\oraldapclnt10.dll

E:\oracle\product\10.2.0\db_1\bin\oraxml10.dll

E:\oracle\product\10.2.0\db_1\bin\tnslsnr.exe

ApplySession failed during prerequisite checks: Prerequisite check "CheckActiveF

ilesAndExecutables" failed.

System intact, OPatch will not attempt to restore the system

OPatch failed with error code = 74

E:\oracle\product\10.2.0\db_1\OPatch\9358800>

Regards

JUDE.

[Former Member · Accepted solution]

Hi,

Oracle database or services are might be running.

First make sure that all Oracle services are stopped.

Then try to run opatch again..

Regards.

Rajesh Narkhede

[former_member285859]

Dear Rajesh Narkhede,

Thanks a lot, we applied the Opatches sucessfully with your commmand,

We took a re-start of our server so by default Oracle services were active, we stoped the services and run the command

E:\oracle\product\10.2.0\db_1\OPatch\9358800>E:\oracle\product\10.2.0\db_1\opatch\opatch apply

and it was sucessfull.

[Former Member]

Hi

First, I think you haven't installed Oracle as suggested by SAP in installation guide (using sapserver.cmd)

Otherwise, ORACLE_HOME would be something like "E:\oracle\<SID>\102".

Second, can you check if the below environment variables are set properly..

JAVA_HOME = C:\j2sdk1.4.2_19-x64
ORACLE_HOME = E:\oracle\product\10.2.0\db_1

Also try to execute "opatch" with absolute path. like:

E:\oracle\product\10.2.0\db_1\OPatch\9358800>E:\oracle\product\10.2.0\db_1\opatch\opatch apply

(Check the correct path of OPATCH in Oracle Home directory...)

You can also try installing latest version of PERL.. (Opatch required perl)

Regards.

Rajesh Narkhede