DG/UX DBD ORACLE COMPILATION PROBLEM. 
Author Message
 DG/UX DBD ORACLE COMPILATION PROBLEM.

We  want to develop Perl CGI scripts to run via web pages to access
Oracle databases. The software we need to achieve this is Perl, DBI
module, perl DBD-Oracle module and Apache - but I'm having some trouble
getting things to work.

I can actually get to the stage of running queries on the Oracle
database from a Perl script but the program always core dumps at the
end?

 (Perl files downloaded from www.perl.com, Apache from
www.apache.org).  DG comes with Perl already but DBI requires a later
version.

Perl 5.6.0
DBI-1.14
DBD-Oracle-1.06
Apache (1.3.9 binary distribution - Intel only!)

AV3700 dgux misi R4.20MU05 generic AViiON PentiumPro
(Oracle 8.0.5)

Below is the output from the compilation and tests.  ANY SUGGESTIONS ?

========================================================================
=====
PART 1 - Intel Installation
========================================================================
=====
Installing DBD is a 4 step process

1. perl Makefile.PL
2. make
3. make test (where it fails)
4. make install
........................................................................

misi-/> perl
Makefile.PL
Using DBI 1.14 installed in /usr/local/lib/perl5/site_perl/5.6.0/AViiON-
dgux/aut
o/DBI

 Configuring
DBD::Oracle ...

Quote:
>>>     Remember to actually *READ* the README

file!
        Especially if you have any probS
because /db/app/oracle/product/8.0.5/li
b/SC4.2/crt1.o doesn't
exist.
Deleting $(COMPOBJ)/crtn.o from COMPOBJS
because /db/app/oracle/product/8.0.5/li
b/SC4.2/crtn.o doesn't
exist.
Evaluating `cat $(LIBHOME)
naldflgs`
  expanded
`cat /db/app/oracle/product/8.0.5/lib/naldflgs`

returned ''

Evaluating `cat $(LIBHOME)
sysliblist`
  expanded
`cat /db/app/oracle/product/8.0.5/lib/sysliblist`
  returned '-lld -lnsl -lsocket -lmw -
ldlems.

Using Oracle
in /db/app/oracle/product/8.0.5
8.0.5.0.0            ORACLE Common RDBMS Libraries and
Utilities
8.0.5.0.0            ORACLE PL/SQL
Libraries
8.0.5.0.0            ORACLE Common Precomp
Libraries
8.0.5.0.0
PL/SQL
8.0.5.0.0            Oracle8 Enterprise
(RDBMS)
8.0.5.0.0
Precomp
8.0.5.0.0
Pro*C/C++

Found /db/app/oracle/product/8.0.5/rdbms/demo/demo_rdbms.mk

Found /db/app/oracle/product/8.0.5/otrace/demo/atmoci.mk

Found /db/app/oracle/product/8.0.5/precomp/demo/proc/demo_proc.mk

Using /db/app/oracle/product/8.0.5/rdbms/demo/demo_rdbms.mk

Reading /db/app/oracle/product/8.0.5/rdbms/demo/demo_rdbms.mk.

Reading /db/app/oracle/product/8.0.5/rdbms/lib/env_rdbms.mk.

Deleting $(COMPOBJ)/crti.o from COMPOBJS
because /db/app/oracle/product/8.0.5/li
b/SC4.2/crti.o doesn't
exist.
Deleting $(COMPOBJ)/crt1.o from COMPOBJl -lm -lgen -lthread -lcluster -
ldshm -lc
'

Discovering Oracle OCI build
rules...
Oracle oci build
prolog:
        Building client shared library
libclntsh.so ...
        Call
script /db/app/oracle/product/8.0.5/bin/genclntsh ...
                echo
genclntsh

genclntsh

        Built /db/app/oracle/product/8.0.5/lib/libclntsh.so ...
DONE
Oracle oci build
command:
                true cc -L/db/app/oracle/product/8.0.5/lib/ -
