Home » RDBMS Server » Server Administration » Multiple Ports on a Single Listener (Oracle 10g Release 2 on Windows 2003)
Multiple Ports on a Single Listener [message #412493] Thu, 09 July 2009 13:22 Go to next message
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 #412494 is a reply to message #412493] Thu, 09 July 2009 13:24 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>do I simply create another listener?
yes
Re: Multiple Ports on a Single Listener [message #412516 is a reply to message #412494] Thu, 09 July 2009 14:56 Go to previous messageGo to next message
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 #412519 is a reply to message #412493] Thu, 09 July 2009 15:10 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>I did some research and testing
We're impressed.
Thanks for the feedback.
Re: Multiple Ports on a Single Listener [message #412520 is a reply to message #412519] Thu, 09 July 2009 15:13 Go to previous message
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.
Previous Topic: Migration 11g: ora-01000 when I call DBMS_STATS
Next Topic: ORA-07445
Goto Forum:
  


Current Time: Tue Dec 06 04:52:57 CST 2016

Total time taken to generate the page: 0.10197 seconds