Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Net Add Second Instance
you just duplicate the SID_DESC section keeping it inside the SID_LIST parenthesis set. See below.
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = name_of_SID1)
> (PROGRAM = 'DUA16:[ORACLE7.NETWORK.ADMIN]ORASRV_NETV2.COM')
> (TIMEOUT = 0)
> )
(SID_DESC = (SID_NAME = name_of_SID2) (PROGRAM ......) (TIMEOUT = ...) )