| TNS-12560: TNS:protocol adapter error [message #63788] |
Sun, 07 November 2004 19:32  |
natik ameen
Messages: 1
Registered: November 2004
|
Junior Member |
 
|
|
I have installed 10g DB server on Linux 3. The DB is running properly. However when I do a TNSPING fro a windows client I am unable to connect. I can ping the server from the client and vice versa. The following is the tnsnames.ora entry:
infr2 =
(description =
(address_list = (address = (protocol = tcp)(host = 192.168.0.102)(port = 1521)))
(connect_data = (sid = infr2)))
PING RESULTS FROM SERVER TO CLIENT:
[[root@infr2 etc]]#ping 192.168.0.100
PING 192.168.0.100 (192.168.0.100) 56(84) bytes of data.
64 bytes from 192.168.0.100: icmp_seq=0 tt1=128 time=0.279ms
..
..
6 packets transmitted, 6 recieved, 0% packet loss, time 5013ms
PING RESULTS FROM CLIENT TO SERVER
C:Documents and Settingsnatik>ping 192.168.0.102
Pinging 192.168.0.102 with 32 bytes of data:
Reply from 192.168.0.102: bytes=32 time<1ms TTL=64
Reply from 192.168.0.102: bytes=32 time<1ms TTL=64
Reply from 192.168.0.102: bytes=32 time<1ms TTL=64
Reply from 192.168.0.102: bytes=32 time<1ms TTL=64
Ping statistics for 192.168.0.102:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
C:Documents and Settingsnatik>tnsping infr2
TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 07-NOV-2
004 10:18:42
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
C:oracleproduct10.1.0dbnetworkadminsqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (description = (address_list = (address = (protocol = tcp)
(host = 192.168.0.102)(port = 1521))) (connect_data = (sid = infr2)))
TNS-12560: TNS<IMG alt="" src="http://www.dbasupport.com/forums/images/smilies/tongue.gif" border=0>rotocol adapter error
The TNSPING is not getting through any ideas. Is there possiblity that some ports are closed. How do I open the ports, if this is the problem. Please help.
|
|
|
|
|
|
| Re: TNS-12560: TNS:protocol adapter error [message #64368 is a reply to message #63792] |
Wed, 19 January 2005 21:40  |
ashok
Messages: 32
Registered: July 2000
|
Member |
|
|
Hai,
I am using win2000 OS and ORACLE 8i. But one day My OS is not working so I reinstall the Win2000 Server and Oracle. After i Create my ORACLESERVICE then I will try to configer TNSLISTNER, It created and started.
When I try to connect through SVRMGRL at that time it gives the error TNS-12560. Who to solve this problen?
Please send me some solution/sugesitions.
Thanking you,
ashok.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
