| TNS Ping Over VPN [message #66140] |
Thu, 13 December 2001 23:12  |
Zahryl
Messages: 1
Registered: December 2001
|
Junior Member |
|
|
I've setup a VPN connection using two Windows 2000 Servers. The VPN is OK as I can access the other network. The problem comes when I tried to do a TNS ping or SQLPlus, I got a "TNS: Operation timed out" message. I can run this if the connection is non-VPN.
Guys, if you have encounter this or have any idea please help. Thanks.
----------------------------------------------------------------------
|
|
|
|
| Re: TNS Ping Over VPN [message #66174 is a reply to message #66140] |
Tue, 08 January 2002 02:31  |
Farid
Messages: 5
Registered: January 2002
|
Junior Member |
|
|
To allow sqlnet traffic to go through the firewall through specific ports you have to have a sqlnet proxy on your firewall. This is a feature that you
firewall vendor has to provide and support and is the only way you can get sqlnet traffic traverse the firewall through well known port. Except for the option of digging a hole in the firewall that allow port ranges access. This does not work too well and for reliable performance you do need a sqlnet proxy.
If you are receiving the ora-12535 error from tnsping as well as sqlplus, the client box is probably unable to find the listener for whatever reason. If the listener is definitely running and you are able to ping the listener's address from the client box but still can't tnsping it, you are probably running into a firewall issue.
The reason for this is that with tnsping failing you are probably timing out before the connection gets to the listener. You can verify that the listener is running by checking the status in lsnrctl or doing a loopback connection through it. You can verify that the listener's address is visible to the remote box by pinging it from the remote box. Firewalls generally filter by port number so this is the next logical thing to check. If the remote connection passes through a firewall and the listener's port has not been opened up you will see this error.
Please review the following note for more information on this issue.
119706.1 Troubleshooting Guide TNS-12535 & ORA-12535 Errors:
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
