Oracle Database 11g listener with 2 ports
837767Feb 8 2011 — edited Feb 8 2011Hello.
We use oracle database 11.1.0.7.4 .
We need to create listener with 2 ports.
I mean listener must work with 1521 port and with 1526 port.
1) I may create 2 listeners. Listener1 and listener2. First with 1521, second with 1526.
Question 1: Can i create only one listener with 2 ports? Please provide commands in listener.ora
2) About tnsnames.ora
Question 2: How to create connecting string to database with 2 ports ?! How to create it, if 1 first listener will be down it will work on second ?
My examples:
listener ora:
LISTENER_TST2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.200.253.154)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ENVS="EXTPROC_DLLS=ANY")
)
)
LISTENER_TST2_1526 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.200.253.154)(PORT = 1526))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1526))
(ENVS="EXTPROC_DLLS=ANY")
)
)
What we need in tnsnames.ora?