Check Oracle Health erro ORA-00923

This forum is intended for the discussion of Nagios plugin development. Feature requests, patches, bug fixes, and all types of development-related discussions are welcome!

NOTE: The SourceForge.net nagiosplug-devel mailing list has been deprecated in favor of this forum in order to expedite support and provide additional features not available on the old mailing list.

Check Oracle Health erro ORA-00923

Postby alexxsantos » Thu Apr 19, 2018 4:13 pm

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<*>')
alexxsantos
 
Posts: 2
Joined: Wed Jul 23, 2014 5:00 pm

Re: Check Oracle Health erro ORA-00923

Postby scottwilkerson » Thu Apr 19, 2018 4:20 pm

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
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
User avatar
scottwilkerson
CTO
 
Posts: 9726
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises


Return to Nagios Plugin Development

Who is online

Users browsing this forum: No registered users and 1 guest