topic Re: Oracle DBD Module install error in Operating System - HP-UX

Oracle DBD Module install error

MikeL_4 — Tue, 09 Dec 2008 20:14:00 GMT

I am trying to install Oracle DBD module, already have DBI installed.

Receiving the following error:

=>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/bin/perl -p -e "s/~DRIVER~/Oracle/g" /opt/perl32/lib/site_perl/5.10.0/PA-RISC2.0/auto/DBI/Driver.xst > Oracle.xsi
/usr/bin/perl /opt/perl32/lib/5.10.0/ExtUtils/xsubpp -typemap /opt/perl32/lib/5.10.0/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
gcc -c -I/u01/oracle/product/9.2.0/rdbms/public -I/u01/oracle/product/9.2.0/rdbms/demo -I/u01/oracle/product/9.2.0/rdbms/demo -I/u01/oracle/product/9.2.0/rdbms/public -I/u01/oracle/product/9.2.0/plsql/public -I/u01/oracle/product/9.2.0/network/public -I/opt/perl32/lib/site_perl/5.10.0/PA-RISC2.0/auto/DBI -mpa-risc-2-0 -D_HPUX_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/pa20_32/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -g -O -DVERSION=\"1.22\" -DXS_VERSION=\"1.22\" -fPIC "-I/opt/perl32/lib/5.10.0/PA-RISC2.0/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2.0.8\" Oracle.c
In file included from Oracle.xs:1:
Oracle.h:114: error: conflicting types for 'OCIXMLTypeCreateFromSrc'
Oracle.h:114: note: an argument type that has a default promotion can't match an empty parameter name list declaration
/u01/oracle/product/9.2.0/rdbms/demo/ociap.h:10054: error: previous declaration of 'OCIXMLTypeCreateFromSrc' was here
*** Error exit code 1

Stop.

Can anyone give me an idea as to what's wrong ??

Re: Oracle DBD Module install error

Dennis Handly — Tue, 09 Dec 2008 23:08:02 GMT

Compile with -E and redirect stdout. Then look to see if you have a duplicate OCIXMLTypeCreateFromSrc.
One at Oracle.h:114 and the other at /u01/oracle/product/9.2.0/rdbms/demo/ociap.h:10054

Re: Oracle DBD Module install error

MikeL_4 — Tue, 09 Dec 2008 23:52:53 GMT

Thanks, but being new to this , how do I set the -E on the compile ??

Re: Oracle DBD Module install error

Dennis Handly — Wed, 10 Dec 2008 00:10:20 GMT

>how do I set the -E on the compile?

You'll need to know how to fiddle with your makefile.

Or toss your makefile and cut & paste above gcc line and add -E.

Re: Oracle DBD Module install error

MikeL_4 — Wed, 10 Dec 2008 03:00:15 GMT

The Makefile alreaqdy contains the -E option suggested: gcc64 -E -c $(PASTHRU_INC) $(INC) \

On the server, I can find only 4 files of this name on the server:
=>find / -name Oracle.h -print
/usr/orasys/owb10.1/perl/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBD/Oracle/Oracle.h
/osg1/patches/DBD-Oracle-1.22/Oracle.h
/osg1/patches/DBD-Oracle-1.22/blib/arch/auto/DBD/Oracle/Oracle.h
/u01/oracle/product/owb10.1.0.4/perl/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBD/Oracle/Oracle.h
=>

Out of these there is no statements in the files under, /usr/orasys/owb10.1/perl/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBD/Oracle/Oracle.h and /u01/oracle/product/owb10.1.0.4/perl/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBD/Oracle/Oracle.h that reference OCIXMLTypeCreateFromSrc.

I am installing under directory: /osg1/patches/DBD-Oracle-1.22 and these 2 files contain the following reference:
sword OCIXMLTypeCreateFromSrc(/*_ OCISvcCtx *svchp, OCIError *errhp,
OCIDuration dur, ub1 src_type, dvoid *src_ptr,
sb4 ind, OCIXMLType **retInstance _*/);

