Friday, March 26, 2010

Setting up DBConsole for a database

  • Verify if dbsnmp user exist:
    • select * from all_users where username= 'DBSNMP'
  • Grant users the right privileges:
    • alter user DBSNMP identified by "<new password>" ;
    • alter user DBSNMP account unlock ;
  • Ensure remote login is enabled
    • Ensure REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE is set in the init.ora for the database
      •  show parameters remote% ;
    • Ensure password file exist in $ORACLE_HOME/dbs. Else create it as under: 
    • $ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=< some password> entries= 5
  • Create DBConsole along with repos:
    • emca -config dbcontrol db -repos create
  • For additional info refer to
  • Verify that dbconsole is up and running
    • emctl status dbconsole
      If you recreated the db, just recreate the dbcontrol repos as under:
      emca -config dbcontrol db -repos recreate
    • If db console is running on your server, you can access EM through browser as under:

No comments:

Post a Comment