Unable to apply opatches on 9.2.0.5.0

[Former Member]

Dear Experts,

I am on SAP 4.7EE, Windows 2003 and Oracle 9.2.0.5.0. We are in the process of upgrading our oracle to 10.2.0.4.

As a pre-requisite we are trying to apply oracle patch 9.2.0.6 so as to run the upgrade assistant, but we are not able to invoke the opatch utility and get the below error.

====================================================================================================

D:\Upgrade_102\p4351589_9206_WINNT\4351589>E:\OPatch\opatch apply

"You have to invoke the patch tool manually."

"The syntax is:"

" perl <path to patch tool>/opatch.pl <patch command>"

"If everything is installed correctly you should be able to run"

" perl <path to patch tool>/opatch.pl"

" and see the basic help message."

D:\Upgrade_102\p4351589_9206_WINNT\4351589>perl E:\OPatch\opatch.pl apply

'perl' is not recognized as an internal or external command,

operable program or batch file.

====================================================================================================

Please do the needful so as to solve the problem.

Thanks in advance

Regards

Hunky

[Former Member]

Hi Haree,

'perl' is not recognized as an internal or external command,

You might need to install "PERL" for windows...

Just go to the below link. Download and install it.. then try to run "Opatch" again..

[http://www.perl.com/download.csp|http://www.perl.com/download.csp]

Regards.

Rajesh Narkhede

[Former Member]

Dear Rajesh,

Thanks very much for the quick reply.., i have succeeded invoking the opatch as per your suggestion, but please check with the below error after running the command,

====================================================================================================

D:\Upgrade_102\p4351589_9206_WINNT\4351589>perl E:\OPatch\opatch.pl apply

OPatch Version 1.0.0.0.48

Perl Version 5.010001

Oracle Home = E:\

Location of Oracle Inventory = E:\inventory

Oracle Universal Installer shared library = E:\oui\lib\win32\oraInstaller.dll

Path to Java = "E:\jdk\jre\bin\java.exe"

Location of Oracle Inventory Pointer = N/A

Location of Oracle Universal Installer components = E:\oui

Required Jar File under Oracle Universal Installer = jlib\OraInstaller.jar

E:\OPatch\opatch.pl version: 1.0.0.0.48

Copyright (c) 2001,2002,2003 Oracle Corporation. All Rights Reserved.

Cannot set up OUI inventory session

ERROR: OPatch failed because of Inventory problem.

====================================================================================================

I am sure that the opatch utility is failing to check the inventory.., can you please help me set right the above error.

Thanks again in advance

Regards

Hunky

[Former Member]

Hi,

*Oracle Home = E:*

Set the ORACLE_HOME and ORACLE_SID system variable correctly pointing to actuall ORACLE_HOME

Try to run the OPatch utility from your %ORACLE_HOME%\OPatch directory with absolute path.

cd <path_to_the_patch_directory>
%ORACLE_HOME%\OPatch\opatch.pl apply

Then try again...

Regards.

Rajesh Narkhede

[Former Member]

Dear Rajesh,

The ORACLE_HOME and ORACLE_SID are set correctly and i have run the command the way you expected.., i am still not able to succeed.

Do you think there is any other problem.., i have also changed the oracle inventory path in the registry(suggestions based on OTN forum) and tried. Still no go.

Any more suggesstions

Thanks and regards

Hunky

[former_member204746]

if your Oracle Inventory is corrupted, you will need to re-install Oracle 9.2, then, you will be able to install 9.2.0.5.

Anyways, i would highly consider upgrading to 10.2.0.4 instead.

[Former Member]

Hi Eric,

The purpose of me posting this is to upgrade to 10.2.0.4 itself, but i will not to be able to do it unless i upgrade to 9.2.0.6 minimum.

Question: Can i proceed to upgrade from 9.2.0.5 directly to 10.2.0.2

I have solved my problem of the OPatch by setting up 2 variables (OPATCH_QUOTE_PERL_CMD and ACTIVE_STATE_PERL set to TRUE)

I have successfully applied the interim patches but now the error is that i am not able to start OracleServiceOMQ service and the error i get it is

Error 1053: The service did not respond to the start or control request in a timely fashion

checked various blogs and forums and yet failed to solve the error, can someone help me.

Thanks and regards

Hunky

[volker_borowski2]

Did I get that right ?

You tried to apply a 9.2.0.6 bugfix to your 9.2.0.5 Oracle version?

This schould not have been possible, OPATCH should have not allowed this?

You need to go to 9.2.0.6 first by using runInstaller.

Then you apply the opatch for 9.2.0.6.

Volker

[Former Member]

Hello Everyone,

I have successfully applied the patch 9.2.0.6 and upgraded my oracle also.

I deleted the service and recreated which did the trick for me.

Thanks and regards

Hunky