- 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