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.