Oracle 10.2.0.4中 OEM bug 8350262

1、发现问题今天在OEL 4环境，从10.2.0.1升级至10.2.0.4，然后dbca建库，进度在91%的时候就不动了一直卡在那等了很久，最后报出来下面的错误~让我们来瞧瞧！

通过google搜索了下原来这是Oracle在10.2.0.4和10.2.0.5的BUG,运气这么好，被我给碰上了~根据提示打开emConfig.log日志文件Vi/u01/app/oracle/product/10.2/db/cfgtoollogs/dbca/prod/emConfig.log Aug 17,2011 10:12:30 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILocCONFIG:Setting oracle.installer.oui_loc to /u01/app/oracle/product/10.2/db/ouiAug 17,2011 10:12:30 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILocCONFIG:Setting oracle.installer.oui_loc to /u01/app/oracle/product/10.2/db/ouiAug 17,2011 10:12:33 AM oracle.sysman.emcp.util.CentralAgentUtilgetCentralAgentHomeAndURLCONFIG:Central Agent home and URL: {}Aug 17,2011 10:12:33 AM oracle.sysman.emcp.EMConfig restoreOuiLocCONFIG:Restoring oracle.installer.oui_loc to /u01/app/oracle/product/10.2/db/ouiAug 17,2011 11:45:57 AM oracle.sysman.emcp.ParamsManager setParamCONFIG:Setting param: LOG_FILE value:/u01/app/oracle/product/10.2/db/cfgtoollogs/dbca/prod/emConfig.logAug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParamCONFIG:Setting param: HOST value: oel1Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParamCONFIG:Setting param: PORT value: 1521Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParamCONFIG:Setting param: SID value: prodAug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParamCONFIG:Setting param: LISTENER value: LISTENERAug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParamCONFIG:Setting param: LISTENER_OH value: /u01/app/oracle/product/10.2/dbAug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setFlagCONFIG:Flag "-config" set to trueAug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setFlagCONFIG:Flag "db" set to trueAug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParamCONFIG:Setting param: EM_HOME value: /u01/app/oracle/product/10.2/dbAug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParamCONFIG:Setting param: DB_UNIQUE_NAME value: prodAug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParamCONFIG:Setting param: SERVICE_NAME value: prodAug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam<product/10.2/db/cfgtoollogs/dbca/prod/emConfig.log"1500L, 138732C 1,1           TopAug 17,2011 10:12:30 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILocCONFIG:Setting oracle.installer.oui_loc to /u01/app/oracle/product/10.2/db/ouiAug 17,2011 10:12:30 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILocCONFIG:Setting oracle.installer.oui_loc to /u01/app/oracle/product/10.2/db/ouiAug 17,2011 10:12:33 AM oracle.sysman.emcp.util.CentralAgentUtilgetCentralAgentHomeAndURLCONFIG:Central Agent home and URL: {}Aug 17,2011 10:12:33 AM oracle.sysman.emcp.EMConfig restoreOuiLocCONFIG:Restoring oracle.installer.oui_loc to /u01/app/oracle/product/10.2/db/ouiAug 17,2011 11:45:57 AM oracle.sysman.emcp.ParamsManager setParamCONFIG:Setting param: LOG_FILE value:/u01/app/oracle/product/10.2/db/cfgtoollogs/dbca/prod/emConfig.logAug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParamCONFIG:Setting param: HOST value: oel1Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParamCONFIG:Setting param: PORT value: 1521Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParamCONFIG:Setting param: SID value: prodAug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParamCONFIG:Setting param: LISTENER value: LISTENERAug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParamCONFIG:Setting param: LISTENER_OH value: /u01/app/oracle/product/10.2/dbAug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setFlagCONFIG:Flag "-config" set to trueAug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setFlagCONFIG:Flag "db" set to trueAug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParamCONFIG:Setting param: EM_HOME value: /u01/app/oracle/product/10.2/dbAug 17, 201111:46:27 AM oracle.sysman.emcp.ParamsManager setParamCONFIG:Setting param: DB_UNIQUE_NAME value: prodAug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParamCONFIG:Setting param: SERVICE_NAME value: prodAug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParamCONFIG:Setting param: ORACLE_HOME value: /u01/app/oracle/product/10.2/dbAug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setFlagCONFIG:Flag "-cluster" set to trueAug 17,2011 11:46:27 AM oracle.sysman.emcp.util.ClusterUtil areNodesAliveCONFIG:Alive node cache contents: []Aug 17,2011 11:46:27 AM oracle.sysman.emcp.util.ClusterUtil areNodesAliveCONFIG:oel1 not found in alive node cacheAug 17,2011 11:46:27 AM oracle.sysman.emcp.util.ClusterUtil areNodesAliveCONFIG:oel2 not found in alive node cacheAug 17,2011 11:46:29 AM oracle.sysman.emcp.util.ClusterUtil areNodesAliveCONFIG:Node: oel1 is accessible.Aug 17,2011 11:46:29 AM oracle.sysman.emcp.util.ClusterUtil areNodesAliveCONFIG:Node: oel2 is accessible.Aug 17,2011 11:46:29 AM oracle.sysman.emcp.ParamsManager getInaccessibleNodeListCONFIG:All nodes are up. Nodes: [oel1, oel2]Aug 17,2011 11:46:29 AM oracle.sysman.emcp.ParamsManager getInaccessibleSidListCONFIG:All nodes are up. Nodes: [oel1, oel2] Sids: [prod1, prod2] 2、Oracle 对这个bug原因的说明：       In Enterprise Manager DatabaseControl with Oracle Database 10.2.0.4 and 10.2.0.5, the root certificate used to securecommunications via the Secure Socket Layer （SSL） protocol will expire on31-Dec-2010 00:00:00. Thecertificate expiration will cause errors if you attempt to configure DatabaseControl on or after 31-Dec-2010. Existing Database Controlconfigurations are not impacted by this issue.

       If you plan to configure Database Control with either of theseOracle Database releases, Oraclestrongly recommends that you apply Patch 8350262 to your Oracle Homeinstallations before you configure Database Control. Configuration of Database Control istypically done when you create or upgrade Oracle Database, or if you runEnterprise Manager Configuration Assistant （EMCA） in standalone mode.

