Cannot Determine Oracle_home For Sid Localhost
Teenage daughter refusing to go to school Word or phrase for "using excessive amount of technology to solve a low-tech task" Wien's oscillator - amplitude stabilization with Zeners (loop's gain) First That ORACLE_HOME path /u01/app/oracle/product/11.2.0 is exactly what's mapped in the offcial oracle-xe-11.2.0-1.0.x86_64.rpm file. –Devy Jun 20 '14 at 21:20 add a comment| up vote 5 down vote You have to set The second parameter is the SID of your default Oracla Database. Output of lsnrctlLSNRCTL> statusMessage 1053 not found; No message file for product=network, facility=TNSTNS-12541: Message 12541 not found; No message file for product=network, facility=TNS TNS-12560: Message 12560 not found; No message file weblink
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. Like Show 1 Likes(1) Actions 6. Please try the request again. Hi, try to use the $ORACLE_SID instead of the Hostname/IP address [...] Usage: check_oracle --tns
I'm not so sure about this one. Like Show 0 Likes(0) Actions 4. You can not post a blank message.
- Best I can figure it has something to do with the NLS_LANG (or was it LANG) environment variable and others not being properl= y setup (in fact I suspect no environment
- As such you need to have the oracle client installed and properly set up.
- To rectify this, if you are using Windows, run the below query: C:\oracle\product\10.2.0\db_2>SET ORACLE_HOME=C:\oracle\product\10.2.0\db_2 C:\oracle\product\10.2.0\db_2>SQLPLUS SYS AS SYSDBA SQL*Plus: Release 10.2.0.3.0 - Production on Tue Apr 16 13:17:42 2013 Copyright (c)
- k@k:/$ export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0 k@k:/$ echo $ORACLE_HOME /usr/lib/oracle/xe/app/oracle/product/10.2.0 k@k:/$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus "/ as sysdba" Error 6 initializing SQL*Plus Message file sp1
.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle
- I've disabled the firewall[oracle@prashan bin]$ systemctl status firewalld● firewalld.service - firewalld - dynamic firewall daemon Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled) Active: inactive (dead)2.
- ehm ...
- Please enter a title.
- All Rights Reserved.
- Re: Cannot create listener on default port 1521 or ANY other port Dude!
- But dbca fails to start the LISTENER.Things I've tried1.
Did you copy an existing installation? But your problems do not end there, although at this point running the check manually from the console should work. popen()'ed children inherit the environment from the > parent (but doesn't read any of the profile or rc-files; sh -c is called > in to execute the program in question). JoseManuel1974 Beginner Posts 29 Number of hosts 1 Number of services 4 Operating Systems CentOS 1 [solved]check_oracle -> Cannot determine ORACLE_HOME for sid ALPHA.RED Jan 5th 2011, 11:30am Hello!!!.
No, register now. It works fine!!!! Depending on the client version you have installed (and I took the version 10 client of course, grumble) those variables have to be set though or your check_nagios goes horribly wrong. I have found this bit to be extremely cumbersome on > my setup.
popen()'ed children inherit the environment from the parent (but doesn't read any of the profile or rc-files; sh -c is called in to execute the program in question). have a peek at these guys Like Show 0 Likes(0) Actions 13. The system returned: (22) Invalid argument The remote host or network may be down. 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 ...
The error message could sure be better :) share|improve this answer answered Nov 1 '12 at 9:37 Kjell 5111 How to set LANG on Windows? –bjan Aug 7 '13 You can set ORACLE_BASE manually if it is required. Same error every time. check over here Screenshot instructions: Windows Mac Red Hat Linux Ubuntu Click URL instructions: Right-click on ad, choose "Copy Link", then paste here → (This may not be possible with some types of
Instead of the above value you give, I would try export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0 share|improve this answer edited Apr 30 '10 at 21:22 answered Apr 30 '10 at 21:17 DCookie 29.1k84866 The dbca utility required a listener to be created. And I haven't installed oracle grid infrastructure.
I kept getting errormessages about the client not being able to set up the NLS environment which ...
the $ORACLE_HOME/bin/mesg does not exist at all! Resetting ORACLE_BASE to its previous value or ORACLE_HOME The Oracle base remains unchanged with value /u01/app/oracle [oracle@prashan bin]$ lsof -i TCP:1521 [oracle@prashan bin]$ It looks like you have not yet libexec]# ./check_oracle -tns 10.0.0.1 > Cannot determine ORACLE_HOME for sid 10.0.0.1 > > Could someone help me? 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.
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 What now? Login as user oracle2. this content 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
Like Show 0 Likes(0) Actions 1 2 3 Previous Next Go to original post Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology quite frankly proved to be a serious > problem to tackle. For example: Source Code oracle_service = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = TCP) (PROTOCOL = TCP) (HOST =
Feb 4, 2016 11:39 AM (in response to prashan91) Message 1070 not found; No message file for product=network, facility=TNSTNS-12545: Beside that CentOS isn't supported, you have probably not setup the Oracle thanks.