Configure DB Console

PreReq:

Set environments (with example values):

export ORACLE_HOME=/oracle/11.2.0.2

export ORACLE_SID=orcl

export ORACLE_HOSTNAME=dbserver

Create the repository and configure the DB Console:

% emca -config dbcontrol db -repos create

parameters:

- database SID

- listener's port

- password for SYS

- password for SYSMAN

- password for DBSNMP

Drop the repository and deconfig the DB Console:

% emca -deconfig dbcontrol db -repos drop

parameters:

- database SID

- listener's port

- password for SYS

- password for SYSMAN

Drop the DB Console (manually):

Warning: this command puts the database in Quiesce Mode for the DB Control Releases 10.x to 11.1.x.

Starting with DB Control Release 11.2.x, the database is no longer put in quiesce mode.

SQL> conn / as sysdba

SQL> drop user sysman cascade;

SQL> drop role MGMT_USER;

SQL> drop user MGMT_VIEW cascade;

SQL> drop public synonym MGMT_TARGET_BLACKOUTS;

SQL> drop public synonym SETEMVIEWUSERCONTEXT;

% emca -deconfig dbcontrol db -repos drop

Link for using DBConsole:

https://servername:1158/em

Useful information:

If you have database in version 10.2.0.4 or 10.2.0.5, you can get the next error on start of DB Console:

"unable to initialize SSL connection".

Best regards,

AndreyDBA.