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

This is not possible in one listener, as the TCP/IP protocol will use *one* port (the first defined)
Also it is unclear to me why you want to do this, as the listener is a *broker* only, ie there is *no connection at all* once it has spawned a background process.

Hth,

Sybrand Bakker, Oracle DBA

"Sylvain - SdV" <sylvain_at_sdv.fr> wrote in message news: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.
>
>
Received on Tue Feb 13 2001 - 15:26:28 CST