While installing the database some time due some problem, everything is installed but enterprise manager does not work.
In another common case (I am not really talking about production servers here) due to some reason like change in ip addresses and so on, enterprise manager stops working.
Whatever the case, In simple words there is a requirement that we need to drop the existing setup of enterprise manager and create new one with new configuration.
Note here I am only talking about dropping and then creating again which I normally do with my development server off course there are other options too.
First drop the present configuration and its repository as follows:
C:\>emca -deconfig dbcontrol db -repos drop
It will ask for following related to your database:
Database SID: dcs
Listener port number: 1521
Password for SYS user:******
Password for SYSMAN user:*****
After entering above information just follow the instruction on the screen.
Then create the new configuration and its repository as follows:
C:\>emca -config dbcontrol db -repos create
It will ask for following related to your database:
Database SID: dcs
Listener port number: 1521
Password for SYS user:******
Password for DBSNMP user:******
Password for SYSMAN user:******
Password for SYSMAN user: Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
After entering above information just follow the instruction on the screen.
Thats it!
4 responses so far ↓
1 omc // Dec 18, 2007 at 9:09 am
both commands are the same, no?
2 Rajender Singh // Dec 18, 2007 at 12:09 pm
Yes OMC!
Both commands are same but parameters are different.
Regards
3 Anand // Jan 4, 2008 at 9:46 am
Well by mistake for dropping the configuration you have written …
“C:\>emca -config dbcontrol db -repos create”
in place of
“C:\>emca -deconfig dbcontrol db -repos drop”.
4 Rajender Singh // Jan 4, 2008 at 12:47 pm
Thanks Anand,
You are right it should be
“C:\>emca -deconfig dbcontrol db -repos dropâ€
Leave a Comment