Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re^4: What are DBD::Oracle's dependencies (on Linux)?

by nguye103 (Acolyte)
on Oct 01, 2004 at 18:54 UTC ( #395702=note: print w/replies, xml ) Need Help??


in reply to Re^3: What are DBD::Oracle's dependencies (on Linux)?
in thread What are DBD::Oracle's dependencies (on Linux)?

I don't understand why one person is telling me that I need to install the Oracle database and another is telling me that I don't need to install the database, just the server. It sounds like the person telling me to install the database is saying that I need to install Oracle (and if i'm wrong, i apologize), but the problem is I need to access the database from another computer from Linux (Suse) without having ORACLE on Linux. I know that I can access the database by just installing DBD-Oracle, but I don't know what I need to get DBD-Oracle to install properly because it says that I need to set my Oracle_home environment variable when I attepmt to install it and I don't know how to go about doing this.
  • Comment on Re^4: What are DBD::Oracle's dependencies (on Linux)?

Replies are listed 'Best First'.
Re^5: What are DBD::Oracle's dependencies (on Linux)?
by dragonchild (Archbishop) on Oct 01, 2004 at 19:29 UTC
    I am a junior Oracle DBA and a Perl developer who's been developing against Oracle databases for five years. I am telling you exactly what you need:
    1. You need DBD::Oracle installed on the machine you want to use to talk to an Oracle database.
    2. To install DBD::Oracle, you need the client libraries that come with the Oracle database. (Basically, you need sqlplus installed, plus a few other things.)
    3. To install those libraries, you need the Oracle installer from www.oracle.com, just like I described.
    4. Then, you point the ORACLE_HOME environment variable to wherever you installed Oracle. This is usually /opt/oracle, but not always.

    These items are not negotiable. They are at a minimum what is needed to install DBD::Oracle. Period. End of story. ikegami was wrong in what he said in his reply.

    Being right, does not endow the right to be rude; politeness costs nothing.
    Being unknowing, is not the same as being stupid.
    Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
    Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.

      These items are negotiable. E.g. Point 2: You don't need SQL*Plus. Elipsis. The story continues
        Let's look at the tape.

        To install DBD::Oracle, you need the client libraries that come with the Oracle database. (Basically, you need sqlplus installed, plus a few other things.) (Emphasis added)

        You're absolutely right ... to install DBD::Oracle, you do not need to install SQL*Plus. However, when dealing with someone who is unsure of themselves, it is better to describe what they need in terms they will understand, so long as you get them to where they need to go. Instead of saying "You need this header file and that header file and this .a and that .ora" ... maybe it's better to say "You need to install XYZ", knowing that installing XYZ will get them 90% of the way to where they need to go.

        You'll note that at the beginning of this thread, I said that it was easiest to install the whole RDBMS, build DBD::Oracle, then delete the RDBMS installation. This is a method I've done before, with good success.

        I've also built DBD::Oracle by source-diving the Makefile.PL, figuring out exactly what headers I needed to have where, and copying them over one by one from another machine with a full install of Oracle on it. I then copied over each and every .a as the build failed. Can you guess which method I prefer to use and recommend?

        Being right, does not endow the right to be rude; politeness costs nothing.
        Being unknowing, is not the same as being stupid.
        Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
        Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (7)
As of 2019-12-05 14:23 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Strict and warnings: which comes first?



    Results (151 votes). Check out past polls.

    Notices?