(RADIATOR) DBD-Oracle problems on SUN

[Ayotunde Itayemi]

Hi All,

I am having problems installing the DBD-Oracle-1.12 module (tried v 1.14 also) on a Solaris SUN box with specs:

NetraX1 (Solaris 8)
perl 5.6.1
DBI-1.21
GNU gcc 3.3
GNU libgcc 3.3
Oracle9iR1 install.

Below is a sample install run and the errors I got.

Thanks.
Tunde I.



bash-2.03# cd DBD-Oracle-1.12
bash-2.03# perl Makefile.PL
Using DBI 1.21 installed in /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI

 Configuring DBD::Oracle ...

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

Using Oracle in /export/spare/oracle9sw
Found header files in rdbms/demo.
Found /export/spare/oracle9sw/precomp/demo/proc/demo_proc.mk
Using /export/spare/oracle9sw/precomp/demo/proc/demo_proc.mk
Reading /export/spare/oracle9sw/precomp/demo/proc/demo_proc.mk.
Reading /export/spare/oracle9sw/precomp/lib/env_precomp.mk.
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.
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.

Attempting to discover Oracle OCI build rules...
gcc    -c -o DBD_ORA_OBJ.o DBD_ORA_OBJ.c
Oracle oci build command:
        echo -xarch=v9  -o DBD_ORA_EXE DBD_ORA_OBJ.o -L/export/spare/oracle9sw/lib/ -lclntsh `cat /export/spare/oracle9sw/lib/ldflags`   `cat /export/spare/oracle9sw/lib/sysliblist` -R/export/spare/oracle9sw/lib -laio  -lposix4  -lm  -lthread
        -xarch=v9 -o DBD_ORA_EXE DBD_ORA_OBJ.o -L/export/spare/oracle9sw/lib/ -lclntsh -lnbeq9 -lnhost9 -lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9 -lntns9 -lnsl -lsocket -lgen -ldl -R/export/spare/oracle9sw/lib -laio -lposix4 -lm -lthread
Unable to interpret Oracle oci build commands. Using fallback approach.


System: perl5.006001 sunos solaris 5.8 generic sun4u sparc sunw,ultra-5_10
Compiler:   gcc -O -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
Linker:     /usr/local/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 -DPRECOMP -I. -I/export/spare/oracle9sw/precomp/public -I/export/spare/oracle9sw/rdbms/public -I/export/spare/oracle9sw/rdbms/demo -I/export/spare/oracle9sw/plsql/public -I/export/spare/oracle9sw/network/public -DSLMXMX_ENABLE -DSLTS_ENABLE -D_SVID_GETTOD -D_REENTRANT $(LPFLAGS) $(USRFLAGS)]

  build:     $(DEMO_PROC_BUILD_SHARED_64)
Evaluating `cat $(LIBHOME)ldflags`
  expanded `cat /export/spare/oracle9sw/lib/ldflags`
  returned '-lnbeq9 -lnhost9 -lnus9 -lnldap9 -lldapclnt9  -lnsslb9   -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9 -lntns9
'
Evaluating `cat $(LIBHOME)sysliblist`
  expanded `cat /export/spare/oracle9sw/lib/sysliblist`
  returned '-lnsl -lsocket -lgen -ldl'
           [ cc -xarch=v9 $(LFLAGS) -o $(EXE) $(OBJS) -L$(LIBHOME) -lclntsh -lnbeq9 -lnhost9 -lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9 -lntns9 $(EXPDLIBS) $(EXOSLIBS) -lnsl -lsocket -lgen -ldl -R/export/spare/oracle9sw/lib -laio $(THREADLIBS) -lposix4 $(LLIBKSTAT) -lm $(USRLIBS) -lthread]

  LDFLAGS:  -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
           [-o $@ -L/export/spare/oracle9sw/precomp/lib/ -L$(LIBHOME)]


