探索ORACLE之11g DataGuard_04 Oracle EnterPrise Manager OEM部署
作者：吴伟龙
我们可以看到EM这个时候无法起来，需要重新配置：
emctl startup console Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.
重新配置 Oracle EnterPrise Manager
[oracle@pri ~]$ emca -config dbcontrol db -repos recreate STARTED EMCA at May 21, 2013 10:58:04 PM EM Configuration Assistant, Version 11.2.0.0.2 Production Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID: Woo Listener port number: 1521 Listener ORACLE_HOME [ /DBSoft/Product/11.2.0/db_1 ]: Password for SYS user: Password for DBSNMP user: Password for SYSMAN user: Email address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): ----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /DBSoft/Product/11.2.0/db_1 Local hostname ................ pri Listener ORACLE_HOME ................ /DBSoft/Product/11.2.0/db_1 Listener port number ................ 1521 Database SID ................ Woo Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: y May 21, 2013 10:59:07 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /DBSoft/cfgtoollogs/emca/PRI/emca_2013_05_21_22_58_03.log. May 21, 2013 10:59:08 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Dropping the EM repository (this may take a while) ... May 21, 2013 11:01:35 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully dropped May 21, 2013 11:01:35 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... May 21, 2013 11:06:35 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created May 21, 2013 11:06:42 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository INFO: Uploading configuration data to EM repository (this may take a while) ... May 21, 2013 11:07:48 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Uploaded configuration data successfully May 21, 2013 11:07:49 PM oracle.sysman.emcp.ParamsManager getLocalListener WARNING: Error retrieving listener for pri May 21, 2013 11:07:52 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib INFO: Software library configured successfully. May 21, 2013 11:07:52 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary INFO: Deploying Provisioning archives ... May 21, 2013 11:08:27 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary INFO: Provisioning archives deployed successfully. May 21, 2013 11:08:27 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Securing Database Control (this may take a while) ... May 21, 2013 11:08:42 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Database Control secured successfully. May 21, 2013 11:08:42 PM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... May 21, 2013 11:09:51 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: Database Control started successfully May 21, 2013 11:09:57 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: >>>>>>>>>>> The Database Control URL is https://pri:1158/em <<<<<<<<<<< May 21, 2013 11:10:31 PM oracle.sysman.emcp.EMDBPostConfig invoke WARNING: ************************ WARNING ************************ Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: /DBSoft/Product/11.2.0/db_1/pri_PRI/sysman/config/emkey.ora. Please ensure this file is backed up as the encrypted data will become unusable if this file is lost. *********************************************************** Enterprise Manager configuration completed successfully FINISHED EMCA at May 21, 2013 11:10:32 PM
这样我们可以看到EM已经配置成功
Oracle EnterPrise Manager 常用管理
--创建一个EM资料库 emca -repos create --重建一个EM资料库 emca -repos recreate --删除一个EM资料库 emca -repos drop --配置数据库的 Database Control emca -config dbcontrol db --删除数据库的 Database Control配置 emca -deconfig dbcontrol db --重新配置db control的端口，默认端口在1158 emca -reconfig ports emca -reconfig ports -dbcontrol_http_port 1160 emca -reconfig ports -agent_port 3940 --先设置ORACLE_SID环境变量后,启动EM console服务 emctl start dbconsole --先设置ORACLE_SID环境变量后,停止EM console服务 emctl stop dbconsole --先设置ORACLE_SID环境变量后,查看EM console服务的状态 emctl status dbconsole --配置dbconsole的步骤 emca -repos create emca -config dbcontrol db emctl start dbconsole --重新配置dbconsole的步骤 emca -repos drop emca -repos create emca -config dbcontrol db emctl start dbconsole
