Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Networking
User Name
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.


  Search this Thread
Old 03-16-2008, 12:08 PM   #1
LQ Newbie
Registered: Mar 2008
Posts: 1

Rep: Reputation: 0
Windows Oracle database access from Linux

I am running CENTOS 5. I have an application on the linux computer that needs to connect to an Oracle 10g database on a Windows XP pc. The Oracle database is set-up as a "share" on the pc. I can ping the windows pc from my linux pc.
Any suggestions?

Old 03-16-2008, 12:54 PM   #2
LQ Guru
Registered: May 2005
Location: Atlanta Georgia USA
Distribution: Redhat (RHEL), CentOS, Fedora, CoreOS, Debian, FreeBSD, HP-UX, Solaris, SCO
Posts: 7,053
Blog Entries: 14

Rep: Reputation: 1226Reputation: 1226Reputation: 1226Reputation: 1226Reputation: 1226Reputation: 1226Reputation: 1226Reputation: 1226Reputation: 1226
Determine which port the Oracle DB is "listening" on (default is 1521).

Try to attach to the specific port with the telnet command:

telnet <windows host that has oracle> 1521

If you see it connect it means you can get to it from the Linux host.

If you don't see it connect it could mean:
1) The DB isn't listening on the port you tried.
2) You have Oracle security configured to only accept the hosts/IPs you've defined and you'll need to modify that. (Not a DBA so can't help you there.)
3) There is something blocking the connection (e.g. Windows firewall, Linux iptables or a firewall device between the Windows host and the Linux host.) Typically it wouldn't be iptables as most people only prevent INBOUND to the Linux host and allow all outbound (i.e. your connection to the Windows host).


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
SuSE 9.3 logins and console crash but pings and Oracle database access ok ponsolo SUSE / openSUSE 0 03-13-2008 07:29 PM
LXer: Oracle(R) Database Standard Edition One and Oracle Enterprise Linux on HP Set New World Record for Price Performance with TPC-C Benchmark LXer Syndicated Linux News 0 06-12-2007 06:01 PM
LXer: Free Linux / Windows Oracle Database 10g Express Edition LXer Syndicated Linux News 0 05-16-2006 11:54 PM
LXer: AquaFold Releases Enterprise Oracle Database Administration Tools for Windows, Linux and OSX LXer Syndicated Linux News 0 05-08-2006 08:54 AM
How to access database created with MS Access on Windows using PHP on Linux Server anjani.78 Linux - Software 1 12-21-2005 07:07 PM > Forums > Linux Forums > Linux - Networking

All times are GMT -5. The time now is 08:19 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration