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
SQL> conn dbsnmp@pri1 as sysdba
Granting SYSDBA privileges to user dbsnmp is not a best practice. You should either use user sys or another user with SYSDBA privileges for monitoring standby databases.
Note that when you set up monitoring settings for a standby database in the Configure Database Instance: Properties page, select "SYSDBA" from the Role drop-down list.
This is an expected behaviour as there is more checking done internally when a user other than 'sys' logs in as sysdba from the console.
Use the following note from metalink. This is a common issue. following this note will fix the issue,
Warning : User Dbsnmp Does Not Have Privileges To Monitor This Database (Doc ID 604389.1)