DBA Scripts & knowledge....!
....there is no such thing as failure, only learning experiences.
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment