Re: Multiple instances and listeners

From: Francesco Dini <dini.f_at_adr.it>
Date: Tue, 30 Nov 1999 15:56:57 +0100
Message-ID: <3843E5B8.2E4FD095@adr.it>

I have four instances under the same ORACLE_HOME and one only listener.ora that works upon four different ports.
This is my listener.ora:

#
# Installation Generated Net V2 Configuration
# Version Date: Sep-16-97
# Filename: Listener.ora
#

LISTENER =
(ADDRESS_LIST =

 (ADDRESS=
(PROTOCOL= IPC)
(KEY= chsl)

 )

        (ADDRESS=
(PROTOCOL= IPC)
(KEY= chsl.world)

 )
 (ADDRESS=
(PROTOCOL= IPC)
(KEY= park)

 )

        (ADDRESS=
(PROTOCOL= IPC)
(KEY= park.world)

 )

        (ADDRESS=
                (PROTOCOL= IPC)
                (KEY= roch)
        )
        (ADDRESS=
                (PROTOCOL= IPC)
                (KEY= roch.world)
        )
        (ADDRESS=
                (PROTOCOL= IPC)
                (KEY= tivo)
        )
        (ADDRESS=
                (PROTOCOL= IPC)
                (KEY= tivo.world)
        )

 (ADDRESS=
(PROTOCOL= TCP)
(Host= sp01n1)
(Port= 1521)

 )
 (ADDRESS=
(PROTOCOL= TCP)
(Host= sp01n1)
(Port= 1522)

 )
 (ADDRESS=
(PROTOCOL= TCP)
(Host= sp01n1)
(Port= 1523)

 )
 (ADDRESS=
(PROTOCOL= TCP)
(Host= sp01n1)
(Port= 1524)

 )
  )
SID_LIST_LISTENER =
(SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME= sp01n1.)
      (ORACLE_HOME= /oracle/product/8.0.5)
      (SID_NAME = chsl)

    )
    (SID_DESC =

      (GLOBAL_DBNAME= sp01n1.)
      (ORACLE_HOME=/oracle/product/8.0.5 )
      (SID_NAME = park)

    )
    (SID_DESC =

      (GLOBAL_DBNAME= sp01n1.)
      (ORACLE_HOME=/oracle/product/8.0.5 )
      (SID_NAME = roch)

    )
    (SID_DESC =

      (GLOBAL_DBNAME= sp01n1.)
      (ORACLE_HOME=/oracle/product/8.0.5 )
      (SID_NAME = tivo)

    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF LIST_CHSL=
 (ADDRESS_LIST=
(ADDRESS=

   (PROTOCOL=IPC)
   (KEY=CHSL)
  )
(ADDRESS=

   (PROTOCOL=IPC)
   (KEY=CHSL.WORLD)
  )
(ADDRESS=

   (PROTOCOL=TCP)
   (HOST=sp01n1)
   (PORT=1521)

  )
 )
STARTUP_WAIT_TIME_LIST_CHSL = 0
CONNECT_TIMEOUT_LIST_CHSL = 10
TRACE_LEVEL_LIST_CHSL = OFF
SID_LIST_CHSL=
 (SID_LIST=
(SID_DESC=

   (SID_NAME=CHSL)
   (ORACLE_HOME=/oracle/product/8.0.5)
  )
 )

LIST_PARK=
 (ADDRESS_LIST=
(ADDRESS=

   (PROTOCOL=IPC)
   (KEY=PARK)
  )
(ADDRESS=

   (PROTOCOL=IPC)
   (KEY=PARK.WORLD)
  )
(ADDRESS=

   (PROTOCOL=TCP)
   (HOST=sp01n1)
   (PORT=1522)

  )
 )
STARTUP_WAIT_TIME_LIST_PARK = 0
CONNECT_TIMEOUT_LIST_PARK = 10
TRACE_LEVEL_LIST_PARK = OFF
SID_LIST_PARK=
 (SID_LIST=
(SID_DESC=

   (SID_NAME=PARK)
   (ORACLE_HOME=/oracle/product/8.0.5)
  )
 )

LIST_ROCH=

        (ADDRESS_LIST=
                (ADDRESS=
                        (PROTOCOL=IPC)
                        (KEY=ROCH)
                )
                (ADDRESS=
                        (PROTOCOL=IPC)
                        (KEY=ROCH.WORLD)
                )
                (ADDRESS=
                        (PROTOCOL=TCP)
                        (HOST=sp01n1)
                        (PORT=1523)
                )
        )

STARTUP_WAIT_TIME_LIST_ROCH = 0
CONNECT_TIMEOUT_LIST_ROCH = 10
TRACE_LEVEL_LIST_ROCH = OFF
SID_LIST_ROCH=

        (SID_LIST=
                (SID_DESC=
                        (SID_NAME=ROCH)
                        (ORACLE_HOME=/oracle/product/8.0.5)
                )
        )


LIST_TIVO=
        (ADDRESS_LIST=
                (ADDRESS=
                        (PROTOCOL=IPC)
                        (KEY=TIVO)
                )
                (ADDRESS=
                        (PROTOCOL=IPC)
                        (KEY=TIVO.WORLD)
                )
                (ADDRESS=
                        (PROTOCOL=TCP)
                        (HOST=sp01n1)
                        (PORT=1524)
                )
        )

STARTUP_WAIT_TIME_LIST_TIVO = 0
CONNECT_TIMEOUT_LIST_TIVO = 10
TRACE_LEVEL_LIST_TIVO = OFF
SID_LIST_TIVO=

        (SID_LIST=
                (SID_DESC=
                        (SID_NAME=TIVO)
                        (ORACLE_HOME=/oracle/product/8.0.5)
                )
        )

Received on Tue Nov 30 1999 - 08:56:57 CST