DBD Oracle problems on solaris 7

• Previous message: Tim Bunce: "Re: Apache, Oracle, Perl DBI Problems"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

To: "'dbi-users@perl.org'" <dbi-users@perl.org>
Date: Fri, 12 Dec 2003 11:14:24 -0600

I am trying to build DBD::Oracle on a Solaris 7 machine and keep running
into make errors. I have read all the readme files and tried Google search
for matching errors but no sucess so far. The logs as requested in the
README file are copied below. Any help is greately appreciated.

# perl Makefile.PL -v
Using DBI 1.39 installed in
/usr/local/lib/perl5/site_perl/5.8.0/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/app/oracle/product/9.2

Oracle version 9.2.0.0.0
Found header files in rdbms/public rdbms/demo.
Found /u01/app/oracle/product/9.2/rdbms/demo/demo_rdbms.mk
Found /u01/app/oracle/product/9.2/otrace/demo/atmoci.mk
Found /u01/app/oracle/product/9.2/precomp/demo/proc/demo_proc.mk
Using /u01/app/oracle/product/9.2/rdbms/demo/demo_rdbms.mk
Reading /u01/app/oracle/product/9.2/rdbms/demo/demo_rdbms.mk
Reading /u01/app/oracle/product/9.2/rdbms/lib/env_rdbms.mk
Read a total of 2318 lines from
/u01/app/oracle/product/9.2/rdbms/lib/env_rdbms.mk (including inclusions)
Read a total of 2674 lines from
/u01/app/oracle/product/9.2/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)
Deleting ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/
  because it is not already set in the environment
  and it can cause ORA-01019 errors.
Deleted ORA_NLS definition: ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/
Deleting ORA_NLS33 = $(ORACLE_HOME)/ocommon/nls/admin/data/
  because it is not already set in the environment
  and it can cause ORA-01019 errors.
Deleted ORA_NLS33 definition: ORA_NLS33 =
$(ORACLE_HOME)/ocommon/nls/admin/data/
Appending '/u01/app/oracle/product/9.2/rdbms/lib/libskgxpd.a
/u01/app/oracle/product/9.2/rdbms/lib/libskgxpu.a
/u01/app/oracle/product/9.2/rdbms/lib/libskgxpt.a' to EXTRALIBS
Appending '$(LIBHOME)libskgxp9.so' to SHLIBS
Appending '/u01/app/oracle/product/9.2/rdbms/lib/libskgxp9.a' to LIBS
Appending '/u01/app/oracle/product/9.2/rdbms/lib/libskgxns.a
/u01/app/oracle/product/9.2/rdbms/lib/libskgxnd.a
/u01/app/oracle/product/9.2/rdbms/lib/libskgxnr.a' to EXTRALIBS
Appending '$(LIBHOME)libskgxn9.so' to SHLIBS
Appending '/u01/app/oracle/product/9.2/rdbms/lib/libskgxn9.a' to LIBS
Evaluating `cat $(LIBHOME)sysliblist`
  expanded `cat /u01/app/oracle/product/9.2/lib/sysliblist`
  returned '-lnsl -lsocket -lgen -ldl '

