Database Control简介。
在Oracle10g开始,Oracle提供了网页形式的管理工具,Database Control。我们可以使用dbca在建库的时候指定安装Database Control。也可以在安装完数据库以后,通过调用emca来创建Database Control。个人认为Database Control的使用一方面方便了DBA对数据库的管理,另一方面由于消耗系统资源,而且大部分在Oracle提供的选项上进行选择,灵活度不够。可以算是好坏摻半把。
利用emca创建Database Control
所谓 repository是存放Database Control在数据库所用到的信息的多个表。在使用emca时必须先创建repository。注意在利用emca创建Database Control前必须确保监听程序能正常使用。
解锁并给dnsnmp用户设置密码
SQL> ALTER USER dnsnmp account unlock identified by dnsnmp;
确认没有sysman用户
SQL> drop user sysman cascade;
[oracle@db1 ~]$ emca -repos create
STARTED EMCA at May 23, 2011 4:35:44 PM
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 //数据库SID
Listener port number: 1521 //监听的端口号
Password for SYS user: //sys密码
Password for SYSMAN user: //sysman密码
Do you wish to continue? [yes(Y)/no(N)]: y
May 23, 2011 4:35:52 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/ORCL/emca_2011-05-23_04-35-44-PM.log.
May 23, 2011 4:35:53 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
May 23, 2011 4:39:30 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully //命令执行成功
FINISHED EMCA at May 23, 2011 4:39:30 PM
创建Database Control
[oracle@db1 ~]$ emca -config dbcontrol db
STARTED EMCA at May 23, 2011 4:43:04 PM
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 //数据库SID
Listener port number: 1521 //监听的端口号
Password for SYS user: //sys密码
Password for DBSNMP user: //DBSNMP用户的密码
Password for SYSMAN user: //sysman密码
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/10.2.0/db_1
Database hostname ................ db1
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
May 23, 2011 4:43:21 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/ORCL/emca_2011-05-23_04-43-04-PM.log.
May 23, 2011 4:43:40 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
May 23, 2011 4:45:27 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
May 23, 2011 4:45:27 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://db1:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully //命令执行成功
FINISHED EMCA at May 23, 2011 4:45:27 PM
利用emca删除Database Control
先删除Database Control
[oracle@db1 ~]$ emca -deconfig dbcontrol db
STARTED EMCA at May 23, 2011 4:35:28 PM
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 //数据库的SID
Do you wish to continue? [yes(Y)/no(N)]: y
May 23, 2011 4:35:31 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/ORCL/emca_2011-05-23_04-35-27-PM.log.
May 23, 2011 4:35:32 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed.
Enterprise Manager configuration completed successfully //命令执行成功
FINISHED EMCA at May 23, 2011 4:35:32 PM
删除repository
[oracle@db1 ~]$ emca -repos drop
STARTED EMCA at May 23, 2011 4:33:08 PM
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 //数据库SID
Listener port number: 1521 //监听的端口号
Password for SYS user: //sys密码
Password for SYSMAN user: //sysman密码
Do you wish to continue? [yes(Y)/no(N)]: y
May 23, 2011 4:33:16 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/ORCL/emca_2011-05-23_04-33-08-PM.log.
May 23, 2011 4:33:16 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
May 23, 2011 4:34:42 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully //命令执行成功
FINISHED EMCA at May 23, 2011 4:34:42 PM
删除数据库中没有删除的对象
drop user sysman cascade;
drop role MGMT_USER;
drop user MGMT_VIEW cascade;
drop public synonym MGMT_TARGET_BLACKOUTS;
drop public synonym SETEMVIEWUSERCONTEXT;
其他Database Control相关命令
emca -reconfig ports -dbcontrol_http_port 1160 //修改EM登录端口为1160
emca -reconfig ports -agent_port 3940 //修改agent登录端口为3940
emctl start dbconsole //启动Database Control
emctl status dbconsole //查看Database Control 状态
emctl stop dbconsole //关闭Database Control
emca -config dbcontrol db -repos create -cluster // 创建集群em
emca -deconfig dbcontrol db -repos drop -cluster //删除集群em
emca -displayConfig dbcontrol -cluster //检查em集群配置
cat $ORACLE_HOME/install/portlist.ini //em工具访问信息
$ cat /u01/app/oracle/product/11.2.0/db_1/install/portlist.ini
Enterprise Manager Console HTTP Port (racdb) = 1158
Enterprise Manager Agent Port (racdb) = 3938
Enterprise Manager Console HTTP Port (prd) = 5500
Enterprise Manager Agent Port (prd) = 1830
参考至:《教你如何成10gOCP》
http://oracle.chinaitlab.com/optimize/757535.html
http://blog.csdn.net/jxzkin/article/details/8032602
http://soft.chinabyte.com/database/371/12338871.shtml
本文原创,转载请注明出处、作者
如有错误,欢迎指正
邮箱:czmcj@163.com