Re: install DBD ORACLE 815 / DEC

From: mclaire <mclaire_at_cismsun.univ-lyon1.fr>
Date: 2000/05/04
Message-ID: <391182A1.B6144DDC@cismsun.univ-lyon1.fr>

Before, we are trying to install DBD:Oracle with : Digital Unix 4.0
ORACLE 8.1.5
Perl 5.00503
DBI 1.13
DBD 1.03
and we obtain "TEST: ...install_driver(Oracle) failed !"

A possible way-out !

We linked up a different
DBD-Oracle-1.03/blib/arch/auto/DBD/Oracle/Oracle.so. We essentially forced Oracle.so to use some lib.a from ORACLE_HOME/lib : 1- modifying Makefile.PL : it's OK for Oracle 8.0.4 but no 8.1.5 2- adding some libraries (-l...) in Makefile : to complete "LDLOADLIBS=", from $ORACLE_HOME/lib

                              (libmni is in $ORACLE_HOME/network)

3- Some precautions, perhaps:

it's better to make DBD with login "oracle" and just "install" with "ROOT"

(because the variable LD8LIBRARY_PATH must be forced in the ROOT environment). NLS_LANG = american_america.WE8ISO8859P1, and PRO-C is installed

                So, I hope it's OK to develop now with ORACLE 8.1.5
                ---------------------------------------------------
Thanks alls for your help !

--

Marie-Claire Legeard
CISM, Université Claude Bernard Lyon I et INSA de Lyon
--

Here is the bad result with profile ROOT (no LIBRARY_PATH (must be forced)) ORA815-test ...>echo $LD_LIBRARY_PATH ... NOTHING! ORA815-test ...>make test PERL_DL_NONLAZY=1 /home/oracle/perl/bin/perl -Iblib/arch -Iblib/lib

-I/home/oracle/perl/lib/5.00503/alpha-dec_osf -I/home/oracle/perl/lib/5.00503 -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: 
cannot load blib/arch/auto/DBD/Oracle/Oracle.so at
/home/oracle/perl/lib/5.00503/alpha-dec_osf/DynaLoader.pm

line 169.
at (eval 1) line 3
at t/base.t line 17

dubious        Test returned status 255 (wstat 65280, 0xff00)DIED. FAILED tests
4-5

Failed 2/5 tests, 60.00% okay

This is the log of [ORA815-test ...>perl Makefile.PL]

System: perl5.00503 osf1 cismbdm.univ-lyon1.fr v4.0 1229 alpha Compiler: cc -O4 -std -fprm d -ieee -D_INTRINSICS -I/usr/local/include -DLANGUAGE_C
Linker: /bin/ld
Using DBI 1.13 installed in
/usr/local/lib/perl5/site_perl/5.005/alpha-dec_osf/auto/DBI Configuring DBD::Oracle
...Read a total of 1405 lines from
/oracle01/app/oracle/SGBD/8.1.5/rdbms/lib/env_rdbms.mk (including inclusions) Read a total of 1620 lines from
/oracle01/app/oracle/SGBD/8.1.5/rdbms/demo/demo_rdbms.mk (including inclusions) ORA815-test ...>make testORA815-test ...>make test Use of uninitialized value at Makefile.PL_old line 735.

Change in Makefile.PL [on line 735] else { $linkvia .= '$(SSDBED) ' if $MK{SSDBED}; $linkvia .= '$(DEF_OPT) ' if $MK{DEF_OPT}; #line 735 # if ($inspdver{RDBMS} =~ /^8\.0\./ and $os eq 'dec_osf' and $osvers >= 4.0) { if ($os eq 'dec_osf' and $osvers >= 4.0) {

		$linkvia .= '$(SCOREPT) $(NAETAB) $(NAEDHS) $(LLIBRDBMS_CLT) $(LLIBMM) ';
                $linkvia .= '$(NETLIBS) $(CORELIBS) $(LLIBCOMMON) $(LLIBEPC) ';
                $need_ldlp_env = "LD_LIBRARY_PATH";
            }
            $linkvia .= '$(OCISHAREDLIBS)';
        }

}

Change in Makefile [LDLOADLIBS = ]

# --- MakeMaker const_loadlibs section:
# DBD::Oracle might depend on some other libraries:
# See ExtUtils::Liblist for details

EXTRALIBS = -L/oracle01/app/oracle/SGBD/8.1.5/lib/ -lclient8 -lvsn8 -lcommon8 -lskgxp8 -lgeneric8 -lmm -lnbeq8

-lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -lnoss8 -ln8 -lncrypt8 -lnoss8 -ln8 -lncrypt8 -lnoname8 -lntcp8

-lntcps8 -lnsslb8 -lntcp8 -lntns8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -lnoss8 -ln8 -lncrypt8

