| Firewall causes ORA-12535:TNS: Operation timed out [message #160458] |
Sun, 26 February 2006 11:16  |
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  |
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 #160467 is a reply to message #160463 ] |
Sun, 26 February 2006 15:01 |
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 |
Littlefoot
Messages: 8623
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
|
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 |
ellicott
Messages: 6
Registered: February 2006 |
Junior Member |
|
|
Thanks Littlefoot and Mahesh Rajendran.
It works!
|
|
|
]
Members
Search
Help
Register
Login
Home
