Is Listener Service running?
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)
> (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 Sat Dec 18 1999 - 22:36:01 CST
