OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » Oracle ports (Oracle 9i/ 10g/ 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle ports [message #606834]

Wed, 29 January 2014 20:12

reym21
Messages: 241
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,

Report message to a moderator

Re: Oracle ports [message #606840 is a reply to message #606834]

Wed, 29 January 2014 22:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: Oracle ports [message #606843 is a reply to message #606840]

Wed, 29 January 2014 23:47

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

BlackSwan,

This is very informative and a good clarifications!

Thanks for the inputs.

Regards,

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 23:19:43 CDT 2024