LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices

Reply
 
Search this Thread
Old 03-16-2008, 12:08 PM   #1
edsalvador
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?

Thanks,
Ed
 
Old 03-16-2008, 12:54 PM   #2
MensaWater
Guru
 
Registered: May 2005
Location: Atlanta Georgia USA
Distribution: Redhat (RHEL), CentOS, Fedora, Debian, FreeBSD, HP-UX, Solaris, SCO
Posts: 6,026
Blog Entries: 5

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

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

e.g.
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).
 
  


Reply


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/Novell 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


All times are GMT -5. The time now is 01:21 PM.

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