1、啟動dbconsole
[Oracle@www.bkjia.com ~]$ emctl start dbconsole
如果提示:OC4J Configuration issue. /opt/oracle/product/10.2.0/oc4j/j2ee/OC4J_DBConsol,則說明沒有配置或沒有建立
2、配置dbconsole
[oracle@www.bkjia.com ~]$ emca -config dbcontrol db
STARTED EMCA at Apr 21, 2009 2:21:41 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: orcl
Listener port number: 1521
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 ................ /opt/oracle/product/10.2.0
Database hostname ................ www.bkjia.com
Listener port number ................ 1521
Database SID ................ orcl
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Apr 21, 2009 2:23:52 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /opt/oracle/product/10.2.0/cfgtoollogs/emca/orcl/emca_2009-04-21_02-21-41-AM.log.
Apr 21, 2009 2:24:14 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Apr 21, 2009 2:24:35 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Apr 21, 2009 2:24:35 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Apr 21, 2009 2:26:15 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Apr 21, 2009 2:26:15 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://www.bkjia.com:5502/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 21, 2009 2:26:15 AM
3、查看dbconsole的狀態和訪問地址
[oracle@www.bkjia.com ~]$ emctl status dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://www.bkjia.com:5502/em/console/aboutApplication #訪問地址
Oracle Enterprise Manager 10g is running.
------------------------------------------------------------------
Logs are generated in directory /opt/oracle/product/10.2.0/www.bkjia.com_orcl/sysman/log
4、刪除資料庫的 Database Control配置
oracle@www.bkjia.com ~]$ emca -deconfig dbcontrol db
5、常用的命令文法:
emca -repos create建立一個EM資料庫
emca -repos recreate重建一個EM資料庫
emca -repos drop刪除一個EM資料庫
emca -config dbcontrol db設定資料庫的 Database Control
emca -deconfig dbcontrol db刪除資料庫的 Database Control配置
emca -reconfig ports 重新設定db control和agent的連接埠
emctl start console啟動EM console服務,使用前需要先設定ORACLE_SID環境變數
emctl stop console停止EM console服務,使用前需要先設定ORACLE_SID環境變數
註:通過查看$ORACLE_HOME/install/portlist.ini 檔案可以知道當前dbcontrol正在使用的連接埠,預設dbcontrol http連接埠1158,agent連接埠3938。如果要重新設定連接埠,可以使用如下命令:
emca -reconfig ports -dbcontrol_http_port 1159
emca -reconfig ports -agent_port 3939
使用命令列工具emctl可以啟動/停止console服務,察看服務狀態等。