原文链接:http://blog.oracle.com.cn/index.php?action/viewspace/itemid/34325
D:\Documents and Settings\xxx>emca
E:\oracle\product\10.2.0\db_1\bin\emca.bat [操作] [模式] [数据库类型] [标记] [参数]-h | –h | -help | –help: 打印此帮助消息-version: 打印版本-config dbcontrol db [-repos (create | recreate)] [-cluster] [-silent] [-backup]
[参数]: 配置数据库的 Database Control
-config centralAgent (db | asm) [-cluster] [-silent] [参数]: 配置中心代理管理
-config all db [-repos (create | recreate)] [-cluster] [-silent] [-backup] [参数]: 配置 Database Control 和中心代理管理
-deconfig dbcontrol db [-repos drop] [-cluster] [-silent] [参数]: 取消配置 Database Control
-deconfig centralAgent (db | asm) [-cluster] [ -silent] [参数]: 取消配置中心代理管理
-deconfig all db [-repos drop] [-cluster] [-silent] [参数]: 取消配置 Database Control 和中心代理管理
-addInst (db | asm) [-silent] [参数]: 为新的 RAC 实例配置 EM
-deleteInst (db | asm) [-silent] [参数]: 取消为指定的 RAC 实例配置 EM
-reconfig ports [-cluster] [参数]: 重新明确分配 Database Control 端口
-reconfig dbcontrol -cluster [-silent] [参数]: 重新配置 RAC Database Control 部署
-displayConfig dbcontrol -cluster [-silent] [参数]: 显示有关 RAC Database Control 配置的信息
-upgrade (db | asm | db_asm) [-cluster] [-silent] [参数]: 将较低版本的 EM 配置升级到当前版本
-restore (db | asm | db_asm) [-cluster] [-silent] [参数]: 将当前版本的 EM 配置复原到较低版本
参数和选项:
[参数]: [ -respFile 文件名 ] [ -paramName paramValue ]*
db: 对数据库 (包括使用 ASM 的数据库) 执行配置操作
asm: 仅对 ASM 实例执行配置操作
db_asm: 对数据库和 ASM 实例执行升级/复原操作
-repos create: 创建新的 Database Control 资料档案库
-repos drop: 删除当前的 Database Control 资料档案库
-repos recreate: 删除当前的 Database Control 资料档案库并重新创建一个
-cluster: 对 RAC 数据库执行配置操作
-silent: 在不提示参数的情况下执行配置操作
-backup: 配置数据库的自动备份
单实例数据库的参数
HOST: 数据库主机名
SID: 数据库 SID
PORT: 监听程序端口号
ORACLE_HOME: 数据库 ORACLE_HOME
HOST_USER: 自动备份的主机用户名
HOST_USER_PWD: 自动备份的主机用户口令
BACKUP_SCHEDULE: 自动备份调度 (HH:MM)
EMAIL_ADDRESS: 通知的电子邮件地址
MAIL_SERVER_NAME: 通知的发件 (SMTP) 服务器
ASM_OH: ASM ORACLE_HOME
ASM_SID: ASM SID
ASM_PORT: ASM 端口
ASM_USER_ROLE: ASM 用户角色
ASM_USER_NAME: ASM 用户名
ASM_USER_PWD: ASM 用户口令
SRC_OH: 要升级的数据库的 ORACLE_HOME
DBSNMP_PWD: DBSNMP 用户的口令
SYSMAN_PWD: SYSMAN 用户的口令
SYS_PWD: SYS 用户的口令
DBCONTROL_HTTP_PORT: Database Control HTTP 端口
AGENT_PORT: EM 代理端口
RMI_PORT: Database Control 的 RMI 端口
JMS_PORT: Database Control 的 JMS 端口
集群数据库的其它参数
CLUSTER_NAME: 集群名
DB_UNIQUE_NAME: 数据库的唯一名称
SERVICE_NAME: 服务名
EM_NODE: Database Control 节点名
EM_SID_LIST: 代理 SID 列表 [以逗号分隔]
启动报错
testhost:{/oracle}$emctl start dbconsole
OC4J Configuration issue. /oracle/app/oracle/product/10.2/oc4j/j2ee/OC4J_DBConsole_testhost_testdb not found.
删除
testhost:{/oracle/app/oracle/product/10.2/network/admin}$emca -repos drop
STARTED EMCA at Oct 20, 2008 3:08:52 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: testdb
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y
Oct 20, 2008 3:09:04 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/app/oracle/product/10.2/cfgtoollogs/emca/testdb/emca_2008-10-20_03-08-52-PM.log.
Oct 20, 2008 3:09:04 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) …
Oct 20, 2008 3:09:46 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Oct 20, 2008 3:09:46 PM
testhost:{/oracle/app/oracle/product/10.2/network/admin}$
创建
testhost:{/oracle}$emca -repos create
STARTED EMCA at Oct 20, 2008 3:10:47 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: testdb
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y
Oct 20, 2008 3:10:58 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/app/oracle/product/10.2/cfgtoollogs/emca/testdb/emca_2008-10-20_03-10-47-PM.log.
Oct 20, 2008 3:10:58 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) …
Oct 20, 2008 3:12:27 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Oct 20, 2008 3:12:27 PM
配置
testhost:{/oracle}$emca -config dbcontrol db
STARTED EMCA at Oct 20, 2008 3:13:13 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: testdb
Database Control is already configured for the database testdb
You have chosen to configure Database Control for managing the database testdb
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) server for notifications (optional):
—————————————————————–
You have specified the following settings
Database ORACLE_HOME ……………. /oracle/app/oracle/product/10.2
Database hostname ……………. testhost
Listener port number ……………. 1521
Database SID ……………. testdb
Email address for notifications ……………
Outgoing Mail (SMTP) server for notifications ……………
—————————————————————–
Do you wish to continue? [yes(Y)/no(N)]: y
Oct 20, 2008 3:13:43 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/app/oracle/product/10.2/cfgtoollogs/emca/testdb/emca_2008-10-20_03-13-13-PM.log.
Oct 20, 2008 3:13:45 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) …
Oct 20, 2008 3:13:52 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) …
Oct 20, 2008 3:14:24 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Oct 20, 2008 3:14:24 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) …
Oct 20, 2008 3:16:05 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Oct 20, 2008 3:16:05 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL ishttps://testhost:1158/em<<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Oct 20, 2008 3:16:05 PM
ORACLE RAC数据库
删除
testhost1:{/oracle}$emca -repos drop -cluster
STARTED EMCA at Oct 20, 2008 4:07:33 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database unique name: nmyzdb
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y
Oct 20, 2008 4:07:48 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/app/oracle/product/10.2/cfgtoollogs/emca/nmyzdb/emca_2008-10-20_04-07-33-PM.log.
Oct 20, 2008 4:07:50 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) …
删除的时候会整体锁住数据库，对数据库的任何访问都没有反应，因此手工中断了删除
创建
testhost1:{/oracle}$emca -repos create -cluster
STARTED EMCA at Oct 20, 2008 4:24:30 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database unique name: nmyzdb
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user: ge
Do you wish to continue? [yes(Y)/no(N)]: y
Oct 20, 2008 4:24:57 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/app/oracle/product/10.2/cfgtoollogs/emca/nmyzdb/emca_2008-10-20_04-24-30-PM.log.
Oct 20, 2008 4:24:59 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) …
Oct 20, 2008 4:28:31 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Oct 20, 2008 4:28:31 PM
testhost1:{/oracle}$
配置
testhost1:{/oracle}$emca -config dbcontrol db -cluster
STARTED EMCA at Oct 20, 2008 4:32:26 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database unique name: nmyzdb
Listener port number: 1521
Cluster name: nmyzdb
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 ……………. /oracle/app/oracle/product/10.2
Database instance hostname ……………. testhost1
Listener port number ……………. 1521
Cluster name ……………. nmyzdb
Database unique name ……………. nmyzdb
Email address for notifications ……………
Outgoing Mail (SMTP) server for notifications ……………
—————————————————————–
Do you wish to continue? [yes(Y)/no(N)]: y
Oct 20, 2008 4:33:03 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/app/oracle/product/10.2/cfgtoollogs/emca/nmyzdb/emca_2008-10-20_04-32-26-PM.log.
Oct 20, 2008 4:33:08 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /oracle/app/oracle/product/10.2/oc4j/j2ee/OC4J_DBConsole_testhost1_testdb1 to remote nodes …
Oct 20, 2008 4:33:08 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /oracle/app/oracle/product/10.2/oc4j/j2ee/OC4J_DBConsole_testhost2_testdb2 to remote nodes …
Oct 20, 2008 4:33:09 PM oracle.sysman.emcp.EMDBCConfig copyAndPropagateOC4JDir
INFO: Propagating /oracle/app/oracle/product/10.2/oc4j/j2ee/isqlplus_testhost1 to remote nodes …
Oct 20, 2008 4:33:10 PM oracle.sysman.emcp.EMDBCConfig copyAndPropagateOC4JDir
INFO: Propagating /oracle/app/oracle/product/10.2/oc4j/j2ee/isqlplus_testhost2 to remote nodes …
Oct 20, 2008 4:33:13 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /oracle/app/oracle/product/10.2/testhost1_testdb1 to remote nodes …
Oct 20, 2008 4:33:15 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /oracle/app/oracle/product/10.2/testhost2_testdb2 to remote nodes …
Oct 20, 2008 4:33:16 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) …
Oct 20, 2008 4:34:55 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) …
Oct 20, 2008 4:36:48 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Oct 20, 2008 4:36:48 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL ishttps://testhost1:1158/em<<<<<<<<<<<
Oct 20, 2008 4:36:48 PM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO:
**************** Current Configuration ****************
INSTANCE NODE DBCONTROL_UPLOAD_HOST
———- ———- ———————
testdb1 testhost1 testhost
testdb2 testhost2 testhost
Enterprise Manager configuration completed successfully
FINISHED EMCA at Oct 20, 2008 4:36:48 PM
数据库的端口修改后，需要修改以下的文件中的端口号，em才能访问：
如果是RAC，那么两台机器都需要改
/oracle/app/oracle/product/10.2/testhost1_testdb1/sysman/config/emoms.properties
/oracle/app/oracle/product/10.2/testhost2_testdb2/sysman/config/emoms.properties
/oracle/app/oracle/product/10.2/testhost1_testdb1/sysman/emd/targets.xm
最后,登录链接如下:
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9375/viewspace-586779/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/9375/viewspace-586779/