Karl Auer wrote:
Hi there.
In common apparently with many others, I can't seem to get DBD::Oracle
installed with the InstantClient. It was retrieved OK from CPAN, and
appears to build OK, but many tests fail and the install is stopped as a
result.
Attached is the output from one install attempt. It seems that many
tests fail with essentially the same message, about a service being
incorrectly configured.
So I'd like to know two things.
Firstly, is there some obvious thing I've missed that will make the
tests work?
Secondly, if not, can I/should I force the install? Attempts to use
sqlplus bring the same error message, so I'm guessing not.
As far as Oracle is concerned, I simply downloaded the three packages
basic, sdk and sqlplus, unpacked them all in a directory, and have set
that directory to be LD_LIBRARY_PATH and ORACLE_HOME. For good measure,
I set ORACLE_USERID to be 'scott/tiger', though that seems unnecessary
and doesn't help :-)
Here are the steps I used
A complete client installation is not needed to install DBD::Oracle. At
a minimum copy over from $ORACLE_HOME the directories:
bin
lib
network
oracore
rdbms
sqlplus
Set the following environment variables
export ORACLE_HOME=<path to Oracle Home dir>
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:/$ORACLE_HOME/bin
Set TWO_TASK appropriately. This varies depending on the type of
connection used. For example, if you use tnsnames.ora for resolution:
export TWO_TASK=<dbname>
You should now be able to connect with:
$ sqlplus <username>/<password>
Build the module:
$ perl Makefile.PL
$ make
Set a user/pass for testing
$ export ORACLE_USERID=<username>/<password>
Test
$ make test
Install
$ sudo make install
Before using it is a good idea to link libclntsh.so somewhere "normal".
/usr/lib/libclntsh.so.10.1 ->
/mp001/app/oracle/product/10/lib/libclntsh.so.10.1
--
Stephen Carville <[EMAIL PROTECTED]>
Unix and Network Admin
Nationwide Totalflood
6033 W. Century Blvd
Los Angeles, CA 90045
310-342-3602
