From: Chris@rogerss.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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)