compiling DBD-Oracle 1.16 against an Oracle 9i 64bit home

compiling DBD-Oracle 1.16 against an Oracle 9i 64bit home

am 13.10.2006 19:09:02 von listmail

I'm trying to compile DBD-Oracle 1.16 against an Oracle 9i 64-bit home
and got a little further this time when I set LD_LIBRARY_PATH to include
$ORACLE_HOME/lib32. I'm not seeing what file it cannot find and the
three .0 files were created. The following is the output of env vars,
the "perl Makefile.pl" and "make commands":

LD_LIBRARY_PATH=:/opt/hpnpl/lib:/opt/EMCpower/lib:/opt/VRTSv cs/EMC/lib:/u01/oracle/qadb/9.2.0/lib32
LD_LIBRARY_PATH_64=/opt/EMCpower/lib/sparcv9
ORACLE_HOME=/u01/oracle/qadb/9.2.0
PATH=/opt/ActivePerl-5.8/bin:/usr/ccs/bin:/opt/SUNWspro/bin: /usr/local/bin:/scripts:/usr/openv/netbackup/bin:/usr/openv/ volmgr/bin:/opt/hpnpl/bin:/usr/sbin:/usr/bin:/opt/ActivePerl -5.8/bin:.:/etc:/opt/EMCpower/bin/sparcv9:/opt/VRTSvcs/EMC/b in:/etc/emc/bin


# perl Makefile.PL -v
Using DBI 1.50 (for perl 5.008008 on sun4-solaris-thread-multi)
installed in
/opt/ActivePerl-5.8/lib/site_perl/5.8.8/sun4-solaris-thread- multi/auto/DBI/

Configuring DBD::Oracle ...

>>> Remember to actually *READ* the README file!
Especially if you have any problems.

