OraFAQ Forum: Networking and Gateways » windows xp firewall

Home » RDBMS Server » Networking and Gateways » windows xp firewall - oracle connectivity

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

windows xp firewall - oracle connectivity [message #135450]

Wed, 31 August 2005 11:30

dinakar5008
Messages: 19
Registered: August 2005
Location: india

Junior Member

i have an oracle 9i enterprise edition rel 2 on windows xp professional system . when firewll is turned on , i am not able to connect to the server from any of my network clients..when i turned off the firewall , i am able to connect ... i tried to give exception on port numbers (tcp) 1521 & 2030 but no use ....
plz help me

Report message to a moderator

Re: windows xp firewall - oracle connectivity [message #135460 is a reply to message #135450]

Wed, 31 August 2005 12:16

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

USE_SHARED_SOCKET is a windows registry setting.
set it to TRUE
reboot the server.
try again.

Report message to a moderator

Re: windows xp firewall - oracle connectivity [message #135891 is a reply to message #135460]

Sun, 04 September 2005 01:30

dinakar5008
Messages: 19
Registered: August 2005
Location: india

Junior Member

used the USE_SHARED_SOCKET and set it to TRUE in server and rebooted .but no use , i am not able to connect from the node , when i given the tnsping myservicename , its responding well , where as when i am trying to connect from sqlplus window. its giving ORA-12535: TNS:operation timed out ... error...

Report message to a moderator

Re: windows xp firewall - oracle connectivity [message #138792 is a reply to message #135450]

Fri, 23 September 2005 13:41

dbawannabie
Messages: 1
Registered: September 2005

Junior Member

Use of USE_SHARED_SOCKET with Oracle 8.1.7 and Windows NT/2000

1. For Oracle 8.1.7 install patch 2376472 (Oracle 8.1.7.4)
get it at Metalink
File name p2376472_8174_WINNT.zip
Updated 14-JUN-2002, Size 112MB

2. Add USE_SHARED_SOCKET to your registry
For Oracle 8.0
\\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
For Oracle 8i or newer
\\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME#

3. Restart the computer

4. Test from LAN with tnsping, sqlplus, netstat
Usually tnsping works fine even before USE_SHARED_SOCKETS
have been set, because it doesn't make a connection to the
service. Check listener.log and sqlnet.log on the server

5. Open the port in firewall (usually 1521)
Sometimes you'll have a modem, a router, a firewall or a
mix of them, consider that you might configure some of them
or all to make port forwarding work.

6. Test from outside the firewall

I hope this might be of help