如何设置使oracle服务端口为静态端口

摘自网上：
外网的应用服务器安装好OracleClient后，防火墙开设端口1551（Oracle监听端口），外网应用服务器程序仍然不能访问数据库。

原因：
For windows platform, the listener spawns a thread when accept an incoming SQL*Net connection and it will listen to a random free port other than the listener port. The connection is redirected to different port, so if the firewall just opens a single port it will not work。

解决方案：
To workaround this, we can set a Windows registry value USE_SHARED_SOCKET, put this registry key under your ORACLE registry://HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME<#>
Create the key USE_SHARED_SOCKET and assign the value TRUE.
After that you need to restart the Oracle service and also the Oracle listener, then it should work.