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:

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

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

For 10.2,

>emca -deconfig dbcontrol db -repos drop

No comments: