Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12154: TNS:could not resolve service name - what am I doing wrong?

Re: ORA-12154: TNS:could not resolve service name - what am I doing wrong?

From: Paul de Anguera <nospam_at_quidnunc.net>
Date: Fri, 10 Sep 1999 06:21:22 GMT
Message-ID: <7ra86a$3t1$5@news.chatlink.com>


In article <37d620d1.88598277_at_88.0.3.103>, tzifa_at_yahoo.com (Hope) wrote:
>Hi All
>I'm trying to install an oracle 8.0 server for testing on an NT
>workstation. I installed the server, installed a Net8 server with
>TCP/IP adaptor and started the OracleTNS service (actually it was
>already started)
>
>I defined the server with easy config on my client , and the testing
>said everything is OK
>When I try to connect with SQL plus I get the following message
>any ideas?

Sounds like a bad TNSNAMES.ORA file to me. Or, it could be resolution of the host name for the service name in the TNSNAMES.ORA if you didn't hard code an IP address. If you're using a DNS look for a HOSTS file in the windows directory, it will override your DNS if it is there.

Paul de Anguera | "You can't write a chord ugly enough to say
Reply to:       | what you want to say sometimes, so you have to
deanguer@       | rely on a giraffe filled with whipped cream."
quidnunc.net    | - Frank Zappa
Received on Fri Sep 10 1999 - 01:21:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US