emctl[@more@]

Oracle10G的EM採用了方式，並且分成了2個產品，database control和grid control。這裡主要介紹如何建立單資料的dbcontrol。Grid control需要下載單獨的光碟。

在用DBCA建庫的時候，可以選擇是否啟用dbcontrol，啟用的話需要在中建立一個sysman的schema，用於儲存EM的一些資料，這個就是EM的資料庫(repository)。

使用命令列工具emca可以建立，修改，重建或者刪除dbcontrol的配置。

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Database Enterprise Edition Release 10.2.0.1.0 - Prod

PL/SQL Release 10.2.0.1.0 - Production

CORE 10.2.0.1.0 Production

TNS for Linux: Version 10.2.0.1.0 - Production

NLSRTL Version 10.2.0.1.0 - Production

SQL>

由於要在資料庫中建EM資料庫，資料庫和監聽都必須已經啟動並正常工作。

配置dbcontrol

[oracle@oracle10 ~]$ emca -config dbcontrol db

STARTED EMCA at Oct 27, 2007 9:33:48 AM

EM Configuration Assistant, Version 10.2.0.1.0 Production

Enter the following information:

Database SID: orcl

Database Control is already configured for the database orcl

You have chosen to configure Database Control for managing the database orcl

This will remove the existing configuration and the default settings and perform. a fresh configuration

Do you wish to continue? [yes(Y)/no(N)]: Y

Listener port number: 1521

Password for SYS user:

Password for DBSNMP user:

Password for SYSMAN user:

Email address for notifications (optional):

Outgoing Mail (SMTP) for notifications (optional):

-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /opt/oracle/product/10.2.0/Database

Database hostname ................ oracle10

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

Oct 27, 2007 9:35:12 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /opt/oracle/product/10.2.0/Database/cfgtoollogs/emca/orcl/emca_2007-10-27_09-33-46-AM.log.

Oct 27, 2007 9:35:33 AM oracle.sysman.emcp.util.DBControlUtil stopOMS

INFO: Stopping Database Control (this may take a while) ...

Oct 27, 2007 9:36:39 AM oracle.sysman.emcp.ParamsManager getLocalListener

WARNING: Error retrieving listener for oracle10

Oct 27, 2007 9:36:54 AM oracle.sysman.emcp.util.DBControlUtil startOMS

INFO: Starting Database Control (this may take a while) ...

Oct 27, 2007 9:39:51 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: Database Control started successfully

Oct 27, 2007 9:39:53 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: >>>>>>>>>>> The Database Control URL is<<<<<<<<<<<

Enterprise Manager configuration completed successfully

FINISHED EMCA at Oct 27, 2007 9:39:53 AM

[oracle@oracle10 ~]$

刪除資料庫的Database Control配置

[oracle@oracle10 ~]$ emca -deconfig dbcontrol db

STARTED EMCA at Oct 27, 2007 10:44:24 AM

EM Configuration Assistant, Version 10.2.0.1.0 Production

Enter the following information:

Database SID: orcl

Do you wish to continue? [yes(Y)/no(N)]: Y

Oct 27, 2007 10:44:47 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /opt/oracle/product/10.2.0/Database/cfgtoollogs/emca/orcl/emca_2007-10-27_10-44-22-AM.log.

Oct 27, 2007 10:44:52 AM oracle.sysman.emcp.util.DBControlUtil stopOMS

INFO: Stopping Database Control (this may take a while) ...

Oct 27, 2007 10:48:13 AM oracle.sysman.emcp.EMReposConfig stopDBMSJobs

WARNING: Error initializing connection. SQL operations cannot be performed

Oct 27, 2007 10:48:13 AM oracle.sysman.emcp.EMReposConfig invoke

WARNING: Unable to remove DBMS jobs.

Enterprise Manager configuration completed successfully

FINISHED EMCA at Oct 27, 2007 10:51:01 AM

[oracle@oracle10 ~]$

此時執行emctl命令的顯示是：

[oracle@oracle10 ~]$ emctl status dbconsole

TZ set to PRC

OC4J Configuration issue. /opt/oracle/product/10.2.0/Database/oc4j/j2ee/OC4J_DBConsole_oracle10_orcl not found.

常用的命令語法：

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服務，察看服務狀態等。

oracle emctl 報錯

相關文章