I have a Unix machine which I need to connect to a remote Oracle database server though Perl/Shell script. I have searched online but did not find a thorough information on whether it's possible to connect the Unix machine with the Oracle DB server without installing an Oracle client.
-
I guess it begs the question: why do you want to avoid installing an Oracle client?tbone– tbone2011-09-30 18:44:27 +00:00Commented Sep 30, 2011 at 18:44
-
It does. Straight-forward answer is that I cannot. As simple as that. Else I would not pose this question. Another answer would be, I am trying to experiment.Sid– Sid2011-09-30 19:20:01 +00:00Commented Sep 30, 2011 at 19:20
-
1Tell IT to stop being lazy and do the install! Or tell your boss that you cannot meet your deadlines, and give him/her the reason why. That should put the needed fire under the necessary butts ;-) "Sorry, we can't do that...Sincerely IT dept" isn't an acceptable answer imo.tbone– tbone2011-10-03 11:06:58 +00:00Commented Oct 3, 2011 at 11:06
-
Suggestion noted for future :) Thanks.Sid– Sid2011-10-03 20:00:00 +00:00Commented Oct 3, 2011 at 20:00
Add a comment
|
1 Answer
I suppose that you don't want / have the opportunity of installing the Oracle Client (that's the better choice). If you don't mind the performance and use Java as a bridge, you can take a look at DBD::JDBC module. It has a server you need to start from the command line with Java.
From the documentation: the DBD::JDBC server is a Java application intended to be run from the command line. It may be installed, along with whatever JDBC driver you wish to use (i.e classes12.jar), on any host capable of accessing the database you wish to use via JDBC.
Perl applications using DBD::JDBC will open a socket connection to this server. You will need to know the hostname and port where this server is running. You can install the server at the same machine you are running the Perl script, or other if you want.
I use this solution at scenarios like yours, where I cannot install the Oracle Client and I don't have high performance requirements in database access.
1 Comment
DVK
OMG. Hack. Evil. But beautiful. +1