Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news.he.net!cyclone-sf.pbi.net!216.196.106.144!border2.nntp.sjc.giganews.com!border1.nntp.sjc.giganews.com!nntp.giganews.com!sjc1.usenetserver.com!news.usenetserver.com!cyclone01.bloor.is.net.cable.rogers.com!news04.bloor.is.net.cable.rogers.com.POSTED!12dc6cf53ab2750!not-for-mail
From: "Chris" <Chris@rogerss.com>
Newsgroups: comp.databases.oracle
Subject: problem with windows and linux
Lines: 109
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
Message-ID: <skZGc.181$UJn1.120@news04.bloor.is.net.cable.rogers.com>
Date: Wed, 07 Jul 2004 20:48:24 GMT
NNTP-Posting-Host: 24.157.50.5
X-Complaints-To: abuse@rogers.com
X-Trace: news04.bloor.is.net.cable.rogers.com 1089233304 24.157.50.5 (Wed, 07 Jul 2004 16:48:24 EDT)
NNTP-Posting-Date: Wed, 07 Jul 2004 16:48:24 EDT
Xref: core-easynews comp.databases.oracle:28136
X-Received-Date: Wed, 07 Jul 2004 13:52:52 MST (news.easynews.com)

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: TNS:protocol 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: TNS:protocol adapter error

Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name:
ERROR:
ORA-12560: TNS:protocol 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.