【问题】: (FAQ)手动配置ORACLE OEM 配置
版本: 7.0.3
模块: 系统部署
【答复】:
解决方法： 1． 停止OEM所有的进程 2． 在数据库中删除OEM信息 （使用sys 登录） SQL> exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'SYSMAN.MGMT_NOTIFY_QTABLE',force=>TRUE); SQL> SHUTDOWN IMMEDIATE; SQL> STARTUP RESTRICT; SQL> EXEC sysman.emd_maintenance.remove_em_dbms_jobs; SQL> EXEC sysman.setEMUserContext('',5); SQL> REVOKE dba FROM sysman; SQL> DECLARE CURSOR c1 IS SELECT owner, synonym_name name FROM dba_synonyms WHERE table_owner = 'SYSMAN'; BEGIN FOR r1 IN c1 LOOP IF r1.owner = 'PUBLIC' THEN EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name; ELSE EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name; END IF; END LOOP; END; / SQL> DROP USER mgmt_view CASCADE; SQL> DROP ROLE mgmt_user; SQL> DROP USER sysman CASCADE; SQL> ALTER SYSTEM DISABLE RESTRICTED SESSION; 3.移除OEM安装目录 / /oc4j/j2ee/OC4J_DBConsole__ 如果是升级上来的，则是如下目录 /.upgrade /oc4j/j2ee/OC4J_DBConsole__.upgrade 4.如果是WINDOWS操作系统，则需删除注册表信息 sc delete 或nmesrvops delete where is the DB Control service name (typically: OracleDBConsole 5.移除下面所有文件 ORACLE_HOME/cfgtoologs/emca/ 6.重新安装EM set ORACLE_HOME = set ORACLE_SID= /bin/emca -config dbcontrol db -repos create

解决方法： 1． 停止OEM所有的进程 2． 在数据库中删除OEM信息 （使用sys 登录） SQL> exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'SYSMAN.MGMT_NOTIFY_QTABLE',force=>TRUE); SQL> SHUTDOWN IMMEDIATE; SQL> STARTUP RESTRICT; SQL> EXEC sysman.emd_maintenance.remove_em_dbms_jobs; SQL> EXEC sysman.setEMUserContext('',5); SQL> REVOKE dba FROM sysman; SQL> DECLARE CURSOR c1 IS SELECT owner, synonym_name name FROM dba_synonyms WHERE table_owner = 'SYSMAN'; BEGIN FOR r1 IN c1 LOOP IF r1.owner = 'PUBLIC' THEN EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name; ELSE EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name; END IF; END LOOP; END; / SQL> DROP USER mgmt_view CASCADE; SQL> DROP ROLE mgmt_user; SQL> DROP USER sysman CASCADE; SQL> ALTER SYSTEM DISABLE RESTRICTED SESSION; 3.移除OEM安装目录 / /oc4j/j2ee/OC4J_DBConsole__ 如果是升级上来的，则是如下目录 /.upgrade /oc4j/j2ee/OC4J_DBConsole__.upgrade 4.如果是WINDOWS操作系统，则需删除注册表信息 sc delete 或nmesrvops delete where is the DB Control service name (typically: OracleDBConsole 5.移除下面所有文件 ORACLE_HOME/cfgtoologs/emca/ 6.重新安装EM set ORACLE_HOME = set ORACLE_SID= /bin/emca -config dbcontrol db -repos create