Tim Bunce wrote:
On Thu, Jan 12, 2006 at 12:34:54PM +0000, Charles Jardine wrote:
Tim Bunce wrote:
http://www.data-plan.com/public/DBD-Oracle-1.17-RC3.tar.gz
"We're getting there". This one fixes the two issues raised against RC2
(thanks Andy and Steffen).
I'd be grateful for more, and wider, testing. Thanks!
Neither this release, nor RC2, work against the Instant Client
on Solaris. Makefile.PL fails with the output shown below.
The original release candidate's Makefile.PL succeeds with
the exact same environment settings (using the makefile
/jackdaw/instantclient/sdk/demo/demo.mk).
I presume you had to use the -m option to specify the .../demo.mk
since demo.mk isn't one of the .mk file names Makefile.PL search for.
No. $ORACLE_HOME points to an Instant Client. demo.mk is the only
makefile it has got. This worked with the first release candidate.
The Makefile.pl -v ouput is below.
What seems to be happening with RC3 is that Makefile.PL is behaving
as if I had a full Oracle install rather than an Instant Client.
What does "ls -l $ORACLE_HOME" show?
[EMAIL PROTECTED] echo $ORACLE_HOME
/jackdaw/instantclient
[EMAIL PROTECTED] ls -l $ORACLE_HOME
lrwxrwxrwx 1 root other 18 Jan 3 10:55
/jackdaw/instantclient -> instantclient_10_2
[EMAIL PROTECTED] ls -l $ORACLE_HOME/.
total 211850
-r--r--r-- 1 root other 1590491 Aug 16 14:35 classes12.jar
-r--r--r-- 1 root other 1525 Aug 16 14:38 glogin.sql
lrwxrwxrwx 1 root other 17 Jan 4 14:58 libclntsh.so ->
libclntsh.so.10.1
-rwxr-xr-x 1 root other 23805656 Aug 16 14:35 libclntsh.so.10.1
-rwxr-xr-x 1 root other 6858120 Aug 16 14:35 libnnz10.so
-rwxr-xr-x 1 root other 1492072 Aug 16 14:35 libocci.so.10.1
-rwxr-xr-x 1 root other 70108288 Aug 16 14:35 libociei.so
-rwxr-xr-x 1 root other 123864 Aug 16 14:35 libocijdbc10.so
-rwxr-xr-x 1 root other 1320016 Aug 16 14:38 libsqlplus.so
-rwxr-xr-x 1 root other 1437104 Aug 16 14:38 libsqlplusic.so
-r--r--r-- 1 root other 1536979 Aug 16 14:35 ojdbc14.jar
drwxr-xr-x 4 root other 512 Aug 16 14:38 sdk
-rwxr-xr-x 1 root other 8784 Aug 16 14:38 sqlplus
[EMAIL PROTECTED] find $ORACLE_HOME/. -name '*.mk'
/jackdaw/instantclient/./sdk/demo/demo.mk
[EMAIL PROTECTED]
And the Makefile.PL outout from the first release candidate.
[EMAIL PROTECTED] perl Makefile.PL -v
Using DBI 1.50 (for perl 5.008007 on sun4-solaris-64) installed in
/net/jackdaw.cam.ac.uk/jackdaw/perl/5.8.7-A/lib/site_perl/5.8.7/sun4-solaris-64/auto/DBI/
Configuring DBD::Oracle ...
>>> Remember to actually *READ* the README file!
Especially if you have any problems.
os=solaris
Using Oracle in /jackdaw/instantclient
path=/jackdaw/perl/5.8.7-A/bin:/home/cj10/bin:/jackdaw/perl/bin:/jackdaw/perl/util:/jackdaw/bin:/jackdaw/instantclient:/usr/openwin/bin:/opt/SUNWspro/bin:/usr/sbin:/usr/bin:/usr/ccs/bin:/jackdaw/instantclient/bin:/jackdaw/instantclient
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)
Found direct-link candidate: clntsh
Oracle sysliblist:
Checking for functioning wait.ph
System: perl5.008007 sunos skylark.csx.cam.ac.uk 5.8 generic_117350-26
sun4u sparc sunw,sun-blade-100
Compiler: /opt/SUNWspro/bin/cc -O -xarch=v9
-I/net/jackdaw.cam.ac.uk/jackdaw/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64
Linker: /usr/ccs/bin/ld
Sysliblist:
Linking with -lclntsh.
Warning: If you have problems you may need to rebuild perl with
threading enabled.
MakeMaker (v6.17)
Checking if your kit is complete...
Looks good
ABSTRACT_FROM => q[Oracle.pm]
AUTHOR => q[Tim Bunce (dbi-users@perl.org)]
DEFINE => q[ -DUTF8_SUPPORT -DNEW_OCI_INIT
-DORA_OCI_VERSION=\"10.2.0.1\"]
DIR => []
EXE_FILES => [q[ora_explain]]
INC => q[-I/jackdaw/instantclient/sdk/include
-I/net/jackdaw.cam.ac.uk/jackdaw/perl/5.8.7-A/lib/site_perl/5.8.7/sun4-solaris-64/auto/DBI/]
LIBS => [q[-L/jackdaw/instantclient/ -lclntsh ]]
NAME => q[DBD::Oracle]
OBJECT => q[$(O_FILES)]
PREREQ_PM => { DBI=>q[0] }
VERSION_FROM => q[Oracle.pm]
clean => { FILES=>q[xstmp.c Oracle.xsi dll.base dll.exp sqlnet.log
libOracle.def ora_explain mk.pm] }
dist => { DIST_DEFAULT=>q[clean distcheck disttest tardist],
COMPRESS=>q[gzip -v9], PREOP=>q[$(MAKE) -f Makefile.old distdir],
SUFFIX=>q[gz] }
dynamic_lib => { OTHERLDFLAGS=>q[] }
Using PERL=/jackdaw/perl/5.8.7-A/bin/perl
Potential libraries are '-L/jackdaw/instantclient/ -lclntsh':
'-lclntsh' found at /jackdaw/instantclient//libclntsh.so.10.1
LD_RUN_PATH=/jackdaw/instantclient
Using DBD::Oracle 1.17.
Using DBD::Oracle 1.17.
Using DBI 1.50 (for perl 5.008007 on sun4-solaris-64) installed in
/net/jackdaw.cam.ac.uk/jackdaw/perl/5.8.7-A/lib/site_perl/5.8.7/sun4-solaris-64/auto/DBI/
Writing Makefile for DBD::Oracle
*** If you have problems...
read all the log printed above, and the README and README.help files.
(Of course, you have read README by now anyway, haven't you?)
[EMAIL PROTECTED]
--
Charles Jardine - Computing Service, University of Cambridge
[EMAIL PROTECTED] Tel: +44 1223 334506, Fax: +44 1223 334679
