This discussion is archived
4 Replies Latest reply: Oct 7, 2013 7:51 AM by slas RSS

User dbsnmp does not have privileges to monitor this database.

slas Newbie
Currently Being Moderated

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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points