Check Oracle Health erro ORA-00923

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
alexxsantos
Posts: 2
Joined: Wed Jul 23, 2014 5:00 pm

Check Oracle Health erro ORA-00923

Post by alexxsantos »

I am trying execute a check for an oracle query using a check_oracle_health and i get the bellow error.

check_oracle_health --connect 'XXXXX' --username 'XXXX' --password 'XXXXX' --mode sql --name="SELECT COUNT(*) FROM ( SELECT DATABASE_MODE, SUBSTR (RECOVERY_MODE, 1, 8) AS "RECOV_MODE", PROTECTION_MODE AS "PROTECTION_MODE", SUBSTR (DESTINATION, 1, 10) AS "DEST", ARCHIVED_SEQ# , APPLIED_SEQ# , ARCHIVED_SEQ#-APPLIED_SEQ# "GAP SIZE" , SUBSTR (SYNCHRONIZATION_STATUS, 1, 8) AS "SYNC_STATUS", SYNCHRONIZED AS "SYNC", GAP_STATUS, STATUS, sysdate FROM V$ARCHIVE_DEST_STATUS WHERE TYPE <> 'LOCAL' AND (GAP_STATUS <> 'NO GAP' OR STATUS <> 'VALID' OR ARCHIVED_SEQ#-APPLIED_SEQ# > 4 ) )"


UNKNOWN - got no valid response for SELECT COUNT(*) FROM ( SELECT DATABASE_MODE, SUBSTR (RECOVERY_MODE, 1, 8) AS RECOV_MODE, PROTECTION_MODE AS PROTECTION_MODE, SUBSTR (DESTINATION, 1, 10) AS DEST, ARCHIVED_SEQ# , APPLIED_SEQ# , ARCHIVED_SEQ#-APPLIED_SEQ# GAP - ORA-00923: FROM keyword not found where expected (DBD ERROR: error possibly near <*> indicator at char 223 in 'SELECT COUNT(*) FROM ( SELECT DATABASE_MODE, SUBSTR (RECOVERY_MODE, 1, 8) AS RECOV_MODE, PROTECTION_MODE AS PROTECTION_MODE, SUBSTR (DESTINATION, 1, 10) AS DEST, ARCHIVED_SEQ# , APPLIED_SEQ# , ARCHIVED_SEQ#-APPLIED_SEQ# GAP<*>')
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Check Oracle Health erro ORA-00923

Post by scottwilkerson »

Sorry we are not the authors of the check_oracle_health plugin and don't believe we will be able to offer the plugins development help you are looking for, here is the author
https://labs.consol.de/nagios/check_ora ... index.html
Former Nagios employee
Creator:
ahumandesign.com
enneagrams.com
Locked