(Solved) Cannot Determine Oracle_home For Sid Orcl Tutorial

Home > Cannot Determine > Cannot Determine Oracle_home For Sid Orcl

Cannot Determine Oracle_home For Sid Orcl

Best I can figure it has something to do with the > > NLS_LANG (or was it LANG) environment variable and others not being > properly > > setup (in fact Carole. So, i indicate a path (/tmp/_...) and now it works well. I don't know. his comment is here

Actual problem here is nagios user doesn't having shell access (/sbin/nologin). Login or register Username or Email Address Are you already registered? It is a highly supported plugin alternative to the depreciated one you are running with, if this is not an option that's fine:http://assets.nagios.com/downloads/nagi ... Can you help me, please?

I have found this bit to be extremely cumbersome > on > > my setup. my /etc/oratab -------- staborcl:/u01/app/oracle/product/10.1.0/db_1:N *:/u01/app/oracle/product/10.1.0/db_1:N --------- But nothing worked. This script calls the check_oracle.sh script.

  • bread555 2009-03-11 16:28:30 UTC #3 As I too recently found this problem, Be aware with that solution, that if you goto different versions of Oracle, that this will not always work.
  • This is the listener check command: case "$cmd" in --tns) tnschk=`ssh [email protected]$REMOTE_SERVER -x "ORACLE_HOME=${ORACLE_HOME};PATH=$PATH:$ORACLE_HOME/bin;LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib;export ORACLE_HOME PATH LD_LIBRARY_PATH; tnsping $2"` tnschk2=` echo $tnschk | grep -c OK` if [ ${tnschk2} -eq 1
  • Re: [Nagios-users] Problem with check_oracle From: Richard Gliebe - 2005-09-30 05:46:49 On Thu, 2005-09-29 at 09:02 -0700, Luis Gardea wrote: > Hi > > I want see the service oracle
  • tullball 2009-01-28 09:37:29 UTC #2 RESOLVED: Add the following line to /etc/oratab: *:/path/to/your/oraclehome/:N This will work if all the SIDs have the same oracle home.
  • The only requisite is having an ssh daemon running on the oracle server and copy the nagios user ssh key to that oracle server so nagios can connect through ssh with

Marco Quote Report Content Go to Page Top Naqada Intermediate Posts 262 Occupation AIX Admin Number of hosts 77 Number of services 2200 Operating Systems Suse11 3 Jan 13th 2011, 4:20pm Quote Report Content Go to Page Top DevMusic Student Posts 93 2 Jan 13th 2011, 10:11am Hi, I can say, my egnlish is not so good, too. :D I cannot say carole verdon wrote: Hi, I wrote a script, check_oracle_databases.sh, that would permit to take dynamically into account the file /etc/oratab to verify all databases that it contains. Top Re: check_oracle by skumar7466 » Mon Jun 03, 2013 4:03 am where do i need to define you command...in nrpe.cfg (hpux end) or in nagios server end.

What am i doing? Can you help me, please? Please don't fill out this field. https://sourceforge.net/p/nagios/mailman/message/17442018/ if [ "${1}" = "-U" ] then ORACLE_OSUSER=$2 && shift 2 else ORACLE_OSUSER="oracle" fi Now we've got all the parameters we need to connect through ssh to a remote Oracle database

See if this is the same as your check_oracle plug in: https://github.com/amc-web-user/nagios-plugins/blob/master/check_oracle 0 Featured Post Top 6 Sources for Identifying Threat Actor TTPs Promoted by Recorded Future Understanding your enemy is I think I even went sofar as to try setting them from withing check_nagios itself at one point before getting to the sqlclient part but ... My advice is to definitly set these variables up by default in your /etc/profile or ~/.bash_profile at th= e very least. Check the file permissions on it and make sure nagios has read access on it.

Carole. https://support.nagios.com/forum/viewtopic.php?t=10626&p=54345 I never did find a clear answer to it and it is just sheer luck tha= t I managed to fix it (just don't ask me how it was a 3 It's the LANG environment variable. All another checks (disk, load...) work well.

The first is the owner (who has to be non-roo= t as requested by the oracle installer) of the oracle client. this content Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Post a reply 6 posts • Page 1 of 1 Return to Recent Posts Comments Tag Cloud Validate and recover database irrecoverable data loss (Incomplete recovery) Update Oracle Enterprise linux with the Oracle public Yum repositories Create your own RMAN backup scripts from But we can help you once you have questions regarding it. "excluding the wizard portion of course."For the check_oracle command above, please let us know what it returns from the command

This last file is located in the $ORACLE_HOME/network/admin directory. I'll be grateful for any help offered to me. quite frankly proved to be a serious problem to tackle. weblink On remote host (HP-UX server), the script works fine: $ /usr/local/nagios/libexec/check_oracle_databases.sh + /usr/local/nagios/libexec/check_oracle_databases.sh all databases OK but on nagios server (solaris server), it don't work.

To submit patches or suggest improvements, send email to [email protected] All another checks (disk, load...) work well. check_oracle uses the standard oracle client as available freely (although not in open source) from oracle.com .

approved solution for that ?

Thanks. NLS_LANG has no special meaning. > > Nagios uses the library wrapper popen() to execute other programs (for > now, anyways). I am doing it a little bit more manual, but you should be able to use a -s to specifically select a SID Home Categories FAQ/Guidelines Terms of Service Privacy Policy Connect with top rated Experts 13 Experts available now in Live!

skumar7466 Posts: 15Joined: Wed May 22, 2013 3:38 am Top Re: check_oracle by slansing » Fri May 31, 2013 10:19 am Have you tried using check_oracle_health? lation.pdfFor check_oracle, as the help portion suggests, you can load the environment on the fly as well, fill in the following with your information:Code: Select all./check_oracle --tablespace $ARG1$ --sid $ARG2$ --user What I couldn't figure out is all the references on the web regarding this issue seem to point toward mod_perl2. check over here if in my check_oracle_databases.sh script i put this: if [ $result -eq 0 ] ; then echo "all databases OK" exit $STATE_OK elif [ $result -eq 1 ] ;

Let me roughly explain it. Top Re: check_oracle by skumar7466 » Thu May 30, 2013 10:57 pm There is no file /etc/oratab. These sids are truncated to eight characters (1234, 12345678, 12345678 and 12345678) and defined in tnsnames.ora on the db-server. Suggested Solutions Title # Comments Views Activity good comptia a+ teacher? 4 54 37d Create index on View 27 46 37d Getting network error using utl tcp package 7 71 34d

Nagios Core users of all experience levels are welcome here. libexec]# ./check_oracle -tns 10.0.0.1 > Cannot determine ORACLE_HOME for sid 10.0.0.1 > > Could someone help me? Or some other problem?? Join our community for more solutions or to ask questions.

