checkin oralce for a pluggable database

An open discussion forum for obtaining help with Nagios Core. Nagios Core users of all experience levels are welcome here. Subforum have been created for the discussion of Nagios Core and Nagios Plugin development.

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

checkin oralce for a pluggable database

Postby medleyb » Mon Mar 13, 2017 4:07 pm

I was using check_oracle_instant for my noncontainer/pliuggable databases (stand Oralce). But check_oracle_instant does not seem to support pluggable databases. Does someone know of something similar that works with pluggable databases? Or has a version of check_oracle_instant that works?
medleyb
 
Posts: 8
Joined: Fri Jan 15, 2016 9:54 am

Re: checkin oralce for a pluggable database

Postby mcapra » Mon Mar 13, 2017 4:47 pm

According to this Oracle article, any solution would need to be using at least Oracle Instant Client v12 or greater:
http://www.oracle.com/technetwork/datab ... 90945.html

I would think you should be able to use v12 of the instant client with check_oracle_instant. Did you encounter specific issues using v12 of the Oracle Instant Client with this plugin?
Be sure to check out our Knowledgebase for helpful articles and solutions!

https://github.com/mcapra/
User avatar
mcapra
Support Tech
 
Posts: 1960
Joined: Thu May 05, 2016 3:54 pm
Location: Nagios Enterprises

Re: checkin oralce for a pluggable database

Postby medleyb » Tue Mar 14, 2017 9:21 am

There are two logons. in "sub logon" you have this: open (SQL,"sqlplus -s mismatch/mismatch@//\\(DESCRIPTION=\\(ADDRESS=\\(PROTOCOL=TCP\\)\\(Host=$host\\)\\(Port=$port\\)\\)\\(CONNECT_DATA=\\(SERVICE=$sid\\)\\)\\)</dev/null |") or die;

If I run against a non-pluggable database it works.

If I run against a pluggable database it throws: Unable to connect to ORACLE SOMEPDB, error ORA-12547 !!!
medleyb
 
Posts: 8
Joined: Fri Jan 15, 2016 9:54 am

Re: checkin oralce for a pluggable database

Postby medleyb » Tue Mar 14, 2017 9:54 am

As a followon, please note that connecting with SQLPLUS itself does work. It is the open statement throwing that error.
medleyb
 
Posts: 8
Joined: Fri Jan 15, 2016 9:54 am

Re: checkin oralce for a pluggable database

Postby medleyb » Tue Mar 14, 2017 10:06 am

further information on the behavior of SQLPlus at the command line

[nagios@NagiosCoreVM libexec]$ sqlplus mismatch/mismatch@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=129.144.31.230)(Port=1521))(CONNECT_DATA=(SID=XXXXXXXX)))

ERROR: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

[nagios@NagiosCoreVM libexec]$ sqlplus mismatch/mismatch@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=129.144.31.230)(Port=1521))(CONNECT_DATA=(SERVICE=XXXXXXXX)))

ERROR: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

[nagios@NagiosCoreVM libexec]$ sqlplus mismatch/mismatch@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=129.144.31.230)(Port=1521))(CONNECT_DATA=(SERVICE=XXXXXXXX.a427173.oraclecloud.internal)))

ERROR: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

[nagios@NagiosCoreVM libexec]$ sqlplus mismatch/mismatch@XXXXXXXX

ERROR: ORA-01017: invalid username/password; logon denied
medleyb
 
Posts: 8
Joined: Fri Jan 15, 2016 9:54 am

Re: checkin oralce for a pluggable database

Postby mcapra » Tue Mar 14, 2017 4:49 pm

Assuming you're definitely using v12 of the instant client (that was never specifically answered), you'd probably have better luck contacting the person who developed this plugin directly (see the header of the plugin). Though this plugin is quite old and doesn't appear to have been updated in several years. Aside from a few odd articles on Google referencing some settings within the Oracle database itself, i'm coming up dry.
Be sure to check out our Knowledgebase for helpful articles and solutions!

https://github.com/mcapra/
User avatar
mcapra
Support Tech
 
Posts: 1960
Joined: Thu May 05, 2016 3:54 pm
Location: Nagios Enterprises

Re: checkin oralce for a pluggable database

Postby medleyb » Fri Mar 17, 2017 9:46 am

Ok, thanks!!!!
medleyb
 
Posts: 8
Joined: Fri Jan 15, 2016 9:54 am

Re: checkin oralce for a pluggable database

Postby cdienger » Fri Mar 17, 2017 12:54 pm

Glad to get you in the right direction. Let us know if there's anything on our end we can assist with or if you'd like to close the thread.
User avatar
cdienger
 
Posts: 97
Joined: Tue Feb 07, 2017 11:26 am


Return to Nagios Core

Who is online

Users browsing this forum: Bing [Bot] and 8 guests