the oracle install is a real PITA.
Install oracle install client for, I think in your situation, 64 bit perl, and for your platform. Downloadable for free from oracle.com, after nagging you to create an account with user/pw.
Before doing anything with the perl install, verify that you can connect to an oracle db with instantclient.
I did something like this
$ cat oracle-env.sh
export INSTANT_CLIENT_PATH=/home/oracleInstalls/10.2/instantclient_10_
+2
export LD_LIBRARY_PATH=$INSTANT_CLIENT_PATH
export PATH=$INSTANT_CLIENT_PATH:$PATH
export TNS_ADMIN=/opt/oracle
export ORACLE_HOME=$INSTANT_CLIENT_PATH
export ORACLE_USERID='user/password'
#export ORACLE_DSN='mydb2.myhost' # this dien't work
export ORACLE_DSN='dbi:Oracle:host=myhost;sid=mydb2' # necessary to ge
+t make test to work in dbd::oracle
#needed for sqlplus
export TWO_TASK=mydb2.myhost
export ORACLE_SID=mydb2
alias go-dbd-oracle='cd /usr/cpanroot64/.cpan/build/DBD-Oracle-1.18'
#$dbh = DBI->connect("dbi:Oracle:host=myhost.com;sid=ORCL", $user, $pa
+sswd);
alias the-sqlplus='sqlplus user/password@mydb2.myhost'
After I verified that I could commit to sqlplus, I cd-ed into the build dir for DBD::Oracle and force-installed.
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|