Solved

ns main err code: 12535, TNS-12535: TNS:operation timed out, ns secondary err code: 12560

Posted on 2012-04-09
8
1,557 Views
Last Modified: 2012-05-07
Hi Experts,

I'm migrating databases from a Windows 2003 to a Windows 2008 server. And I'm having a problem when testing one of the DBLinks which work fine on the Windows 2003, but whenever I try it on the Windows 2008 I get  a TNS - 12560 timeout error. I've checked both TNSNAMES and SQLNET files and they are both the same. In addition I did a TNSPING on the new machine and it failed, but when I Ping'ed the server I got a successful response I've checked log files but they report the same thing. Please help me solve this issue.

Thanks,
7Souls
0
Comment
Question by:7Souls
  • 4
  • 3
8 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
99% of the time this error is a firewall issue.  If the 2008 server has a firewall, turn it off temporarily and try.
0
 

Author Comment

by:7Souls
Comment Utility
Hi slightwv,

The firewall was off, I should have mentioned it in my post.

Thanks,
7Souls
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
Check for a firewall between the new serer and the server you are linking to.
0
 

Author Comment

by:7Souls
Comment Utility
How do I do that?
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
Comment Utility
Check with your network group, system administrators, etc...
0
 

Author Comment

by:7Souls
Comment Utility
Hi slightwv,

I've just been informed that's what I need to do. I will let you know if that solve's the problem.

Thanks,
7Souls
0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
Comment Utility
---but when I Ping'ed the server I got a successful response

Just for your information...

Ping response is different from firewall connection(actually firewall is something which will block the ports between the host and guest)

ie., even when you are connected in same LAN you can block the connections between the system using a firewall.. ie., by blocking some particular ports between host and guest

in general database(listener) port by default it runs on 1521..(If not you have to check in listener.ora to which port that has been configured)

and you have to open the Bidirectional connectivity between the host and guest...

this can be checked using the telnet command

for ex: telnet <ip_address> <port_number>

telnet 192.10.xx.xxx 1521 (if this is success then it will give a blank screen else, it will display you a message trying to connect... and it will throw the same error which you have mentioned in your question .. TNS Operation Timed Out
0
 

Author Closing Comment

by:7Souls
Comment Utility
Thanks, slightwv...
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
INTRODUCTION The purpose of this document is to demonstrate the Installation and configuration of the Data Protection Manager product. Note that this demonstration was prepared on the basis of Windows OS is 2008 R2 and DPM 2010. DATA PROTECTI…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now