Oracle Query

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
jcwuerfl
Posts: 76
Joined: Tue Jun 10, 2014 12:44 pm

Oracle Query

Post by jcwuerfl »

Getting this output on an Oracle Query, any ideas?

Code: Select all

(No output on stdout) stderr: /bin/sh: -c: line 0: unexpected EOF while looking for matching `"'
/bin/sh: -c: line 1: syntax error: unexpected end of file
mp4783
Posts: 116
Joined: Wed May 14, 2014 11:11 am

Re: Oracle Query

Post by mp4783 »

One possible explanation is that the file, assuming it is a text based script of some sort, is encoded in MS-DOS format. If you execute "cat -vet check_oracle" (or whatever the plugin is called) and you see a "^M" at the end of each line, then this could be the problem.

Assuming your plugin is called check_oracle, you can fix it (or at least try) by executing the following:

Code: Select all

cp -p check_oracle check_oracle.org

dos2unix check_oracle
Now if you execute "cat -vet check_oracle", each line should end with a "$".
jcwuerfl
Posts: 76
Joined: Tue Jun 10, 2014 12:44 pm

Re: Oracle Query

Post by jcwuerfl »

I think there are some issues with the 12 Oracle Instant client. Went back to v11 for the client and that worked fine.

Thanks
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Oracle Query

Post by tgriep »

Thanks for posting the resolution. Shall we close the post?
Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked