Bug #64326 for DBD-Oracle: Install impossible

Thu Dec 30 04:44:40 2010 maoboyindo [...] hotmail.fr - Ticket created

Subject:

Install impossible

PERL Version : 5.8.7 Oracle Version : 7.3.4 According to the table in the address : http://search.cpan.org/~pythian/DBD-Oracle- 1.27/Oracle.pm#Which_version_DBD::Oracle_is_for_me? I have to install DBD::Oracle Version 1.16. I can't find oldest version of this library. I've modified Makefile.PL to remove the test about the Oracle's version. I've taken some files such oci.h, oro.h, ... on a directory of an Oracle 9iAS and put them into the $ORACLE_HOME directory. Here are the results : enzo,root:/usr/local/lib/perl5/5.8.7/DBD-Oracle-1.17>perl Makefile.PL Using DBI 1.615 (for perl 5.008007 on sun4-solaris) installed in /usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris/auto/DBI/ Configuring DBD::Oracle for perl 5.008007 on solaris (sun4-solaris) Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /s01/app/oracle/product/7.3.4 symbol _sqlplus_release is UNDEFINED If sqlplus failed due to a linker/symbol/relocation/library error or similar problem then it's likely that you've not configured your environment correctly. Specifically, your LD_LIBRARY_PATH environment variable set to include the directory containing the Oracle libraries. 7.3.4.0.0 Oracle Common RDBMS Libraries and Utilities 7.3.4.0.0 ORACLE PL/SQL Libraries 7.3.4.0.0 ORACLE Common Precomp Libraries 2.3.4.0.0 PL/SQL V2 7.3.4.0.1 Oracle7 Server (RDBMS) 7.3.4.0.0 Precomp 2.2.4.0.0 Pro*C 1.5.6.15.0 PL/SQL Procedure Builder Oracle version 7.3.4 (7.3) Found /s01/app/oracle/product/7.3.4/rdbms/demo/oracle.mk Found /s01/app/oracle/product/7.3.4/precomp/demo/proc/proc.mk Using /s01/app/oracle/product/7.3.4/rdbms/demo/oracle.mk Your LD_LIBRARY_PATH env var is set to '' WARNING: Your LD_LIBRARY_PATH env var doesn't include '/s01/app/oracle/product/7.3.4/lib' but probably needs to. Reading /s01/app/oracle/product/7.3.4/rdbms/demo/oracle.mk Reading /s01/app/oracle/product/7.3.4/rdbms/lib/env_rdbms.mk Attempting to discover Oracle OCI build rules gcc -B/usr/ccs/bin/ -c DBD_ORA_OBJ.c by executing: [make - f /s01/app/oracle/product/7.3.4/rdbms/demo/oracle.mk build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC] Oracle oci build command: [true -L/s01/app/oracle/product/7.3.4/lib - L/s01/app/oracle/product/7.3.4/rdbms/lib -o DBD_ORA_EXE DBD_ORA_OBJ.o /s01/app/o] Found header files in /s01/app/oracle/product/7.3.4/rdbms/demo. Checking for functioning wait.ph System: perl5.008007 sunos 5.7 generic_patch sun4u sparc sunw,ultra-1 solaris Compiler: gcc -B/usr/ccs/bin/ -O -fno-strict-aliasing -pipe - I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 Linker: /usr/ccs/bin/ld Sysliblist: -lsocket -lnsl -lm -ldl -lposix4 Oracle makefiles would have used these definitions but we override them: CC: /opt/SUNWspro4.2/SUNWspro/bin/cc CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS) $(SHARED_CFLAG) $(ENV_FLAGS) [$(GFLAG) -xO2 $(CDEBUG) -Xa -xstrconst -xcg92 -xF -mr -K PIC -DSLXMX_ENABLE -DSLTS_ENABLE -D_REENTRANT $(QACCFLAGS) -I/] CLIBS: $(LOCALLIBS) $(EXOSLIBS) $(LIBBSD) $(OTHERLIBS) $(SECLIBS) $(M6LIBS) [ -lsocket -lnsl -lm -ldl -lposix4 - R /opt/SUNWcluster/lib:/usr/dt/lib:/s01/app/oracle/product/7.3.4/lib -Y P,$(LD_LIBRA] LDFLAGS: -L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib [-L$(LIBHOME) -L/s01/app/oracle/product/7.3.4/rdbms/lib] LDSTRING: -R /opt/SUNWcluster/lib:/usr/dt/lib:$(ORACLE_HOME)/lib \ -Y P,$(LD_LIBRARY_PATH):/opt/SUNWcluster/lib:/usr/ccs/lib:/usr/lib \ -Qy -lc [- R /opt/SUNWcluster/lib:/usr/dt/lib:/s01/app/oracle/product/7.3.4/lib -Y P,$(LD_LIBRARY_PATH):/opt/SUNWcluster/lib:/usr] Linking with OTHERLDFLAGS = -L/s01/app/oracle/product/7.3.4/lib - L/s01/app/oracle/product/7.3.4/rdbms/lib /s01/app/oracle/product] WARNING: If you have problems you may need to rebuild perl with threading enabled. Checking if your kit is complete... Looks good LD_RUN_PATH=/s01/app/oracle/product/7.3.4/lib:/s01/app/oracle/product/7. 3.4/rdbms/lib Using DBD::Oracle 1.17. Using DBD::Oracle 1.17. Using DBI 1.615 (for perl 5.008007 on sun4-solaris) installed in /usr/local/lib/perl5/site_perl/5.8.7/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.txt files. (Of course, you have read README by now anyway, haven't you?) enzo,root:/usr/local/lib/perl5/5.8.7/DBD-Oracle-1.17>make 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 /usr/local/bin/perl -p - e "s/~DRIVER~/Oracle/g" /usr/local/lib/perl5/site_perl/5.8.7/sun4- solaris/auto/DBI/Driver.xst > Oracle.xsi /usr/local/bin/perl /usr/local/lib/perl5/5.8.7/ExtUtils/xsubpp - typemap /usr/local/lib/perl5/5.8.7/ExtUtils/typemap -typemap typemc gcc -B/usr/ccs/bin/ -c -I/s01/app/oracle/product/7.3.4/rdbms/demo - I/s01/app/oracle/product/7.3.4/rdbms/demo -I/s01/app/oracle/proc In file included from /s01/app/oracle/product/7.3.4/rdbms/demo/oci.h:1010, from dbdimp.h:39, from Oracle.h:15, from Oracle.xs:1: /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:5976: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:5987: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:5995: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:5999: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6008: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6057: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6085: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6128: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6141: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6191: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6220: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6232: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6240: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6499: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6502: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6507: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6525: error: parse error before '*' token /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6540: error: parse error before '*' token /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6555: error: parse error before '*' token /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6580: error: parse error before "OraText" Oracle.xs: In function `XS_DBD__Oracle__db_ora_lob_write': Oracle.xs:152: error: `SQLCS_IMPLICIT' undeclared (first use in this function) Oracle.xs:152: error: (Each undeclared identifier is reported only once Oracle.xs:152: error: for each function it appears in.) Oracle.xs:175: error: `SQLCS_NCHAR' undeclared (first use in this function) Oracle.xs: In function `XS_DBD__Oracle__db_ora_lob_append': Oracle.xs:206: error: `SQLCS_IMPLICIT' undeclared (first use in this function) Oracle.xs:229: error: `SQLCS_NCHAR' undeclared (first use in this function) Oracle.xs: In function `XS_DBD__Oracle__db_ora_lob_read': Oracle.xs:283: error: `SQLCS_IMPLICIT' undeclared (first use in this function) Oracle.xs:310: error: `SQLCS_NCHAR' undeclared (first use in this function) Oracle.c: In function `boot_DBD__Oracle': Oracle.c:1606: error: `SQLCS_IMPLICIT' undeclared (first use in this function) Oracle.c:1618: error: `SQLCS_NCHAR' undeclared (first use in this function) *** Error code 1 make: Fatal error: Command failed for target `Oracle.o' Somebody can help me ??? Thank you.