L/db/app/oracle/pro
duct/8.0.5/rdbms/lib -o DBD_ORA_EXE
DBD_ORA_OBJ.o /db/app/oracle/product/8.0.5/r
dbms/lib/defopt.o /db/app/oracle/product/8.0.5/lib/sscoreed.o /db/app/or
acle/pro
duct/8.0.5/lib/libclntsh.so /db/app/oracle/product/8.0.5/lib/nautab.o /d
b/app/or
acle/product/8.0.5/lib/naeet.o /db/app/oracle/product/8.0.5/lib/naect.o
/db/app/
oracle/product/8.0.5/lib/naedhs.o
`cat /db/app/oracle/product/8.0.5/lib/naldflgs
`  -lnetv2 -lnttcp -lnetwork -lncr  -lnetv2 -lnttcp -lnetwork -lclient -
lvsn -lc
ommon -lgeneric -lmm -lnlsrtl3  -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -
lnetv2 -lnt
tcp -lnetwork -lncr  -lnetv2 -lnttcp -lnetwork -lclient -lvsn -lcommon -
lgeneric
  -lepc -lnlsrtl3  -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lclient -lvsn -
lcommon -
lgeneric -lnlsrtl3  -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3
`cat /db/app/oracle/pr
oduct/8.0.5/lib/sysliblist`  -
lm

Found header files in
rdbms/demo.

System: perl5.006 dgux misi r4.20mu05 generic aviion
pentiumpro
Compiler: gcc -
O2
Linker:   /usr/bin/ld

Oracle makefiles would have used these definitions but we override
them:
  CC:
cc

  CFLAGS:   $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS)
$(PFLAGS)\
        $(SHARED_CFLAG)
$(USRFLAGS)
           [$(GFLAG) $(CDEBUG) $(QACCFLAGS) -I/db/pc -lnlsrtl3  -
lcore4 -lnlsrtl
3 -lcore4 -lnlsrtl3 -lclient -lvsn -lcommon -lgeneric -lnlsrtl3  -
lcore4 -lnlsrt
l3 -lcore4 -lnlsrtl3
`cat /db/app/oracle/product/8.0.5/lib/sysliblist`  -lm
[from 'build'
rule]

Checking if your kit is
complete...
Looks
good

Warning: By default new modules are installed into
your 'site_lib'
directories. Since site_lib directories come after the normal
library
directories you must delete any old DBD::Oracle files and directories
from
your 'privlib' and 'archlib' directories and their auto
subdirectories.
app/oracle/product/8.0.5/rdbms/demo -
I/db/app/oracle/product/8.0.5/rdbms/public
-I/db/app/oracle/product/8.0.5/plsql/public -
I/db/app/oracle/product/8.0.5/netwo
rk/public $(LPFLAGS)
$(USRFLAGS)]

  LDFLAGS:  -L$(LIBHOME) -
L$(ORACLE_HOME)/rdbms/lib
           [-L$(LIBHOME) -
L/db/app/oracle/product/8.0.5/rdbms/lib]

Linking with OTHERLDFLAGS = -L/db/app/oracle/product/8.0.5/lib/ -
L/db/app/oracle
/product/8.0.5/rdbms/lib   /db/app/oracle/product/8.0.5/rdbms/lib/defopt
.o /db/a
pp/oracle/product/8.0.5/lib/sscoreed.o /db/app/oracle/product/8.0.5/lib/
libclnts
h.so /db/app/oracle/product/8.0.5/lib/nautab.o /db/app/oracle/product/8.
0.5/lib/
naeet.o /db/app/oracle/product/8.0.5/lib/naect.o /db/app/oracle/product/
8.0.5/li
b/naedhs.o `cat /db/app/oracle/product/8.0.5/lib/naldflgs`  -lnetv2 -
lnttcp -lne
twork -lncr  -lnetv2 -lnttcp -lnetwork -lclient -lvsn -lcommon -
lgeneric -lmm -l
nlsrtl3  -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lnetv2 -lnttcp -lnetwork -
lncr  -l
netv2 -lnttcp -lnetwork -lclient -lvsn -lcommon -lgeneric  -
le
Using DBD::Oracle
1.06.
Using DBI 1.14 installed in /usr/local/lib/perl5/site_perl/5.6.0/AViiON-
dgux/aut
o/DBI

