Re: Oracle Developer gives ORA 12154

[Quoted] [Quoted] Several approaches, but the best may be

Create an string value entry in the registry under \HKEY_LOCAL_MACHINE\Software\Oracle

called TNS_ADMIN and fill in the location of one of your tnsnames.ora files ; [Quoted] <drive>:SomeOracle_home\network\admin

[Quoted] Oracle will look in that location for the tns info ; otherwise you'll have to [Quoted] [Quoted] keep copies of a good tnsnames.ora file in ALL your Oracle Home directories...

[Quoted] [Quoted] "Dave Penn" <djpenn3_at_NO_SPAM_hotmail.com> wrote:

>Here's my setup and problem...I hope somebody can help!
>
>Win2K Pro, SP1
>
>I've installed several instances of Oracle: 8.1.6 Personal, 8.1.7 Personal,
>and 8.1.6 Enterprise. I can go into any or all of them and set up a
>connection (using the DBA Studio) to a database on my school's server and
>connect through SQL*PLUS so I know I've got those listeners working. But I
>tried to install Oracle Developer, and the installer wouldn't let me install
>it to any of the 3 existing homes (the homes of the instances mentioned
>above), giving a message that "the location specified, D:\<path> is already
>in use as an Oracle Home for 'Oracle 816 Production'. It cannot be used as
>an Oracle Home for 'nt'.
>
>So I installed it to a separate home of its own, and I've tried to connect
>to any of the local db's that were configured during installation of the 3
>instances listed above, but I get ORA 12154: TNS:cannot resolve service
>name. Same when I try to connect to the remote db at my school. I've added
>an entry in the TNSNAMES.ORA for the db at school, using the same case,
>indentation, spaces, etc. to make it look exactly like the ones that were
>already there, but to no avail.
>
>Any help would be hugely appreciated.
>
>Dave Penn
>
Received on Mon Apr 23 2001 - 18:58:13 CEST