Create 10g DBconsole on the fly

Q: Hi, where is my local DB console?
A: You can easily destroy it and re-setup everything on the fly.

Cleanup dbconsole
$ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop
You will be prompted to give SID, listener port number, SYS/SYSMAN password and that is it.

Recreate dbconsole
$ORACLE_HOME/bin/emca -config dbcontrol db -repos create
you need SID, listener port number, SYS/DBSNMP/SYSMAN password. Another
2 optional thing are Email address for notifications and Outgoing Mail (SMTP) server.

Quicker than you think, right?
Note: there is a trick when play with 10gR1 instead of 10gR2


About Pang

Oracle DBA working in database, fusion middleware and identity management and cloud.
This entry was posted in OEM and grid control. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s