Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: How can we connect to a oracle database in windows box from a linux box

by chacham (Curate)
on Jul 10, 2012 at 13:59 UTC ( #980872=note: print w/ replies, xml ) Need Help??


in reply to How can we connect to a oracle database in windows box from a linux box

Please explain once more:

  1. Where is the database?
  2. Where is the client?
  3. Where is the code being run from?

It might help to get it running on the same box before making it work remotely. Here is an example i have from a linux box connecting to XE on the same box.

DBI->connect('dbi:Oracle:XE', 'scott', 'tiger', {RaiseError => 1, Auto +Commit => 0}) or die "Database connection not made: $DBI::errstr";}


Comment on Re: How can we connect to a oracle database in windows box from a linux box
Download Code
Re^2: How can we connect to a oracle database in windows box from a linux box
by marto (Chancellor) on Jul 10, 2012 at 14:26 UTC

    They're specifically asking how to connect from a Linux machine to Oracle running on a Windows machine. Setting up an Oracle database on the Linux server to prove that connecting works locally seems like an unnecessary step, since this isn't their goal.

      Thanx. When i read it this morning, i was a bit confused, and wanted a little more clarity. But i see it now. And, there are more details posted below. Thanx!
Re^2: How can we connect to a oracle database in windows box from a linux box
by pavanpvss (Novice) on Jul 10, 2012 at 14:30 UTC

    Hi

    The database is vantive which runs on windows box atl-vanapp01 to atl-vanapp10 depending upon the availability of the server. Client is in local linux box. The query is run on windows box and the code to fetch the data is run from local unix box.

    Thanks

      I mean local linux box

      OK, standard debugging.

      Can you tnsping the db from the linux box? IIRC, the Oracle client will handle it from there, so the normal connection string ought to work.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://980872]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (5)
As of 2014-09-21 05:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (166 votes), past polls