一次配置oracle em的經曆

標籤：oracle   rac   em   

對oracle10grac配置em，原本是非常簡單的事，卻花費了很長時間，記錄下來，備忘。

首先是報如下錯誤：

[[email protected] admin]$ emca -config dbcontrol dbSTARTED EMCA at Aug 17, 2014 9:06:47 AMEM Configuration Assistant, Version 10.2.0.5.0 ProductionCopyright (c) 2003, 2009, Oracle.  All rights reserved.Enter the following information:Database SID: racdb1Listener port number: 1521Password for SYS user:  Password for DBSNMP user:  Aug 17, 2014 9:06:57 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineWARNING: ORA-28000: the account is lockedPassword for SYSMAN user:  Aug 17, 2014 9:07:02 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineWARNING: ORA-28000: the account is lockedEmail address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): ASM ORACLE_HOME [ /u01/app/oracle/product/11.2.0/db ]: ASM SID [ +ASM ]: ASM port [ 1521 ]: ASM user role [ SYSDBA ]: ASM username [ SYS ]: ASM user password:  ASM user password:  -----------------------------------------------------------------You have specified the following settingsDatabase ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbLocal hostname ................ node1Listener port number ................ 1521Database SID ................ racdb1Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ASM ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbASM SID ................ +ASMASM port ................ 1521ASM user role ................ SYSDBAASM username ................ SYS-----------------------------------------------------------------Do you wish to continue? [yes(Y)/no(N)]: yAug 17, 2014 9:12:22 AM oracle.sysman.emcp.EMConfig performINFO: This operation is being logged at /u01/app/oracle/product/11.2.0/db/cfgtoollogs/emca/racdb/emca_2014-08-17_09-06-47-AM.log.Aug 17, 2014 9:12:34 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsoleINFO: Securing Database Control (this may take a while) ...Aug 17, 2014 9:13:01 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsoleINFO: Database Control secured successfully.Aug 17, 2014 9:13:01 AM oracle.sysman.emcp.util.DBControlUtil startOMSINFO: Starting Database Control (this may take a while) ...Aug 17, 2014 9:17:40 AM oracle.sysman.emcp.util.PlatformInterface executeCommandWARNING: Error executing /u01/app/oracle/product/11.2.0/db/bin/emctl start dbconsole Aug 17, 2014 9:17:40 AM oracle.sysman.emcp.EMConfig performSEVERE: Error starting Database ControlRefer to the log file at /u01/app/oracle/product/11.2.0/db/cfgtoollogs/emca/racdb/emca_2014-08-17_09-06-47-AM.log for more details.Could not complete the configuration. Refer to the log file at /u01/app/oracle/product/11.2.0/db/cfgtoollogs/emca/racdb/emca_2014-08-17_09-06-47-AM.log for more details.

[[email protected] ~]# cat /u01/app/oracle/product/11.2.0/db/cfgtoollogs/emca/racdb/emca_2014-08-17_09-06-47-AM.log 

Aug 17, 2014 9:17:40 AM oracle.sysman.emcp.EMConfig performCONFIG: Stack Trace: oracle.sysman.emcp.exception.EMConfigException: Error starting Database Controlat oracle.sysman.emcp.EMDBPostConfig.performConfiguration(EMDBPostConfig.java:649)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)

網上查資料，是oracle的bug。

Oracle對此的解釋是：

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.

 

可以查看：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] [ID 1222603.1]

解決方案：

如果是在建立執行個體前就已經打了這個patch的話，那之後就不會報錯了。如果是在建立執行個體之後才打的這個patch，那麼需要執行以下：

對於單一實例：
1.使用Opatch安裝Patch 8350262
2.設定ORACLE_HOME and ORACLE_SID 環境變數，執行 <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


對於RAC：
1.使用Opatch安裝Patch 8350262, 在一個節點安裝就ok了。
2.在所有節點執行：設定ORACLE_HOME and ORACLE_SID 環境變數，執行 <PATCH_HOME>/killDBConsole.(windows 平台省略這一步)
3.Re-secure Database Control on the first cluster node with the following command:
<ORACLE_HOME>/bin/emctl secure dbconsole -reset
4.Re-secure Database Control on the remaining cluster nodes with 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 command on each node in the cluster:
<ORACLE_HOME>/bin/emctl start dbconsole

