Re: 2 instances, 1 IP and 2 TCP ports ?

>Subject: 2 instances, 1 IP and 2 TCP ports ?
>From: "Sylvain - SdV" sylvain_at_sdv.fr
>Date: 2/13/01 5:52 PM GMT Standard Time
>Message-id: <96bptj$ck7$1_at_reader1.fr.uu.net>
>
>
> Hi !
>
>My Oracle Server (v 8.0.5) has 2 instances, actually listening on the same
>port, on the same IP.
>
>What I want my listener to listen to, is IP:port1 and IP:port2.
>What I want too, is if I connect via IP:port1, user could access instance 1
>and instance 2; but if connect via IP:port2, user coul only access instance
>2.
>
>So, what my listener.ora file will look like ?
>This one ? :
>
>LISTENER =
> (ADDRESS_LIST =
> (ADDRESS= (PROTOCOL= TCP)(Host= oracle.domain.com)(Port= 1521))
> (ADDRESS= (PROTOCOL= TCP)(Host= oracle.domain.com)(Port= 15210))
> )
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME= oracle.)
> (ORACLE_HOME= /oracle/oracle8)
> (SID_NAME = inst1)
>---> here something like "Use ports 1521"...... ?
> )
> (SID_DESC =
> (GLOBAL_DBNAME= oracle.)
> (ORACLE_HOME= /oracle/oracle8)
> (SID_NAME = inst2)
>---> here something like "Use ports 1521,15210"...... ?
> )
> (SID_DESC =
> (SID_NAME = extproc)
> (ORACLE_HOME = /oracle/oracle8)
> (PROGRAM = extproc)
> )
> )
>
>
>Hope my English is good enough to be understood !
>
>Sylvain H.
>
>

Hi Sylvain,
  I'm not sure whether you'd be able to limit the access to an instance by port number using a single listener - I may be very wrong. However, you should be able to do it by employing multiple listeners. The first listens on both the first port for both instances, while the second listens on the second port for only 1 instance.
Regards,
  Rob Received on Tue Feb 13 2001 - 15:26:53 CST