Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Possible to mimic an Oracle install?

by thmsdrew (Scribe)
on Jan 23, 2013 at 13:42 UTC ( #1014904=perlquestion: print w/ replies, xml ) Need Help??
thmsdrew has asked for the wisdom of the Perl Monks concerning the following question:

I'm trying to use DBI in a script on a client to connect to an Oracle database separate from the client. It fails when trying to connect, due to an issue where it is looking for a library that it can't find. I assume this is because Oracle isn't actually installed on the client. Is there a way I can mimic an Oracle install such that the Perl side of things will have everything it needs? Is there something I can configure somewhere to do something like this? Or do I actually need Oracle installed on the client for this to work?

Comment on Possible to mimic an Oracle install?
Re: Possible to mimic an Oracle install?
by vinoth.ree (Parson) on Jan 23, 2013 at 14:03 UTC

    The DBD::Oracle is the Oracle specific module enable connectivity to an Oracle database from perl through DBI

    Its necessary to have the Oracle client installed in the system to connect with the oracle server

      By "...in the system..." do you mean on the client?

        By "in the system" they mean the computer running your code.

Re: Possible to mimic an Oracle install?
by mje (Deacon) on Jan 24, 2013 at 09:25 UTC

    I don't know if this will help you as even after reading some of the comments it is not clear exactly what you are trying to achived.

    You don't need to install all of Oracle to use DBD::Oracle. You can just install Instant Client in which you need the client, sdk and sqlplus which are all downloadable separately and are fairly small.

    UPDATE: You can access Oracle without installing Oracle's client libraries. There are so called wire-protocol ODBC drivers for Oracle from various companies. Of course, you have to install them.

      Thanks, I'll look into this.

      EDIT This is exactly what I was looking for, I think. Wish I hadn't done all of that headbanging in here yesterday and just figured out that this is what they were probably talking about.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1014904]
Approved by vinoth.ree
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (15)
As of 2014-08-22 19:53 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (163 votes), past polls