2 instances, 1 IP and 2 TCP ports ?

From: Sylvain - SdV <sylvain_at_sdv.fr>
Date: Tue, 13 Feb 2001 17:52:45 -0000
Message-ID: <96bptj$ck7$1@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 - 11:52:45 CST