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: Oracle 8.0.6 EE listener problem

Re: Oracle 8.0.6 EE listener problem

From: Winnie Liu <hkitty_at_earthlink.net>
Date: 2000/05/13
Message-ID: <ScfT4.58410$g4.1620761@newsread2.prod.itd.earthlink.net>#1/1

Did you start up the listener on your server though? Oracle is complaining that there is no listener listening in your server. Even though your listener file is correct, Oracle will NOT automatically start up your listener! You will need to start that service yourself.

Winnie

Alex Savitsky wrote in message ...
>Hi,
>
>I have the following problem:
>
>Windows NT network (NT4 Server SP5), one computer is running Oracle 8.0.6
>Enterprise Edition. When I try to setup connection from another computer
>(same OS), only Named Pipes connection seem to work. TCP/IP gives "TNS: no
>listener" error. listener.ora and tnsnames.ora are plain simple:
>
>LISTENER.ORA
>LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)))
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = ILUVATAR)(PORT = 1521)))))
>
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = D:\ORANT\Ora8i)
> (PROGRAM = extproc))
> (SID_DESC =
> (GLOBAL_DBNAME = ARDA)
> (ORACLE_HOME = D:\ORANT\Ora8i)
> (SID_NAME = ARDA)))
>
>TNSNAMES.ORA
>ARDA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = ILUVATAR))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = ARDA)
> )
> )
>
>Do I miss something? Any ideas?
>
>Please reply on my work address: alex_at_locus.on.ca
>
>Thanks in advance.
>
>Alex Savitsky
>Senior Software Engineer
>Locus Systems Inc.
>
>
>
Received on Sat May 13 2000 - 00:00:00 CDT

Original text of this message

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