探索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@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