EM配置及其相关命令

单实例配置

一、Recreaterepository

emca -config dbcontrol db -reposcreate        创建em资料库并同时配制DatabaseControl
emca -deconfig dbcontrol db -repos drop       删除Database Control并同时删除em资料库

 

oracle@lin21ux:~> emca -config dbcontrol db -repos recreate

 

STARTED EMCA at Nov 25, 2010 8:08:52 PM

EM Configuration Assistant, Version 10.2.0.1.0Production

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

 

Enter the following information:

Database SID:  zxin

 

Listener port number: 1521

Password for SYS user: oracle

Password for SYSMAN user:oracle

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

 

 

遇见的问题：

1） oracle 10205版本中需要加DB_UNIQUE_NAME=zxin

2） /etc/hosts文件必须正确

3） remote_login_passwordfile=EXCLUSIVE

orapwdfile=$ORACLE_HOME/dbs/orapwZXIN password=sys entries=5

 

二、相关命令

命令总结:

emca -config dbcontrol db -reposcreate    创建em资料库,并配制Database Control

emca -deconfig dbcontrol db -reposdrop    取消配制Database Control,并删除em资料库

emca -repos create                         创建一个EM资料库

emca -repos recreate                       重建一个EM资料库

emca -repos drop                           删除一个EM资料库

emca -config dbcontrol db                  配置数据库的 Database Control

emca -deconfig dbcontrol db                删除数据库的 Database Control配置

emctl start dbconsole                      先设置ORACLE_SID环境变量后,启动EM console服务

emctl stop dbconsole                       先设置ORACLE_SID环境变量后,停止EM console服务

emctl status dbconsole                     先设置ORACLE_SID环境变量（set ORACLE_SID=ZXIN）后,查看EM console服务的状态

 

emctl start dbconsole

 

三、路径

URL: http://10.42.109.21:1158/em/console/aboutApplication

 

 

四、终极手段：

       实在不行，执行下面步骤：

a. drop user sysman cascade;

b. drop role MGMT_USER;

c. drop user MGMT_VIEW cascade;

d. drop public synonym MGMT_TARGET_BLACKOUTS;

e. drop public synonym SETEMVIEWUSERCONTEXT;

f.emca -config dbcontrol db -repos create

 

端口号可查看文件：$ORACLE_HOME/install/portlist.ini

RAC EM配置

 

 

 

 

 

 

 

 

Asm密码：manager

 

 

 

 

密码填：oracle