LISTENER.ORA modification

From: Harald Diesveld <hdiesvel_at_best.ms.philips.com>
Date: 1997/01/13
Message-ID: <32DA53E9.4CC3@best.ms.philips.com>#1/1

Hello,

I have trouble installing the gateway to SQL Server. I am not able to modify my listener.ora file as stated in the installation guide. When I do that I get an error restarting the listener service. My listener.ora file (before the changes) is quoted below:

################
# Filename......: listener.ora
# Node..........: local.world

# Date..........: 24-MAY-94 13:23:20

################

LISTENER =
  (ADDRESS_LIST =

        (ADDRESS=


          (PROTOCOL= IPC)

          (KEY= oracle.world)

        )
        (ADDRESS=


          (PROTOCOL= IPC)

          (KEY= ORCL)

        )
        (ADDRESS= 


          (COMMUNITY= TCP.world)

          (PROTOCOL= TCP)

          (Host= clm02)

          (Port= 1521)

        )
        (ADDRESS= 


          (COMMUNITY= TCP.world)

          (PROTOCOL= TCP)

          (Host= clm02)

          (Port= 1526)

        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL)
    )
  )
PASSWORDS_LISTENER = (oracle)

To this, I have to add something like

        (ADDRESS= 


          (COMMUNITY= TCP.world)

          (PROTOCOL= TCP)

          (Host= ws03)

          (Port= 1433)

        )

This I can manage, but then the SID_NAME must be added:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = MSQL)
    )
  )

I don't know where to put this. I cannot find a sample listener.ora file that has two SID_LIST elements.

Could someone show me how to modify this listener.ora file in a correct way?

Many greetings from The Netherlands,

Harald Diesveld
Philips Medical Systems Nederland BV Received on Mon Jan 13 1997 - 00:00:00 CST