Re: LISTENER.ORA modification

Harald Diesveld wrote:
>
> 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

The SID_LIST_LISTENER part of the LISTENER.ORA file should look like this for two (or more) SID's:

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

• JHY