Writing Makefile for
DBD::Oracle

***  If you have problems, read the README and README.help files
***
     (Of course, you have read README by now anyway, haven't
you?)

WARNING - YOUR ORACLE INSTALLATION HAS A SECURITY
PROBLEM.
Read the README.sec file for more information and patch
details.
This is just a warning. It does not affect DBD::Oracle in any
way.
misi-/>
misi-/>
misi-/>
misi-/>
misi-/>
misi-/>
make

mkdir
blib

mkdir
blib/lib

mkdir
blib/lib/DBD

mkdir
blib/arch

mkdir
blib/arch/auto

mkdir
blib/arch/auto/DBD

mkdir
blib/arch/auto/DBD/Oracle

mkdir
blib/lib/auto

mkdir
blib/lib/auto/DBD

mkdir
blib/lib/auto/DBD/Oracle

cp oraperl.ph
blib/lib/oraperl.ph
cp Oracle.pm
blib/lib/DBD/Oracle.pm
cp Oraperl.pm
blib/lib/Oraperl.pm
        /usr/bin/perl -p -e "s/~DRIVER~/Oracle/g"
< /usr/local/lib/perl5/site_pe
rl/5.6.0/AViiON-dgux/auto/DBI/Driver.xst >
Oracle.xsi
        /usr/bin/perl -I/usr/local/lib/perl5/5.6.0/AViiON-dgux -
I/usr/local/lib/
perl5/5.6.0 /usr/local/lib/perl5/5.6.0/ExtUtils/xsubpp  -
typemap /usr/local/lib/
perl5/5.6.0/ExtUtils/typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc
Oracle.c
        gcc -c -I/db/app/oracle/product/8.0.5/rdbms/demo -
I/db/app/oracle/produc
t/8.0.5/rdbms/public -I/db/app/oracle/product/8.0.5/plsql/public -
I/db/app/oracl
e/product/8.0.5/network/public -
I/db/app/oracle/product/8.0.5/rdbms/demo -I/db/a
pp/oracle/product/8.0.5/rdbms/demo -
I/usr/local/lib/perl5/site_perl/5.6.0/AViiON
-dgux/auto/DBI  -O2      -DVERSION=\"1.06\"  -DXS_VERSION=\"1.06\" -
fpic -I/usr/
local/lib/perl5/5.6.0/AViiON-dgux/CORE -Wall -Wno-comment
Oracle.c
Oracle.c: In function
`XS_DBD__Oracle_constant':
Oracle.c:17: warning: unused variable
`Perl___notused'
Oracle.c: In function
`XS_DBD__Oracle__dr_discon_all_':
Oracle.c:47: warning: unused variable
`Perl___notused'
Oracle.c: In function
`XS_DBD__Oracle__db__login':
Oracle.c:64: warning: unused variable
`Perl___notused'
Oracle.c: In function
`XS_DBD__Oracle__db_commit':
Oracle.c:98: warning: unused variable
`Perl___notused'
Oracle.c: In function
`XS_DBD__Oracle__db_rollback':
Oracle.c:115: warning: unused variable
`Perl___notused'
Oracle.c: In function
`XS_DBD__Oracle__db_disconnect':
Oracle.c:132: warning: unused variable
`Perl___notused'
Oracle.c: In function
`XS_DBD__Oracle__db_STORE':
Oracle.c:165: warning: unused variable
`Perl___notused'
Oracle.c: In function
`XS_DBD__Oracle__db_FETCH':
Oracle.c:187: warning: unused variable
`Perl___notused'
Oracle.c: In function
`XS_DBD__Oracle__db_DESTROY':
Oracle.c:206: warning: unused variable
`Perl___notused'
Oracle.c: In function
`XS_DBD__Oracle__st__prepare':
Oracle.c:257: warning: unused variable
`Perl___notused'
Oracle.c: In
fun_DBD__Oracle__st_FETCH_attrib':
Oracle.c:576: warning: unused variable
`Perl___notused'
Oracle.c: In function
`XS_DBD__Oracle__st_DESTROY':
Oracle.c:598: warning: unused variable
`Perl___notused'
Oracle.c: In function
`XS_DBD__Oracle__st_ora_fetch':
Oracle.c:644: warning: unused variable
`Perl___notused'
ction
`XS_DBD__Oracle__st_rows':

