Re: Oracle Developer gives ORA 12154

Perfect! I sensed I was close and that the fix was fairly straightforward, but it would have taken me eons to have come across that registry entry. Of course, it would have taken all the fun out of it if Oracle had just given me this info voluntarily:-) ...or maybe I should have spotted it somewhere and didn't.

Thanks tons, in any case. It'll save me an hour of driving each day for the next several weeks!

Come collect your free beer if you're ever in Minnesota.

Dave Penn

"TurkBear" <noone_at_nowhere.com> wrote in message news:dhn8etkebg0qq1hlmbtjsflj69vr3n3ueb_at_4ax.com...
>
> 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 ;
> <drive>:SomeOracle_home\network\admin
>
>
>
> Oracle will look in that location for the tns info ; otherwise you'll have
 to
> keep copies of a good tnsnames.ora file in ALL your Oracle Home
 directories...
>
>
>
> "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 - 21:59:28 CEST