oracle之EMCA

oracle中安装em有三种方法
Oracle Universal Installer (OUI)
Oracle Database Configuration Assistant (DBCA)
Enterprise Manager Configuration Assistant (EMCA)
前两种是在图形化界面中安装，最后一种是纯命令安装
这里我们就看一下emca的用法：

一、卸载 EM Database Control
[oracle@odd-PROD1 ~]$ emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Nov 2, 2016 2:17:58 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.


Enter the following information:
Database SID: PROD1
Listener port number: 1521
Password for SYS user:  
Password for SYSMAN user:  


----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Nov 2, 2016 2:18:21 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/PROD1/emca_2016_11_02_14_17_57.log.
Nov 2, 2016 2:18:22 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Nov 2, 2016 2:18:27 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Nov 2, 2016 2:21:11 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Nov 2, 2016 2:21:18 PM




二、创建和配置EM Database Control
[oracle@odd-PROD1 ~]$ emca -config dbcontrol db -repos create


STARTED EMCA at Nov 2, 2016 2:25:18 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.


Enter the following information:
Database SID: PROD1
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]: /u01/app/oracle/product/11.2.0/dbhome_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 ................ /u01/app/oracle/product/11.2.0/dbhome_1


Local hostname ................ odd.oracle.com
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1
Listener port number ................ 1521
Database SID ................ PROD1
Email address for notifications ............... 
Outgoing Mail (SMTP) server for notifications ............... 


-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Nov 2, 2016 2:26:48 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/PROD1/emca_2016_11_02_14_25_18.log.
Nov 2, 2016 2:26:49 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Nov 2, 2016 2:32:11 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Nov 2, 2016 2:32:19 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Nov 2, 2016 2:33:17 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Nov 2, 2016 2:33:18 PM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for odd.oracle.com
Nov 2, 2016 2:33:23 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Nov 2, 2016 2:33:40 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Nov 2, 2016 2:33:40 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Nov 2, 2016 2:34:27 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Nov 2, 2016 2:34:27 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://odd.oracle.com:1158/em <<<<<<<<<<<
Nov 2, 2016 2:34:35 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: /u01/app/oracle/product/11.2.0/dbhome_1/odd.oracle.com_PROD1/sysman/config/emkey.ora. 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 Nov 2, 2016 2:34:35 PM


此时可以打开网页







已经进入em

三、em的开启与关闭
停止em控制台服务
[oracle@odd-PROD1 ~]$ emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://odd.oracle.com:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 11g Database Control ... 
 ...  Stopped. 
开启em控制台服务
[oracle@odd-PROD1 ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://odd.oracle.com:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ....... started. 
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/odd.oracle.com_PROD1/sysman/log 
查看em控制台服务的状态
[oracle@odd-PROD1 ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://odd.oracle.com:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running. 
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/odd.oracle.com_PROD1/sysman/log 


其他一些emca的命令（这里不一一演示）
创建em资料库
emca -repos create
删除em资料库
emca -repos drop
重建em资料库
emca -repos recreate
配置dbcontrol
emca -config dbcontrol db
删除dbcontrol的配置
emca -deconfig dbcontrol db

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

转载于:http://blog.itpub.net/31386161/viewspace-2127519/