By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,314 Members | 1,772 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,314 IT Pros & Developers. It's quick & easy.

Tns-12560: Tns Protocol Adapter Error

P: 1
HI 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.124

Pinging 192.168.1.124 with 32 bytes of data:

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

Ping statistics for 192.168.1.124:
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.124)(PORT = 1521))) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_
NAME = xe)))
TNS-12560: TNS:protocol adapter error

Could u pls help me to solve this problem?
Suggestions are Welcome.
Jul 5 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.