Listener and Multiple Ports

[vr76413]

Hi guys..

Solaris 10 and Oracle 10gR2

I have one DB called DSS listening on PORT 1521. Can i make this listener to also listen on Port 1556 by making an entry like that, so there will be load balancing ?

================================================
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u10/app/ORACLE/product/10.2.0.1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = sdssssX)(PORT = 1521)
(ADDRESS = (PROTOCOL = TCP)(HOST = sdssssX)(PORT = 1526))
)
)
==========================================


thanks
Ron

[tamilselvan]

Did you get an error with 2 ports?

[vr76413]

no..there are no error messages.
But how do i know, if the listener has used port 1521 or port 1526 ?

thanks
Ron.

[Bore]

lsnrtl status
or some OS utility showing the ports (netstat say)

Regards

[LKBrwn_DBA]

Not sure, but you may need to add something like this to your tnsnames.ora file:

DB01 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sdssssX)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = sdssssX)(PORT = 1526))
      (LOAD_BALANCE=ON)
    )
    (CONNECT_DATA =
      (SERVER=DEDICATED)
      (SERVICE_NAME = DB01.WORLD)
    )
  )