Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Problem: Perl module for oracle

Problem: Perl module for oracle

From: Alberto Brosich <brosich_at_univ.trieste.it>
Date: Wed, 20 May 1998 11:20:44 +0200
Message-ID: <3562A06B.C39FC2D0@univ.trieste.it>


i'm trying to install perl DBI and DBD modules on Digital Alpha 7000 with Digital Unix 4.0b patch-kit 7. I have oracle 8.0.4 with net8 and pro*c installed.

DBI is correctly installed.

After modify lines 371-372 of Makefile.PL
- s/\.(\$\(OBJ_EXT\))/$1/g;

+ s/\\.(\$\(OBJ_EXT\))/$1/g;

perl Makefile.PL seems works fine. This is output:



# perl Makefile.PL

 Configuring DBD::Oracle ...

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

Using Oracle in /oraprod/app/oracle/product/8.0.4
Reading /oraprod/app/oracle/product/8.0.4/rdbms/demo/demo_rdbms.mk.
Reading /oraprod/app/oracle/product/8.0.4/rdbms/lib/env_rdbms.mk. System: perl5.00404 osf1 nasaxp.rto.dec.com v4.0 564 alpha Compiler: cc -O4 -std -D_INTRINSICS -I/usr/local/include
-D__LANGUAGE_C__

Linker: /usr/bin/ld
Oracle proc.mk would have used these values but we override them:   CC: cc
  CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS)\
        $(SHARED_CFLAG) $(USRFLAGS)
           [ $(CDEBUG?:-O4 -fast -fp_reorder -U_FASTMATH) -std1 -DOSF1

-DA_OSF -Wf,-readonly_strings -D_INTRINSICS
-I/oraprod/app/oracle/product/8.0.4/rdbms/demo
-I/oraprod/app/oracle/product/8.0.4/rdbms/public
-I/oraprod/app/oracle/product/8.0.4/plsql/public
-I/oraprod/app/oracle/product/8.0.4/network/public ]
  LDFLAGS:  -L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib
           [-L/oraprod/app/oracle/product/8.0.4/lib/

-L/oraprod/app/oracle/product/8.0.4/rdbms/lib]

Linking with /oraprod/app/oracle/product/8.0.4/lib/nautab.o

/oraprod/app/oracle/product/8.0.4/lib/naeet.o
/oraprod/app/oracle/product/8.0.4/lib/naect.o
/oraprod/app/oracle/product/8.0.4/lib/naedhs.o -lsql     -lnetv2 -lnttcp

-lnetwork -lncr -lnetv2 -lnttcp -lnetwork -lclient -lvsn -lcommon
-lgeneric -lmm -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lnetv2
-lnttcp -lnetwork -lncr -lnetv2 -lnttcp -lnetwork -lclient -lvsn
-lcommon -lgeneric -lepc -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3
-lclient -lvsn -lcommon -lgeneric -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4
-lnlsrtl3 -lexc -lmld -lrt -laio_raw -lm -lm [from $(PROLDLIBS)]

'COMPRESS' is not a known MakeMaker parameter name. 'SUFFIX' is not a known MakeMaker parameter name.

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.

Using DBI 0.93 installed in
/usr/opt/PERL5004/lib/perl5/site_perl/alpha-dec_osf/auto/DBI Writing Makefile for DBD::Oracle


make hasn't errors or warnings

but

make test has following errors:



PERL_DL_NONLAZY=1 /usr/bin/perl -I./blib/arch -I./blib/lib
-I/usr/opt/PERL5004/lib/perl5/alpha-dec_osf/5.00404
-I/usr/opt/PERL5004/lib/perl5 -e 'use Test::Harness qw(&runtests
$verbose); $verbose=0; runtests @ARGV;' t/*.t t/base..............install_driver(Oracle) failed: Can't load './blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: dlopen: Unresolved symbols at
/usr/opt/PERL5004/lib/perl5/alpha-dec_osf/5.00404/DynaLoader.pm line 166.

 at (eval 1) line 2

        DBI::install_driver('DBI', 'Oracle') called at t/base.t line 17 dubious

        Test returned status 2 (wstat 512, 0x200) DIED. FAILED tests 4-5

        Failed 2/5 tests, 60.00% okay
t/plsql.............install_driver(Oracle) failed: Can't load './blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: dlopen: Unresolved symbols at
/usr/opt/PERL5004/lib/perl5/alpha-dec_osf/5.00404/DynaLoader.pm line 166.

 at (eval 1) line 2

        DBI::install_driver('DBI', 'Oracle') called at /usr/opt/PERL5004/lib/perl5/site_perl/DBI.pm line 348

        DBI::connect('DBI', '', 'scott/tiger', '', 'Oracle') called at t/plsql.t line 18
dubious

        Test returned status 2 (wstat 512, 0x200) Failed Test Status Wstat Total Fail Failed List of failed


t/base.t          2   512     5    2  40.00%  4-5
t/plsql.t         2   512    ??   ??       %  ??
Failed 2/2 test scripts, 0.00% okay. 2/5 subtests failed, 60.00% okay. PERL_DL_NONLAZY=1 /usr/bin/perl -I./blib/arch -I./blib/lib
-I/usr/opt/PERL5004/lib/perl5/alpha-dec_osf/5.00404
-I/usr/opt/PERL5004/lib/perl5 test.pl

Oraperl test application $Revision: 1.30 $ install_driver(Oracle) failed: Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: dlopen: Unresolved symbols at
/usr/opt/PERL5004/lib/perl5/alpha-dec_osf/5.00404/DynaLoader.pm line 166.

 at (eval 3) line 2

        DBI::install_driver('DBI', 'Oracle') called at blib/lib/Oraperl.pm line 58

        require Oraperl.pm called at (eval 2) line 1
        main::BEGIN() called at blib/lib/Oraperl.pm line 0
        eval {...} called at blib/lib/Oraperl.pm line 0
        eval 'use Oraperl; 1

;' called at test.pl line 38
BEGIN failed--compilation aborted at (eval 2) line 1. *** Exit 2
Stop.

I think problem is the first error:
t/base..............install_driver(Oracle) failed: Can't load './blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: dlopen: Unresolved symbols at
/usr/opt/PERL5004/lib/perl5/alpha-dec_osf/5.00404/DynaLoader.pm line 166.

but i don't know solutions.

Anyone have the same problem?

OS version - DU 4.0b

Perl version - 5.004_04 built for alpha-dec_osf
DBI version  - 0.93
DBD Oracle   - 0.47
Oracle ver.  - 8.0.4

Alberto Brosich
System Manager
University of Trieste
Italy Received on Wed May 20 1998 - 04:20:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US