打補丁後，清除並建立em，各種報錯，無奈下手工刪除各種資料：

Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> DROP public synonym SETEMVIEWUSERCONTEXT;Synonym dropped.SQL> DROP PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;Synonym dropped.SQL> drop role MGMT_USER;Role dropped.SQL> DROP USER MGMT_VIEW CASCADE;DROP USER MGMT_VIEW CASCADE          *ERROR at line 1:ORA-01918: user 'MGMT_VIEW' does not existSQL> DROP USER SYSMAN CASCADE;User dropped.SQL> exit

之後建立em成功，

[[email protected] ~]$ emca -config dbcontrol db -repos createSTARTED EMCA at Aug 17, 2014 2:58:04 PMEM Configuration Assistant, Version 10.2.0.5.0 ProductionCopyright (c) 2003, 2009, Oracle.  All rights reserved.Enter the following information:Database SID: racdb1Listener port number: 1521Password for SYS user:  Password for DBSNMP user:  Password for SYSMAN user:  Email address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): ASM ORACLE_HOME [ /u01/app/oracle/product/11.2.0/db ]: ASM SID [ +ASM ]: +ASM1ASM port [ 1521 ]: ASM user role [ SYSDBA ]:       ASM username [ SYS ]: ASM user password:  -----------------------------------------------------------------You have specified the following settingsDatabase ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbLocal hostname ................ node1Listener port number ................ 1521Database SID ................ racdb1Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ASM ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbASM SID ................ +ASM1ASM port ................ 1521ASM user role ................ SYSDBAASM username ................ SYS-----------------------------------------------------------------Do you wish to continue? [yes(Y)/no(N)]: yAug 17, 2014 2:58:32 PM oracle.sysman.emcp.EMConfig performINFO: This operation is being logged at /u01/app/oracle/product/11.2.0/db/cfgtoollogs/emca/racdb/emca_2014-08-17_02-58-04-PM.log.Aug 17, 2014 2:58:34 PM oracle.sysman.emcp.EMReposConfig createRepositoryINFO: Creating the EM repository (this may take a while) ...Aug 17, 2014 3:02:14 PM oracle.sysman.emcp.EMReposConfig invokeINFO: Repository successfully createdAug 17, 2014 3:02:24 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsoleINFO: Securing Database Control (this may take a while) ...Aug 17, 2014 3:02:50 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsoleINFO: Database Control secured successfully.Aug 17, 2014 3:02:50 PM oracle.sysman.emcp.util.DBControlUtil startOMSINFO: Starting Database Control (this may take a while) ...Aug 17, 2014 3:04:27 PM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: Database Control started successfullyAug 17, 2014 3:04:27 PM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: >>>>>>>>>>> The Database Control URL is https://node1:1158/em <<<<<<<<<<<Enterprise Manager configuration completed successfullyFINISHED EMCA at Aug 17, 2014 3:04:27 PM

登陸之後，發現不是rac的em，重新設定

[[email protected] dbs]$ cd /u01/app/crs_home/bin[[email protected] bin]$ ./cemutlo -ncrs[[email protected] bin]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Sun Aug 17 17:18:28 2014Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> show parameter nameNAME     TYPE VALUE------------------------------------ ----------- ------------------------------db_file_name_convert     stringdb_name      string racdbdb_unique_name     string racdbglobal_names     boolean TRUEinstance_name     string racdb1lock_name_space      stringlog_file_name_convert     stringservice_names     string service1, SYS$ADMIN.TARGET_QUE UE.RACDB.EPOINT.COM, service2,  racdb.epoint.comSQL> 

