4 Replies Latest reply: Oct 7, 2013 9:51 AM by slas RSS

    User dbsnmp does not have privileges to monitor this database.

    slas

      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.