Hello,http://otn.oracle.com/tech/oci/instantclient/instantclient.html
"Download and be ready in seconds. Deploy your applications right out of the box. Deliver the promise. Free.
Naturally I'd like DBD::Oracle to support "Instant Clients".
Short answer: It works on Linux, at least as far as passing make test.
Long answer:
Looks like the Oracle developers aren't talking to the documentation guys (as usual) - the installation instructions say to 'Unzip the packages into a single directory such as "instantclient".'.
Except it's an RPM file.
So, installed the RPM, it puts libraries in /usr/lib/oracle/client/10.1.2. The basic package comes with this lot:
[EMAIL PROTECTED] andyh]# rpm --query --list -p oracle-instantclient-basic-10.1.0.2-1.i386.rpm /usr/lib/oracle/10.1.0.2/client/lib/classes12.jar /usr/lib/oracle/10.1.0.2/client/lib/libclntsh.so.10.1 /usr/lib/oracle/10.1.0.2/client/lib/libnnz10.so /usr/lib/oracle/10.1.0.2/client/lib/libocci.so.10.1 /usr/lib/oracle/10.1.0.2/client/lib/libociei.so /usr/lib/oracle/10.1.0.2/client/lib/libocijdbc10.so /usr/lib/oracle/10.1.0.2/client/lib/ojdbc14.jar
No headers so obviously can't compile against just this - have to use a full
Oracle home for that. Compiled DBD-Oracle svn rev. 185. against Oracle
10.1.0.2
Relevant bits of environment:
[EMAIL PROTECTED] DBD-Oracle]# echo $ORACLE_HOME
[EMAIL PROTECTED] DBD-Oracle]# echo $PATH /usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin: /root/bin [EMAIL PROTECTED] DBD-Oracle]# echo $LD_LIBRARY_PATH /usr/lib/oracle/10.1.0.2/client/lib [EMAIL PROTECTED] DBD-Oracle]# echo $NLS_LANG ENGLISH_UNITED KINGDOM.WE8ISO8859P15 [EMAIL PROTECTED] DBD-Oracle]# echo $ORACLE_USERID test/test@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=testbox.localhost)(PORT= 1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dev101)))
So no reference left to the Oracle home - started a fresh session for this to make sure. Specified the connect string using the full syntax since it won't know where tnsnames.ora is. LD_LIBRARY_PATH pointing to the Instant Client libraries.
[EMAIL PROTECTED] DBD-Oracle]# make test PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/01base.......ok t/10general....ORACLE_HOME environment variable not set! t/10general....ok t/20select.....ORACLE_HOME environment variable not set! t/20select.....ok t/21nchar......NLS_LANG=ENGLISH_UNITED KINGDOM.WE8ISO8859P15 ORACLE_HOME environment variable not set! NLS_CHARACTERSET=WE8ISO8859P15 NLS_NCHAR_CHARACTERSET=UTF8
t/21nchar......ok t/25plsql......ORACLE_HOME environment variable not set! t/25plsql......ok t/30long.......ORACLE_HOME environment variable not set! t/30long.......ok t/40ph_type....ORACLE_HOME environment variable not set! t/40ph_type....ok 11/19 Placeholder behaviour for ora_type=1 (the default) varies with Oracle version. Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x Your system doesn't. If that seems odd, let us know. t/40ph_type....ok t/50cursor.....ORACLE_HOME environment variable not set! t/50cursor.....ok t/60reauth.....skipped all skipped: no reason given t/70meta.......ORACLE_HOME environment variable not set! t/70meta.......ok All tests successful, 1 test skipped. Files=10, Tests=1554, 43 wallclock secs ( 7.29 cusr + 0.95 csys = 8.24 CPU)
So it whinges a bit about ORACLE_HOME not being set, but works.
Thanks for this info. Could you please also provide the perl Makefile.PL command that you used to generate the Makefile?
I generate it with -F, but I had lots of errors not only related to ORACLE_HOME. After the make test did not work.
Thanks in advance for your help.
