RE: ORACLE_HOME

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Mon, 18 Jan 2010 22:13:32 -0500
Message-ID: <BAY107-W71DEA60D73B318959A567A1650_at_phx.gbl>


There is another way to handle this situation. You may create an

 oraenv_SID.bat file and put some settings like following to login to right database using right oracle home. It is quite helpful if you are managing more then one database and/or with mutiple oracle homes.  

set ORACLE_HOME=c:\oracle

set local=ORCL ---entry from tnsnames.ora file

set ORACLE_SID=ORCL

You may run this file on dos command and then login to that database.  

Regards

Rafiq

Date: Mon, 18 Jan 2010 16:27:56 -0800
From: oratune_at_yahoo.com
Subject: Re: ORACLE_HOME
To: wellmetus_at_gmail.com; jslowik_at_cps92.com CC: oracle-l_at_freelists.org

If you have multiple ORACLE_HOME locations on a Windows server you'll also have the Oracle Home Selector at Start->All programs-> Oracle Universal Installer -> Oracle Home Selector. This sets the ORACLE_HOME in the registry to point to one of the valid locations Windows knows of. It will also tell you which home you're currently using by simply starting it.  

David Fitzjarrell  

From: Roger Xu <wellmetus_at_gmail.com>
To: Joel Slowik <jslowik_at_cps92.com>
Cc: oracle-l_at_freelists.org
Sent: Mon, January 18, 2010 5:03:04 PM
Subject: Re: ORACLE_HOME

In my case below, I just want to know which tnsnames.ora file I am using. There are many tnsnames.ora files in this server and I was able to try each to figure out the one I am using. But this is not the right way to get the answer ... (I feel home when running Oracle in UNIX :)

On Mon, Jan 18, 2010 at 3:41 PM, Joel Slowik <jslowik_at_cps92..com> wrote:

As I am learning oracle in the windows environment, Iíve noticed that it usually only matters if you have more than one oracle database instance up and running on the same server.  

Thatís just my experience so far.  

-joel
 

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\bin;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:\>      

Confidentiality Note: This electronic message transmission is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. If you have received this transmission, but are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this information is strictly prohibited. If you have received this e-mail in error, please contact Continuum Performance Systems at {203.245.5000} and delete and destroy the original message and all copies.                                                



Hotmail: Trusted email with Microsoftís powerful SPAM protection. http://clk.atdmt.com/GBL/go/196390706/direct/01/
--

http://www.freelists.org/webpage/oracle-l Received on Mon Jan 18 2010 - 21:13:32 CST

Original text of this message