Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle home

Re: Oracle home

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Tue, 01 Oct 2002 13:45:48 -0500
Message-ID: <1uqjpuse0tod5ba1fk09t4kqgekhmjb87e@4ax.com>


Lets be very clear about this:
Neither entry you listed is a valid ORACLE_HOME; they are locations for your tnsnames.ora files used by SqlNet and should be referenced ( in one place only for ease of admin) by using the TNS_ADMIN variable mentioned below set to the /network.admin directory you want to use.
If on Windows( you do not say) there is a program ( under Oracle Installation Products usually) called the Oracle Home selector - it allows changing the default home on the fly..But, except for major version differences ( 8.1 to 9.1 for instance) Oracle can usually handle its tasks without changing the default home - the use of the TNS_ADMIN 'tells' all Oracle products where to find the connection info it needs..

In a Unix environment, you need to do an export ORACLE_HOME=/whatever/home/you/want ( In your example, either \ORADEV or \ORA92 ) hth,

"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote:

>Check out the TNS_ADMIN environment variable.
>
>also the SQL*Net administrator's guide.
>"Michael Gast" <mig-sm_at_web.de> wrote in message
>news:3D99ADF0.9020308_at_web.de...
>> Hi,
>>
>> i've downloaded and installed for some testing Oracle 9.2 and Oracle
>> Developer 9.0.2. Now the Oracle home is set to ORADEV902\network\admin
>> and not to ORA92\network\admin (that's what i expected). Note: I've
>> installed the dev environment after the DBMS.
>>
>> Unfortunately, i do not find the switch to set the path to the notwork
>> files to the proper directory. Where is it stored? What settings must be
>> done?
>>
>> --
>> Due to spam, this email address is only used for newsgroup postings.
>>
>> All emails sent to this address are immediately deleted. Therefore any
>> eMails sent directly to this address never will be answered.
>>
>> Mit freundlichen Grüßen / Best Regards
>> Michael Gast
>> SEPP MED GmbH
>>
>

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Tue Oct 01 2002 - 13:45:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US