In the file: /u01/oracle/product/9.2.0/rdbms/demo/ociap.h it contains the following reference:
sword OCIXMLTypeCreateFromSrc(OCISvcCtx *svchp, OCIError *errhp,
OCIDuration dur, ub1 src_type, dvoid *src_ptr,
sb4 ind, OCIXMLType **retInstance);

Not sure now what needs to be done to resolve issue....

Re: Oracle DBD Module install error

James R. Ferguson — Wed, 10 Dec 2008 03:36:07 GMT

Hi Mike:

Your makefile shows you are running a 32-bit Perl. If you Oracle isn't a 32-bit then this may be your problem. You must maintain the same "bitness" for both Perl and Oracle.

Regards!

...JRF...

Re: Oracle DBD Module install error

Dennis Handly — Wed, 10 Dec 2008 03:56:00 GMT

>The Makefile already contains the -E option suggested

This isn't executed is it? Anyway, I need that output.

>/osg1/patches/DBD-Oracle-1.22:
sword OCIXMLTypeCreateFromSrc(/*_ OCISvcCtx *svchp, OCIError *errhp,
OCIDuration dur, ub1 src_type, dvoid *src_ptr,
sb4 ind, OCIXMLType **retInstance _*/);

This is a garbage K&R declaration. Remove those "/*_" and "_*/"

>/u01/oracle/product/9.2.0/rdbms/demo/ociap.h it contains the following reference:
sword OCIXMLTypeCreateFromSrc(OCISvcCtx *svchp, OCIError *errhp,
OCIDuration dur, ub1 src_type, dvoid *src_ptr,
sb4 ind, OCIXMLType **retInstance);

This looks good, an ANSI C prototype.

Re: Oracle DBD Module install error

MikeL_4 — Wed, 10 Dec 2008 20:03:54 GMT

