Home » RDBMS Server » Networking and Gateways » Oracle ports (Oracle 9i/ 10g/ 11g)
Oracle ports [message #606834] Wed, 29 January 2014 20:12 Go to next message
reym21
Messages: 178
Registered: February 2010
Location: Philippines
Senior Member

Gurus,

Good day!

We're planning to change the ports of our database servers by type of servers (Production, Test/staging and Development).
We want that all Production dB ports would start as default re: 1521/1526/1522, Test/staging would start at 1621//1622/1623
while the Development would start at 1721/1722/1723. Or since we had a different versions of Oracle databases in a single box,
we opted also to implement by versions, re: Oracle 9i- ports 17xx, Oracle 10g- ports 16xx and Oracle 11g- port 15xx.
It this a good strategy to address security and network congestion?

Thanks for your advice.

Regards,

Re: Oracle ports [message #606840 is a reply to message #606834] Wed, 29 January 2014 22:40 Go to previous messageGo to next message
BlackSwan
Messages: 22798
Registered: January 2009
Senior Member
>We want that all Production dB ports would start as default re: 1521/1526/1522, Test/staging would start at 1621//1622/1623
databases do NOT have ports.
Listener may be configured to monitor one or more ports.

Please realize that the listener is only involved between client & the database to complete the initial connection request.
After the listener hands the request off to the requested database, the listener has NO involvement with any continuing packet exchange between client & DB!

>It this a good strategy to address security and network congestion?
The proposal is totally moronic & laughable.

How does using a different port# "address security"?
Security by obscurity is as transparent as glass.

Do you realize that every Network Interface Card (NIC) is a SERIAL device?
The fact every NIC is a serial device means that when any packet exchange uses port# 1521 then NO other port# can be in use concurrently.
So assigning multiple port#s, does NOTHING to reduce "network congestion"!

While you may think this proposal is "progress"; it is an utter waste of time & resources which will add nothing but unneeded complexity.

A single listener running from the highest version of ORACLE_HOME using a single port(1521) is sufficient & the recommended implementation.
Re: Oracle ports [message #606843 is a reply to message #606840] Wed, 29 January 2014 23:47 Go to previous message
reym21
Messages: 178
Registered: February 2010
Location: Philippines
Senior Member

BlackSwan,

This is very informative and a good clarifications!

Thanks for the inputs.

Regards,
Previous Topic: JBoss Connection in oracle db 10g
Next Topic: TNS:could not resolve the connect identifier specified
Goto Forum:
  


Current Time: Mon Sep 22 13:33:22 CDT 2014

Total time taken to generate the page: 0.11836 seconds