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:
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".
Please follow the link to resolve this issue.
--
Best regards,
AndreyDBA.