Oracle 8.0.6 EE listener problem

From: Alex Savitsky <asavicki_at_sprint.ca>
Date: 2000/05/12
Message-ID: <aB0T4.35671$wz3.72093@newscontent-01.sprint.ca>#1/1

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 Fri May 12 2000 - 00:00:00 CDT