Data Guard collection is failing with:
---
DBO_Instance_General Failed with the exception: Failed to execute query on instance [YourAgentName], user account [YourAccount]. Reason : [ORA-00942: table or view does not exist (possible missing privileges)- Profile:OracleProfile{host='YourHost', instance='YourInstance', username='YourAccount', asSysDBA=false, ports='6777', properties={oracle.jdbc.ReadTimeout=900000}} Query: "select /*+ RULE */ version "db_version", decode(log_mode,'NOARCHIVELOG','NO','YES') "is_archived", decode(a.asm_files,0,'NO','YES') "is_asm", case when dg.dataguard > 0 THEN 'YES' when controlfile_type = 'STANDBY' THEN 'YES' else 'NO' ... .nt(*) asm_files from v$datafile where name like '+%' and rownum<2) a, (select count(*) dataguard from sys.v$archive_dest where target = 'STANDBY' and rownum<2) dg, (select count(*) rman_conf from sys.v$RMAN_STATUS where rownum<2) r, (select count(*) cell_count from sys.v$cell where rownum<2) c"].
Please make sure that the database account on the Data Guard instance has the SYSDBA role, otherwise Foglight cannot monitor it especially if it is standby mode.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center