Andy Hassall wrote:
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.


Hello,

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.



Reply via email to