Sunday, February 17, 2019

Configure DB Console


PreReq:




Set environments (with example values):



export ORACLE_HOME=/oracle/11.2.0.4


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:port/em



No comments:

Post a Comment