SQL*Net Add Second Instance

From: Donald P. Welker <welker_at_a1.vsdec.npt.nuwc.navy.mil>
Date: 1997/12/11
Message-ID: <01bd067f$492bea70$0a87be81@illuvatar>#1/1

We are running Omnis RDBMS client against Oracle 7.1.3.2.0 (OpenVMS VAX w/ Multinet) and would like to connect to a second instance. We have created the second instance but don't know the precise format for modifying the LISTENTER.ORA file. The relevant section looks like this:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = name_of_SID1)
(PROGRAM = 'DUA16:[ORACLE7.NETWORK.ADMIN]ORASRV_NETV2.COM')
(TIMEOUT = 0)

    )
  )

I assume I need to create a copy of the referenced DCL script and point it at the correct instance, but how do I add the second SID= entry? Do I need to put a comma between them, etc.? Received on Thu Dec 11 1997 - 00:00:00 CST