This is so much fun trying to get this module installed !!! :(

I removed the comments from the files mentioned and got by that issue....

Now when I run the make test, it fails, and I have no idea what I need to do to resolve this either....

Failed Test Stat Wstat Total Fail List of Failed
-----------------------------------------------------------------------------------------------
t/24implicit_utf8.t 4 1024 74 4 33-34 70-71
t/32xmltype.t 255 65280 4 2 4
5 tests and 126 subtests skipped.
Failed 2/29 test scripts. 5/1081 subtests failed.
Files=29, Tests=1081, 35 wallclock secs (25.99 cusr + 2.23 csys = 28.22 CPU)
Failed 2/29 test programs. 5/1081 subtests failed.
*** Error exit code 255

--------------------------------------------
Full list of the make test run:
=>make test
/usr/bin/perl /opt/perl64/lib/5.10.0/ExtUtils/xsubpp -typemap /opt/perl64/lib/5.10.0/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
gcc64 -c -I/u01/oracle/product/9.2.0/rdbms/public -I/u01/oracle/product/9.2.0/rdbms/demo -I/u01/oracle/product/9.2.0/rdbms/demo -I/u01/oracle/product/9.2.0/rdbms/public -I/u01/oracle/product/9.2.0/plsql/public -I/u01/oracle/product/9.2.0/network/public -I/opt/perl64/lib/site_perl/5.10.0/PA-RISC2.0-LP64/auto/DBI -mpa-risc-2-0 -D_HPUX_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/pa20_64/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -g -O -DVERSION=\"1.22\" -DXS_VERSION=\"1.22\" -fPIC "-I/opt/perl64/lib/5.10.0/PA-RISC2.0-LP64/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2.0.8\" Oracle.c
rm -f blib/arch/auto/DBD/Oracle/Oracle.sl
LD_RUN_PATH="/u01/oracle/product/9.2.0/lib:/u01/oracle/product/9.2.0/rdbms/lib" /usr/bin/ld -b -L/usr/local/pa20_64/lib -L/usr/local/lib/pa20_64 -L/usr/lib/pa20_64 -L/usr/local/lib -L/pro/local/lib -L/lib/pa20_64 Oracle.o dbdimp.o oci8.o +s +n -L/u01/oracle/product/9.2.0/rdbms/lib/ -L/u01/oracle/product/9.2.0/lib/ -lclntsh `cat /u01/oracle/product/9.2.0/lib/ldflags` -lm -lqsmashr -o blib/arch/auto/DBD/Oracle/Oracle.sl \
\

Warning: Some debug info sections were missing.
PXDB aborted.
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.sl
cp ora_explain blib/script/ora_explain
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/ora_explain
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................# Test loading DBI, DBD::Oracle and version
t/01base................ok
t/10general.............ok
2/31 skipped: various reasons
t/12impdata.............ok
t/14threads.............skipped
all skipped: this hpux perl 5.010000 not configured to support iThreads
t/15nls.................ok
t/20select..............ok
1/36 skipped: various reasons
t/21nchar...............ok
t/22nchar_al32utf8......ok
t/22nchar_utf8..........ok
t/23wide_db.............skipped
all skipped: Database character set is not Unicode
t/23wide_db_8bit........skipped
all skipped: Database character set is not Unicode
t/23wide_db_al32utf8....skipped
all skipped: Database character set is not Unicode
t/24implicit_utf8.......ok 1/74
t/24implicit_utf8.......NOK 33/74
t/24implicit_utf8.......NOK 34/74# row 4: DUMP(nch) = Typ=1 Len=4: 0,38,0,58

t/24implicit_utf8.......NOK 70/74
t/24implicit_utf8.......NOK 71/74# row 4: DUMP(nch) = Typ=1 Len=4: 0,38,0,58
t/24implicit_utf8.......dubious
Test returned status 4 (wstat 1024, 0x400)
DIED. FAILED tests 33-34, 70-71
Failed 4/74 tests, 94.59% okay
t/25plsql...............ok
t/26exe_array...........ok
t/28array_bind..........ok
t/30long................ok
122/479 skipped: various reasons
t/31lob.................ok 6/9DBD::Oracle::db do failed: ORA-00942: table or view does not exist (DBD ERROR: error possibly near <*> indicator at char 14 in 'select * from <*>v$session where 0=1') [for Statement "select * from v$session where 0=1"] at t/31lob.t line 64.
t/31lob.................ok
1/9 skipped: various reasons
t/31lob_extended........ok
t/32xmltype.............ok 3/4Unsupported named object type for bind parameter at t/32xmltype.t line 71.
t/32xmltype.............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED test 4
Failed 1/4 tests, 75.00% okay
t/34pres_lobs...........ok
t/40ph_type.............ok 1/19 Placeholder behaviour for ora_type=1 VARCHAR2 (the default) varies with Oracle version.
Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x
Your system doesn't. If that seems odd, let us know.
t/40ph_type.............ok
t/50cursor..............Can't determine open_cursors from v$parameter, so using default
t/50cursor..............ok
t/51scroll..............ok
t/55nested..............ok
t/56embbeded............ok
t/60reauth..............skipped
all skipped: ORACLE_USERID_2 not defined.
t/70meta................ok
t/80ora_charset.........ok
Failed Test Stat Wstat Total Fail List of Failed
-----------------------------------------------------------------------------------------------
t/24implicit_utf8.t 4 1024 74 4 33-34 70-71
t/32xmltype.t 255 65280 4 2 4
5 tests and 126 subtests skipped.
Failed 2/29 test scripts. 5/1081 subtests failed.
Files=29, Tests=1081, 35 wallclock secs (25.99 cusr + 2.23 csys = 28.22 CPU)
Failed 2/29 test programs. 5/1081 subtests failed.
*** Error exit code 255

Stop.
=>

Re: Oracle DBD Module install error

MikeL_4 — Mon, 15 Dec 2008 18:00:29 GMT

Thanks