Here is the listener.ora file

From: jean-paul <jpchausseau_at_cgf-pharmatechREMOVE.com>
Date: Fri, 20 Jul 2001 17:55:05 GMT
Message-ID: <995651705.81718@news.aei.ca>

Scott,

It was a good idea to ask for this file. I should have thought of it myself of course (sorry...).

Just a few comments: Port 9000 is not used by any other application on the server. Also, replacing the line:
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 9000)) with (ADDRESS = (PROTOCOL = TCP)(HOST = SERVEUR01)(PORT = 9000))

does not change the (negative) outcome.

# C:\ORACLE805\NET80\ADMIN\LISTENER.ORA Configuration File:C:\oracle805\net80\admin\listener.ora # Generated by Oracle Net8 Assistant

PASSWORDS_LISTENER= (oracle)

LISTENER =
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world))
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (PROTOCOL = NMP)(SERVER = SERVEUR01)(PIPE = ORAPIPE))
(ADDRESS = (PROTOCOL = TCP)(HOST = Serveur01)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVEUR01)(PORT = 1526))
(ADDRESS = (PROTOCOL = SPX)(SERVICE = Serveur01_lsnr))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 9000))
  )

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =

      (SID_NAME = extproc)
      (PROGRAM = extproc)

    )
(SID_DESC =

      (GLOBAL_DBNAME = Serveur01)
      (SID_NAME = ORCL)

    )
  )

"Scott Watson" <swatson_at_datachest.com> a écrit dans le message news: CTH57.901$OK2.131401_at_news20.bellglobal.com...

> I think it would help if you posted you listener.ora file.
>
> scott watson.

Received on Fri Jul 20 2001 - 12:55:05 CDT