[[email protected] dbs]$ emca -config dbcontrol db -repos create -clusterSTARTED EMCA at Aug 17, 2014 5:02:15 PMEM Configuration Assistant, Version 10.2.0.5.0 ProductionCopyright (c) 2003, 2009, Oracle.  All rights reserved.Enter the following information:Database unique name: racdbDatabase Control is already configured for the database racdbYou have chosen to configure Database Control for managing the database racdbThis will remove the existing configuration and the default settings and perform a fresh configurationDo you wish to continue? [yes(Y)/no(N)]: yListener port number: 1521Cluster name: crsPassword for SYS user:  Password for DBSNMP user:  Password for SYSMAN user:  Email address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): ASM ORACLE_HOME [ /u01/app/oracle/product/11.2.0/db ]: ASM port [ 1521 ]: ASM user role [ SYSDBA ]: ASM username [ SYS ]: ASM user password:  -----------------------------------------------------------------You have specified the following settingsDatabase ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbDatabase instance hostname ................ node1Listener port number ................ 1521Cluster name ................ crsDatabase unique name ................ racdbEmail address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ASM ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbASM port ................ 1521ASM user role ................ SYSDBAASM username ................ SYS-----------------------------------------------------------------Do you wish to continue? [yes(Y)/no(N)]: yAug 17, 2014 5:02:38 PM oracle.sysman.emcp.EMConfig performINFO: This operation is being logged at /u01/app/oracle/product/11.2.0/db/cfgtoollogs/emca/racdb/emca_2014-08-17_05-02-15-PM.log.Aug 17, 2014 5:02:40 PM oracle.sysman.emcp.util.DBControlUtil stopOMSINFO: Stopping Database Control (this may take a while) ...Aug 17, 2014 5:02:44 PM oracle.sysman.emcp.EMReposConfig createRepositoryINFO: Creating the EM repository (this may take a while) ...Aug 17, 2014 5:05:22 PM oracle.sysman.emcp.EMReposConfig invokeINFO: Repository successfully createdAug 17, 2014 5:05:27 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFilesINFO: Propagating /u01/app/oracle/product/11.2.0/db/oc4j/j2ee/OC4J_DBConsole_node1_racdb1 to remote nodes ...Aug 17, 2014 5:05:28 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFilesINFO: Propagating /u01/app/oracle/product/11.2.0/db/oc4j/j2ee/OC4J_DBConsole_node2_racdb2 to remote nodes ...Aug 17, 2014 5:05:28 PM oracle.sysman.emcp.EMDBCConfig copyAndPropagateOC4JDirINFO: Propagating /u01/app/oracle/product/11.2.0/db/oc4j/j2ee/isqlplus_node1 to remote nodes ...Aug 17, 2014 5:05:29 PM oracle.sysman.emcp.EMDBCConfig copyAndPropagateOC4JDirINFO: Propagating /u01/app/oracle/product/11.2.0/db/oc4j/j2ee/isqlplus_node2 to remote nodes ...Aug 17, 2014 5:05:34 PM oracle.sysman.emcp.EMAgentConfig deployStateDirsINFO: Propagating /u01/app/oracle/product/11.2.0/db/node1_racdb1 to remote nodes ...Aug 17, 2014 5:05:37 PM oracle.sysman.emcp.EMAgentConfig deployStateDirsINFO: Propagating /u01/app/oracle/product/11.2.0/db/node2_racdb2 to remote nodes ...Aug 17, 2014 5:05:38 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsoleINFO: Securing Database Control (this may take a while) ...Aug 17, 2014 5:06:30 PM oracle.sysman.emcp.util.DBControlUtil startOMSINFO: Starting Database Control (this may take a while) ...Aug 17, 2014 5:08:26 PM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: Database Control started successfullyAug 17, 2014 5:08:26 PM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: >>>>>>>>>>> The Database Control URL is https://node1:1158/em <<<<<<<<<<<Aug 17, 2014 5:08:41 PM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessageINFO: ****************  Current Configuration  **************** INSTANCE            NODE           DBCONTROL_UPLOAD_HOST----------        ----------        ---------------------racdb1            node1             node1racdb2            node2             node1Enterprise Manager configuration completed successfullyFINISHED EMCA at Aug 17, 2014 5:08:41 PM

其他問題：

如果drop repos特別慢，可以嘗試如下語句：alter system unquiesce;