Monday, September 28, 2009

Enterprise Manager Recreate

1).Delete DB Control Configuration Files using EMCA scripts

In 10.2g run, $emca -deconfig dbcontrol db Then enter sid as prompt
and then y.

2).Delete DB Control Configuration Files Manually:

Remove the following directories from your filesystem:
$ORACLE_HOME/hostname_sid
$ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_hostname_sid

3).Delete DB Control Repository using RepManager:
Invoke following command, RepManager hostname listener_port sid -
action drop
But don't delete by RepManager. It puts the database in quiescence
mode.

it gave me
-bash: RepManager: command not found

4).Delete DB Control Repository Objects Manually
drop user sysman cascade;
drop role MGMT_USER;
drop user MGMT_VIEW cascade;


5).Delete DB Control Configuration Files and Repository Objects using
EMCA

For 10.2,

>emca -deconfig dbcontrol db -repos drop

No comments: