- 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:
 
Friday, March 26, 2010
Setting up DBConsole for a database
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment