创建一个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
-------------
oracle从10g以来一直大力推荐dba通过EM来进行管理,不管个人的喜好如何,都不能否认EM还是具有很强的易用性的。
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=oratest)(PORT=1521))
)
EM Configuration Assistant, Version 11.1.0.5.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Database SID: test11g
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user: Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------
Listener port number ................ 1521
Database SID ................ test11g
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
Do you wish to continue? [yes(Y)/no(N)]: Y
Aug 29, 2007 8:41:20 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle11g/cfgtoollogs/emca/test11g/emca_2007_08_29_08_40_56.log.
Aug 29, 2007 8:41:30 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Aug 29, 2007 8:50:26 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Aug 29, 2007 8:50:28 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Aug 29, 2007 9:16:21 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Aug 29, 2007 9:17:05 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Aug 29, 2007 9:20:57 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfullyAug 29, 2007 9:21:22 AM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Aug 29, 2007 9:21:22 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Aug 29, 2007 9:26:27 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Aug 29, 2007 9:26:27 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Aug 29, 2007 9:27:34 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Aug 29, 2007 9:27:34 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Aug 29, 2007 9:36:05 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Aug 29, 2007 9:36:08 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://oratest:1158/em <<<<<<<<<<<
Aug 29, 2007 9:37:50 AM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************ WARNING ************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Aug 29, 2007 9:37:51 AM
$ more /oracle11g/product/11g/oratest_test11g/sysman/config/emkey.ora
KEY=056790FE22685160158605895E3E62FC06D7C153C224D99BAA82236AD677DD962B974B3BDA0A678E9D8278C75662EFEB5A8EB793695A79C131F79B8F8BDBBD03
80955F67D1BFBE675F5E20B9DC6B710A92
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/653579/viewspace-1021945/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/653579/viewspace-1021945/