DBD::Oracle technically just needs the Oracle client, so even if you have a full version of oracle installed, it will just use the client part. In order to find all the required files, you will have to tell the build procedure where to find all of that. That information usually gets passed by means of the $ORACLE_HOME environment variable.

You'll need to set that to a valid installation path. That may either be a full-fledged installation or to an installation of the Oracle Instant Client. Both will work. And as the client can speak to a different version of the server (the database itself does not need to run on the same machine), you are not bound to using the exact same version of the database: you can talk to a Oracle 9 database with an Oracle Instant Client version 11. FWIW You can have several versions of both installed on the same machine without any of them prohibiting any of the others to function. That is a great way to test your updates.

When you have compiled and tested and installed DBD::Oracle, it then has builtin information about the libraries it uses, but it does not have enough information builtin to find all the message files (damn locales) or other diagnostical information. That is why you also need to set $ORACLE_HOME at runtime.

I hope I interpreted your question correctly.


Enjoy, Have FUN! H.Merijn

In reply to Re^5: Perl DBI not working with Oracle DBD in 11g r2 environment by Tux
in thread Perl DBI not working with Oracle DBD in 11g r2 environment by seekhelp

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.