Re: Multiple Instances

From: Fred Stojentin <stojentin_at_orgdv.din.de>
Date: Thu, 24 Jun 1999 14:52:32 GMT
Message-ID: <377243a0.25835237@news.cis.dfn.de>

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 - 09:52:32 CDT