Problem of Interim patches(8290549) of oracle 9.2.0.8

[former_member474881]

Hi,

I am facing a problem which is oracle interim patches of oracle 9.2.0.8.

When I performed opatch apply, I get the message as below:

OPatch encounters the following issues during file patching:

The following java archives had problems with being patched:

1. osdadmin.jar

[ object: AdminPasswdField.class ]

2. ultrasearch_midtier.jar

[ object: InvalidInputException.class ]

3. CDC.jar

[ object: ChangeTable.class ]

4. ultrasearch_midtier.jar

[ object: IsearchResBun.class ]

5. ultrasearch_midtier.jar

[ object: AdminUtil.class ]

6. osdadmin.jar

[ object: Root$RootServerList.class ]

7. osdadmin.jar

[ object: Root.class ]

8. CDC.jar

[ object: AdvanceChangeSet.class ]

9. qsma.jar

[ object: QsmaDataReports.class ]

10. qsma.jar

[ object: QsmaFileManager.class ]

11. CDC.jar

[ object: SubscriptionHandle.class ]

12. ultrasearch_midtier.jar

[ object: AdminObject.class ]

13. qsma.jar

[ object: QsmaDataManager.class ]

Replying 'Y' will terminate the patch installation immediately. It WILL NOT restore any updates that have been performed to this point. It WILL NOT update the inventory.

Replying 'N' will update the inventory showing the patch has been applied.

NOTE: After replying either 'Y' or 'N' it is critical to review:

Metalink Note 312767.1 How to rollback a failed Interim patch installation.

Do you want to STOP?

If I choose N, I get opatch verification fail which is opatch failed.

After that I enter opatch lsinventory to check the opatch result, I get this:

Oracle Interim Patch Installer version 1.0.0.0.57

Copyright (c) 2007 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under

OPatch/docs for usage reference. We also recommend using

the latest OPatch version. For the latest OPatch version

and other support related issues, please refer to document

293369.1 which is viewable from metalink.oracle.com

Oracle Home : /oracle_origlog/oracle/ID1/920_32

Oracle Home Inventory : /oracle/ID1/920_32/inventory

Central Inventory : /oracle/ID1/oraInventory

from : /etc/oraInst.loc

OUI location : /oracle/ID1/920_32/oui

OUI shared library : /oracle/ID1/920_32/oui/lib/linux/liboraInstaller.so

Java location : /oracle/ID1/920_32/jre/1.4.2/bin/java