Thu Dec 30 05:13:13 2010 bohica [...] ntlworld.com - Correspondence added

On Thu Dec 30 04:44:40 2010, maoboyindo wrote: Show quoted text

> PERL Version : 5.8.7 > Oracle Version : 7.3.4 > > According to the table in the address : > http://search.cpan.org/~pythian/DBD-Oracle- > 1.27/Oracle.pm#Which_version_DBD::Oracle_is_for_me? > > I have to install DBD::Oracle Version 1.16. > I can't find oldest version of this library.

It is on CPAN here -> http://search.cpan.org/~timb/DBD-Oracle-1.16/ If you need older module versions look on backpan. Show quoted text

> I've modified Makefile.PL to remove the test about the Oracle's version.

Doubt that will work. Show quoted text

> I've taken some files such oci.h, oro.h, ... on a directory of an > Oracle 9iAS and put them into the $ORACLE_HOME directory.

Not sure this will work. Show quoted text

> Here are the results : > > enzo,root:/usr/local/lib/perl5/5.8.7/DBD-Oracle-1.17>perl Makefile.PL > Using DBI 1.615 (for perl 5.008007 on sun4-solaris) installed > in /usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris/auto/DBI/ > > Configuring DBD::Oracle for perl 5.008007 on solaris (sun4-solaris) > > Remember to actually *READ* the README file! Especially if you have any > problems. > > Using Oracle in /s01/app/oracle/product/7.3.4 > symbol _sqlplus_release is UNDEFINED > > If sqlplus failed due to a linker/symbol/relocation/library > error or similar problem > then it's likely that you've not configured your > environment correctly. > Specifically, your LD_LIBRARY_PATH environment variable > set to include the directory containing the Oracle > libraries. > > 7.3.4.0.0 Oracle Common RDBMS Libraries and Utilities > 7.3.4.0.0 ORACLE PL/SQL Libraries > 7.3.4.0.0 ORACLE Common Precomp Libraries > 2.3.4.0.0 PL/SQL V2 > 7.3.4.0.1 Oracle7 Server (RDBMS) > 7.3.4.0.0 Precomp > 2.2.4.0.0 Pro*C > 1.5.6.15.0 PL/SQL Procedure Builder > Oracle version 7.3.4 (7.3) > Found /s01/app/oracle/product/7.3.4/rdbms/demo/oracle.mk > Found /s01/app/oracle/product/7.3.4/precomp/demo/proc/proc.mk > Using /s01/app/oracle/product/7.3.4/rdbms/demo/oracle.mk > Your LD_LIBRARY_PATH env var is set to ''

