Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

User dbsnmp does not have privileges to monitor this database.

slasOct 4 2013 — edited Oct 7 2013

Trying to get databases set up for monitoring after successful agent deployment but can't get past this message in the database config. I've done the below, am I missing something?

1) Granted sysdba to dbsnmp on primary.

2) Copied over PW file to standby database.

3) All queries reflect the proper privilege.

SQL> SELECT * FROM v$pwfile_users WHERE sysdba='TRUE';

USERNAME                SYSDB SYSOP SYSAS

------------------------------ ----- ----- -----

SYS                            TRUE  TRUE  FALSE

DBSNMP                    TRUE  FALSE FALSE

and

SQL> conn dbsnmp@pri1 as sysdba

Enter password:

Connected.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 4 2013
Added on Oct 4 2013
4 comments
2,261 views