oracle oem 安装配置,Oracle OEM 配置

OEM 配置

(1)创建一个EM资料库 ¬

emca -reposcreate ¬

(2)重建一个EM资料库 ¬

emca -reposrecreate ¬

(3)删除一个EM资料库 ¬

emca -reposdrop ¬

(4)配置数据库的DatabaseControl ¬

emca -configdbcontrol db ¬

(5)删除数据库的DatabaseControl配置 ¬

emca -deconfigdbcontrol db ¬

(6)重新配置db control的端口，默认端口在1158 ¬

emca -reconfigports ¬

emca -reconfigports -dbcontrol_http_port 1160 ¬

emca -reconfigports -agent_port 3940 ¬

(7)先设置ORACLE_SID环境变量后,启动EM console服务 ¬

emctl startdbconsole ¬

(8)先设置ORACLE_SID环境变量后,停止EM console服务 ¬

emctl stopdbconsole ¬

(9)先设置ORACLE_SID环境变量后,查看EM console服务的状态 ¬

emctl statusdbconsole ¬

(10)配置dbconsole的步骤 ¬

emca -reposcreate ¬

emca -configdbcontrol db ¬

emctl startdbconsole ¬

(11)重新配置dbconsole的步骤 ¬

emca -reposdrop ¬

emca -reposcreate ¬

emca -configdbcontrol db ¬

emctl startdbconsole ¬

手工重建OEM

我们的db是11.2.0.3的。

(1)删除dbcontrol 和repository：

/bin/emca -deconfig dbcontrol db -repos drop

(2)重新创建dbcontrol 和repository：

bin/emca -config dbcontrol db -repos create

Duplicate active database:

Set oracle_sid=orcl rman target=sys/robert auxname=sys/Robert@orcl2 duplicate target database to neworcl from active database nofilenamecheck spfile

set control_files ‘c:oracleoradataneworclcontrol01.ctl’,

‘c:oracleoradataneworclcontrol02.ctl’

set db_file_name_convert ‘c:oracleoradataorcl’,’ c:oracleoradataneworcl’

set log_file_name_convert ‘c:oracleoradataorcl’,’c:oracleoradataneworcl’;