You need to fix this. Show quoted text

> WARNING: Your LD_LIBRARY_PATH env var doesn't > include '/s01/app/oracle/product/7.3.4/lib' but probably needs to. > Reading /s01/app/oracle/product/7.3.4/rdbms/demo/oracle.mk > Reading /s01/app/oracle/product/7.3.4/rdbms/lib/env_rdbms.mk > > Attempting to discover Oracle OCI build rules > gcc -B/usr/ccs/bin/ -c DBD_ORA_OBJ.c > by executing: [make - > f /s01/app/oracle/product/7.3.4/rdbms/demo/oracle.mk build ECHODO=echo > ECHO=echo GENCLNTSH='echo genclntsh' CC] > Oracle oci build command: > [true -L/s01/app/oracle/product/7.3.4/lib - > L/s01/app/oracle/product/7.3.4/rdbms/lib -o DBD_ORA_EXE > DBD_ORA_OBJ.o /s01/app/o] > > Found header files in /s01/app/oracle/product/7.3.4/rdbms/demo. > > Checking for functioning wait.ph > > > System: perl5.008007 sunos 5.7 generic_patch sun4u sparc sunw,ultra-1 > solaris > Compiler: gcc -B/usr/ccs/bin/ -O -fno-strict-aliasing -pipe - > I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 > Linker: /usr/ccs/bin/ld > Sysliblist: -lsocket -lnsl -lm -ldl -lposix4 > Oracle makefiles would have used these definitions but we override them: > CC: /opt/SUNWspro4.2/SUNWspro/bin/cc > CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) > $(PFLAGS) $(SHARED_CFLAG) $(ENV_FLAGS) > [$(GFLAG) -xO2 $(CDEBUG) -Xa -xstrconst -xcg92 -xF -mr -K > PIC -DSLXMX_ENABLE -DSLTS_ENABLE -D_REENTRANT $(QACCFLAGS) -I/] > CLIBS: $(LOCALLIBS) $(EXOSLIBS) $(LIBBSD) $(OTHERLIBS) $(SECLIBS) > $(M6LIBS) > [ -lsocket -lnsl -lm -ldl -lposix4 - > R /opt/SUNWcluster/lib:/usr/dt/lib:/s01/app/oracle/product/7.3.4/lib -Y > P,$(LD_LIBRA] > LDFLAGS: -L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib > [-L$(LIBHOME) -L/s01/app/oracle/product/7.3.4/rdbms/lib] > LDSTRING: -R /opt/SUNWcluster/lib:/usr/dt/lib:$(ORACLE_HOME)/lib \ > -Y > P,$(LD_LIBRARY_PATH):/opt/SUNWcluster/lib:/usr/ccs/lib:/usr/lib \ > -Qy -lc > [- > R /opt/SUNWcluster/lib:/usr/dt/lib:/s01/app/oracle/product/7.3.4/lib -Y > P,$(LD_LIBRARY_PATH):/opt/SUNWcluster/lib:/usr] > Linking with OTHERLDFLAGS = -L/s01/app/oracle/product/7.3.4/lib - > L/s01/app/oracle/product/7.3.4/rdbms/lib /s01/app/oracle/product] > > > WARNING: If you have problems you may need to rebuild perl with > threading enabled. > Checking if your kit is complete... > Looks good > LD_RUN_PATH=/s01/app/oracle/product/7.3.4/lib:/s01/app/oracle/product/7. > 3.4/rdbms/lib > Using DBD::Oracle 1.17. > Using DBD::Oracle 1.17. > Using DBI 1.615 (for perl 5.008007 on sun4-solaris) installed > in /usr/local/lib/perl5/site_perl/5.8.7/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.txt > files. > (Of course, you have read README by now anyway, haven't you?) > > enzo,root:/usr/local/lib/perl5/5.8.7/DBD-Oracle-1.17>make > 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 > /usr/local/bin/perl -p - > e "s/~DRIVER~/Oracle/g" /usr/local/lib/perl5/site_perl/5.8.7/sun4- > solaris/auto/DBI/Driver.xst > Oracle.xsi > /usr/local/bin/perl /usr/local/lib/perl5/5.8.7/ExtUtils/xsubpp - > typemap /usr/local/lib/perl5/5.8.7/ExtUtils/typemap -typemap typemc > gcc -B/usr/ccs/bin/ -c -I/s01/app/oracle/product/7.3.4/rdbms/demo - > I/s01/app/oracle/product/7.3.4/rdbms/demo -I/s01/app/oracle/proc > In file included > from /s01/app/oracle/product/7.3.4/rdbms/demo/oci.h:1010, > from dbdimp.h:39, > from Oracle.h:15, > from Oracle.xs:1: > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:5976: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:5987: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:5995: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:5999: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6008: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6057: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6085: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6128: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6141: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6191: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6220: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6232: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6240: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6499: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6502: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6507: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6525: error: parse > error before '*' token > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6540: error: parse > error before '*' token > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6555: error: parse > error before '*' token > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6580: error: parse > error before "OraText" > Oracle.xs: In function `XS_DBD__Oracle__db_ora_lob_write': > Oracle.xs:152: error: `SQLCS_IMPLICIT' undeclared (first use in this > function)

