[Fwd: compiling DBD-Oracle 1.16 against an Oracle 9i 64bit home]

I simply removed the extra cc reference and ran it manually then ran make again then make test, make install and I'm up and running...

cc -G -L/usr/lib -L/usr/ccs/lib -L/opt/SUNWspro/WS6U2/lib Oracle.o dbdimp.o oci8.o *EXTRA CC RIGHT HERE* 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




-------- Original Message --------
Subject: compiling DBD-Oracle 1.16 against an Oracle 9i 64bit home
Date: Fri, 13 Oct 2006 13:09:02 -0400
From: listmail <listmail@xxxxxxxxxxxx>
To: dbi-users@xxxxxxxx



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/VRTSvcs/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/bin:/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@xxxxxxxx)]
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-thread-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-thread-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/CORE" -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-thread-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/CORE" -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-thread-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/CORE" -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'


.

Relevant Pages

  • Re: Adding RAM
    ... About Oracle, I currently use Mysql for my TM databases but I have been ... Limited to a 4GB database but that should be adequate ... The rpm is easy to install and you get a nice tutorial to ... Here's the link to the Oracle-10g + Compiere installation on SuSE ...
    (alt.os.linux.suse)
  • Re: Upgrade 8i to 9i --- multiple oracle_base !!!!!!
    ... > it's own system owning account. ... > 1) Install one copy of the latest version of SQL-Backtrack into its own ... completely separate from any Oracle directories. ... > 2) Shutdown and cold backup both databases. ...
    (comp.databases.oracle.server)
  • RE: :Oracle install problem On Solaris 8
    ... I tried to reinstall the Oracle client. ... To: Hemanth Kumar; Michael Nhan ... Subject: RE::Oracle install problem On Solaris 8 ...
    (perl.dbi.users)
  • RE: Problems to Install Oracle Client 10g over Red Hat AS 3.0update3
    ... Oracle 10g R1 DB go out of memory once in a while goes for a toss till it ... "General Red Hat Linux discussion list" ... Problems to Install Oracle Client 10g over Red Hat AS 3.0update3 ...
    (RedHat)
  • Re: About Oracle 10g XE
    ... >> I am learning Oracle from an institute and it would be helpful if I ... >> I want to know is, does this product give one the ability to run SQL ... Or does anybody know whether SAS and Oracle can ... I would like to install this in my office computer (Win XP, ...
    (comp.databases.oracle.misc)