A weird issue...though hopefully not for everyone...


I am trying to connect to a 10g database on a Red Hat Linux server from my
9i client on a XP pc.
Both are on my local home network, behind a router.

I can ping the linux server from my XP box successfully:
C:\>ping 192.168.1.101

Pinging 192.168.1.101 with 32 bytes of data:

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

On the linux server itself, I can sqlplus to the database no problem:
oracle10@linuxbox<1>:/db01/app/oracle10> sqlplus system@red1

SQL*Plus: Release 10.1.0.2.0 - Production on Wed Jul 7 16:30:13 2004

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning and Data Mining options

SQL>

I can also VPN into work and connect to any database there successfully,
from my XP box.

My problem is connecting from my XP box to my Linux server via sqlplus.

note: my vpn connection is disconnected, and I can ping the server when
trying the below stuff

examples:
TNSPING EXAMPLE
C:\>tnsping red1

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on
07-JUL-2004 16:26:32

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

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.1.101)(PORT = 1521)) (CONNECT_DATA = (SID = RED1)))
TNS-12560: TNSrotocol adapter error

C:\>


SQLPLUS EXAMPLE
C:\>sqlplus system@red1

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Jul 7 16:27:29 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter password:
ERROR:
ORA-12560: TNSrotocol adapter error

Enter user-name:
ERROR:
ORA-12560: TNSrotocol adapter error

Enter user-name:
ERROR:
ORA-12560: TNSrotocol adapter error

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

C:\>



FILES:

sqlnet.ora:
NAME.DEFAULT_ZONE = world
NAMES.DEFAULT_DOMAIN = world
NAMES.DIRECTORY_PATH= (TNSNAMES)

tnsnames.ora:
RED1.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
(CONNECT_DATA = (SID = RED1))
)


I belive the problem has something to do with my linux setup, but linux is
pretty new to me.

Any help would be great.

"Chris" <Chris (AT) rogerss (DOT) com> wrote

have you lookup ora-12560 ? possibly <ora-12560 trace sybrand> would
be a sweet tripple to search for.

other things to check :

- is the listner realy up ? (to check with ps -ef )
- you could telnet from xp to linux on port 1521 to check if the port
is open
- check the listner.log
- you could use tcpdump on linux to check arriving packets
- did you install firewalling ???

regards

s.kapitza

skapitza (AT) volcanomail (DOT) com (s.kapitza) wrote in message news:<26703915.0407082038.4af783d7 (AT) posting (DOT) google.com>...

Thanks. I disabled the iptables service on the linux box and
everything worked fine. I find out how to edit that file and then all
will be fine.

THank you s.kapitza.