Re: ORA-12154 with Toad and Designer

Been a while since I've done this, but ...

If you are using shared connections (MTS in ora speak)things change

Turn on tracing on the connection, you will see that even though you are using the IP ADDRESS of the solaris server in the TNSNAMES.ORA file, the server will return the HOSTNAME, and then your client gets confused.

Go to the hosts file in the windows OS on each client and add the ip address and hostname of the database server

should be OK, otherwise I'm wrong, but I'm notif you're running MTS

Stuart, resting DBA

"Ryan" <rgaffuri_at_cox.net> wrote in message news:EJZoa.143409$yh1.9016313_at_news1.east.cox.net...
>
> "Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message
> news:MPG.190def3bb278c8f9989743_at_news.la.sbcglobal.net...
> > rgaffuri_at_cox.net said...
> > > Yes, I know there are lots of posts on ORA-12154 and I read them.
> > > Didnt get what I want.
> > >
> > > On my new site we have:
> > >
> > > Oracle 8.1.7 database instances(several) on several Solaris v5.08
> > > platforms
> > > I have 817 client installed
> > > Second Oracle home Designer 2.1.2
> > > Also have toad installed
> > >
> > > No problem connecting to any databases with SQLPLUS. I have my
> > > TNSNAMES.ORA in the appropriate network/admin and net80/admin
> > > directories.
> > >
> > > However, when I try to connect to the database with either TOAD or
> > > Designer I get the ORA-12154: unable to resolve service names.
> > >
> > > In toad you can set your SQLNET and I do set it to one of my Oracle
> > > homes(need two homes because older version of designer needs older
> > > home) and its says my SQLNET is correct, but still get the error.
> > >
> > > any ideas?
> > >
> > > also, anyone got a link to a tech support forum on quest software
> > > site? couldnt find it.
> > >
> > You have two (or more) tnsnames.ora files. Are they identical? I mean,
> > really identical? Recently a friend asked me to help him resolve his
> > 12154 error ... and it turned out to be a missing right parens ... so
> > Net8 totally ignored that particular entry (with no error message). The
> > reason I'm not sure about how many tnsnames.ora files you have is
> > because you use forward slashes in your example, as if your client is on
> > Solaris; but you talk about Toad (a PC app).
> >
> > Check your path to see which sqlplus is getting run. I assume you have a
> > sqlplus (or sqlplusw) in the bin directory of both homes. Temporarily
> > rename the one that's first in your path and see if you can still
> > connect via sqlplus using the second home's copy. That will tell you if
> > both tnsnames.ora are correct.
> >
> > When you connect with sqlplus, you'll be using the tnsnames.ora in
> > net80/admin (I assume), so it's probably the "correct one." Rename the
> > one in network/admin and copy the net80/admin one.
> > --
> > /Karsten
> > DBA > retired > DBA
>
> Server is on Solaris. Client is on Windows 2k. My bad.
>
>
Received on Tue Apr 22 2003 - 13:05:03 CEST