TNS-12560: TNS:protocol adapter error


ping is ok

tnsping throws error


e:\raj\YKR_SQL>tnsping apssoft

 

TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 08-DEC-2

009 15:30:21

 
Copyright (c) 1997, 2003, Oracle.  All rights reserved.

 
Used parameter files:

G:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora

 
Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)

(HOST = 10.31.32.35)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = apssoft)))

TNS-12560: TNS:protocol adapter error
 
 
[root@apsimsoft admin]# service iptables stop
Flushing firewall rules:                                               [  OK  ]
Setting chains to policy ACCEPT: filter                    [  OK  ]
Unloading iptables modules:                                      [  OK  ]
or
 
write a rule to allow tnsping on Linux fire wall ( iptables)
 


 

Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post