 TNS-12560: TNS:protocol adapter error [message #249836] |
Fri, 06 July 2007 02:08  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
