Re: Oracle Developer gives ORA 12154

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Mon, 23 Apr 2001 19:23:46 GMT
Message-ID: <6j%E6.15530$%N.124586_at_skycache.prestige.net>


I had what sounds like a similar problem. What ended up fixing the problem was that I had to manually start the listener after starting the local DB. I now have an icon for lsnrctl.exe on my quick start bar.

"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:23:46 CEST

Original text of this message