You will want to apply patch number 8708893 after you upgrade your Grid Control OMS to 10.2.0.5.
You can ignore the warning OUI-67303 if any, after applying the patch.
bash-3.00$ cd 8708893 bash-3.00$ export PATH=$ORACLE_HOME/OPatch:$PATH bash-3.00$ chmod 664 $ORACLE_HOME/j2ee/OC4J_EM/applications/em/em/home.jsp bash-3.00$ opatch lsinventory bash-3.00$ opatch napply -skip_subset Invoking OPatch 10.2.0.4.5 Oracle Interim Patch Installer version 10.2.0.4.5 Copyright (c) 2008, Oracle Corporation. All rights reserved. UTIL session Oracle Home : /apps/oracle/product/grid/oms10g Central Inventory : /apps/oracle/product/grid/oraInventory from : /var/opt/oracle/oraInst.loc OPatch version : 10.2.0.4.5 OUI version : 10.2.0.5.0 OUI location : /apps/oracle/product/grid/oms10g/oui Log file location : /apps/oracle/product/grid/oms10g/cfgtoollogs/opatch/opatch2009-09-10_03-36-57AM.log Patch history file: /apps/oracle/product/grid/oms10g/cfgtoollogs/opatch/opatch_history.txt Invoking utility “napply” Checking conflict among patches… Checking if Oracle Home has components required by patches… Checking skip_subset Checking conflicts against Oracle Home… Conflicts/Supersets for each patch are: Patch : 8321694 Bug Superset of 8321694 Super set bugs are: 8321694 Following patches will be rolled back from Oracle Home on application of the patches in the given list : 8321694 Do you want to proceed? [y|n] y User Responded with: Y OPatch continues with these patches: 7303584 7623620 8321694 8351454 8351955 8396767 8444248 8472279 8484881 8538082 8583901 8639888 8645799 8680162 8708612 8708893 Do you want to proceed? [y|n] y User Responded with: Y Running prerequisite checks… OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only. Backing up files affected by the patch ‘NApply’ for restore. This might take a while… Applying patch 7303584… ApplySession applying interim patch ‘7303584′ to OH ‘/apps/oracle/product/grid/oms10g’ ApplySession rolling back interim patch ‘8321694′ from OH ‘/apps/oracle/product/grid/oms10g’ Patching component oracle.sysman.top.oms, 10.2.0.5.0… Updating jar file “/apps/oracle/product/grid/oms10g/sysman/jlib/emcore_emjsp.jar” with “/apps/oracle/product/grid/oms10g/.patch_storage/8321694_Mar_20_2009_04_46_24/files//sysman/jlib/emcore_emjsp.jar/_home.class” Copying file to “/apps/oracle/product/grid/oms10g/j2ee/OC4J_EM/applications/em/em/home.jsp” RollbackSession removing interim patch ‘8321694′ from inventory OPatch back to application of the patch ‘7303584′ after auto-rollback. Backing up files affected by the patch ‘7303584′ for rollback. This might take a while… Patching component oracle.sysman.top.oms, 10.2.0.5.0… Updating jar file “/apps/oracle/product/grid/oms10g/sysman/jlib/emCORE.jar” with “/sysman/jlib/emCORE.jar/oracle/sysman/eml/metrics/target/MonitoringSettings.class” Updating jar file “/apps/oracle/product/grid/oms10g/sysman/jlib/emCORE.jar” with “/sysman/jlib/emCORE.jar/oracle/sysman/eml/mntr/metrics/UserDefinedMetricLauncherDataObject.class” ApplySession adding interim patch ‘7303584′ to inventory Verifying the update… Inventory check OK: Patch ID 7303584 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 7303584 are present in Oracle Home. Applying patch 7623620… ApplySession applying interim patch ‘7623620′ to OH ‘/apps/oracle/product/grid/oms10g’ Backing up files affected by the patch ‘7623620′ for rollback. This might take a while… Patching component oracle.sysman.top.oms, 10.2.0.5.0… Copying file to “/apps/oracle/product/grid/oms10g/sysman/admin/emdrep/sql/core/latest/sdk/sdk_credential_pkgbody.sql” ApplySession adding interim patch ‘7623620′ to inventory Verifying the update… Inventory check OK: Patch ID 7623620 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 7623620 are present in Oracle Home. Applying patch 8321694… ApplySession applying interim patch ‘8321694′ to OH ‘/apps/oracle/product/grid/oms10g’ Backing up files affected by the patch ‘8321694′ for rollback. This might take a while… Patching component oracle.sysman.top.oms, 10.2.0.5.0… Updating jar file “/apps/oracle/product/grid/oms10g/sysman/jlib/emcore_emjsp.jar” with “/sysman/jlib/emcore_emjsp.jar/_home.class” Copying file to “/apps/oracle/product/grid/oms10g/j2ee/OC4J_EM/applications/em/em/home.jsp” ApplySession adding interim patch ‘8321694′ to inventory Verifying the update… Inventory check OK: Patch ID 8321694 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8321694 are present in Oracle Home. Applying patch 8351454… ApplySession applying interim patch ‘8351454′ to OH ‘/apps/oracle/product/grid/oms10g’ Backing up files affected by the patch ‘8351454′ for rollback. This might take a while… Patching component oracle.sysman.top.oms, 10.2.0.5.0… Updating jar file “/apps/oracle/product/grid/oms10g/sysman/jlib/emCORE.jar” with “/sysman/jlib/emCORE.jar/oracle/sysman/eml/admin/rep/proxy/ProxyHandler.class” ApplySession adding interim patch ‘8351454′ to inventory Verifying the update… Inventory check OK: Patch ID 8351454 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8351454 are present in Oracle Home. Applying patch 8351955… ApplySession applying interim patch ‘8351955′ to OH ‘/apps/oracle/product/grid/oms10g’ Backing up files affected by the patch ‘8351955′ for rollback. This might take a while… Patching component oracle.sysman.top.oms, 10.2.0.5.0… Copying file to “/apps/oracle/product/grid/oms10g/sysman/admin/emdrep/sql/core/latest/severity/severity_pkgbodys.sql” ApplySession adding interim patch ‘8351955′ to inventory Verifying the update… Inventory check OK: Patch ID 8351955 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8351955 are present in Oracle Home. Applying patch 8396767… ApplySession applying interim patch ‘8396767′ to OH ‘/apps/oracle/product/grid/oms10g’ Backing up files affected by the patch ‘8396767′ for rollback. This might take a while… Patching component oracle.sysman.top.oms, 10.2.0.5.0… Updating jar file “/apps/oracle/product/grid/oms10g/sysman/emcli/omssideext/standardomsside.jar” with “/sysman/emcli/omssideext/standardomsside.jar/oracle/sysman/emdrep/blackout/emcli/BlackoutOMSSideMsg.class” Updating jar file “/apps/oracle/product/grid/oms10g/sysman/emcli/omssideext/standardomsside.jar” with “/sysman/emcli/omssideext/standardomsside.jar/oracle/sysman/emdrep/blackout/emcli/BlackoutOMSSideMsgID.class” Updating jar file “/apps/oracle/product/grid/oms10g/sysman/emcli/omssideext/standardomsside.jar” with “/sysman/emcli/omssideext/standardomsside.jar/oracle/sysman/emdrep/blackout/emcli/StopBlackoutVerb.class” ApplySession adding interim patch ‘8396767′ to inventory Verifying the update… Inventory check OK: Patch ID 8396767 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8396767 are present in Oracle Home. Applying patch 8444248… ApplySession applying interim patch ‘8444248′ to OH ‘/apps/oracle/product/grid/oms10g’ Backing up files affected by the patch ‘8444248′ for rollback. This might take a while… Patching component oracle.sysman.top.oms, 10.2.0.5.0… Copying file to “/apps/oracle/product/grid/oms10g/sysman/admin/emdrep/sql/core/latest/ping/ping_pkgbodys.sql” ApplySession adding interim patch ‘8444248′ to inventory Verifying the update… Inventory check OK: Patch ID 8444248 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8444248 are present in Oracle Home. Applying patch 8472279… ApplySession applying interim patch ‘8472279′ to OH ‘/apps/oracle/product/grid/oms10g’ Backing up files affected by the patch ‘8472279′ for rollback. This might take a while… Patching component oracle.sysman.top.oms, 10.2.0.5.0… Copying file to “/apps/oracle/product/grid/oms10g/sysman/admin/emdrep/sql/core/latest/sdk/sdk_target_pkgbody.sql” ApplySession adding interim patch ‘8472279′ to inventory Verifying the update… Inventory check OK: Patch ID 8472279 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8472279 are present in Oracle Home. Applying patch 8484881… ApplySession applying interim patch ‘8484881′ to OH ‘/apps/oracle/product/grid/oms10g’ Backing up files affected by the patch ‘8484881′ for rollback. This might take a while… Patching component oracle.sysman.top.oms, 10.2.0.5.0… Copying file to “/apps/oracle/product/grid/oms10g/sysman/admin/emdrep/sql/core/latest/statbsln/bslni_pkgbody.sql” Copying file to “/apps/oracle/product/grid/oms10g/sysman/admin/emdrep/sql/core/latest/collections/collections_triggers.sql” Copying file to “/apps/oracle/product/grid/oms10g/sysman/admin/emdrep/sql/core/latest/template/template_pkgbody.sql” Copying file to “/apps/oracle/product/grid/oms10g/sysman/admin/emdrep/sql/core/latest/policy/policy_pkgbody.sql” Copying file to “/apps/oracle/product/grid/oms10g/sysman/admin/emdrep/sql/core/latest/policy/policy_triggers.sql” Copying file to “/apps/oracle/product/grid/oms10g/sysman/admin/emdrep/sql/core/latest/template/template_pkgbody.sql” ApplySession adding interim patch ‘8484881′ to inventory Verifying the update… Inventory check OK: Patch ID 8484881 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8484881 are present in Oracle Home. Applying patch 8538082… ApplySession applying interim patch ‘8538082′ to OH ‘/apps/oracle/product/grid/oms10g’ Backing up files affected by the patch ‘8538082′ for rollback. This might take a while… Patching component oracle.sysman.top.oms, 10.2.0.5.0… Copying file to “/apps/oracle/product/grid/oms10g/sysman/admin/emdrep/sql/core/latest/basic/basic_loader_pkgbody.sql” ApplySession adding interim patch ‘8538082′ to inventory Verifying the update… Inventory check OK: Patch ID 8538082 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8538082 are present in Oracle Home. Applying patch 8583901… ApplySession applying interim patch ‘8583901′ to OH ‘/apps/oracle/product/grid/oms10g’ Backing up files affected by the patch ‘8583901′ for rollback. This might take a while… Patching component oracle.sysman.top.oms, 10.2.0.5.0… Copying file to “/apps/oracle/product/grid/oms10g/sysman/admin/emdrep/sql/core/latest/system_dashboard/em_system_dashboard_pkgbody.sql” ApplySession adding interim patch ‘8583901′ to inventory Verifying the update… Inventory check OK: Patch ID 8583901 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8583901 are present in Oracle Home. Applying patch 8639888… ApplySession applying interim patch ‘8639888′ to OH ‘/apps/oracle/product/grid/oms10g’ Backing up files affected by the patch ‘8639888′ for rollback. This might take a while… Patching component oracle.sysman.top.oms, 10.2.0.5.0… Copying file to “/apps/oracle/product/grid/oms10g/sysman/admin/emdrep/sql/core/latest/ecm/ecm_snapshot_pkgbody.sql” Copying file to “/apps/oracle/product/grid/oms10g/sysman/admin/emdrep/sql/core/latest/ecm/ecm_delta_pkgbody.sql” ApplySession adding interim patch ‘8639888′ to inventory Verifying the update… Inventory check OK: Patch ID 8639888 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8639888 are present in Oracle Home. Applying patch 8645799… ApplySession applying interim patch ‘8645799′ to OH ‘/apps/oracle/product/grid/oms10g’ Backing up files affected by the patch ‘8645799′ for rollback. This might take a while… Patching component oracle.sysman.top.oms, 10.2.0.5.0… Copying file to “/apps/oracle/product/grid/oms10g/sysman/admin/emdrep/sql/core/latest/notification/notification_ui_pkgbody.sql” Copying file to “/apps/oracle/product/grid/oms10g/sysman/admin/emdrep/sql/core/latest/sdk/sdk_user_pkgbody.plb” ApplySession adding interim patch ‘8645799′ to inventory Verifying the update… Inventory check OK: Patch ID 8645799 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8645799 are present in Oracle Home. Applying patch 8680162… ApplySession applying interim patch ‘8680162′ to OH ‘/apps/oracle/product/grid/oms10g’ Backing up files affected by the patch ‘8680162′ for rollback. This might take a while… Patching component oracle.sysman.top.oms, 10.2.0.5.0… Copying file to “/apps/oracle/product/grid/oms10g/sysman/admin/emdrep/sql/core/latest/jobs/jobs_engine_pkgbody.sql” ApplySession adding interim patch ‘8680162′ to inventory Verifying the update… Inventory check OK: Patch ID 8680162 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8680162 are present in Oracle Home. Applying patch 8708612… ApplySession applying interim patch ‘8708612′ to OH ‘/apps/oracle/product/grid/oms10g’ Backing up files affected by the patch ‘8708612′ for rollback. This might take a while… Patching component oracle.sysman.top.oms, 10.2.0.5.0… Updating jar file “/apps/oracle/product/grid/oms10g/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/db/conf/DBConfigController.class” Updating jar file “/apps/oracle/product/grid/oms10g/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/db/conf/DBConfigController$DiscoveryThread.class” Updating jar file “/apps/oracle/product/grid/oms10g/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/db/conf/DBConfigController$SavingThread.class” Updating jar file “/apps/oracle/product/grid/oms10g/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/db/conf/RACDBConfigUI.class” Updating jar file “/apps/oracle/product/grid/oms10g/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/db/adm/dist/streams/SetupController.class” Updating jar file “/apps/oracle/product/grid/oms10g/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/db/rsc/streams/StreamsMsg.class” Updating jar file “/apps/oracle/product/grid/oms10g/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/db/rsc/streams/StreamsMsgID.class” Updating jar file “/apps/oracle/product/grid/oms10g/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/emo/dist/streams/StreamSetupBean.class” Updating jar file “/apps/oracle/product/grid/oms10g/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/emo/dist/streams/StreamSetupSQLGenerator.class” Updating jar file “/apps/oracle/product/grid/oms10g/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/emo/dist/streams/StreamsCommandHandler.class” ApplySession adding interim patch ‘8708612′ to inventory Verifying the update… Inventory check OK: Patch ID 8708612 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8708612 are present in Oracle Home. Applying patch 8708893… ApplySession applying interim patch ‘8708893′ to OH ‘/apps/oracle/product/grid/oms10g’ Backing up files affected by the patch ‘8708893′ for rollback. This might take a while… Patching component oracle.sysman.top.oms, 10.2.0.5.0… Copying file to “/apps/oracle/product/grid/oms10g/sysman/admin/rollback_8708893.lst” ApplySession adding interim patch ‘8708893′ to inventory Verifying the update… Inventory check OK: Patch ID 8708893 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8708893 are present in Oracle Home. The local system has been patched and can be restarted. UtilSession: N-Apply done. ——————————————————————————– The following warnings have occurred during OPatch execution: 1) OUI-67303: Following patches will be rolled back from Oracle Home on application of the patches in the given list : 8321694 ——————————————————————————– OPatch Session completed with warnings. OPatch completed with warnings. bash-3.00$
From the OMS home:
>sqlplus sysman/oracle123@rac01/EMGRID SQL*Plus: Release 10.1.0.5.0 - Production on Thu Sep 10 05:12:49 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: SQL> @post_install_script repository owner: SYSMAN today date: 10Sep2009 job queue value: 10 PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. … SQL> exec emd_maint_util.recompile_invalid_objects() PL/SQL procedure successfully completed. SQL> SELECT object_name FROM user_objects WHERE status = ‘INVALID’ order by object_name ; no rows selected
Posted by Charles Kim, Oracle ACE
