Page 1 of 1

Check Oracle Health erro ORA-00923

Posted: Thu Apr 19, 2018 4:13 pm
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<*>')

Re: Check Oracle Health erro ORA-00923

Posted: Thu Apr 19, 2018 4:20 pm
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