Re: problem with windows and linux

"Chris" <Chris_at_rogerss.com> wrote in message news:<skZGc.181$UJn1.120_at_news04.bloor.is.net.cable.rogers.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_at_linuxbox<1>:/db01/app/oracle10> sqlplus system_at_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_at_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.

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 Received on Fri Jul 09 2004 - 06:38:36 CEST