RE: ORACLE_HOME
Date: Tue, 19 Jan 2010 08:36:38 -0500
Message-ID: <0684DA55864E404F8AD2E2EBDFD557DA03E7D544_at_JAXMSG01.crowley.com>
You might want to check Martin Bach's notes, (I havn't), but there is an order of precedence which I will not attempt to be accurate about.
First the environment and which tnsnames.ora file is being used are two different things.
For the tnsnames.ora file the order a program would look might probably be - or close to. Remember, once the connect string is found looking for the connect string ceases.
- The directory you started the program in. if there is one there it will be used.
- The TNS_ADMIN system environment variable - start control panel, system, ... advanced, env var button,...
- $ORACLE_HOME/network/admin directory -- this depends of course on what environment is set. (normally the default - which is why it is easier to run one windows DB/server).
- (might look in path, not sure)
- not sure of other steps.
Hope that helps, or prompts someone to elaborate more specifically.
Joel Patterson
Database Administrator
904 727-2546
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu
Sent: Monday, January 18, 2010 4:28 PM
To: oracle-l_at_freelists.org
Subject: ORACLE_HOME
As I am learning Oracle in the Windows environment, I noticed that I do not have to set ORACLE_HOME.
Am I missing something? Thanks!
H:\>echo %ORACLE_HOME%
%ORACLE_HOME%
H:\>sqlplus system/manager_at_triwebb
SQL*Plus: Release 10.1.0.4.2 - Production on Mon Jan 18 15:23:00 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release
10.2.0.4.0 - 64
bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
H:\>set
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\rxu\Application Data
CATALINA_HOME=C:\Tomcat5028
CLASSPATH=C:\j2sdk1.4.2_06;C:\Tomcat5028\webapps\WEB-INF\classes
CLIENTNAME=BB011257
ClusterLog=C:\WINDOWS\Cluster\cluster.log
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=DRAGON
ComSpec=C:\WINDOWS\system32\cmd.exe
FP_NO_HOST_CHECK=NO
HOMEDRIVE=H:
HOMEPATH=\
HOMESHARE=\\cbcsrv1\users$\rxu
JAVA_HOME=C:\j2sdk1.4.2_06
LOGONSERVER=\\CBCADC2
NUMBER_OF_PROCESSORS=8
OS=Windows_NT
Path=E:\OraIAS\jdk\jre\bin\classic;E:\OraIAS\jdk\jre\bin;E:\OraIAS\bin;E
:\OraIAS
\jlib;E:\OraPortal\bin;E:\OraPortal\jlib;D:\oracle\product\10.2.0\db_1\b
in;C:\WI NDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Dell\SysMgt\
RAC5;C:\Program Files\Dell\SysMgt\oma\bin;%OMPATH%;C:\j2sdk1.4.2_06\bin PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86 PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 11, GenuineIntel PROCESSOR_LEVEL=6 PROCESSOR_REVISION=0f0b
ProgramFiles=C:\Program Files
PROMPT=$P$G
SESSIONNAME=RDP-Tcp#129
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\rxu\LOCALS~1\Temp\1
TMP=C:\DOCUME~1\rxu\LOCALS~1\Temp\1
USERDNSDOMAIN=CARTERBC.NET
USERDOMAIN=CARTERBC
USERNAME=rxu
USERPROFILE=C:\Documents and Settings\rxu windir=C:\WINDOWS
H:\>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 19 2010 - 07:36:38 CST