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";}

[download]
  • Comment on Re: How can we connect to a oracle database in windows box from a linux box
  • Download Code

Replies are listed 'Best First'.
Re^2: How can we connect to a oracle database in windows box from a linux box
by marto (Cardinal) 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.

[reply]
      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!
[reply]
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

[reply]
      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.

[reply]

      I mean local linux box

[reply]

In Section Seekers of Perl Wisdom