Return
-
Title
No Tablespace data is being gathered by the DBO_Oracle agent. -
Description
No Tablespace data is being gathered by the DBO_Oracle agent. There are many "ORA-00942: table or view does not exist" error messages and "ORA-01031: insufficient privileges" error messages in the Oracle agent log.
-
Cause
The user named under the "Monitored Connection Profile" section of the Oracle agent's properties does not have sufficient privileges.
-
Resolution
Re-run the grant script for the user named in the Oracle agent's properties and then deactivate and activate the agent.
-
Additional Information
The grant script must be run by a SYSDBA user.