Home » RDBMS Server » Networking and Gateways » ORA-12535: TNS: operation timed out (Oracle 11gR2 (11.2.0))
ORA-12535: TNS: operation timed out [message #574572] Sun, 13 January 2013 03:09 Go to next message
ramesh_samane
Messages: 63
Registered: May 2006
Member
I have two related questions:

Scenario 1:

1. I have two remote Windows machines with database on each. One is Win 2003 Server (machine A) and another one is Win XP (machine B)
2. I can ping from A to B.
3. I can ping from B to A.
4. I can tnsping from A to B.
5. I CAN'T tnsping from B to A.
6. Windows Firewall on both machines are off.

What could be possible reason for point# 5?

Scenario 2:

Now, the second part:

1. I had an unwanted entry in tnsnames.ora on B which I removed.
2. Then I restarted the listener on B. Actually, I wanted to restart the one on A to check if that resolves issue mentioned in point# 5 above.
3. I tried tnsping from A to B but suprisingly it is also giving "operation timed out" error now. So now tnsping not working from either sides.

I didn't make any changes in listener.ora on B, just stopped it and started again. Only change made was removing unwanted entry in tnsnames.ora on B.

Why does that affected database connectivity from A to B which was working fine previously?

If any extra information needed please let me know, and thanks in advance for your answers.

NOTE: The two machines are connected through VPN using LogMeIn Hamachi. Hamachi assigns it's own IP address to each machine. Machine A is Windows Server 2003 and B is Windows XP.

- Ramesh
Re: ORA-12535: TNS: operation timed out [message #574573 is a reply to message #574572] Sun, 13 January 2013 05:09 Go to previous messageGo to next message
John Watson
Messages: 4672
Registered: January 2010
Location: Global Village
Senior Member
You need to show what you are doing. Use copy/paste, and format the result correctly with code tags as described here How to use [code] tags and make your code easier to read What is needed is the output of ping, tnsping, nslookup, and lsnrctl status. Also the tnsnames.ora file, the hosts file, and the results of nslookup for the hostnames. All from both machines.
Re: ORA-12535: TNS: operation timed out [message #574590 is a reply to message #574572] Sun, 13 January 2013 20:06 Go to previous messageGo to next message
ramesh_samane
Messages: 63
Registered: May 2006
Member
Issue resolved. Problem was with Symantec firewall, opening port 1521 solved the issue.
Re: ORA-12535: TNS: operation timed out [message #574600 is a reply to message #574590] Mon, 14 January 2013 01:10 Go to previous message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel
Previous Topic: listener
Next Topic: TNSNAMES
Goto Forum:
  


Current Time: Mon Oct 20 17:24:25 CDT 2014

Total time taken to generate the page: 0.10755 seconds