一. Bug问题表现
2011年安装Oracle 10.2.0.4和10.2.0.5版本时,在配置OEM的时候会报错。忽略这个错误后,DB可以成功创建或者升级。
MOS上关于这个bug的说明,参考:[ID 1222603.1]
该bug的表现为DBCA和DBUA配置失败:
Database Configuration Assistant (DBCA) and Database Upgrade Assistant (DBUA) will report the following error in the console:
Could not complete the Enterprise Manager configuration.
Enterprise manager configuration failed due to the following error –
Error starting Database Control
Enterprise Manager Configuration Assistant (EMCA) will write errors similar to those below to the emca.log file:
CONFIG: Securing Database Control completed successfully .
Jan 2, 2011 7:22:47 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Jan 2, 2011 7:22:47 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jan 2, 2011 7:22:47 PM oracle.sysman.emcp.util.PlatformInterface addEnvVarToList
CONFIG: Value for env var 'ORACLE_HOSTNAME' is '', discarding the same
CONFIG: Returning env array from cache
Jan 2, 2011 7:22:47 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Starting execution: /myhost/bin/emctl start dbconsole
Jan 2, 2011 7:27:26 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Exit value of 1
Jan 2, 2011 7:27:26 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://myhost:5501/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control
............................................................................................. failed.
------------------------------------------------------------------
Logs are generated in directory /myhost/sysman/log
Jan 2, 2011 7:27:26 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /myhost/bin/emctl start dbconsole
Jan 2, 2011 7:27:26 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error starting Database Control
Refer to the log file at /myhost/dbua/d4/upgrade/emConfig.log for more details.
Jan 2, 2011 7:27:26 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error starting Database Control
at oracle.sysman.emcp.EMDBPostConfig.performUpgrade(EMDBPostConfig.java:763)
at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:232)
at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:193)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:184)
at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:436)
at oracle.sysman.assistants.util.em.EMConfigStep.executeImpl(EMConfigStep.java:140)
at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
at oracle.sysman.assistants.util.step.BasicStep.callStep(BasicStep.java:251)
at oracle.sysman.assistants.dbma.backend.EMConfigStep.executeStepImpl(EMConfigStep.java:104)
at oracle.sysman.assistants.dbma.backend.SummarizableStep.executeImpl(SummarizableStep.java:175)
at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2488)
at java.lang.Thread.run(Thread.java:534)
The EMCA console will display output similar to the following:
aime@myhost09 db_1]$ bin/emca -config dbcontrol db -repos recreate -cluster
STARTED EMCA at Jan 11, 2011 4:11:01 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database unique name: catest
Database Control is already configured for the database catest
You have chosen to configure Database Control for managing the database catest
This will remove the existing configuration and the default settings and perform a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]: Y
Listener port number: 1521
Cluster name: mycluster
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
........
Jan 11, 2011 4:18:05 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Jan 11, 2011 4:19:31 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jan 11, 2011 4:28:38 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error starting Database Control
Refer to the log file at /myhost/oracle/product/10.2.0/db_1/cfgtoollogs/emca/catest/emca_2011-01-11_
04-11-01-PM.log for more details.
Could not complete the configuration. Refer to the log file at /myhost/oracle/product/10.2.0/db_
1/cfgtoollogs/emca/catest/emca_2011-01-11_04-11-01-PM.log for more details.
二.Oracle对这个bug原因的说明:
In Enterprise Manager Database Control with Oracle Database 10.2.0.4 and 10.2.0.5,the root certificate used to secure communications via the Secure Socket Layer (SSL) protocol will expire on 31-Dec-2010 00:00:00. The certificate expiration will cause
errors if you attempt to configure Database Control on or after 31-Dec-2010.Existing Database Control configurations are not impacted by this issue.
If you plan to configure Database Control with either of these Oracle Database releases,Oracle strongly recommends that you applyPatch
8350262to your Oracle Home installations before you configure Database Control.Configuration of Database Control is typically done when you create or upgrade Oracle Database, or if you run Enterprise Manager Configuration Assistant (EMCA) in standalone
mode.
Note the following:
(1)The issue impacts configuration of Database Control with Oracle Database 10.2.0.4 and 10.2.0.5 only. It does not impact database creation or upgrade.
(2)The issue does not impact existing Database Control configurations.
(3)Application ofPatch 8350262does not require any database downtime
这个Patch不受平台限制。
三.解决该问题步骤
如果是在创建实例之前就把该patch给打上了,那么在创建OEM的时候不会受影响。
如果是已经报错了,解决步骤如下:
For Single Instance:
1.使用Opatch安装Patch 8350262
2.force stop the Database Control (dbconsole) process using the killDBConsole script bundled with the patch.Note that the dbconsole process cannot be stopped using the emctl stop dbconsole command, as EMCTL is unable to connect to the process.
(1)Set the ORACLE_HOME and ORACLE_SID environment variables.
(2)Execute <PATCH_HOME>/killDBConsole.
--windows平台省略这一步
3.Re-secure Database Control with the following command:
<ORACLE_HOME>/bin/emctl secure dbconsole -reset
4.Re-start Database Control with the following command:
<ORACLE_HOME>/bin/emctl start dbconsole
For RAC Instance:
1.使用Opatch安装Patch 8350262,在一个节点安装就ok了。
2.force stop the Database Control (dbconsole) process by executing the killDBConsole script bundled with the patchon each node in the cluster
在所有节点执行
(1)Set the ORACLE_HOME and ORACLE_SID environment variables.
(2)Execute <PATCH_HOME>/killDBConsole.
--windows平台省略这一步
3. Re-secure Database Controlon the first cluster nodewith the following command:
<ORACLE_HOME>/bin/emctl secure dbconsole -reset
4. Re-secure Database Controlon the remaining cluster nodeswith the following command. Note that the -reset switch is not included with this command:
<ORACLE_HOME>/bin/emctl secure dbconsole
5.Re-start Database Control by executing the following commandon each node in the cluster:
<ORACLE_HOME>/bin/emctl start dbconsole
-------------------------------------------------------------------------------------------------------
分享到:
相关推荐
oracle 10.2.0.4安装包 windows
Oracle 10.2.0.4 64位客户端
oracle linux 10.2.0.4安装包
Oracle 10.2.0.4 rac 详细安装文档
Oracle 10.2.0.4 64位服务端,在网上找了很久也没找到,这里分享一下。
Oracle10.2.0.4 服务器,客户端office2010 在 windows server 2008 64 下安装 压缩包内容: oraparam.ini refhost.xml mini-KMS_Activator_v1.3_Office2010_VL_ENG.exe oracle10.2.0.4在win2008 64 下安装.docx(图解)
oracle10.2.0.1升级到10.2.0.4
OracleRAC_10.2.0.1升级到10.2.0.4安装配置参考手册
oracle 10.2.0.1升级参考手册,不会的筒子们可以参考下。
Redhat linux5.6下Oracle 10g (10.2.0.1)安装及升级到10.2.0.4
将oracle10G升级至10.2.0.4
Linux(RHEL5)下ORACLE_10g_10.2.0.1.0升级到10.2.0.5.0操作文档(超给力版本)... 1 目录... 2 1. 文档更新记录... 3 2. 文档说明... 3 3. 升级前,需要做的准备工作:... 4 3.1.1. 临时增加shared pool和java pool...
在Window 7 64位操作系统上安装Oracle 10g 及 配置PLSQL Developer 8.0.时将用到它,详情请看我的博客http://blog.csdn.net/youqishini/article/details/7014532
Oracle 10.2.0.4EM证书过期补丁p8350262_10204_Generic
Oracle10.2.0.4安装手册分享.pdf
操作规范(二)——Linux 5.4安装Oracle 10.2.0.4 redhat linux 5.4 安装Oracle 10.2.0.4 截图 图文并茂
10.2.0.5 oracle数据驱动,数据库jar maven 构建问题
oracle 10.2.0.5 patch 下载地址 windows linux aix 等
Oracle_RAC_10.2.0.1升级到10.2.0.4-安装配置参考手册