Log file location : /oracle_origlog/oracle/ID1/920_32/.patch_storage/<patch ID>/*.log

Creating log file "/oracle/ID1/920_32/.patch_storage/LsInventory__04-23-2009_16-22-22.log"

Result:

Installed Patch List:

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

1) Patch 8290549 applied on Thu Apr 23 15:41:36 SGT 2009

[ Base Bug(s): 6787081 5933477 6375910 6079599 6647071 8290638 6117049 4115449 6690077 7154115 6639973 6066116 5149865 7592365 7127618 5490859 5744161 6079582 5839764 5722472 5605370 6769003 4609147 5089244 7154111 4969005 4683638 6521027 6654193 5726053 5754150 5631915 5526018 7120509 6053580 5917099 4970079 2701372 2855117 6826554 5517051 7335157 6057120 6451637 5080775 6120177 6613049 5965170 5116414 8290549 6862814 5514908 6529567 5964709 5188321 4157520 6444045 6646842 5901910 5057695 6395038 6864197 6042409 5849054 6404861 5703297 6020552 6404447 6703834 7375695 4334992 5558878 6350567 5901875 7576801 6493035 6319169 4057920 5369855 5745084 5345437 6619946 6453643 6864082 4088156 5372831 5491035 6954722 5527732 6055396 5631836 ]

OPatch succeeded.

So it means I have successfully patching the interim patches to the system???

Kindly please help.

Thanks,

Nancy

[Former Member]

Hi Nancy,

Can we get the output from "opatch lsinventory" ? I'm curious if you might have some errors in the installation of previous one-off patches or maybe with your oraInst.loc file.

For example, if you see:

Patch 5961654 : applied on Thu Feb 12 15:45:13 CST 2009

Created on

Bugs fixed:

5961654

• Warning: no filemap entries available.

Check out metalink document:

Subject: Opatch Lsinventory Result Shows: * Warning: no filemap entries available.

Doc ID: 431783.1

[former_member474881]

Hi Rich,

Output of opatch lsinventory is as below:

_______________________________________________________________________________________

Oracle Interim Patch Installer version 1.0.0.0.57

Copyright (c) 2007 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under

OPatch/docs for usage reference. We also recommend using

the latest OPatch version. For the latest OPatch version

and other support related issues, please refer to document

293369.1 which is viewable from metalink.oracle.com

Oracle Home : /oracle_origlog/oracle/ID1/920_32

Oracle Home Inventory : /oracle/ID1/920_32/inventory

Central Inventory : /oracle/ID1/oraInventory

from : /etc/oraInst.loc

OUI location : /oracle/ID1/920_32/oui

OUI shared library : /oracle/ID1/920_32/oui/lib/linux/liboraInstaller.so

Java location : /oracle/ID1/920_32/jre/1.4.2/bin/java

Log file location : /oracle_origlog/oracle/ID1/920_32/.patch_storage/<patchID>/*.log

Creating log file "/oracle/ID1/920_32/.patch_storage/LsInventory__04-24-2009_14-54-11.log"

Result:

Installed Patch List:

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

1) Patch 8290549 applied on Thu Apr 23 15:41:36 SGT 2009

[ Base Bug(s): 6787081 5933477 6375910 6079599 6647071 8290638 6117049 4115449 6690077 7154115 6639973 6066116 5149865 7592365 7127618 5490859 5744161 6079582 5839764 5722472 5605370 6769003 4609147 5089244 7154111 4969005 4683638 6521027 6654193 5726053 5754150 5631915 5526018 7120509 6053580 5917099 4970079 2701372 2855117 6826554 5517051 7335157 6057120 6451637 5080775 6120177 6613049 5965170 5116414 8290549 6862814 5514908 6529567 5964709 5188321 4157520 6444045 6646842 5901910 5057695 6395038 6864197 6042409 5849054 6404861 5703297 6020552 6404447 6703834 7375695 4334992 5558878 6350567 5901875 7576801 6493035 6319169 4057920 5369855 5745084 5345437 6619946 6453643 6864082 4088156 5372831 5491035 6954722 5527732 6055396 5631836 ]

OPatch succeeded.

_____________________________________________________________________________________

Thanks for your reply.

BR,

Nancy

[Former Member]

Nancy,

Could we get a look at the patch log?

/oracle_origlog/oracle/ID1/920_32/.patch_storage/<patch ID>/*.log

It should be something like...

/oracle_origlog/oracle/ID1/920_32/.patch_storage/8290549/*.log

Do you see anything obvious in there?

You might double-check that your version of OPatch is compatible with that CPU.

[Former Member]

I forgot the most obvious question.. what OS are you running?

[former_member474881]

Hi Rich,

Sorry for the late reply.

I can read this log there:

There are 13 issues patching Java library in Oracle Home.

FILE PROBLEM: some files are not patched.

OPATCH_JAVA_ERROR: Patch was not successfully applied.

Verification of the patch failed.

ERROR: OPatch failed as verification of the patch failed.

____________________________________________________________________________

This is running on SUSE linux 9

Thanks a lot.

BR,

Nancy

[Former Member]

Hi Nancy,

I'm stumped. It doesn't appear to be anything obvious. Are you experiencing any noticible loss of service? Are all the objects listed in dba_objects VALID that you would expect to be valid? Are all the items in dba_registry valid?

I'd recommend opening an SR with Oracle Support. I've found a posting on Metalink that lists that error as benign but this Doc(753348.1) is specific to applying 7608318, CPUJan2009 Application Server 10.1.2.2 Oracle Fusion Middleware. A file doesn't exist and Oracle knows and says it's ok.

But I wouldn't take that chance with your DB! Open an SR!

Have you tried to install this patch on another DB? If not, can you? If so, same problem? Obviously not a production DB though!

Maybe now is a good time to go to Oracle 10.2.0.4 and it's 30+ one-off patches?

Best of luck. I'm curious what the resolution will be!

Regards,

Rich

[former_member474881]

Hi Rich,

OK, I will try oracle 10.0.2.4 then. Anyway, thanks a lot for your help, appreciate it.

BR,

Nancy

[markus_doehr2]

Is it maybe possible that e. g. enterprise manager is still running? Or iSQL?

Markus

[former_member474881]

Hi Markus,

How can i check whether Enterprise Manager or iSQL is running?

Thanks a lot in advance.

BR,

Nancy

[Former Member]

DB Console should be..

emctl status

iSQLPLUS should be..

isqlplusctl stop

If you look in $ORACLE_HOME/install/portlist.ini you can see whether DB Console or iSQLPlus are even installed.

[oracle:<ROWDEV > /oracle] cat $ORACLE_HOME/install/portlist.ini

iSQL*Plus HTTP port number =5560

iSQL*Plus HTTP port number =5561