Home » RDBMS Server » Server Administration » Firewall causes ORA-12535:TNS: Operation timed out
Firewall causes ORA-12535:TNS: Operation timed out [message #160458] Sun, 26 February 2006 11:16 Go to next message
ellicott
Messages: 6
Registered: February 2006
Junior Member
I am sure this question has been asked before. But I couldn't find answer. So I am asking again.

My Enterprise Manager Console on client machine can not connect to 9i server which runs on Windows XP. The error is ORA-12535:TNS:operation timed out.

Once the Windows Firewall on 9i server is turn off, connection can be established! However, if I add port 1521 as exception to Firewall and turn on Firewall, it stops work! In the listener.log of server I found that the port for connection always increase every time, such as port=3361; port=3363; port=3573. That probably explain why allowing 1521 port exception on Firewall doesn't work.

Well, if this is the case, what can I do for having connection while turn on Firewall?


Your help will be apprecaited,
P.S. How to turn on tracing on network activity.


Re: Firewall causes ORA-12535:TNS: Operation timed out [message #160460 is a reply to message #160458] Sun, 26 February 2006 11:26 Go to previous messageGo to next message
ellicott
Messages: 6
Registered: February 2006
Junior Member

I was missing a piece information in my previous post:

The changing port in listener.log is used by server's jrew.exe.


Re: Firewall causes ORA-12535:TNS: Operation timed out [message #160463 is a reply to message #160460] Sun, 26 February 2006 12:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you already set USE_SHARED_SOCKET?
Else
set USE_SHARED_SOCKET=TRUE in registry and reboot.
Try again.
Re: Firewall causes ORA-12535:TNS: Operation timed out [message #160467 is a reply to message #160463] Sun, 26 February 2006 15:01 Go to previous messageGo to next message
ellicott
Messages: 6
Registered: February 2006
Junior Member
Mahesh Rajendran wrote on Sun, 26 February 2006 12:34

Did you already set USE_SHARED_SOCKET?
Else
set USE_SHARED_SOCKET=TRUE in registry and reboot.
Try again.



No. I didn't set USE_SHARED_SOCKET. I am new in the area. Which config file I can set up USE_SHARED_SOCKET=TRUE


I apprecaite your concrete help,
Re: Firewall causes ORA-12535:TNS: Operation timed out [message #160468 is a reply to message #160467] Sun, 26 February 2006 15:13 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It is not in a config file, but in Windows registry; registry editor is run by typing "regedit" in "Start - Run ..." on Windows taskbar.
Re: Firewall causes ORA-12535:TNS: Operation timed out [message #160473 is a reply to message #160468] Sun, 26 February 2006 17:54 Go to previous message
ellicott
Messages: 6
Registered: February 2006
Junior Member

Thanks Littlefoot and Mahesh Rajendran.


It works!

Previous Topic: Database creation
Next Topic: Default Tablespaces
Goto Forum:
  


Current Time: Sun Jan 26 14:24:49 CST 2025