Re: Multiple Instances

Thanks
Thanks
Thanks

You win a travel in Rome

Thank you very much!

It's all right now.

Fred Stojentin wrote:

> On Thu, 24 Jun 1999 11:04:42 +0200, Kekko <dini.f_at_adr.it> wrote:
>
> Hi Kekko,
>
> >I would know which are the correct steps for creating another instance
> >(Rel. 7.3.4 on HP UX 10.20). In particular how can I modify the actual
> >listener.ora?
> >Thanks
> >Kekko
> >
>
> Here is an example for multi instance listener.
> Normally the standard listener is used for all (three) instances, but
> under some circumstances it's useful to have them separated.
> If you need to set up with MTS please repost.
>
> The databases are ABC, XYZ and JOLY.
>
> ----- TOP OF FILE listener.ora
> #--------------------------------------------------------------
> # /u01/app/oracle/product/7.3.4/network/admin/listener.ora
> #--------------------------------------------------------------
> #--------------------------------------------------------------
> # Listener LISTENER (instances/databases ABC, JOLY and XYZ)
> #--------------------------------------------------------------
> LISTENER=
> (ADDRESS_LIST=
> (ADDRESS=
> (PROTOCOL=IPC)
> (KEY=JOLY)
> )
> (ADDRESS=
> (PROTOCOL=IPC)
> (KEY=JOLY.WORLD)
> )
> (ADDRESS=
> (PROTOCOL=IPC)
> (KEY=XYZ)
> )
> (ADDRESS=
> (PROTOCOL=IPC)
> (KEY=XYZ.WORLD)
> )
> (ADDRESS=
> (PROTOCOL=IPC)
> (KEY=ABC)
> )
> (ADDRESS=
> (PROTOCOL=IPC)
> (KEY=ABC.WORLD)
> )
> (ADDRESS=
> (COMMUNITY=TCP_COM.WORLD)
> (PROTOCOL=TCP)
> (Host=x.x.x.x)
> (Port=1521)
> )
> (ADDRESS=
> (COMMUNITY=TCP_COM.WORLD)
> (PROTOCOL=TCP)
> (Host=z.z.z.z)
> (Port=1521)
> )
> )
> STARTUP_WAIT_TIME_LISTENER=0
> CONNECT_TIMEOUT_LISTENER=100
> # Use Trace on level 16 for error searching!
> TRACE_LEVEL_LISTENER=OFF
> # TRACE_DIRECTORY_LISTENER=/u01/app/oracle/product/7.3.4/network/trace
> # TRACE_FILE_LISTENER=listener.trc
> # LOG_DIRECTORY_LISTENER=/u01/app/oralce/product/7.3.4/network/log
> # LOG_FILE_LISTENER=listener.log
> SID_LIST_LISTENER=
> (SID_LIST=
> (SID_DESC=
> (SID_NAME=JOLY)
> (ORACLE_HOME=/u01/app/oracle/product/7.3.4)
> )
> (SID_DESC=
> (SID_NAME=XYZ)
> (ORACLE_HOME=/u01/app/oracle/product/7.3.4)
> )
> (SID_DESC=
> (SID_NAME=ABC)
> (ORACLE_HOME=/u01/app/oracle/product/7.3.4)
> )
> )
>
> #--------------------------------------------------------------
> # Listener JOLY (only for JOLY)
> #--------------------------------------------------------------
> L_JOLY=
> (ADDRESS_LIST=
> (ADDRESS=
> (PROTOCOL=IPC)
> (KEY=JOLY)
> )
> (ADDRESS=
> (PROTOCOL=IPC)
> (KEY=JOLY.WORLD)
> )
> (ADDRESS=
> (COMMUNITY=TCP_COM.WORLD)
> (PROTOCOL=TCP)
> (Host=z.z.z.z)
> (Port=1521)
> )
> (ADDRESS=
> (COMMUNITY=TCP_COM.WORLD)
> (PROTOCOL=TCP)
> (Host=x.x.x.x)
> (Port=1521)
> )
> )
> STARTUP_WAIT_TIME_L_JOLY=0
> CONNECT_TIMEOUT_L_JOLY=100
> TRACE_LEVEL_L_JOLY=OFF
> # TRACE_DIRECTORY_L_JOLY=/u01/app/oracle/product/7.3.4/network/trace
> # TRACE_FILE_L_JOLY=l_JOLY.trc
> # LOG_DIRECTORY_L_JOLY=/u01/app/oralce/product/7.3.4/network/log
> # LOG_FILE_L_JOLY=l_JOLY.log
> SID_LIST_L_JOLY=
> (SID_LIST=
> (SID_DESC=
> (SID_NAME=JOLY)
> (ORACLE_HOME=/u01/app/oracle/product/7.3.4)
> )
> )
>
> #--------------------------------------------------------------
> # Listener XYZ (only for XYZ)
> #--------------------------------------------------------------
> L_XYZ=
> (ADDRESS_LIST=
> (ADDRESS=
> (PROTOCOL=IPC)
> (KEY=XYZ)
> )
> (ADDRESS=
> (PROTOCOL=IPC)
> (KEY=XYZ.WORLD)
> )
> (ADDRESS=
> (COMMUNITY=TCP_COM.WORLD)
> (PROTOCOL=TCP)
> (Host=z.z.z.z)
> (Port=1521)
> )
> (ADDRESS=
> (COMMUNITY=TCP_COM.WORLD)
> (PROTOCOL=TCP)
> (Host=x.x.x.x)
> (Port=1521)
> )
> )
> STARTUP_WAIT_TIME_L_XYZ=0
> CONNECT_TIMEOUT_L_XYZ=100
> TRACE_LEVEL_L_XYZ=OFF
> # TRACE_DIRECTORY_L_XYZ=/u01/app/oracle/product/7.3.4/network/trace
> # TRACE_FILE_L_XYZ=l_XYZ.trc
> # LOG_DIRECTORY_L_XYZ=/u01/app/oralce/product/7.3.4/network/log
> # LOG_FILE_L_XYZ=l_XYZ.log
> SID_LIST_L_XYZ=
> (SID_LIST=
> (SID_DESC=
> (SID_NAME=XYZ)
> (ORACLE_HOME=/u01/app/oracle/product/7.3.4)
> )
> )
> ----- BOTTOM OF FILE listener.ora
Received on Thu Jun 24 1999 - 11:47:59 CDT