Re: local 8i db on nt - tnsnames error

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 20 Dec 1999 15:23:41 GMT
Message-ID: <83lhlt$rr1$3@news.seed.net.tw>

Peter Hewson <phew_at_ozemail.com.au> wrote in message news:385BBA0E.AFEB88EC_at_ozemail.com.au...
> Hi,
>
> I am trying to connect to a local 8i database on my nt machine.
> >From sqlplus, if I don't enter the host string it is OK.
> But if I enter devl, it has a TNS failure. Toad needs a host string,
> so it does'nt work.
>
> Here is my tnsnames.ora entry
> -----
> devl =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = IPC)
Change this line to:

(PROTOCOL = TPC)
> (Host = piii-500)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = devl)
> )
> )

[snip]

PORT is the attribute for TCP/IP protocol, not for IPC. Received on Mon Dec 20 1999 - 09:23:41 CST