error"TNS:listener was not given the SERVICE_NAME"

[danieloo]

this is a patch which only applies to the 1.2 version of the oracle_serverspace wizard

[naveenreddyv]

do you mean 11.2?
I am using 11.2 version and 64 bit OS

[danieloo]

No sorry, i mean the oracle serverspace plugin version 1.2

[naveenreddyv]

Sorry, I was not able to find the serverspace plugin in our nagios plugin list....
what can I do to resolve this issue?

[danieloo]

ahh your problem is voor the query.. the patch isn't for that one..
You will have to manually edit the command arguments and add the Servicename like this:
-connect IPAddress:1521/service_name

[danieloo]

sorry for the previous confusion, here is the patch for oracle_query wizard.
Place it in de correct directory usually; /usr/local/nagiosxi/html/includes/configwizards/oracle_query
and execute the next command
patch oracle_query.inc.php < oracle_query.inc.php.txt

[slansing]

Thank you for the file! I hope it helps him out.

[danieloo]

I have created patches for all three oralce plugins..
Nicholas Scott will apply them to the wizards and make them available.

[lmiltchev]

naveenreddyv,

Is your issue resolved? Have you tried the patch posted by danieloo?

[naveenreddyv]

sorry for the delay in response...
Please find the below response after running the patch

patching file oracle_query.inc.php
Hunk #1 FAILED at 46.
Hunk #2 FAILED at 88.
Hunk #3 FAILED at 127.
Hunk #4 FAILED at 157.
Hunk #5 FAILED at 177.
Hunk #6 FAILED at 216.
Hunk #7 FAILED at 301.
Hunk #8 FAILED at 338.
Hunk #9 FAILED at 364.
Hunk #10 FAILED at 399.
Hunk #11 FAILED at 429.
Hunk #12 FAILED at 456.
Hunk #13 FAILED at 491.
13 out of 13 hunks FAILED -- saving rejects to file oracle_query.inc.php.rej

Thanks,
Naveen Reddy