Tuesday, November 13, 2012

[RDBMS] Enable Database 11g Console

To enable the Database Control in an Oracle Database 11g you should complete the following tasks:

1. Login as oracle in the server.
2. [Optional] Delete any previous installation. It will ask for Database SID, Listener Port Number, Oracle Home Location and SYS/SYSMAN/DBSNMP Password:

emca -deconfig dbcontrol db -repos drop
3. Issue this command. It will ask for Database SID, Listener Port Number, Oracle Home Location and SYS/SYSMAN/DBSNMP Password:
emca -config dbcontrol db -repos create
That's it! You can now access it from your web browser using the following URL:
https://hostname:1158/em

Extra: If you want to check the Database Control status you can issue the command emctl status dbconsole in the server. Also you can start or stop it using emctl start dbconsole and emctl stop dbconsole.

Problem solved!