probably because you've used to new a DBD::Oracle. Show quoted text

> Oracle.xs:152: error: (Each undeclared identifier is reported only once > Oracle.xs:152: error: for each function it appears in.) > Oracle.xs:175: error: `SQLCS_NCHAR' undeclared (first use in this > function) > Oracle.xs: In function `XS_DBD__Oracle__db_ora_lob_append': > Oracle.xs:206: error: `SQLCS_IMPLICIT' undeclared (first use in this > function) > Oracle.xs:229: error: `SQLCS_NCHAR' undeclared (first use in this > function) > Oracle.xs: In function `XS_DBD__Oracle__db_ora_lob_read': > Oracle.xs:283: error: `SQLCS_IMPLICIT' undeclared (first use in this > function) > Oracle.xs:310: error: `SQLCS_NCHAR' undeclared (first use in this > function) > Oracle.c: In function `boot_DBD__Oracle': > Oracle.c:1606: error: `SQLCS_IMPLICIT' undeclared (first use in this > function) > Oracle.c:1618: error: `SQLCS_NCHAR' undeclared (first use in this > function) > *** Error code 1 > make: Fatal error: Command failed for target `Oracle.o' > > Somebody can help me ??? > > Thank you. >

Get 1.16. Set LD_LIBRARY_PATH make sure you have a consistent set of Oracle 7 files - not a mix from different places get sqlplus working first before attempting to build DBD::Oracle Martin -- Martin J. Evans Wetherby, UK

Thu Dec 30 05:13:14 2010 The RT System itself - Status changed from 'new' to 'open'

