Home » RDBMS Server » Networking and Gateways » TNS-12560: TNS:protocol adapter error
icon4.gif   TNS-12560: TNS:protocol adapter error [message #249836] Fri, 06 July 2007 02:08 Go to next message
harikrishnadhas.k
Messages: 1
Registered: July 2007
Location: Coimbatore
Junior Member
TNS-12560: TNS:protocol adapter error


Hello,

I'm new to linux platform. I have installed oracle xe server in Fedora core 4. The installation is gone smoothly and it is working in that machine.

I want to connect oracle client(9i) which is running in the windows xp.
I have added a oracle service using the net manager to the database(XE) running in the linux server.

But when i trying to connect to that DB it shows TNS-12560: TNS:protocol adapter error.

I give the ping command to that linux server, It gone smoothly

C:\>ping 192.168.1.92

Pinging 192.168.1.92 with 32 bytes of data:

Reply from 192.168.1.92: bytes=32 time<1ms TTL=64
Reply from 192.168.1.92: bytes=32 time<1ms TTL=64
Reply from 192.168.1.92: bytes=32 time<1ms TTL=64
Reply from 192.168.1.92: bytes=32 time<1ms TTL=64

Ping statistics for 192.168.1.92:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

When i give the tnsping to that database it shows the same error message:

C:\>tnsping xe

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 05-JUL-20
07 11:39:59

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
e:\oracle\ora92\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.1.92)(PORT = 1521))) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_
NAME = xe)))
TNS-12560: TNS:protocol adapter error

TNSNAMES.ORA IN WINDOWS XP:
# TNSNAMES.ORA Network Configuration File: e:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

XE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.92)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = xe)
)
)

LISTENERE.ORA IN WINDOWS XP:
I have no listener.ora file

SQLNET.ORA IN WINDOWS XP:

# SQLNET.ORA Network Configuration File: e:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES)

SQLNET.LOG IN WINDOWS XP:
***********************************************************************
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.92)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=xe)(SERVER=SHARED)(CID=(PROGRAM=C:\Pro gram Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=QTET03)(USER=Harikrishnadhas.K))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
Time: 05-JUL-2007 10:30:17
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 538s
TNS-00538: Message 538 not found; product=NETWORK; facility=TNS

nt secondary err code: 65
nt OS err code: 0

When i check listener staus using lsnrctl status in the oracle server the output is

[root@oracle-xe ~]# lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-JUL-2007 12:09:40

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Message 1053 not found; No message file for product=network, facility=TNSMessage 1020 not found; No message file for product=network, facility=TNSMessage 1021 not found; No message file for product=network, facility=TNSMessage 1022 not found; No message file for product=network, facility=TNSMessage 1023 not found; No message file for product=network, facility=TNSMessage 1026 not found; No message file for product=network, facility=TNSMessage 1034 not found; No message file for product=network, facility=TNSMessage 1024 not found; No message file for product=network, facility=TNSMessage 1025 not found; No message file for product=network, facility=TNSMessage 1040 not found; No message file for product=network, facility=TNSMessage 1422 not found; No message file for product=network, facility=TNSMessage 1033 not found; No message file for product=network, facility=TNSMessage 1028 not found; No message file for product=network, facility=TNSMessage 1415 not found; No message file for product=network, facility=TNS Message 1050 not found; No message file for product=network, facility=TNS
Message 1050 not found; No message file for product=network, facility=TNS
Message 1050 not found; No message file for product=network, facility=TNS
Message 1029 not found; No message file for product=network, facility=TNSMessage 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1052 not found; No message file for product=network, facility=TNS[root@oracle-xe ~]#

Could u pls help me to solve this problem?
Suggestions are Welcome.
Re: TNS-12560: TNS:protocol adapter error [message #249935 is a reply to message #249836] Fri, 06 July 2007 09:59 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
can you post content of

lsnrctl reload?
LISTENER.ORA file.
Previous Topic: Facing problem while attempting to connect Oracle database from D2K
Next Topic: I cannot start the Listener
Goto Forum:
  


Current Time: Thu Dec 08 02:20:19 CST 2016

Total time taken to generate the page: 0.12564 seconds