| Multiple Ports on a Single Listener [message #412493] |
Thu, 09 July 2009 13:22  |
Firearm
Messages: 7
Registered: October 2008
Location: Illinois
|
Junior Member |
|
|
Can you configure a single Oracle Listener to use more than one port for a database instance? I have read a couple areas on how to do this but they didn't work. Can this be done and how?
Basically I want my Listener to use ports 1521 and 1525.
Why? Well that is another story but I do need to know if I can do it or do I simply create another listener?
|
|
|
|
|
|
| Re: Multiple Ports on a Single Listener [message #412516 is a reply to message #412494] |
Thu, 09 July 2009 14:56  |
Firearm
Messages: 7
Registered: October 2008
Location: Illinois
|
Junior Member |
|
|
I did some research and testing on this and I guess you can in fact run multiple ports on a single listener. I configured our test server to use 1521 and 1525 and it seems to connect to both ports just fine. Here is what I did as per Metalink ID 232010.1
My LISTNER.ORA:
LISTENER10GR2 =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (PROTOCOL = TCP)(HOST = mydatabase)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = mydatabase)(PORT = 1525))
)
And a status:
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mydatabase)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mydatabase)(PORT=1525)))
Also set the local_listener param, in my case to LISTENER10GR2.
[Updated on: Thu, 09 July 2009 14:58] Report message to a moderator |
|
|
|
|
|
| Re: Multiple Ports on a Single Listener [message #412520 is a reply to message #412519] |
Thu, 09 July 2009 15:13 |
Firearm
Messages: 7
Registered: October 2008
Location: Illinois
|
Junior Member |
|
|
You are welcome. I am of course not like most people who simply post and hope for an answer. I post my question and also continue on trying to find the answer myself. I also am one who likes to share my results if I find another answer.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
