tnsping from any client to new server fails
593894Aug 20 2007 — edited Aug 21 2007Hi there,
This was my first oracle 10g install and everything seemed to be working but now its not. I just installed a 10g server and added it's IP to my tnsnames.ora files on my other computers. I can ping it regularly just fine but tnsping fails. Any ideas? Our network has a subnetmask of 255.255.255.192, could that cause a problem?
--------------------------------------------------------------------------------------
[root@SLE admin]# ping 154.114.145.253
PING 154.114.145.253 (154.114.145.253) 56(84) bytes of data.
64 bytes from 154.114.145.253: icmp_seq=0 ttl=63 time=0.963 ms
64 bytes from 154.114.145.253: icmp_seq=1 ttl=63 time=0.664 ms
64 bytes from 154.114.145.253: icmp_seq=2 ttl=63 time=114 ms
--- 154.114.145.253 ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2001ms
rtt min/avg/max/mdev = 0.664/38.837/114.884/53.773 ms, pipe 2
-------------------------------------------------------------------------------------
[root@SLE admin]# tnsping xxdm10.lps.fares10.com
TNS Ping Utility for Linux: Version 9.2.0.1.0 - Production on 20-AUG-2007 14:59:59
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/u01/app/oracle/product/9.2/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 154.114.145.253)(PORT = 1521))) (CONNECT_DATA = (SID = XXDM10) (SERVER = DEDICATED)))
TNS-12560: TNS:protocol adapter error
---------------------------------------------------------------------------------------
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12545
TNS-12545: Connect failed because target host or object does not exist
ns secondary err code: 12560
nt main err code: 515
TNS-00515: Connect failed because target host or object does not exist
nt secondary err code: 2
nt OS err code: 0