Tuesday, April 17, 2012

Manually configure the Oracle EM dbconsole


To Create EM Dbconsole:
$ emca -repos create
$ emca -config dbcontrol db
or$emca -config dbcontrol db -repos create


To start/stop or check status of EM Db console:

$ emctl start dbconsole
$ emctl stop dbconsole
$ emctl status dbconsole


To remove DB-Console:

$emca -deconfig dbcontrol db -repos drop
Silent mode:
emca -deconfig dbcontrol db -repos drop -silent -HOST your-server-name -SID $SID -SYSMAN_PWD $SYSMAN_PWD -DBSNMP_PWD $DBSNMP_PWD -SYS_PWD $SYS_PWD -PORT 1521


Incase of SSL issue and dbconsole cannot be started:  


emctl unsecure dbconsole
emctl secure dbconsole (or:
emctl secure dbconsole -sysman_pwd < Password for SYSMAN user >)


To Re-create DB-Console:
$ emca -config dbcontrol db -repos recreate


EM for RAC

emca -reconfig dbcontrol -cluster
emca -config dbcontrol db -cluster -repos recreate

emca -deconfig dbcontrol db -repos drop -cluster
emca -config dbcontrol db -repos create -cluster
emca -addNode db -silent -DB_UNIQUE_NAME $DB_NAME -MODIFY_NODE $NODE -SERVICE_NAME $SID

No comments:

Post a Comment