Linking with  -L/export/spare/oracle9sw/lib -lclntsh [from $(LIBCLNTSH)]


Warning: If you have problems you may need to rebuild perl with -Uusemymalloc.

Checking if your kit is complete...
Looks good
LD_RUN_PATH=/export/spare/oracle9sw/lib
Using DBD::Oracle 1.12.
Using DBI 1.21 installed in /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/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?)

bash-2.03# make
Skip blib/lib/oraperl.ph (unchanged)
Skip blib/lib/DBD/Oracle.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/mk.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged)
Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged)
Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged)
Skip blib/lib/Oraperl.pm (unchanged)
gcc -c -I. -I/export/spare/oracle9sw/precomp/public -I/export/spare/oracle9sw/rdbms/public -I/export/spare/oracle9sw/rdbms/demo -I/export/spare/oracle9sw/plsql/public -I/export/spare/oracle9sw/network/public -I/export/spare/oracle9sw/rdbms/demo -I/export/spare/oracle9sw/rdbms/demo -I/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O   -DVERSION=\"1.12\" -DXS_VERSION=\"1.12\" -fPIC -I/usr/local/lib/perl5/5.6.1/sun4-solaris/CORE  Oracle.c
In file included from Oracle.h:20,
                 from Oracle.xs:1:
dbdimp.h:44:20: ocidfn.h: No such file or directory
dbdimp.h:57:21: ociapr.h: No such file or directory
In file included from Oracle.h:20,
                 from Oracle.xs:1:
