Re: local 8i db on nt - tnsnames error

I can't help wonder why you have PROTOCOL=IPC and PORT=1521 together. Normally, you would have PROTOCOL=TCP when you specify PORT=1521. (The same should apply in both tnsnames.ora and listener.ora)

Could this be part of your problem?

:)BF

Peter Hewson <phew_at_ozemail.com.au> wrote in message news:385BB9C4.622BC0D0_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)
> (Host = piii-500)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = devl)
> )
> )
> -----
>
>
> Here is my listener.ora entry
> ------
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(HOST = piii-500)(PORT = 1521))
> )
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = ExtProc)
> (ORACLE_HOME = d:\ORANT8i)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = devl)
> (ORACLE_HOME = d:\ORANT8i)
> (SID_NAME = devl)
> )
> )
> -------
>
> Any advice anyone?
>
> Thanks, Peter
>
>
Received on Mon Dec 20 1999 - 06:28:34 CET