-lnoss8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lntcp8 -lntns8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8

-lcommon8 -ltrace8 -lclntsh -L$(LIBHOME) /oracle01/app/oracle/SGBD/8.1.5/rdbms/lib/ssdbaed.o

/oracle01/app/oracle/SGBD/8.1.5/rdbms/lib/defopt.o $(LIBHOME)scorept.o $(LIBHOME)naeet.o $(LIBHOME)naect.o

$(LIBHOME)nautab.o $(LIBHOME)naedhs.o -lclient8 -lvsn8 -lcommon8 -lskgxp8 -lgeneric8 -lmm -lnbeq8 -lnhost8

-lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -lnoss8 -ln8 -lncrypt8 -lnoss8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8

-lnsslb8 -lntcp8 -lntns8 $(ANOLIBS) $(PROTOCOLLIBS) $(NATIVELIBS) $(NATIVESYSLIBS) -l$(ILIB_PREFIX)n8$(ILIB_SUFFIX) -l$(ILIB_PREFIX)nl8$(ILIB_SUFFIX) -l$(ILIB_PREFIX)nro8$(ILIB_SUFFIX) -lnbeq8

-lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -lnoss8 -ln8 -lncrypt8 -lnoss8 -ln8 -lncrypt8 -lnoname8 -lntcp8

-lntcps8 -lnsslb8 -lntcp8 -lntns8 $(ANOLIBS) $(PROTOCOLLIBS) $(NATIVELIBS) $(NATIVESYSLIBS) -l$(ILIB_PREFIX)n8$(ILIB_SUFFIX) -l$(ILIB_PREFIX)nl8$(ILIB_SUFFIX) -lnls8$(LIB_SUFFIX) $(LLIBCV6) -lcore8

-lnls8$(LIB_SUFFIX) -lcore8 -lnls8$(LIB_SUFFIX) -lcommon8 -ltrace8$(LIB_SUFFIX) -lclntsh#

LDLOADLIBS = -L/oracle01/app/oracle/SGBD/8.1.5/lib/ -lclient8 -lvsn8 -lcommon8 -lskgxp8 -lgeneric8 -lmm -lnbeq8

-lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -lnoss8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lntns8

-ltnsapi8 -lagent8 -lserver8 -lnhost8 -lcore8 -lnls8 -lnl8 -lnro8 -locijdbc8 -lordvir8 -ltrace8

-lclntshLDLOADLIBS = -L/oracle01/app/oracle/SGBD/8.1.5/lib/ -lclient8 -lvsn8 -lcommon8 -lskgxp8 -lgeneric8

-lmm -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -lnoss8 -ln8 -lncrypt8 -lnoss8 -ln8 -lncrypt8

-lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lntcp8 -lntns8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8

-lnsslb8 -lnoss8 -lnoss8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lntcp8 -lntns8 -lnls8 -lcore8 -ltrace8 -lagent8

-lserver8 -locijdbc8 -lordvir8 -lnmi -lclntsh

BSLOADLIBS =
LD_RUN_PATH = /oracle01/app/oracle/SGBD/8.1.5/lib

# --- MakeMaker const_cccmd section:

CCCMD = $(CC) -c $(INC) $(CCFLAGS) $(OPTIMIZE) \        
$(PERLTYPE) $(LARGE) $(SPLIT) $(DEFINE_VERSION) \

$(XS_DEFINE_VERSION)

result of the command : make test

a- before modify the Makefile

Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
ar cr tmp.a Oracle.o dbdimp.o oci7.o oci8.o: tmp.a LD_RUN_PATH="/oracle01/app/oracle/SGBD/8.1.5/lib" ld -o blib/arch/auto/DBD/Oracle/Oracle.so -shared

-expect_unresolved "*" -O4 -msym -s -L/usr/local/lib -all tmp.a -none

/oracle01/app/oracle/SGBD/8.1.5/rdbms/lib/ssdbaed.o /oracle01/app/oracle/SGBD/8.1.5/rdbms/lib/defopt.o

-L/oracle01/app/oracle/SGBD/8.1.5/lib/ -lclntsh

PERL_DL_NONLAZY=1 /bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/perl5/5.00503/alpha-dec_osf

-I/usr/local/lib/perl5/5.00503 -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: Unresolved symbol in blib/arch/auto/DBD/Oracle/Oracle.so: upioep at /usr/local/lib/perl5/5.00503/alpha-dec_osf/DynaLoader.pm line 169. at (eval 1) line 3
at t/base.t line 17

dubious        Test returned status 255 (wstat 65280, 0xff00)DIED. 
FAILED tests 4-5        Failed 2/5 tests, 60.00% okay

  b- After modify the Makefile
     -------------------------

Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bsar cr tmp.a Oracle.o dbdimp.o oci7.o oci8.o:

