jump to navigation

Connecting to Oracle behind a firewall May 21, 2008

Posted by maxmil in : Oracle , trackback

Although 1521 is Oracles default listener port it is not enough to only open this port. When a client connects to Oracle it then picks another port for the communication. If this port happens to be closed in the firewall then the connection fails with a timeout error.

To force Oracle to use port 1521 on Windows you have to add a key to the registry.

– Open regedit.
– Navegate to \\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
– Create string USE_SHARED_SOCKET
– Edit and set value to TRUE

Comments»

no comments yet - be the first?