Using Oracle in /u01/oracle/qadb/9.2.0
DEFINE _SQLPLUS_RELEASE = "902000700" (CHAR)
Oracle version 9.2.0.7 (9.2)
Found /u01/oracle/qadb/9.2.0/rdbms/demo/demo_rdbms.mk
Found /u01/oracle/qadb/9.2.0/otrace/demo/atmoci.mk
Found /u01/oracle/qadb/9.2.0/precomp/demo/proc/demo_proc.mk
Using /u01/oracle/qadb/9.2.0/rdbms/demo/demo_rdbms.mk
Reading /u01/oracle/qadb/9.2.0/rdbms/demo/demo_rdbms.mk
Reading /u01/oracle/qadb/9.2.0/rdbms/lib/env_rdbms.mk
Read a total of 2323 lines from
/u01/oracle/qadb/9.2.0/rdbms/lib/env_rdbms.mk (including inclusions)
Read a total of 2684 lines from
/u01/oracle/qadb/9.2.0/rdbms/demo/demo_rdbms.mk (including inclusions)
Deleted SHELL definition: SHELL=/bin/sh
Deleted LIB_EXT definition: LIB_EXT=a
Deleted OBJ_EXT definition: OBJ_EXT=o
Deleted AR definition: AR=ar
Deleted AS definition: AS=as
Deleted CC definition: CC=cc
Deleted CHMOD definition: CHMOD=chmod
Deleted CPP definition: CPP=cpp
Deleted ECHO definition: ECHO=echo
Deleted LD definition: LD=ld
Deleted PERL definition: PERL=perl
Deleted CFLAGS definition: CFLAGS=$(GFLAG) $(OPTIMIZE) $(CDEBUG)
$(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
Deleted LDFLAGS definition: LDFLAGS=-o $@ $(LDPATHFLAG)$(PRODLIBHOME)
$(LDPATHFLAG)$(LIBHOME)
Deleted OPTIMIZE definition: OPTIMIZE=$(OPTIMIZE3)
Deleted AR definition: AR=/usr/ccs/bin/ar
Deleted AS definition: AS=/usr/ccs/bin/as
Deleted LD definition: LD=/usr/ccs/bin/ld
Deleted CPP definition: CPP=$(CC) -E $(ANSI)
Deleted CHMOD definition: CHMOD=/bin/chmod
Deleted ASFLAGS definition: ASFLAGS=$(NOKPIC_ASFLAGS) $(KPIC_OPTION)
Deleted CCFLAGS definition: CCFLAGS=$(NOKPIC_CCFLAGS) $(KPIC_OPTION)
Appending '/u01/oracle/qadb/9.2.0/rdbms/lib/libskgxpd.a
/u01/oracle/qadb/9.2.0/rdbms/lib/libskgxpu.a
/u01/oracle/qadb/9.2.0/rdbms/lib/libskgxpt.a' to EXTRALIBS
Appending '$(LIBHOME)libskgxp9.so' to SHLIBS
Appending '/u01/oracle/qadb/9.2.0/rdbms/lib/libskgxp9.a' to LIBS
Appending '/u01/oracle/qadb/9.2.0/rdbms/lib/libskgxns.a
/u01/oracle/qadb/9.2.0/rdbms/lib/libskgxnd.a
/u01/oracle/qadb/9.2.0/rdbms/lib/libskgxnr.a' to EXTRALIBS
Appending '$(LIBHOME)libskgxn9.so' to SHLIBS
Appending '/u01/oracle/qadb/9.2.0/rdbms/lib/libskgxn9.a' to LIBS
Evaluating `cat $(LIBHOME)sysliblist`
expanded `cat /u01/oracle/qadb/9.2.0/lib/sysliblist`
returned '-lnsl -lsocket -lgen -ldl '

Attempting to discover Oracle OCI build32 rules
cc -c DBD_ORA_OBJ.c
by executing: [make -f /u01/oracle/qadb/9.2.0/rdbms/demo/demo_rdbms.mk
build32 ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=true
OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o]
returned:
[/usr/ccs/bin/make -f /u01/oracle/qadb/9.2.0/rdbms/demo/demo_rdbms.mk
build \]
[EXE=DBD_ORA_EXE OBJS='DBD_ORA_OBJ.o' LIBDIR=lib32 \]
[NOKPIC_CCFLAGS='-Xa -xstrconst -xF -xarch=v8 -xchip=ultra
-W2,-AKNR_S -W2,-Rglobal_hoist -Wc,-Qdelay-speculate
-Wc,-Qdepgraph-safe_spec_load=3 -W2,-Rloop -errtags=yes -v' \]
[LINKEXSYSLIBS='-R /opt/SUNWcluster/lib:/u01/oracle/qadb/9.2.0/lib -Y
P,:/opt/SUNWcluster/lib:/usr/ccs/lib:/usr/lib -Qy -lc -laio -lposix4
-lkstat']
[cc -Xa -xstrconst -xF -xarch=v8 -xchip=ultra -W2,-AKNR_S
-W2,-Rglobal_hoist -Wc,-Qdelay-speculate
-Wc,-Qdepgraph-safe_spec_load=3 -W2,-Rloop -errtags=yes -v -K PIC
-L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o build
-L/u01/oracle/qadb/9.2.0/rdbms/lib32/ -L/u01/oracle/qadb/9.2.0/lib32/
-o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat
/u01/oracle/qadb/9.2.0/lib32/ldflags` `cat
/u01/oracle/qadb/9.2.0/lib32/sysliblist` -R/u01/oracle/qadb/9.2.0/lib32
-laio -lposix4 -lkstat -lm -lthread]
reduced to:
[cc -Xa -xstrconst -xF -xarch=v8 -xchip=ultra -W2,-AKNR_S
-W2,-Rglobal_hoist -Wc,-Qdelay-speculate
-Wc,-Qdepgraph-safe_spec_load=3 -W2,-Rloop -errtags=yes -v -K PIC
-L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o build
-L/u01/oracle/qadb/9.2.0/rdbms/lib32/ -L/u01/oracle/qadb/9.2.0/lib32/
-o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat
/u01/oracle/qadb/9.2.0/lib32/ldflags` `cat
/u01/oracle/qadb/9.2.0/lib32/sysliblist` -R/u01/oracle/qadb/9.2.0/lib32
-laio -lposix4 -lkstat -lm -lthread]
Oracle oci build command:
[cc -Xa -xstrconst -xF -xarch=v8 -xchip=ultra -W2,-AKNR_S
-W2,-Rglobal_hoist -Wc,-Qdelay-speculate
-Wc,-Qdepgraph-safe_spec_load=3 -W2,-Rloop -errtags=yes -v -K PIC
-L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o build
-L/u01/oracle/qadb/9.2.0/rdbms/lib32/ -L/u01/oracle/qadb/9.2.0/lib32/
-o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat
/u01/oracle/qadb/9.2.0/lib32/ldflags` `cat
/u01/oracle/qadb/9.2.0/lib32/sysliblist` -R/u01/oracle/qadb/9.2.0/lib32
-laio -lposix4 -lkstat -lm -lthread]

Found header files in plsql/public rdbms/public rdbms/demo.

Checking for functioning wait.ph


System: perl5.008008 sunos axe 5.6 generic_105181-33 sun4u sparc
sunw,ultra-60
Compiler: cc -O -D_POSIX_PTHREAD_SEMANTICS -D_REENTRANT
-DUSE_SITECUSTOMIZE -DNO_HASH_SEED -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64
Linker: /usr/ccs/bin/ld
Sysliblist: -lnsl -lsocket -lgen -ldl
Oracle makefiles would have used these definitions but we override them:
CC: cc

CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) -xO3 $(CDEBUG) -Xa $(PROFILE) -xstrconst -dalign
-xF $(XS) $(MR) -xildoff -errtags=yes -v -xarch=v9 -xchip=ultra3
-W2,-AKNR_S -Wd,-xsafe=unboundsym -Wc,-Qiselect-funcalign=32
-xcode=abs44 -Wc,-Qgsched-trace_late=1 -Wc,-Qgsched-T5
-xalias_level=weak -D_REENTRANT -DSS_64BIT_SERVER -DBIT64 -DMACHINE64 -K
PIC -I/u01/oracle/qadb/9.2.0/rdbms/demo
-I/u01/oracle/qadb/9.2.0/rdbms/public
-I/u01/oracle/qadb/9.2.0/plsql/public
-I/u01/oracle/qadb/9.2.0/network/public -DSLMXMX_ENABLE -DSLTS_ENABLE
-D_SVID_GETTOD -D_REENTRANT $(LPFLAGS) $(USRFLAGS)]

LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
[-o $@ -L/u01/oracle/qadb/9.2.0/rdbms/lib/ -L$(LIBHOME)]


Linking with OTHERLDFLAGS = cc -Xa -xstrconst -xF -xarch=v8
-xchip=ultra -W2,-AKNR_S -W2,-Rglobal_hoist -Wc,-Qdelay-speculate
-Wc,-Qdepgraph-safe_spec_load=3 -W2,-Rloop -errtags=yes -v -K PIC
-L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib
-L/u01/oracle/qadb/9.2.0/rdbms/lib32/ -L/u01/oracle/qadb/9.2.0/lib32/
-lclntsh `cat /u01/oracle/qadb/9.2.0/lib32/ldflags` `cat
/u01/oracle/qadb/9.2.0/lib32/sysliblist` -R/u01/oracle/qadb/9.2.0/lib32
-laio -lposix4 -lkstat -lm -lthread [from 'build32' rule]


MakeMaker (v6.30)
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=\"9.2.0.7\"]
DIR => []
EXE_FILES => [q[ora_explain]]
INC => q[-I/u01/oracle/qadb/9.2.0/rdbms/demo
-I/u01/oracle/qadb/9.2.0/rdbms/public
-I/u01/oracle/qadb/9.2.0/plsql/public
-I/u01/oracle/qadb/9.2.0/network/public
-I/u01/oracle/qadb/9.2.0/rdbms/demo
-I/u01/oracle/qadb/9.2.0/plsql/public
-I/u01/oracle/qadb/9.2.0/rdbms/public
-I/u01/oracle/qadb/9.2.0/rdbms/demo
-I/opt/ActivePerl-5.8/lib/site_perl/5.8.8/sun4-solaris-threa d-multi/auto/DBI/]
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[ cc -Xa -xstrconst -xF -xarch=v8
-xchip=ultra -W2,-AKNR_S -W2,-Rglobal_hoist -Wc,-Qdelay-speculate
-Wc,-Qdepgraph-safe_spec_load=3 -W2,-Rloop -errtags=yes -v -K PIC
-L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib
-L/u01/oracle/qadb/9.2.0/rdbms/lib32/ -L/u01/oracle/qadb/9.2.0/lib32/
-lclntsh `cat /u01/oracle/qadb/9.2.0/lib32/ldflags` `cat
/u01/oracle/qadb/9.2.0/lib32/sysliblist` -R/u01/oracle/qadb/9.2.0/lib32
-laio -lposix4 -lkstat -lm -lthread] }
Using PERL=/opt/ActivePerl-5.8/bin/perl
Use of uninitialized value in substitution (s///) at Makefile.PL line 1446.
LD_RUN_PATH=/u01/oracle/qadb/9.2.0/lib32:/u01/oracle/qadb/9. 2.0/rdbms/lib32
Using DBD::Oracle 1.16.
Using DBD::Oracle 1.16.
Using DBI 1.50 (for perl 5.008008 on sun4-solaris-thread-multi)
installed in
/opt/ActivePerl-5.8/lib/site_perl/5.8.8/sun4-solaris-thread- multi/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?)

# make -v
make: Warning: Ignoring DistributedMake -v option
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
/opt/ActivePerl-5.8/bin/perl -p -e "s/~DRIVER~/Oracle/g"
/opt/ActivePerl-5.8/lib/site_perl/5.8.8/sun4-solaris-thread- multi/auto/DBI//Driver.xst
> Oracle.xsi
/opt/ActivePerl-5.8/bin/perl
/opt/ActivePerl-5.8/lib/5.8.8/ExtUtils/xsubpp -typemap
/opt/ActivePerl-5.8/lib/5.8.8/ExtUtils/typemap -typemap typemap
Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
cc -c -I/u01/oracle/qadb/9.2.0/rdbms/demo
-I/u01/oracle/qadb/9.2.0/rdbms/public
-I/u01/oracle/qadb/9.2.0/plsql/public
-I/u01/oracle/qadb/9.2.0/network/public
-I/u01/oracle/qadb/9.2.0/rdbms/demo
-I/u01/oracle/qadb/9.2.0/plsql/public
-I/u01/oracle/qadb/9.2.0/rdbms/public
-I/u01/oracle/qadb/9.2.0/rdbms/demo
-I/opt/ActivePerl-5.8/lib/site_perl/5.8.8/sun4-solaris-threa d-multi/auto/DBI/
-D_POSIX_PTHREAD_SEMANTICS -D_REENTRANT -DUSE_SITECUSTOMIZE
-DNO_HASH_SEED -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O
-DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -KPIC
"-I/opt/ActivePerl-5.8/lib/5.8.8/sun4-solaris-thread-multi/C ORE"
-DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2.0.7\" Oracle.c
cc -c -I/u01/oracle/qadb/9.2.0/rdbms/demo
-I/u01/oracle/qadb/9.2.0/rdbms/public
-I/u01/oracle/qadb/9.2.0/plsql/public
-I/u01/oracle/qadb/9.2.0/network/public
-I/u01/oracle/qadb/9.2.0/rdbms/demo
-I/u01/oracle/qadb/9.2.0/plsql/public
-I/u01/oracle/qadb/9.2.0/rdbms/public
-I/u01/oracle/qadb/9.2.0/rdbms/demo
-I/opt/ActivePerl-5.8/lib/site_perl/5.8.8/sun4-solaris-threa d-multi/auto/DBI/
-D_POSIX_PTHREAD_SEMANTICS -D_REENTRANT -DUSE_SITECUSTOMIZE
-DNO_HASH_SEED -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O
-DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -KPIC
"-I/opt/ActivePerl-5.8/lib/5.8.8/sun4-solaris-thread-multi/C ORE"
-DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2.0.7\" dbdimp.c
cc -c -I/u01/oracle/qadb/9.2.0/rdbms/demo
-I/u01/oracle/qadb/9.2.0/rdbms/public
-I/u01/oracle/qadb/9.2.0/plsql/public
-I/u01/oracle/qadb/9.2.0/network/public
-I/u01/oracle/qadb/9.2.0/rdbms/demo
-I/u01/oracle/qadb/9.2.0/plsql/public
-I/u01/oracle/qadb/9.2.0/rdbms/public
-I/u01/oracle/qadb/9.2.0/rdbms/demo
-I/opt/ActivePerl-5.8/lib/site_perl/5.8.8/sun4-solaris-threa d-multi/auto/DBI/
-D_POSIX_PTHREAD_SEMANTICS -D_REENTRANT -DUSE_SITECUSTOMIZE
-DNO_HASH_SEED -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O
-DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -KPIC
"-I/opt/ActivePerl-5.8/lib/5.8.8/sun4-solaris-thread-multi/C ORE"
-DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2.0.7\" oci8.c
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
cc -G -L/usr/lib -L/usr/ccs/lib -L/opt/SUNWspro/WS6U2/lib Oracle.o
dbdimp.o oci8.o cc -Xa -xstrconst -xF -xarch=v8 -xchip=ultra
-W2,-AKNR_S -W2,-Rglobal_hoist -Wc,-Qdelay-speculate
-Wc,-Qdepgraph-safe_spec_load=3 -W2,-Rloop -errtags=yes -v -K PIC
-L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib
-L/u01/oracle/qadb/9.2.0/rdbms/lib32/ -L/u01/oracle/qadb/9.2.0/lib32/
-lclntsh `cat /u01/oracle/qadb/9.2.0/lib32/ldflags` `cat
/u01/oracle/qadb/9.2.0/lib32/sysliblist` -R/u01/oracle/qadb/9.2.0/lib32
-laio -lposix4 -lkstat -lm -lthread -o
blib/arch/auto/DBD/Oracle/Oracle.so \
\

ld: fatal: file cc: open failed: No such file or directory
ld: fatal: File processing errors. No output written to
blib/arch/auto/DBD/Oracle/Oracle.so
*** Error code 1
make: Fatal error: Command failed for target
`blib/arch/auto/DBD/Oracle/Oracle.so'