tmp.aLD_RUN_PATH="/oracle01/app/oracle/SGBD/8.1.5/lib" ld -o blib/arch/auto/DBD/Oracle/Oracle.so -shared

-expect_unresolved "*" -O4 -msym -s -L/usr/local/lib -all tmp.a -none

/oracle01/app/oracle/SGBD/8.1.5/rdbms/lib/ssdbaed.o /oracle01/app/oracle/SGBD/8.1.5/rdbms/lib/defopt.o

/oracle01/app/oracle/SGBD/8.1.5/lib/scorept.o /oracle01/app/oracle/SGBD/8.1.5/lib/naeet.o

/oracle01/app/oracle/SGBD/8.1.5/lib/naect.o /oracle01/app/oracle/SGBD/8.1.5/lib/naedhs.o

-L/oracle01/app/oracle/SGBD/8.1.5/lib/ -lclient8 -lvsn8 -lcommon8 -lskgxp8 -lgeneric8 -lmm -lnbeq8

-lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -lnoss8 -ln8 -lncrypt8 -lnoss8 -ln8 -lncrypt8 -lnoname8 -lntcp8

-lntcps8 -lnsslb8 -lntcp8 -lntns8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -lnoss8

-lnoss8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lntcp8 -lntns8 -lnls8 -lcore8 -ltrace8 -lagent8 -lserver8

-locijdbc8 -lordvir8 -lnmi -lclntsh

ld:Warning: naeeti defined as GLOBAL RCONST but is defined in a shared lib as a GLOBAL OBJECT
Warning: naeetc defined as GLOBAL RCONST but is defined in a shared lib as a GLOBAL OBJECT
Warning: naeetiu defined as GLOBAL RCONST but is defined in a shared lib as a GLOBAL OBJECT
Warning: naeetcu defined as GLOBAL RCONST but is defined in a shared lib as a GLOBAL OBJECT
Warning: naecti defined as GLOBAL RCONST but is defined in a shared lib as a GLOBAL OBJECT
Warning: naectc defined as GLOBAL RCONST but is defined in a shared lib as a GLOBAL OBJECT
Warning: uacsiz defined as GLOBAL RCONST but is defined in a shared lib as a GLOBAL OBJECT ... PERL_DL_NONLAZY=1 /home/oracle/perl/bin/perl -Iblib/arch -Iblib/lib

-I/home/oracle/perl/lib/5.00503/alpha-dec_osf -I/home/oracle/perl/lib/5.00503 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t

t/base..............ok
t/general...........okt/long..............ok
t/plsql.............ok
t/reauth............skipping test on this platformAll

tests successful, 1 test skipped.
Files=5, Tests=224, 21 wallclock secs ( 2.55 cusr + 0.43 csys = 2.98 CPU) PERL_DL_NONLAZY=1 /home/oracle/perl/bin/perl -Iblib/arch -Iblib/lib

-I/home/oracle/perl/lib/5.00503/alpha-dec_osf -I/home/oracle/perl/lib/5.00503 test.pl
Oraperl test application $Revision: 1.2 $Oraperl emulation interface version 1.39 DBD::Oracle 1.03 using OCI8 by Tim Bunce
DBI 1.13 by Tim Bunce
Data sources:

        dbi:Oracle:EXTPROC_CONNECTION_DATA.UNIV-LYON1.FR        
	dbi:Oracle:NORA.UNIV-LYON1.FR
        dbi:Oracle:TEST.UNIV-LYON1.FR
        dbi:Oracle:cism
        dbi:Oracle:nora
        dbi:Oracle:test
        dbi:Oracle:w3

Connecting to '' (from command line, else uses ORACLE_SID or TWO_TASK - recommended)
as 'scott/tiger' (via ORACLE_USERID env var or default - recommend name/passwd_at_dbname)(ORACLE_SID='test', TWO_TASK='') Warning: Oracle's SIGCHLD signal handler breaks perl `backticks` commands: Interrupted system

call(d_sigaction=define)
Testing internal row fetch overhead.50000 fetches: 1 wallclock secs ( 0.97 usr + 0.00 sys = 0.97 CPU)50000

per clock second, 51724 per cpu second
Fields: 5

Names:     'NUM_T'      'DATE_T'        'CHAR_T'        'ROWID_T'       'NULL_T'
Lengths:   134  76      31      21      1
OraTypes:  2    12      1       104     1
SQLTypes:  3    9       12      -9104   12
Scale:     0    0       0       0       0
Precision: 38   75      30      20      0
Nullable:  1    1       1       1       1

Est row width: 49
Data rows: fetch: '7.2', '04-MAY-00', 'SCOTT', 'AAAADCAABAAAAVtAAA', undef Received on Thu May 04 2000 - 00:00:00 CDT

Re: install DBD ORACLE 815 / DEC_OSF unix