Accessing Oracle when ports are restricted 1

[GaryMurray]

I am trying to connect to a remote server that has an Oracle 8 database on it through a firewall to firewall VPN.

The only ports that are open on the firewall are 1521 1525 1526, I am unable to communicate with the database.

I do not want to restrict the database so that it only communicates on 1521 what do I need to do to gain access?

Thanks
Gary

 

[Turkbear]

Hi,
IIRC,you can use Connection Manager to specify the ports ..

There is also a listener setting that will cause it to use the same port ( usually 1521) for all communications -

Unless restricted, Oracle wil use a random port to handle the session's communications after the initial contact on 1521.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[joebednarz]

If your target database is on a Windows machine, you can put a setting in the registry that will help. \\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ will have multiple "HOMEx" keys for each Oracle home installed. Find the one corresponding to your database and add a key (on the right side) called "USE_SHARED_SOCKET" and assign a value of TRUE. You will have to restart the machine for this to work, but it is specifically designed to help with firewall connections. This setting forces the database and listener to only communicate on port 1521 (or the listening port) and may appease your network guys. I've heard this works for Linux, but haven't needed it on those boxes...

JoeB
Use smaller fonts to save disk space...