if in my check_oracle_databases.sh script i put the following lines, i obtain that: if [ $result -eq 0 ] ; then echo "all databases OK" exit $STATE_OK else Please refer to our Privacy Policy or Contact Us for more details You seem to have CSS turned off. I use NagMin 2.1.0 to configure nagios. I have found this bit to be extremely cumbersome on my setup.

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 Sign up for the SourceForge newsletter: I agree to receive quotes, newsletters and other information from sourceforge.net and its partners regarding IT services and products. Yes, my password is: Password Remain logged in Lost Password Search subject only Display results as threads More Options Dashboard Forum Undone Threads Members Icinga PNP Icinga Exchange Monitoring Plugins NagVis You also need to go through the document I linked above before attempting to connect to your oracle server, it was designed for XI but the same rules apply.

The biggest problem I have had with check_oracle however is when it is run by the Nagios process. You may redistribute copies of the plugins under the terms of the GNU General Public License. It's very urgent. libexec]# ./check_oracle -tns 10.0.0.1 Cannot determine ORACLE_HOME for sid 10.0.0.1 Could someone help me?

Solved Issue with check_oracle plugin nagios Posted on 2013-08-12 Linux Oracle Database 2 Verified Solutions 3 Comments 1,394 Views Last Modified: 2013-08-26 Hi, I have an issue with check_oracle plugin which