Re: problem with windows and linux

From: Chris <gagnech_at_rogers.com>
Date: 10 Jul 2004 07:16:19 -0700
Message-ID: <3d4d53e6.0407100616.9711dbf_at_posting.google.com>


skapitza_at_volcanomail.com (s.kapitza) wrote in message news:<26703915.0407082038.4af783d7_at_posting.google.com>...
> "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

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. Received on Sat Jul 10 2004 - 16:16:19 CEST

Original text of this message