Thu Dec 30 05:35:26 2010 maoboyindo [...] hotmail.fr - Correspondence added

From:

maoboyindo [...] hotmail.fr

Show quoted text

> Get 1.16. > Set LD_LIBRARY_PATH > make sure you have a consistent set of Oracle 7 files - not a mix from > different places > get sqlplus working first before attempting to build DBD::Oracle > > Martin

I've defined the $LD_LIBRARY_PATH variable. Here is the result : enzo,root:/usr/local/lib/perl5/5.8.7/DBD-Oracle-1.16>perl Makefile.PL Using DBI 1.615 (for perl 5.008007 on sun4-solaris) installed in /usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris/auto/DBI/ Configuring DBD::Oracle ... Show quoted text

>>> Remember to actually *READ* the README file!

Especially if you have any problems. Using Oracle in /s01/app/oracle/product/7.3.4 symbol _sqlplus_release is UNDEFINED 7.3.4.0.0 Oracle Common RDBMS Libraries and Utilities 7.3.4.0.0 ORACLE PL/SQL Libraries 7.3.4.0.0 ORACLE Common Precomp Libraries 2.3.4.0.0 PL/SQL V2 7.3.4.0.1 Oracle7 Server (RDBMS) 7.3.4.0.0 Precomp 2.2.4.0.0 Pro*C 1.5.6.15.0 PL/SQL Procedure Builder Oracle version 7.3.4 (7.3) Found /s01/app/oracle/product/7.3.4/rdbms/demo/oracle.mk Found /s01/app/oracle/product/7.3.4/otrace/demo/atmoci.mk Found /s01/app/oracle/product/7.3.4/precomp/demo/proc/proc.mk Using /s01/app/oracle/product/7.3.4/rdbms/demo/oracle.mk Reading /s01/app/oracle/product/7.3.4/rdbms/demo/oracle.mk Reading /s01/app/oracle/product/7.3.4/rdbms/lib/env_rdbms.mk Attempting to discover Oracle OCI build rules gcc -B/usr/ccs/bin/ -c -I/s01/app/oracle/product/7.3.4/rdbms/demo - I/s01/app/oracle/product/7.3.4/rdbms/public -I. -I/s01/app/oracc by executing: [make - f /s01/app/oracle/product/7.3.4/rdbms/demo/oracle.mk build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC] Oracle oci build command: [true -L/s01/app/oracle/product/7.3.4/lib - L/s01/app/oracle/product/7.3.4/rdbms/lib -o DBD_ORA_EXE DBD_ORA_OBJ.o /s01/app/o] Found header files in rdbms/demo. Checking for functioning wait.ph System: perl5.008007 sunos 5.7 generic_patch sun4u sparc sunw,ultra-1 solaris Compiler: gcc -B/usr/ccs/bin/ -O -fno-strict-aliasing -pipe - I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 Linker: /usr/ccs/bin/ld Sysliblist: -lsocket -lnsl -lm -ldl -lposix4 Oracle makefiles would have used these definitions but we override them: CC: /opt/SUNWspro4.2/SUNWspro/bin/cc CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS) $(SHARED_CFLAG) $(ENV_FLAGS) [$(GFLAG) -xO2 $(CDEBUG) -Xa -xstrconst -xcg92 -xF -mr -K PIC -DSLXMX_ENABLE -DSLTS_ENABLE -D_REENTRANT $(QACCFLAGS) -I/] CLIBS: $(LOCALLIBS) $(EXOSLIBS) $(LIBBSD) $(OTHERLIBS) $(SECLIBS) $(M6LIBS) [ -lsocket -lnsl -lm -ldl -lposix4 - R /opt/SUNWcluster/lib:/usr/dt/lib:/s01/app/oracle/product/7.3.4/lib -Y P,/s01/app/o] LDFLAGS: -L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib [-L$(LIBHOME) -L/s01/app/oracle/product/7.3.4/rdbms/lib] LDSTRING: -R /opt/SUNWcluster/lib:/usr/dt/lib:$(ORACLE_HOME)/lib \ -Y P,$(LD_LIBRARY_PATH):/opt/SUNWcluster/lib:/usr/ccs/lib:/usr/lib \ -Qy -lc [- R /opt/SUNWcluster/lib:/usr/dt/lib:/s01/app/oracle/product/7.3.4/lib -Y P,/s01/app/oracle/product/7.3.4/lib:/opt/SUNWc] Linking with OTHERLDFLAGS = -L/s01/app/oracle/product/7.3.4/lib - L/s01/app/oracle/product/7.3.4/rdbms/lib /s01/app/oracle/product] Warning: If you have problems you may need to rebuild perl with threading enabled. Use of uninitialized value in substitution (s///) at Makefile.PL line 1443. LD_RUN_PATH=/s01/app/oracle/product/7.3.4/lib:/s01/app/oracle/product/7. 3.4/rdbms/lib Using DBD::Oracle 1.16. Using DBD::Oracle 1.16. Using DBI 1.615 (for perl 5.008007 on sun4-solaris) installed in /usr/local/lib/perl5/site_perl/5.8.7/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?) enzo,root:/usr/local/lib/perl5/5.8.7/DBD-Oracle-1.16>make Skip blib/lib/DBD/Oracle.pm (unchanged) Skip blib/lib/oraperl.ph (unchanged) Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged) Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged) Skip blib/lib/Oraperl.pm (unchanged) Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged) Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged) cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm gcc -B/usr/ccs/bin/ -c -I/s01/app/oracle/product/7.3.4/rdbms/demo - I/s01/app/oracle/product/7.3.4/rdbms/public -I. -I/s01/app/oracc In file included from /s01/app/oracle/product/7.3.4/rdbms/demo/oci.h:1010, from dbdimp.h:44, from Oracle.h:20, from Oracle.xs:1: /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:5976: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:5987: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:5995: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:5999: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6008: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6057: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6085: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6128: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6141: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6191: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6220: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6232: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6240: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6499: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6502: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6507: error: parse error before "OraText" /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6525: error: parse error before '*' token /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6540: error: parse error before '*' token /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6555: error: parse error before '*' token /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6580: error: parse error before "OraText" Oracle.xs: In function `XS_DBD__Oracle__db_ora_lob_write': Oracle.xs:142: error: `SQLCS_IMPLICIT' undeclared (first use in this function) Oracle.xs:142: error: (Each undeclared identifier is reported only once Oracle.xs:142: error: for each function it appears in.) Oracle.xs:165: error: `SQLCS_NCHAR' undeclared (first use in this function) Oracle.xs: In function `XS_DBD__Oracle__db_ora_lob_append': Oracle.xs:196: error: `SQLCS_IMPLICIT' undeclared (first use in this function) Oracle.xs:219: error: `SQLCS_NCHAR' undeclared (first use in this function) Oracle.xs: In function `XS_DBD__Oracle__db_ora_lob_read': Oracle.xs:275: error: `SQLCS_IMPLICIT' undeclared (first use in this function) Oracle.xs:302: error: `SQLCS_NCHAR' undeclared (first use in this function) Oracle.c: In function `boot_DBD__Oracle': Oracle.c:1588: error: `SQLCS_IMPLICIT' undeclared (first use in this function) Oracle.c:1600: error: `SQLCS_NCHAR' undeclared (first use in this function) *** Error code 1 make: Fatal error: Command failed for target `Oracle.o' I don't understand what you mean with "make sure you have a consistent set of Oracle 7 files - not a mix from different places get sqlplus working first before attempting to build DBD::Oracle" Can you tell me a little more ... Thank you.

Thu Dec 30 07:33:49 2010 bohica [...] ntlworld.com - Correspondence added

On Thu Dec 30 05:35:26 2010, maoboyindo wrote: Show quoted text

> > Get 1.16. > > Set LD_LIBRARY_PATH > > make sure you have a consistent set of Oracle 7 files - not a mix from > > different places > > get sqlplus working first before attempting to build DBD::Oracle > > > > Martin

> > I've defined the $LD_LIBRARY_PATH variable. > > Here is the result : > enzo,root:/usr/local/lib/perl5/5.8.7/DBD-Oracle-1.16>perl Makefile.PL > Using DBI 1.615 (for perl 5.008007 on sun4-solaris) installed > in /usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris/auto/DBI/ > > Configuring DBD::Oracle ... >

> >>> Remember to actually *READ* the README file!

> Especially if you have any problems. > > Using Oracle in /s01/app/oracle/product/7.3.4 > symbol _sqlplus_release is UNDEFINED > 7.3.4.0.0 Oracle Common RDBMS Libraries and Utilities > 7.3.4.0.0 ORACLE PL/SQL Libraries > 7.3.4.0.0 ORACLE Common Precomp Libraries > 2.3.4.0.0 PL/SQL V2 > 7.3.4.0.1 Oracle7 Server (RDBMS) > 7.3.4.0.0 Precomp > 2.2.4.0.0 Pro*C > 1.5.6.15.0 PL/SQL Procedure Builder > Oracle version 7.3.4 (7.3) > Found /s01/app/oracle/product/7.3.4/rdbms/demo/oracle.mk > Found /s01/app/oracle/product/7.3.4/otrace/demo/atmoci.mk > Found /s01/app/oracle/product/7.3.4/precomp/demo/proc/proc.mk > Using /s01/app/oracle/product/7.3.4/rdbms/demo/oracle.mk > Reading /s01/app/oracle/product/7.3.4/rdbms/demo/oracle.mk > Reading /s01/app/oracle/product/7.3.4/rdbms/lib/env_rdbms.mk > > Attempting to discover Oracle OCI build rules > gcc -B/usr/ccs/bin/ -c -I/s01/app/oracle/product/7.3.4/rdbms/demo - > I/s01/app/oracle/product/7.3.4/rdbms/public -I. -I/s01/app/oracc > by executing: [make - > f /s01/app/oracle/product/7.3.4/rdbms/demo/oracle.mk build ECHODO=echo > ECHO=echo GENCLNTSH='echo genclntsh' CC] > Oracle oci build command: > [true -L/s01/app/oracle/product/7.3.4/lib - > L/s01/app/oracle/product/7.3.4/rdbms/lib -o DBD_ORA_EXE > DBD_ORA_OBJ.o /s01/app/o] > > Found header files in rdbms/demo. > > Checking for functioning wait.ph > > > System: perl5.008007 sunos 5.7 generic_patch sun4u sparc sunw,ultra-1 > solaris > Compiler: gcc -B/usr/ccs/bin/ -O -fno-strict-aliasing -pipe - > I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 > Linker: /usr/ccs/bin/ld > Sysliblist: -lsocket -lnsl -lm -ldl -lposix4 > Oracle makefiles would have used these definitions but we override them: > CC: /opt/SUNWspro4.2/SUNWspro/bin/cc > > CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) > $(PFLAGS) $(SHARED_CFLAG) $(ENV_FLAGS) > [$(GFLAG) -xO2 $(CDEBUG) -Xa -xstrconst -xcg92 -xF -mr -K > PIC -DSLXMX_ENABLE -DSLTS_ENABLE -D_REENTRANT $(QACCFLAGS) -I/] > > CLIBS: $(LOCALLIBS) $(EXOSLIBS) $(LIBBSD) $(OTHERLIBS) $(SECLIBS) > $(M6LIBS) > [ -lsocket -lnsl -lm -ldl -lposix4 - > R /opt/SUNWcluster/lib:/usr/dt/lib:/s01/app/oracle/product/7.3.4/lib -Y > P,/s01/app/o] > > LDFLAGS: -L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib > [-L$(LIBHOME) -L/s01/app/oracle/product/7.3.4/rdbms/lib] > > LDSTRING: -R /opt/SUNWcluster/lib:/usr/dt/lib:$(ORACLE_HOME)/lib \ > -Y > P,$(LD_LIBRARY_PATH):/opt/SUNWcluster/lib:/usr/ccs/lib:/usr/lib \ > -Qy -lc > [- > R /opt/SUNWcluster/lib:/usr/dt/lib:/s01/app/oracle/product/7.3.4/lib -Y > P,/s01/app/oracle/product/7.3.4/lib:/opt/SUNWc] > > > Linking with OTHERLDFLAGS = -L/s01/app/oracle/product/7.3.4/lib - > L/s01/app/oracle/product/7.3.4/rdbms/lib /s01/app/oracle/product] > > > Warning: If you have problems you may need to rebuild perl with > threading enabled. > > Use of uninitialized value in substitution (s///) at Makefile.PL line > 1443. > LD_RUN_PATH=/s01/app/oracle/product/7.3.4/lib:/s01/app/oracle/product/7. > 3.4/rdbms/lib > Using DBD::Oracle 1.16. > Using DBD::Oracle 1.16. > Using DBI 1.615 (for perl 5.008007 on sun4-solaris) installed > in /usr/local/lib/perl5/site_perl/5.8.7/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?) > > enzo,root:/usr/local/lib/perl5/5.8.7/DBD-Oracle-1.16>make > Skip blib/lib/DBD/Oracle.pm (unchanged) > Skip blib/lib/oraperl.ph (unchanged) > Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged) > Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged) > Skip blib/lib/Oraperl.pm (unchanged) > Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged) > Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged) > cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm > gcc -B/usr/ccs/bin/ -c -I/s01/app/oracle/product/7.3.4/rdbms/demo - > I/s01/app/oracle/product/7.3.4/rdbms/public -I. -I/s01/app/oracc > In file included > from /s01/app/oracle/product/7.3.4/rdbms/demo/oci.h:1010, > from dbdimp.h:44, > from Oracle.h:20, > from Oracle.xs:1: > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:5976: error: parse > error before "OraText"

The file ociap.h cannot be compiled. Show quoted text

> /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:5987: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:5995: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:5999: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6008: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6057: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6085: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6128: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6141: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6191: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6220: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6232: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6240: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6499: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6502: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6507: error: parse > error before "OraText" > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6525: error: parse > error before '*' token > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6540: error: parse > error before '*' token > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6555: error: parse > error before '*' token > /s01/app/oracle/product/7.3.4/rdbms/demo/ociap.h:6580: error: parse > error before "OraText" > Oracle.xs: In function `XS_DBD__Oracle__db_ora_lob_write': > Oracle.xs:142: error: `SQLCS_IMPLICIT' undeclared (first use in this > function)

The macro SQLCS_IMPLICIT is not defined - it should be in the header files oracle supplies but some did not compile. Show quoted text

> Oracle.xs:142: error: (Each undeclared identifier is reported only once > Oracle.xs:142: error: for each function it appears in.) > Oracle.xs:165: error: `SQLCS_NCHAR' undeclared (first use in this > function) > Oracle.xs: In function `XS_DBD__Oracle__db_ora_lob_append': > Oracle.xs:196: error: `SQLCS_IMPLICIT' undeclared (first use in this > function) > Oracle.xs:219: error: `SQLCS_NCHAR' undeclared (first use in this > function) > Oracle.xs: In function `XS_DBD__Oracle__db_ora_lob_read': > Oracle.xs:275: error: `SQLCS_IMPLICIT' undeclared (first use in this > function) > Oracle.xs:302: error: `SQLCS_NCHAR' undeclared (first use in this > function) > Oracle.c: In function `boot_DBD__Oracle': > Oracle.c:1588: error: `SQLCS_IMPLICIT' undeclared (first use in this > function) > Oracle.c:1600: error: `SQLCS_NCHAR' undeclared (first use in this > function) > *** Error code 1 > make: Fatal error: Command failed for target `Oracle.o' > > I don't understand what you mean with "make sure you have a consistent > set of Oracle 7 files - not a mix from different places > get sqlplus working first before attempting to build DBD::Oracle"

You said: "I've taken some files such oci.h, oro.h, ... on a directory of an Oracle 9iAS and put them into the $ORACLE_HOME directory." so I assumed you are building against Oracle 7 but with header files from Oracle 9 - that is inconsistent. Get sqlplus connecting to your database first to ensure it is all set up properly and you have the environment correct. If you cannot make sqlplus work you have little chance of making DBD::Oracle work. Show quoted text

> Can you tell me a little more ... > > Thank you.

above. Martin -- Martin J. Evans Wetherby, UK

Thu Dec 30 07:53:14 2010 champoux [...] pythian.com - Correspondence added

This is not a bug with DBD::Oracle you should send this to the dbi-users@perl.org forum.. You are also going about this it the completely wrong manner. To connect to Oracle 7 you will need either 1) an Oracle 7 client including ProC 2) an Oracle 8i client 3) an Oracle 9 client. OraPerl might work as well but I have never used it. You cannot just move bits and pieces of a client about and expect it to work. You still might be able to get a 9 client online by downloading the full 9 DB which still can be found on the Oracle site. If you happen to have the original Oracle 7 disks about they came with a working version of DBD and DBI so you might want to look on them Connecting to a 20+ years old DB is always going to cause you trouble s as it has not been supported since the last century (always wanted to say that)

Thu Mar 24 06:42:24 2011 bohica [...] ntlworld.com - Status changed from 'open' to 'rejected'

Bug #64326 for DBD-Oracle: Install impossible

Preferred bug tracker