Anthony Key
asked on
ns main err code: 12535, TNS-12535: TNS:operation timed out, ns secondary err code: 12560
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
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
99% of the time this error is a firewall issue. If the 2008 server has a firewall, turn it off temporarily and try.
ASKER
Hi slightwv,
The firewall was off, I should have mentioned it in my post.
Thanks,
7Souls
The firewall was off, I should have mentioned it in my post.
Thanks,
7Souls
Check for a firewall between the new serer and the server you are linking to.
ASKER
How do I do that?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
---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
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
ASKER
Thanks, slightwv...