Oracle.c:286: warning: unused variable
`Perl___notused'
Oracle.c: In function
`XS_DBD__Oracle__st_bind_param':
Oracle.c:302: warning: unused variable
`Perl___notused'
Oracle.c: In function
`XS_DBD__Oracle__st_bind_param_inout':
Oracle.c:344: warning: unused variable
`Perl___notused'
Oracle.c: In function
`XS_DBD__Oracle__st_execute':
Oracle.c:392: warning: unused variable
`Perl___notused'
Oracle.c: In function
`XS_DBD__Oracle__st_fetchrow_arrayref':
Oracle.c:439: warning: unused variable
`Perl___notused'
Oracle.c: In function
`XS_DBD__Oracle__st_fetchrow_array':
Oracle.c:458: warning: unused variable
`Perl___notused'
Oracle.c: In function
`XS_DBD__Oracle__st_finish':
Oracle.c:486: warning: unused variable
`Perl___notused'
Oracle.c: In function
`XS_DBD__Oracle__st_blob_read':
Oracle.c:516: warning: unused variable
`Perl___notused'
Oracle.c: In function
`XS_DBD__Oracle__st_STORE':
Oracle.c:554: warning: unused variable
`Perl___notused'
Oracle.c: In function `XSOracle.c: In function
`XS_DBD__Oracle__db_reauthenticat
e':

Oracle.c:696: warning: unused variable
`Perl___notused'
Oracle.c: In function
`boot_DBD__Oracle':
Oracle.c:716: warning: unused variable
`Perl___notused'
        gcc -c -I/db/app/oracle/product/8.0.5/rdbms/demo -
