The Oracle database agent log includes messages such as the following:
YYYY-MM-DD HH:MM:SS.SSS ECHO ERROR [DBO-TESTSERVER.EXAMPLE.COM-TESTINSTANCE-lowPriorityPool-40-[DBO_Locks_Activity][YYYY/MM/DD HH:MM:SS]] com.quest.qsi.fason.oracle.collection.processor.DBOInstanceProcessor - Failed to run DBOLocksActivityProcessor processor of DBO_Locks_Activity collection of DBO-TESTSERVER.EXAMPLE.COM-TESTINSTANCE instance.
java.lang.RuntimeException: Failed to execute collection [DBO_Locks_Activity], reason=ORA-00942: table or view does not exist
(possible missing privileges)- Profile:OracleProfile{host='TESTSERVER.EXAMPLE.COM', instance='TESTINSTANCE', username='foglight', asSysDBA=false, ports='1556', properties={oracle.jdbc.ReadTimeout=900000}}
CAUSE 1
The SQL error -924, ORA-00942: table or view does not exist, is thrown when:
1. The table or view entered does not exist,
2. A synonym that is not allowed here was used,
3. A view was referenced where a table is required
CAUSE 2
Privileges to that table or view may not have been granted to access the table.
Re-validate the connection from Global/Agent Administration, and if it fails noting Missing Privileges:
Note: There is a Known Issue with the 6.1.0.11, 6.3.0.10, and 6.3.0.11 cartridges missing a permission for v$px_session.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center