Thanks for the question, Jongwouk.
Asked: January 18, 2017 - 6:49 am UTC
Last updated: January 19, 2017 - 3:50 am UTC
Version: ORACLE Database 11g Enterprise edition
Viewed 1000+ times
You Asked
hi tom
Am trying to do some tests about firewall between a client and oracle database.
Note that I am not a DB expert, so apologies that I am not able to describe the Oracle elements correctly and my English skills.
first thing to do is find out 'ORACLE Database 11g Enterprise edition' can use dynamic port.
(1-1)which means, initial server port is 1521, and the oracle server will dynamically allocate a different port for the connection to continue on.
or
(1-2)client connect with the server 1521 port and do something else using other port.
so my problem is i am getting hard time server to do the dynamic allocation.
My server is 'Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -64bit' and OS is Windows 7.
if you needs some config files, please let me know.
thanks for reading this and sorry about my English skills.
and Connor said...
You can check MOS Note 124140.1 which discusses this in detail.
You may see information that says "once a connection is done through port 1521, a randomly assigned port is then used". This information is *out of date*. We now do "port sharing" which means you only need to open up 1521.
Hope this helps.
Is this answer out of date? If it is, please let us know via a Comment