TNS-12560: TNS:protocol adapter error

[Natik]

Hi. 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 Settings\natik>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 Settings\natik>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:\oracle\product\10.1.0\db\network\admin\sqlnet.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: TNSrotocol 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.Cannot connect to Server from Client PING RESULTS FROM SERVER TO CLIENT:

[waitecj]

What is the status of the listener on your server?

c:\> LSNRCTL STATUS

[akhadar]

Also can u put the sqlnet.ora and TNSNAMES.Ora parameters here.

[Natik]

Here you go.

The following is the sqlnet.ora file on the client:

# sqlnet.ora Network Configuration File: C:\oracle\product\10.1.0\db\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

---------------------------------------------------------------------
The following is the tnsnames.ora file on the client:

# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\db\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

STTN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 68.101.184.14)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sttn)
)
)

infr2 =
(description =
(address_list = (address = (protocol = tcp)(host = 192.168.0.102)(port = 1521)))
(connect_data = (sid = infr2)))


# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.102)(PORT = 1521))
# (CONNECT_DATA =
# (SERVER = DEDICATED)
# (SERVICE_NAME = infr2)
# )
# )

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

Also the LISTENER is running on the server.

Thanks.

[waitecj]

And in listener.ora, you have an entry set and it is listening on port 1521?

Where you have the following in tnsnames.ora:

infr2 =
(description =
(address_list = (address = (protocol = tcp)(host = 192.168.0.102)(port = 1521)))
(connect_data = (sid = infr2)))

I have:

infr2 =
(description =
(address_list = (address = (protocol = tcp)(host = 192.168.0.102)(port = 1521)))
(connect_data = (SERVICE_NAME= infr2)))