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. 2 10464
"Chris" <Ch***@rogerss.com> wrote in message news:<sk****************@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@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.
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 sk******@volcanomail.com (s.kapitza) wrote in message news:<26**************************@posting.google. com>... "Chris" <Ch***@rogerss.com> wrote in message news:<sk****************@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@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.
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Read Roberts |
last post by:
I have the current Windows binary install of Python 2.3.4 on my
Windows XP system.
I am pained to discover that tkFileDialog.askdirectory() returns a
mangled path when a directory is selected...
|
by: VNG |
last post by:
I have an ANSI C program that was compiled under Windows MSVC++ 6.0 (SP6) and
under Linux gnu, and ran under P3, P4 and AMD.
It runs fine on P3 and AMD under both Windows and Linux, but under P4...
|
by: Rudolf Bargholz |
last post by:
Hi,
I have a ralatively simple SQL:
select FK from TABLE where upper(A) like 'B%' and upper(C) like 'D%'
We have DB2 UDB v7.1 FP 12 installed on Linux and on Windows 2003
On Linux using...
|
by: Thames |
last post by:
I just did some replication operations between remote DB on linux and
local DB on windows yesterday
It gave me such errors when I perform db connection via command line
windows (local DB on...
|
by: git_cs |
last post by:
Hey, guys and gals
Somedays ago, I had asked for the DES algorithm in C language.
Although I have written the algorthim in C myself, I am facing a
peculiar problem, which I hope some of u guys and...
|
by: dawnerd |
last post by:
Hello everyone.
I have a question, or problem if you will, that I'm sure someone knows
the answer to. I have a database that stores information on a given
user. The information is stored in a...
|
by: Chris |
last post by:
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...
|
by: =?ISO-8859-1?Q?Tom=E1s_=D3_h=C9ilidhe?= |
last post by:
On May 3, 8:09 am, apati...@gmail.com wrote:
A programmer that uses Vista? :O
Vista is a hog of an operating system. Downgrade to Windows XP or get
yourself a Linux distro.
|
by: Chuck Chopp |
last post by:
I have some code that is being built on the following:
Windows Server 2003, both 32-bit & 64-bit editions
Windows Vista, both 32-bit & 64-bit editions
Windows Server 2008, both 32-bit & 64-bit...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |