problem with windows and linux
Date: Wed, 07 Jul 2004 20:48:24 GMT
Message-ID: <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. Received on Wed Jul 07 2004 - 22:48:24 CEST