Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

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

by ikegami (Pope)
on Oct 01, 2004 at 18:16 UTC ( #395687=note: print w/replies, xml ) Need Help??


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

Nothing else. From the DBD::Oracle docs,

$dbh = DBI->connect("dbi:Oracle:host=myhost.com;sid=ORCL", $user, $pas +swd);

Note "myhost.com". The database does not have to be on the local machine. DBD::Oracle will contact the database over a network or over the internet.

Replies are listed 'Best First'.
Re^2: What are DBD::Oracle's dependencies (on Linux)?
by dragonchild (Archbishop) on Oct 01, 2004 at 18:40 UTC
    You still need to install, at the least, the client software so that DBD::Oracle can link against it. Most of the DBD::*s are just layers over the client libraries. Most are written in XS, for that very reason.

    This, incidentally, is why most DBI work on Windows tends to use ODBC, because ActiveState has DBD::ODBC already compiled and most RDBMSes will talk in ODBC.

    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.

Re^2: What are DBD::Oracle's dependencies (on Linux)?
by nguye103 (Acolyte) on Oct 01, 2004 at 18:21 UTC
    So that means that I still need to install DBD-Oracle? When I try to install DBD_Oracle, it says that the ORACLE_HOME environment variable must be set. I don't know where or how to do this. I read that I need to install the Oracle client, but I don't know where to find this.
      The documentation tells you. See http://search.cpan.org/~timb/DBD-Oracle-1.15/Oracle.pm
      The ORACLE_HOME environment variable should be set correctly. In general, the value used should match the version of Oracle that was used to build DBD::Oracle. If using dynamic linking then ORACLE_HOME should match the version of Oracle that will be used to load in the Oracle client libraries (via LD_LIBRARY_PATH, ldconfig, or similar on Unix).
      Followed by example
      $ENV{ORACLE_HOME} = '/home/oracle/product/7.x.x';
      Get it now?

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (11)
As of 2019-12-09 13:56 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?