dbdimp.h:97: parse error before "Lda_Def"
dbdimp.h:97: warning: no semicolon at end of struct or union
dbdimp.h:98: warning: data definition has no type or storage class
dbdimp.h:105: parse error before '}' token
dbdimp.h:126: parse error before "Cda_Def"
dbdimp.h:126: warning: no semicolon at end of struct or union
dbdimp.h:127: warning: data definition has no type or storage class
dbdimp.h:153: parse error before '}' token
dbdimp.h:279: parse error before "Lda_Def"
Oracle.xsi: In function `XS_DBD__Oracle__db_commit':
Oracle.xsi:73: dereferencing pointer to incomplete type
Oracle.xsi: In function `XS_DBD__Oracle__db_rollback':
Oracle.xsi:82: dereferencing pointer to incomplete type
Oracle.xsi: In function `XS_DBD__Oracle__db_disconnect':
Oracle.xsi:91: dereferencing pointer to incomplete type
Oracle.xsi:95: dereferencing pointer to incomplete type
Oracle.xsi:96: dereferencing pointer to incomplete type
Oracle.xsi:97: dereferencing pointer to incomplete type
Oracle.xsi:101: dereferencing pointer to incomplete type
Oracle.xsi:101: dereferencing pointer to incomplete type
Oracle.xsi:103: dereferencing pointer to incomplete type
Oracle.xsi:105: dereferencing pointer to incomplete type
Oracle.xsi:109: dereferencing pointer to incomplete type
Oracle.xsi:109: dereferencing pointer to incomplete type
Oracle.xsi:109: dereferencing pointer to incomplete type
Oracle.xsi: In function `XS_DBD__Oracle__db_DESTROY':
Oracle.xsi:144: dereferencing pointer to incomplete type
Oracle.xsi:146: dereferencing pointer to incomplete type
Oracle.xsi:153: dereferencing pointer to incomplete type
Oracle.xsi:154: dereferencing pointer to incomplete type
Oracle.xsi:155: dereferencing pointer to incomplete type
Oracle.xsi:157: dereferencing pointer to incomplete type
Oracle.xsi:158: dereferencing pointer to incomplete type
Oracle.xsi:158: dereferencing pointer to incomplete type
Oracle.xsi:158: dereferencing pointer to incomplete type
Oracle.xsi:160: dereferencing pointer to incomplete type
Oracle.xsi:168: dereferencing pointer to incomplete type
Oracle.xsi:169: dereferencing pointer to incomplete type
Oracle.xsi:174: dereferencing pointer to incomplete type
Oracle.xsi:174: dereferencing pointer to incomplete type
Oracle.xsi:174: dereferencing pointer to incomplete type
Oracle.xsi: In function `XS_DBD__Oracle__st_execute':
Oracle.xsi:288: dereferencing pointer to incomplete type
Oracle.xsi:289: dereferencing pointer to incomplete type
Oracle.xsi:293: dereferencing pointer to incomplete type
Oracle.xsi:294: dereferencing pointer to incomplete type
Oracle.xsi:295: dereferencing pointer to incomplete type
Oracle.xsi:309: dereferencing pointer to incomplete type
Oracle.xsi:310: dereferencing pointer to incomplete type
Oracle.xsi: In function `XS_DBD__Oracle__st_finish':
Oracle.xsi:385: dereferencing pointer to incomplete type
Oracle.xsi:386: dereferencing pointer to incomplete type
Oracle.xsi:390: dereferencing pointer to incomplete type
Oracle.xsi:393: dereferencing pointer to incomplete type
Oracle.xsi:393: dereferencing pointer to incomplete type
Oracle.xsi:393: dereferencing pointer to incomplete type
Oracle.xsi: In function `XS_DBD__Oracle__st_DESTROY':
Oracle.xsi:460: dereferencing pointer to incomplete type
Oracle.xsi:462: dereferencing pointer to incomplete type
Oracle.xsi:468: dereferencing pointer to incomplete type
Oracle.xsi:469: dereferencing pointer to incomplete type
Oracle.xsi:469: dereferencing pointer to incomplete type
Oracle.xsi:469: dereferencing pointer to incomplete type
Oracle.xsi:471: dereferencing pointer to incomplete type
Oracle.xsi:472: dereferencing pointer to incomplete type
Oracle.xsi:473: dereferencing pointer to incomplete type
Oracle.xsi:481: dereferencing pointer to incomplete type
Oracle.xsi:481: dereferencing pointer to incomplete type
Oracle.xsi:481: dereferencing pointer to incomplete type
Oracle.xs: In function `XS_DBD__Oracle__st_ora_fetch':
Oracle.xs:57: dereferencing pointer to incomplete type
Oracle.xs:57: dereferencing pointer to incomplete type
Oracle.xs:57: dereferencing pointer to incomplete type
Oracle.xs:60: dereferencing pointer to incomplete type
Oracle.xs:60: dereferencing pointer to incomplete type
Oracle.xs:60: dereferencing pointer to incomplete type
Oracle.xs:60: dereferencing pointer to incomplete type
Oracle.xs:60: dereferencing pointer to incomplete type
Oracle.xs:60: dereferencing pointer to incomplete type
Oracle.xs:60: dereferencing pointer to incomplete type
Oracle.xs:60: dereferencing pointer to incomplete type
Oracle.xs:64: dereferencing pointer to incomplete type
Oracle.xs:66: dereferencing pointer to incomplete type
Oracle.xs:85: dereferencing pointer to incomplete type
Oracle.xs:85: dereferencing pointer to incomplete type
Oracle.xs:85: dereferencing pointer to incomplete type
Oracle.xs:85: dereferencing pointer to incomplete type
Oracle.xs:85: dereferencing pointer to incomplete type
Oracle.xs:85: dereferencing pointer to incomplete type
Oracle.xs:85: dereferencing pointer to incomplete type
Oracle.xs:85: dereferencing pointer to incomplete type
Oracle.xs:87: dereferencing pointer to incomplete type
Oracle.xs:87: dereferencing pointer to incomplete type
Oracle.xsi: In function `boot_DBD__Oracle':
Oracle.xsi:18: sizeof applied to an incomplete type
Oracle.xsi:19: sizeof applied to an incomplete type
make: *** [Oracle.o] Error 1
bash-2.03#
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20030811/1266fbad/attachment.html>