客户要使用Oracle RAC Enterprise Manager Database Control来管理Linux平台的RAC数据库。通过DBCA创建EM的时候发现有告警报出,查看日志,有如下报错信息:
May 30, 2011 3:40:05 PM oracle.sysman.emcp.util.PlatformInterface addEnvVarToList
CONFIG: Value for env var 'DISPLAY' is '', discarding the same
May 30, 2011 3:40:05 PM oracle.sysman.emcp.util.PlatformInterface addEnvVarToList
CONFIG: Value for env var 'TZ' is '', discarding the same
May 30, 2011 3:40:05 PM oracle.sysman.emcp.util.PlatformInterface addEnvVarToList
CONFIG: Value for env var 'ORACLE_HOSTNAME' is '', discarding the same
May 30, 2011 3:40:05 PM oracle.sysman.emcp.util.PlatformInterface executeEMCTL
CONFIG: Executing 'emctl start dbconsole ' on node xtbgdb1 with sid xtbgdb1
May 30, 2011 3:44:24 PM oracle.sysman.emcp.util.PlatformInterface executeEMCTL
CONFIG: TZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.5.0 Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.https://xtbgdb1:1158/em/console/aboutApplicationStarting Oracle Enterprise Manager 10g Database Control ............................................................................................. failed. ------------------------------------------------------------------Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/xtbgdb1_xtbgdb1/sysman/log :failed
May 30, 2011 3:44:24 PM oracle.sysman.emcp.util.PlatformInterface executeEMCTL
CONFIG: Cluster Error Message: TZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.5.0 Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.https://xtbgdb1:1158/em/console/aboutApplicationStarting Oracle Enterprise Manager 10g Database Control ............................................................................................. failed. ------------------------------------------------------------------Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/xtbgdb1_xtbgdb1/sysman/log :failed
oracle.ops.mgmt.cluster.ClusterException: TZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.5.0 Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.https://xtbgdb1:1158/em/console/aboutApplicationStarting Oracle Enterprise Manager 10g Database Control ............................................................................................. failed. ------------------------------------------------------------------Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/xtbgdb1_xtbgdb1/sysman/log :failed
at oracle.ops.mgmt.cluster.ClusterCmd.runCmd(ClusterCmd.java:2085)
at oracle.sysman.emcp.util.ClusterUtil.runCmd(ClusterUtil.java:1165)
at oracle.sysman.emcp.util.PlatformInterface.executeEMCTL(PlatformInterface.java:1044)
at oracle.sysman.emcp.util.PlatformInterface.executeEMCTL(PlatformInterface.java:971)
at oracle.sysman.emcp.util.DBControlUtil.startOMS(DBControlUtil.java:158)
at oracle.sysman.emcp.EMDBPostConfig.performConfiguration(EMDBPostConfig.java:615)
at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:227)
at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:196)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:184)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:494)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1161)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:478)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:426)
May 30, 2011 3:44:24 PM oracle.sysman.emcp.util.PlatformInterface executeEMCTL
CONFIG: Executing 'emctl start dbconsole ' on node xtbgdb2 with sid xtbgdb2
May 30, 2011 3:47:34 PM oracle.sysman.emcp.util.PlatformInterface executeEMCTL
CONFIG: TZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.5.0 Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.https://xtbgdb1:1158/em/console/aboutApplicationStarting Oracle Enterprise Manager 10g Database Control ............................................................................................. failed. ------------------------------------------------------------------Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/xtbgdb2_xtbgdb2/sysman/log :failed
经过搜索发现是Oracle 在EM使用上的一个license过期的问题,需要应用8350262补丁。
补丁可以在这里下载,包括10.2.0.4p8350262_10204_Generic.zip和10.2.0.5
p8350262_10205_Generic.zip版本的补丁,平台是通用的。
下面是补丁的应用步骤:
Bugs Fixed by this patch:
-------------------------
8350262:CREATE DBCONSOLE CERT WITH 10YEAR VALIDITY
Patch Preinstall Steps:
-----------------------
1. For non-recommended patches, you must have the exact symptoms
described in the service request (SR).
2. Verify the OUI Inventory.
OPatch needs access to a valid OUI inventory to apply patches.
Validate the OUI inventory with the following command:
% opatch lsinventory
If the command errors out, contact Oracle Support and work to validate
and verify the inventory setup before proceeding.
3. Please use the latest Version of OPatch.
Oracle recommends that all customers be on the latest version of OPatch.
Please review the following metalink note and follow the instructions
to update to the latest version if needed:
https://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=224346.1
4. Confirm executables appear in your system PATH.
The patching process will use the unzip and the opatch executables. After
sourcing the ORACLE_HOME environment, confirm both of these exist before
continuing:
- "which opatch"
- "which unzip"
If either of these executables do not show in the PATH, correct the problem
before proceeding.
5. Create a location for storing the unzipped patch. This location
will be referred to later in the document as .
6. Unzip the patch zip file into the .
unzip -d p8350262_102050_Generic.zip
7. Shut down services running from the ORACLE_HOME.
Before applying this patch, do a clean shut down of all services
running from the ORACLE_HOME.
Patch Installation Steps:
-------------------------
1. Shutdown EM DB Console using the following command.
% $ORACLE_HOME/bin/emctl stop dbconsole
2. Set your current directory to the directory where the patch
is located:
% cd /8350262
Ensure that the directory containing the opatch script. appears in
your $PATH; then enter the following command:
% opatch apply
3. Start EM DB Console using the following command.
% $ORACLE_HOME/bin/emctl start dbconsole
NOTE:
------
There may be cases when Starting dbconsole may fail post 31-Dec-2010.
In this case, Please set ORACLE_HOME to your Database Home & ORACLE_SID
and run the following from the patch folder.
% ./killDBConsole
Patch Deinstallation Instructions:
----------------------------------
1. Shutdown EM DB Console using the following command.
% $ORACLE_HOME/bin/emctl stop dbconsole
2. Set your current directory to the directory where the patch
is located:
% cd /8350262
3. Ensure that the directory containing the opatch script. appears in
your $PATH; then run the following command:-
% opatch rollback -id 8350262
4. Start EM DB Console using the following command.
% $ORACLE_HOME/bin/emctl start dbconsole
如果启动不成功,我们可以尝试对EM进行重建:
1).删除EM(包括资料库):
emca -deconfig dbconsole db -repos drop -cluster
2).重建EM(包括资料库):
emca -config dbconsole db -repos create -cluster
下面贴出对该补丁的解释:
ATTENTION - Enterprise Manager Database Control 10.2.0.4 Or 10.2.0.5 - Patch Required from 31-Dec-2010 onwards (文档 ID 1217493.1)
修改时间:2013-5-13类型:ALERT
In this Document
Description |
What is the Issue? |
Occurrence |
What Versions Are Affected? |
Symptoms |
What Will Happen If You Fail to Apply the Patch? |
Workaround |
Who Should Apply the Patch? |
Patches |
History |
References |
APPLIES TO:
Oracle Database Configuration Assistant - Version 10.2.0.4 to 10.2.0.5 [Release 10.2]Oracle Database - Enterprise Edition - Version 10.2.0.4 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
Enterprise Manager Database Control 10.2.0.4, 10.2.0.5
***Checked for relevance on 14-Mar-2013***
DESCRIPTION
What is the Issue?
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 affected by this issue.
If you plan to configure Database Control with either of these Oracle Database releases, Oracle strongly recommends that you apply Patch 8350262 to 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.
OCCURRENCE
What Versions Are Affected?
- 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.
- The issue does not impact existing Database Control configurations.
- Application of Patch 8350262 will not require database downtime.
SYMPTOMS
What Will Happen If You Fail to Apply the Patch?
If you do not apply Patch 8350262 to your Oracle Home installation before you attempt to configure Database Control on or after 31-Dec-2010, you will encounter errors during the configuration process. See My Oracle Support Note 1222603.1 for instructions on recovering from the expected Database Control configuration errors.
WORKAROUND
Who Should Apply the Patch?
If you: | Oracle recommends that you: |
---|---|
Have an existing Oracle Database 10.2.0.4 or 10.2.0.5 installation and plan to configure or re-configure Database Control on or after 31-Dec-2010 Database Control is configured when using one of the following tools: - Database Configuration Assistant (DBCA) - Database Upgrade Assistant (DBUA) - Enterprise Manager Configuration Assistant (EMCA) | 1. Apply Patch 8350262 to the Oracle Home installation. This patch can be downloaded from My Oracle Support. 2. Configure or re-configure Database Control. If you are not able to apply Patch 8350262 before running DBUA, DBCA or EMCA, you will need to follow the steps outlined in My Oracle Support Note 1222603.1 to recover from the expected Database Control configuration errors. |
Plan to install Oracle Database 10.2.0.4 or 10.2.0.5 on or after 31-Dec-2010 and intend to configure Database Control Database Control is configured when using one of the following tools: - Database Configuration Assistant (DBCA) - Database Upgrade Assistant (DBUA) - Enterprise Manager Configuration Assistant (EMCA) | 1. Install Oracle Database patch set release 10.2.0.4 or 10.2.0.5 to your existing Oracle Home installation. 2. After applying the patch set, apply Patch 8350262 to the Oracle Home installation. This patch can be downloaded from My Oracle Support. 3. Configure Database Control. If you are not able to apply Patch 8350262 before running DBUA, DBCA or EMCA, you will need to follow the steps outlined in My Oracle Support Note 1222603.1 to recover from the expected Database Control configuration errors. |
NOTE: patch 8350262 is included in 10.2.0.5 database patch 5 and 10.2.0.5.3 (PSU3)
PATCHES
HISTORY
REFERENCES
NOTE:1222603.1 - Enterprise Manager Database Control Configuration - Recovering From Errors Due to CA Expiry on Oracle Database 10.2.0.4 or 10.2.0.5 [Video]
NOTE:342443.1 - 10.2.0.x Oracle Database and Networking Patches for Microsoft Platforms
NOTE:11724962.8 - Bug 11724962 - 10.2.0.5.3 Patch Set Update (PSU)
NOTE:753736.1 - Quick Reference to RDBMS Database Patchset Patch Numbers
--end--
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23135684/viewspace-696791/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23135684/viewspace-696791/