I/db/app/oracle/produc
t/8.0.5/rdbms/public -I/db/app/oracle/product/8.0.5/plsql/public -
I/db/app/oracl
e/product/8.0.5/network/public -
I/db/app/oracle/product/8.0.5/rdbms/demo -I/db/a
pp/oracle/product/8.0.5/rdbms/demo -
I/usr/local/lib/perl5/site_perl/5.6.0/AViiON
-dgux/auto/DBI  -O2      -DVERSION=\"1.06\"  -DXS_VERSION=\"1.06\" -
fpic -I/usr/
local/lib/perl5/5.6.0/AViiON-dgux/CORE -Wall -Wno-comment
dbdimp.c
dbdimp.c: In function
`dbd_discon_all':
dbdimp.c:57: warning: unused variable
`Perl___notused'
dbdimp.c: In function
`ora_db_login6':
dbdimp.c:250: warning: unsigned int format, long unsigned int arg (arg
5)
dbdimp.c:183: warning: unused variable
`Perl___notused'
dbdimp.c: In function
`ora_db_disconnect':
dbdimp.c:377: warning: unused variable
`Perl___notused'
dbdimp.c: In function
`pp_exec_rset':
dbdimp.c:870: warning: unused variable
`Perl___notused'
dbdimp.c:945: warning: unused variable
`Perl___notused'
dbdimp.c: In function
`ora_st_execute':
dbdimp.c:1236: warning: unused variable
`Perl___notused'
dbdimp.c: In function
`ora_st_finish':
dbdimp.c:1537: warning: unused variable
`Perl___notused'
dbdimp.c: In function
`ora_st_destroy':
dbdimp.c:1624: warning: unused variable
`imp_dbh'
        gcc -c -I/db/app/oracle/product/8.0.5/rdbms/demo -
I/db/app/oracle/produc
t/8.0.5/rdbms/public -I/db/app/oracle/product/8.0.5/plsql/public -
I/db/app/oracl
e/product/8.0.5/network/public -
I/db/app/oracle/product/8.0.5/rdbms/demo -I/db/a
pp/oracle/product/8.0.5/rdbms/demo -
I/usr/local/lib/perl5/site_perl/5.6.0/AViiON
-dgux/auto/DBI  -O2      -DVERSION=\"1.06\"  -DXS_VERSION=\"1.06\" -
fpic -I/usr/
local/lib/perl5/5.6.0/AViiON-dgux/CORE -Wall -Wno-comment
oci7.c
        gcc -c -I/db/app/oracle/product/8.0.5/rdbms/demo -
I/db/app/oracle/produc
t/8.0.5/rdbms/public -I/db/app/oracle/product/8.0.5/plsql/public -
I/db/app/oracl
e/product/8.0.5/network/public -
I/db/app/oracle/product/8.0.5/rdbms/demo -I/db/a
pp/oracle/product/8.0.5/rdbms/demo -
I/usr/local/lib/perl5/site_perl/5.6.0/AViiON
-dgux/auto/DBI  -O2      -DVERSION=\"1.06\"  -DXS_VERSION=\"1.06\" -
fpic -I/usr/
local/lib/perl5/5.6.0/AViiON-dgux/CORE -Wall -Wno-comment
oci8.c
oci8.c: In function
`dbd_rebind_ph_rset':
oci8.c:414: warning: implicit declaration of function
`pp_rebind_ph_rset_in'
oci8.c: In function
`dbd_rebind_ph_lob':
oci8.c:435: warning: unsigned int format, ub4 arg (arg
5)
oci8.c: In function
`ora_st_fetch':
oci8.c:885: warning: unused variable
`Perl___notused'
oci8.c:892: warning: unused variable
`Perl___notused'
Running Mkbootstrap for DBD::Oracle
()
        chmod 644
Oracle.bs
        LD_RUN_PATH="" gcc -o blib/arch/auto/DBD/Oracle/Oracle.so  -
shared -L/us
r/local/lib Oracle.o  dbdimp.o  oci7.o  oci8.o -
L/db/app/oracle/product/8.0.5/li
b/ -
L/db/app/oracle/product/8.0.5/rdbms/lib   /db/app/oracle/product/8.0.5/r
dbms
/lib/defopt.o /db/app/oracle/product/8.0.5/lib/sscoreed.o /db/app/oracle
/product
/8.0.5/lib/libclntsh.so /db/app/oracle/product/8.0.5/lib/nautab.o /db/ap
p/oracle
/product/8.0.5/lib/naeet.o /db/app/oracle/product/8.0.5/lib/naect.o /db/
app/orac
le/product/8.0.5/lib/naedhs.o
`cat /db/app/oracle/product/8.0.5/lib/naldflgs`  -
lnetv2 -lnttcp -lnetwork -lncr  -lnetv2 -lnttcp -lnetwork -lclient -
lvsn -lcommo
n -lgeneric -lmm -lnlsrtl3  -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -
lnetv2 -lnttcp
-lnetwork -lncr  -lnetv2 -lnttcp -lnetwork -lclient -lvsn -lcommon -
lgeneric  -l
epc -lnlsrtl3  -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lclient -lvsn -
lcommon -lgen
eric -lnlsrtl3  -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3
`cat /db/app/oracle/produc
t/8.0.5/lib/sysliblist`  -
lm
        chmod 755
blib/arch/auto/DBD/Oracle/Oracle.so
        cp Oracle.bs
blib/arch/auto/DBD/Oracle/Oracle.bs
        chmod 644
blib/arch/auto/DBD/Oracle/Oracle.bs
        /usr/bin/perl -Iblib/arch -Iblib/lib -
I/usr/local/lib/perl5/5.6.0/AViiON
-dgux -I/usr/local/lib/perl5/5.6.0 ora_explain.PL
ora_explain
Extracted ora_explain from ora_explain.PL with variable
substitutions.
mkdir
blib/script

        cp ora_explain
blib/script/ora_explain
        /usr/bin/perl -I/usr/local/lib/perl5/5.6.0/AViiON-dgux -
I/usr/local/lib/
perl5/5.6.0 -MExtUtils::MakeMaker  -e "MY->fixin(shift)"
blib/script/ora_explain

misi-/>
misi-/>
misi-/>
misi-/>
ORACLE_USERID=system/manager

misi-/> export
ORACLE_USERID
misi-/> make
test
        PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -
I/usr/local/lib/
perl5/5.6.0/AViiON-dgux -I/usr/local/lib/perl5/5.6.0 -e 'use
Test::Harness qw(&r

t/*.t
t/base..............dubious

        Test returned status 0 (wstat 139,
0x8b)
        test program seems to have generated a
core
t/general...........dubious

        Test returned status 0 (wstat 139,
0x8b)
        test program seems to have generated a
core
DIED. FAILED tests 3-
16
        Failed 14/16 tests, 12.50%
okay
t/long..............ok
108/140
t/long..............ok

t/plsql.............ok
13/631041
t/plsql.............NOK 14ORA-01041: internal error. hostdef extension
doesn't e
xist (DBD ERROR:
OCIStmtExecute)
t/plsql.............ok 18/63ORA-01041: internal error. hostdef
extension doesn't
 exist (DBD ERROR:
OCIStmtExecute)
                                 5 test scripts, 40.00% okay. 66/219
subtests fa
iled, 69.86%
okay.
*** Error code
2

Stop.

t/plsql.............NOK 20ORA-01041: internal error. hostdef extension
doesn't e
xist (DBD ERROR: OCIStmtExecute) at t/plsql.t line
111.
Issuing rollback() for database handle being DESTROY'd without explicit
disconne
ct
().

t/plsql.............dubious

        Test returned status 2 (wstat 512,
0x200)
DIED. FAILED tests 3-4, 7, 10-11, 14-15, 19-
63
        Failed 52/63 tests, 17.46%
okay
t/reauth............skipped test on this
platform
Failed Test  Status Wstat Total Fail  Failed  List of
failed
------------------------------------------------------------------------
-------
t/base.t          0   139    ??   ??
%  ??
t/general.t       0   139    16   14  87.50%  3-
16
t/plsql.t         2   512    63   52  82.54%  3-4, 7, 10-11, 14-15, 19-
63
1 test
skipped.

Failed
3/

misi-/>
========================================================================
=====
END OF PART 1 - Intel Installation
========================================================================
=====

Sent via Deja.com
http://www.*-*-*.com/



Mon, 09 Jun 2003 19:22:09 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Compilation problem on DG/UX 4.11

2. Oracle DBD/DBI on HP-UX: can't load Oracle.sl

3. Success: DBD-Oracle-1.03 on HP-UX 11.0 (64Bit Version) and Oracle 8.1.6

4. Problems installing DBD-Oracle-1.06 on HP-UX 11

5. Problems builduing DBD-Oracle-0.50 under HP-UX 10.20

6. sybperl installation problem on DG/UX

7. problems with perl under dg/ux

8. Help!!! DG/UX Compile Problem

9. DG/UX perl5.004_4 compile problem

10. Problem Compiling Perl5.001n on DG-UX

11. make test of DBD::Oracle 1.12 fails with HP/UX 11.00

12. Oracle DBD / HP-UX

 

 
Powered by phpBB® Forum Software