探索ORACLE之11g DataGuard_04 Oracle EnterPrise Manager OEM部署

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20674423/viewspace-768616/，如需转载，请注明出处，否则将追究法律责任。