Note the following:       （1）The issue impacts configuration ofDatabase Control with Oracle Database 10.2.0.4 and 10.2.0.5 only. It does notimpact database creation or upgrade.       （2）The issue does not impact existingDatabase Control configurations.       （3）Application of Patch 8350262 does not require any databasedowntime 3、解决问题ORACLE 给出的建议操作步骤如下：Recovering from Configuration Errors on a Single InstanceDatabase

单实例Recovering from Configuration Errors on a Single InstanceDatabase
1. Ignore any errors and continue with the installation or upgrade. Thedatabase will be created without errors.2. Apply Patch 8350262 to your Oracle Home installation usingOPatch.opatch applyInvoking OPatch 10.2.0.4.2Oracle Interim Patch Installer version 10.2.0.4.2
Copyright （c） 2007, Oracle Corporation. All rights reserved.Oracle Home : /myhost
Central Inventory : /scratch/pchebrol/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.2
OUI version : 10.2.0.4.0
OUI location : /myhost/oui
Log file location : /myhost/cfgtoollogs/opatch/opatch2011-01-02_11-00-00AM.logApplySession applying interim patch "8350262" to OH "/myhost"Running prerequisite checks...OPatch detected non-cluster Oracle Home from the inventory andwill patch the local system only.Backing up files and inventory （not for auto-rollback） for theOracle Home
Backing up files affected by the patch "8350262" for restore. This might take awhile...
Backing up files affected by the patch "8350262" for rollback. This might takea while...Patching component oracle.sysman.agent.core, 10.2.0.4.0a...
Updating jar file "/myhost/sysman/jlib/emCORE.jar" with
"/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class"
Updating jar file "/myhost/sysman/jlib/emCORE.jar" with
"/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class"
Updating jar file "/myhost/sysman/jlib/emCORE.jar" with
"/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/RootCert.class"
Updating jar file "/myhost/sysman/jlib/emCORE.jar" with
"/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/SecConstants.class"
Updating jar file "/myhost/sysman/jlib/emd_java.jar" with"/sysman/jlib/emd_
java.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class"
Updating jar file "/myhost/sysman/jlib/emd_java.jar" with"/sysman/jlib/emd_
java.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class"
Updating jar file "/myhost/sysman/jlib/emd_java.jar" with"/sysman/jlib/emd_
java.jar/oracle/sysman/eml/sec/util/RootCert.class"
Updating jar file "/myhost/sysman/jlib/emd_java.jar" with"/sysman/jlib/emd_
java.jar/oracle/sysman/eml/sec/util/SecConstants.class"
ApplySession adding interim patch "8350262" to inventoryVerifying the update...
Inventory check OK: Patch ID 8350262 is registered in Oracle Home inventorywith proper meta-data.
Files check OK: Files from Patch ID 8350262 are present in Oracle Home.OPatch succeeded.

Oracle 11.2.0.1在AMD CPU 64位硬件，32位操作系统下的BUG 8670579安装Oracle 10g RAC 到最后遇到PRKP-1001 、CRS-0215错误的解决方法相关资讯 Oracle教程

Oracle中纯数字的varchar2类型和（07/29/2015 07:20:43）
Oracle教程：Oracle中查看DBLink密（07/29/2015 07:16:55）
[Oracle] SQL*Loader 详细使用教程（08/11/2013 21:30:36）

Oracle教程：Oracle中kill死锁进程（07/29/2015 07:18:28）
Oracle教程：ORA-25153 临时表空间（07/29/2015 07:13:37）
Oracle教程之管理安全和资源（04/08/2013 11:39:32）

本文评论查看全部评论（0）