EM安装方法

单机EM安装方法：

1、查看em使用方法

emca -help  

2、无论是否建立过，先删除

emca -deconfig dbcontrol db -repos drop

3、建立EM

emca -config dbcontrol db -repos create

4、EM状态查看

emctl status dbconsole

5、EM启动

emctl start dbconsole

 

 

RAC集群EM安装方法：

1、查看em使用方法

emca -help  

2、无论是否建立过，先删除

emca -deconfig dbcontrol db -repos drop
emca -deconfig dbcontrol db -repos drop -cluster

3、新建rac数据库的EM

emca -config dbcontrol db -repos create -cluster 

遇到报错WARNING: Error during db connection : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor 

解决方法：
1）
Remove all the ASM password files from each node: 

rm Grid Oracle Home/dbs/orapw+ASM1 
rm Grid Oracle Home/dbs/orapw+ASM2 

2）
Create ASM password file manually on the first node as the OS user which owns the Grid Infrastructure: 

orapwd file=’orapw+ASM1’ entries=5 password=’here your password’

3）Add the ASMSNMP user in ASM instance, and grant sysdba privilege to it: 

sqlplus / as sysasm
create user asmsnmp identified by ‘password’; 
grant sysdba to asmsnmp;

4）Verify the ASMSNMP user was created: 

select * from v$pwfile_users; 

4、再次新建rac数据库EM，注意EM通过listener_scan 访问ASM实例，因此创建EM需在listener_scan1所在节点，否则报错SEVERE: Error getting hostname for the cluster node rac02. This node may not be configured correctly

emca -config dbcontrol db -repos create -cluster