Attempting to discover Oracle OCI build rules
/opt/SUNWspro/bin/cc -c DBD_ORA_OBJ.c
by executing: (make -f /u01/app/oracle/product/9.2/rdbms/demo/demo_rdbms.mk
build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=echo OPTIMIZE=
CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o)
returned:
[echo -L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o build
-L/u01/app/oracle/product/9.2/rdbms/lib/ -L/u01/app/oracle/product/9.2/lib/
-o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat
/u01/app/oracle/product/9.2/lib/ldflags` `cat
/u01/app/oracle/product/9.2/lib/sysliblist`
-R/u01/app/oracle/product/9.2/lib -laio -lposix4 -lkstat -lm -lthread

[-L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o build
-L/u01/app/oracle/product/9.2/rdbms/lib/ -L/u01/app/oracle/product/9.2/lib/
-o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh -lnbeq9 -lnhost9 -lnus9 -lnldap9
-lldapclnt9 -lnsslb9 -lnnis9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9
-lntns9 -lnsl -lsocket -lgen -ldl -R/u01/app/oracle/product/9.2/lib -laio
-lposix4 -lkstat -lm -lthread
]
reduced to:
[-L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o build
-L/u01/app/oracle/product/9.2/rdbms/lib/ -L/u01/app/oracle/product/9.2/lib/
-o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh -lnbeq9 -lnhost9 -lnus9 -lnldap9
-lldapclnt9 -lnsslb9 -lnnis9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9
-lntns9 -lnsl -lsocket -lgen -ldl -R/u01/app/oracle/product/9.2/lib -laio
-lposix4 -lkstat -lm -lthread
]
Oracle oci build command:
        + -L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o build
-L/u01/app/oracle/product/9.2/rdbms/lib/ -L/u01/app/oracle/product/9.2/lib/
-o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh -lnbeq9 -lnhost9 -lnus9 -lnldap9
-lldapclnt9 -lnsslb9 -lnnis9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9
-lntns9 -lnsl -lsocket -lgen -ldl -R/u01/app/oracle/product/9.2/lib -laio
-lposix4 -lkstat -lm -lthread

System: perl5.008 sunos daytona 5.7 generic_106541-14 sun4us sparc
fjsv,gpusk
Compiler: /opt/SUNWspro/bin/cc -O -D_REENTRANT -I/usr/local/include
-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/app/oracle/product/9.2/rdbms/demo
-I/u01/app/oracle/product/9.2/rdbms/public
-I/u01/app/oracle/product/9.2/plsql/public
-I/u01/app/oracle/product/9.2/network/public -DSLMXMX_ENABLE -DSLTS_ENABLE
-D_SVID_GETTOD -D_REENTRANT $(LPFLAGS) $(USRFLAGS)]

  LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
           [-o $@ -L/u01/app/oracle/product/9.2/rdbms/lib/ -L$(LIBHOME)]

Linking with OTHERLDFLAGS = -L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o
build -L/u01/app/oracle/product/9.2/rdbms/lib/
-L/u01/app/oracle/product/9.2/lib/ -lclntsh -lnbeq9 -lnhost9 -lnus9
-lnldap9 -lldapclnt9 -lnsslb9 -lnnis9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9
-lntcp9 -lntns9 -lnsl -lsocket -lgen -ldl -R/u01/app/oracle/product/9.2/lib
-laio -lposix4 -lkstat -lm -lthread
 [from 'build' rule]

Argument "9.200.0.0" isn't numeric in numeric ge (>=) at Makefile.PL line
669.

MakeMaker (v6.03)
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]
  DIR => []
  EXE_FILES => [q[ora_explain]]
  INC => q[-I/u01/app/oracle/product/9.2/rdbms/demo
-I/u01/app/oracle/product/9.2/rdbms/public
-I/u01/app/oracle/product/9.2/plsql/public
-I/u01/app/oracle/product/9.2/network/public
-I/u01/app/oracle/product/9.2/rdbms/demo
-I/u01/app/oracle/product/9.2/rdbms/public
-I/u01/app/oracle/product/9.2/rdbms/demo
-I/usr/local/lib/perl5/site_perl/5.8.0/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[Oracle.xsi dll.base dll.exp sqlnet.log libOracle.def
ora_explain mk.pm] }
  dist => { DIST_DEFAULT=>q[clean distcheck disttest ci tardist],
COMPRESS=>q[gzip -v9], PREOP=>q[$(MAKE) -f Makefile.old distdir],
SUFFIX=>q[gz] }
  dynamic_lib => { OTHERLDFLAGS=>q[ -L/opt/SUNWcluster/lib
-R/opt/SUNWcluster/lib -o build -L/u01/app/oracle/product/9.2/rdbms/lib/
-L/u01/app/oracle/product/9.2/lib/ -lclntsh -lnbeq9 -lnhost9 -lnus9
-lnldap9 -lldapclnt9 -lnsslb9 -lnnis9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9
-lntcp9 -lntns9 -lnsl -lsocket -lgen -ldl -R/u01/app/oracle/product/9.2/lib
-laio -lposix4 -lkstat -lm -lthread
] }
Using PERL=/usr/local/bin/perl
LD_RUN_PATH=/u01/app/oracle/product/9.2/lib:/u01/app/oracle/product/9.2/rdbm
s/lib
Using DBD::Oracle 1.14.
Using DBD::Oracle 1.14.
Using DBI 1.39 installed in
/usr/local/lib/perl5/site_perl/5.8.0/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
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp oraperl.ph blib/lib/oraperl.ph
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
/usr/local/bin/perl -p -e "s/~DRIVER~/Oracle/g"
/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris-thread-multi/auto/DBI/Driv
er.xst > Oracle.xsi
/usr/local/bin/perl /usr/local/lib/perl5/5.8.0/ExtUtils/xsubpp -typemap
/usr/local/lib/perl5/5.8.0/ExtUtils/typemap Oracle.xs > Oracle.xsc && mv
Oracle.xsc Oracle.c
/opt/SUNWspro/bin/cc -c -I/u01/app/oracle/product/9.2/rdbms/demo
-I/u01/app/oracle/product/9.2/rdbms/public
-I/u01/app/oracle/product/9.2/plsql/public
-I/u01/app/oracle/product/9.2/network/public
-I/u01/app/oracle/product/9.2/rdbms/demo
-I/u01/app/oracle/product/9.2/rdbms/public
-I/u01/app/oracle/product/9.2/rdbms/demo
-I/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris-thread-multi/auto/DBI
-D_REENTRANT -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
-O -DVERSION=\"1.14\" -DXS_VERSION=\"1.14\" -KPIC
"-I/usr/local/lib/perl5/5.8.0/sun4-solaris-thread-multi/CORE"
-DUTF8_SUPPORT Oracle.c
"/u01/app/oracle/product/9.2/rdbms/demo/ort.h", line 927: warning: parameter
has incomplete type: tdo
"/u01/app/oracle/product/9.2/rdbms/demo/ort.h", line 1042: warning:
parameter has incomplete type: type_ref
"/u01/app/oracle/product/9.2/rdbms/demo/ort.h", line 1044: warning:
parameter has incomplete type: tdo
"/u01/app/oracle/product/9.2/rdbms/demo/ociap.h", line 6338: warning:
parameter has incomplete type: hndl
"/u01/app/oracle/product/9.2/rdbms/demo/ociap.h", line 6556: warning:
parameter has incomplete type: argv
/opt/SUNWspro/bin/cc -c -I/u01/app/oracle/product/9.2/rdbms/demo
-I/u01/app/oracle/product/9.2/rdbms/public
-I/u01/app/oracle/product/9.2/plsql/public
-I/u01/app/oracle/product/9.2/network/public
-I/u01/app/oracle/product/9.2/rdbms/demo
-I/u01/app/oracle/product/9.2/rdbms/public
-I/u01/app/oracle/product/9.2/rdbms/demo
-I/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris-thread-multi/auto/DBI
-D_REENTRANT -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
-O -DVERSION=\"1.14\" -DXS_VERSION=\"1.14\" -KPIC
"-I/usr/local/lib/perl5/5.8.0/sun4-solaris-thread-multi/CORE"
-DUTF8_SUPPORT dbdimp.c
"/u01/app/oracle/product/9.2/rdbms/demo/ort.h", line 927: warning: parameter
has incomplete type: tdo
"/u01/app/oracle/product/9.2/rdbms/demo/ort.h", line 1042: warning:
parameter has incomplete type: type_ref
"/u01/app/oracle/product/9.2/rdbms/demo/ort.h", line 1044: warning:
parameter has incomplete type: tdo
"/u01/app/oracle/product/9.2/rdbms/demo/ociap.h", line 6338: warning:
parameter has incomplete type: hndl
"/u01/app/oracle/product/9.2/rdbms/demo/ociap.h", line 6556: warning:
parameter has incomplete type: argv
"dbdimp.c", line 263: syntax error before or at: /
cc: acomp failed for dbdimp.c
*** Error code 2
make: Fatal error: Command failed for target `dbdimp.o'

In case dbdimp.c has any impact on the make process the line which has the
syntax error is pasted below
//Move (((char *)shared_dbh) + DBH_DUP_OFF, ((char *)imp_dbh) + DBH_DUP_OFF
, DBH_DUP_LEN, char *) ;

Needless to say any help is greately appreciated.

Zahid Naqvi
Unix Systems Engineer
"Perfection of means and confusion of goals seem-in my opinion-to
characterize our age."
- Albert Einstein

**********************************************************************
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

• Previous message: Tim Bunce: "Re: Apache, Oracle, Perl DBI Problems"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]