Re: Oracle home

As others , including me, have mentioned you can set an environment variable ( a SYSTEM one) called

TNS_ADMIN =E:\ORACLE\ORA92\network\admin

You can also add this to the Registry ( in the HKLM/SOFTWARE/ORACLE section, not in one of the home listings )

Oracle 'checks' the environment variables, then the registry, then the default location under the current Oracle_Home to find the tnsnames.ora files...

hth,

Michael Gast <mig-sm_at_web.de> wrote:

>Hi Daniel,
>
>Daniel Morgan schrieb:
>> Michael Gast wrote:
>>
>>
>>>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?
>>
>> Based on your example ORACLE_HOME and ORA_BASE should be ORA92 ... not
>> either of the directories you mention.
>>
>> Daniel Morgan
>>
>
>You are right. My explanation was much to short and therefore i apologize.
>
>Now back to the problem: In the registry i find in the key
>HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES the values:
>
>DEFAULT_HOME = OraHome92
>HOME_COUNTER = 2
>LAST_HOME = 1
>ID0\NAME = OraHome92
>ID0\PATH = E:\ORACLE\ORA92
>ID1\NAME = OraDev902
>ID1\PATH = E:\ORACLE\ORADEV902
>
>What i expect in this case is, that the network configuration from the
>directory E:\ORACLE\ORA92\network\admin would be used. This is actually
>not the case. Instead, the system is currently using
>E:\ORACLE\ORADEV902\network\admin and i do not know why. So what must be
>done to use the settings in OraHome92?

-----------== 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 Wed Oct 02 2002 - 09:19:29 CDT