Re: Listener with multiple databases

From: Nathan Hughes <nhughes_at_cerberus.umd.umich.edu>
Date: 1997/07/15
Message-ID: <5qg2dd$dcu@cerberus.umd.umich.edu>#1/1

Steven Egberghs <steven.egberghs_at_pec.be> writes:

>My configuration is :
>AIX 4.1
>Oracle WG 7.3
>Tcp/IP-clients

In listener.ora, you need to put each database you want the listener to service in the SID_LIST_LISTENER section. I.E:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME = DB1.world)
      (SID_NAME = DB1)

    )
    (SID_DESC =

      (GLOBAL_DBNAME = DB2.world)
      (SID_NAME = DB2)

    )
  )

That should be all you need. Run lsnrctl reload and you're off.

-- 
/(o\ Nathan D. Hughes
\o)/ nhughes_at_umich.edu

Received on Tue Jul 15 1997 - 00:00:00 CDT