Issue with DBD:Oracle 1.34 module on 64 bit Linux machine

kiran kumar <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.general
Message-ID <CAEmky99H_8heFAHGJxSHXUmy9-G7jUJn9kyes4Q20Q9ej-MdKQ@mail.gmail.com> 
Hi,



I have installed DBD:Oracle 1.34 module on 64 bit Linux machine with root
user and when I run it root user its working file,

But when I run it using non root user, I am getting the error



“install_driver(Oracle) failed: Can't load
'/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: libclntsh.so.10.1: cannot open shared object file:
No such file or directory at
/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.

 at (eval 3) line 3

Compilation failed in require at (eval 3) line 3.

Perhaps a required shared library or dll isn't installed where expected

 at ./PreciseMedia_update.pl line 32”



Please help me.



Attached is the list of logs required.



Let me know if further information is required.



Thanks in Advance.


Regards,

Kiran P
make.log (application/octet-stream, 5.3 KB) 
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/Object.pm blib/lib/DBD/Oracle/Object.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI/Driver.xst > Oracle.xsi
/usr/bin/perl /usr/lib/perl5/5.8.8/ExtUtils/xsubpp  -typemap /usr/lib/perl5/5.8.8/ExtUtils/typemap -typemap typemap  Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
gcc -c  -I/home/oracle/oracle/product/10.2.0/client_1/rdbms/public -I/home/oracle/oracle/product/10.2.0/client_1/rdbms/demo -I/home/oracle/oracle/product/10.2.0/client_1/rdbms/public -I/home/oracle/oracle/product/10.2.0/client_1/plsql/public -I/home/oracle/oracle/product/10.2.0/client_1/network/public -I/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic   -DVERSION=\"1.34\" -DXS_VERSION=\"1.34\" -fPIC "-I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE"  -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"10.2.0.1\" -DORA_OCI_102 Oracle.c
gcc -c  -I/home/oracle/oracle/product/10.2.0/client_1/rdbms/public -I/home/oracle/oracle/product/10.2.0/client_1/rdbms/demo -I/home/oracle/oracle/product/10.2.0/client_1/rdbms/public -I/home/oracle/oracle/product/10.2.0/client_1/plsql/public -I/home/oracle/oracle/product/10.2.0/client_1/network/public -I/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic   -DVERSION=\"1.34\" -DXS_VERSION=\"1.34\" -fPIC "-I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE"  -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"10.2.0.1\" -DORA_OCI_102 dbdimp.c
dbdimp.c: In function ‘fb_ary_cb_alloc’:
dbdimp.c:324: warning: comparison is always false due to limited range of data type
dbdimp.c:325: warning: comparison is always false due to limited range of data type
dbdimp.c:326: warning: comparison is always false due to limited range of data type
dbdimp.c:327: warning: comparison is always false due to limited range of data type
dbdimp.c:328: warning: comparison is always false due to limited range of data type
dbdimp.c: In function ‘fb_ary_alloc’:
dbdimp.c:344: warning: comparison is always false due to limited range of data type
dbdimp.c:345: warning: comparison is always false due to limited range of data type
dbdimp.c:346: warning: comparison is always false due to limited range of data type
dbdimp.c:347: warning: comparison is always false due to limited range of data type
gcc -c  -I/home/oracle/oracle/product/10.2.0/client_1/rdbms/public -I/home/oracle/oracle/product/10.2.0/client_1/rdbms/demo -I/home/oracle/oracle/product/10.2.0/client_1/rdbms/public -I/home/oracle/oracle/product/10.2.0/client_1/plsql/public -I/home/oracle/oracle/product/10.2.0/client_1/network/public -I/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic   -DVERSION=\"1.34\" -DXS_VERSION=\"1.34\" -fPIC "-I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE"  -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"10.2.0.1\" -DORA_OCI_102 oci8.c
oci8.c: In function ‘ora_blob_read_mb_piece’:
oci8.c:1744: warning: comparison is always false due to limited range of data type
oci8.c: In function ‘describe_obj_by_tdo’:
oci8.c:3083: warning: comparison is always false due to limited range of data type
oci8.c: In function ‘ora_describe’:
oci8.c:3283: warning: comparison is always false due to limited range of data type
oci8.c:4672:2: warning: no newline at end of file
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/home/oracle/oracle/product/10.2.0/client_1/lib:/home/oracle/oracle/product/10.2.0/client_1/rdbms/lib" gcc  -shared -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic Oracle.o dbdimp.o oci8.o -L/home/oracle/oracle/product/10.2.0/client_1/lib/ -L/home/oracle/oracle/product/10.2.0/client_1/rdbms/lib/   -lclntsh   `cat /home/oracle/oracle/product/10.2.0/client_1/lib/sysliblist` -ldl -lm  -lpthread -o blib/arch/auto/DBD/Oracle/Oracle.so 	\
	     	\
	  
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
Manifying blib/man3/DBD::Oracle.3pm
Manifying blib/man3/DBD::Oraperl.3pm
makefile.log (application/octet-stream, 4.1 KB) 
Using DBI 1.616 (for perl 5.008008 on x86_64-linux-thread-multi) installed in /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI/

Configuring DBD::Oracle for perl 5.008008 on linux (x86_64-linux-thread-multi)

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

Installing on a linux, Ver#2.6
Using Oracle in /home/oracle/oracle/product/10.2.0/client_1
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)
Found /home/oracle/oracle/product/10.2.0/client_1/rdbms/demo/demo_rdbms.mk
Found /home/oracle/oracle/product/10.2.0/client_1/rdbms/demo/demo_rdbms64.mk
Found /home/oracle/oracle/product/10.2.0/client_1/rdbms/lib/ins_rdbms.mk
Using /home/oracle/oracle/product/10.2.0/client_1/rdbms/demo/demo_rdbms.mk
Your LD_LIBRARY_PATH env var is set to '/home/oracle/oracle/product/10.2.0/client_1/lib:/home/oracle/oracle/product/10.2.0/client_1/lib32'
Reading /home/oracle/oracle/product/10.2.0/client_1/rdbms/demo/demo_rdbms.mk
Reading /home/oracle/oracle/product/10.2.0/client_1/rdbms/lib/env_rdbms.mk

Attempting to discover Oracle OCI build rules
gcc    -c -o DBD_ORA_OBJ.o DBD_ORA_OBJ.c
by executing: [make -f /home/oracle/oracle/product/10.2.0/client_1/rdbms/demo/demo_rdbms.mk build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=true OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o]
Oracle oci build command:
	[true -L/home/oracle/oracle/product/10.2.0/client_1/lib/ -L/home/oracle/oracle/product/10.2.0/client_1/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh   `cat /home/oracle/oracle/product/10.2.0/client_1/lib/sysliblist` -ldl -lm  -lpthread]

Found header files in /home/oracle/oracle/product/10.2.0/client_1/rdbms/public.

client_version=10.2


DEFINE= -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"10.2.0.1\" -DORA_OCI_102


Checking for functioning wait.ph


System: perl5.008008 linux ls20-bc1-14.build.redhat.com 2.6.18-128.1.1.el5 #1 smp mon jan 26 13:58:24 est 2009 x86_64 x86_64 x86_64 gnulinux 
Compiler:   gcc -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm
Linker:     /usr/bin/ld
Sysliblist: -ldl -lm -lpthread -lnsl -lirc 
Oracle makefiles would have used these definitions but we override them:
  CC:       cc
  CFLAGS:   $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
	$(SHARED_CFLAG) $(USRFLAGS)
           [$(GFLAG) -O3 $(CDEBUG) -m32 $(TRIGRAPHS_CCFLAGS) -fPIC -I/home/oracle/oracle/product/10.2.0/client_1/rdbms/demo -I/home/oracle/oracle/product/10.2.0/client_1/rdbms/public -I/home/oracle/oracle/product/10.2.0/client_1/plsql/public -I/home/oracle/oracle/product/10.2.0/client_1/network/public -DLINUX -D_GNU_SOURCE -D_LARGEFILE64_SOURCE=1 -D_LARGEFILE_SOURCE=1 -DSLTS_ENABLE -DSLMXMX_ENABLE -D_REENTRANT -DNS_THREADS -fno-strict-aliasing $(LPFLAGS) $(USRFLAGS)]
  LDFLAGS:  $(LDFLAGS32)
           [-m32 -o $@ -L/home/oracle/oracle/product/10.2.0/client_1/rdbms//lib32/ -L/home/oracle/oracle/product/10.2.0/client_1/lib32/ -L/home/oracle/oracle/product/10.2.0/client_1/lib32/stubs/]
Linking with OTHERLDFLAGS = -L/home/oracle/oracle/product/10.2.0/client_1/lib/ -L/home/oracle/oracle/product/10.2.0/client_1/rdbms/lib/   -lclntsh   `cat /home/oracle/oracle/product/10.2.0/client_1/lib/sysliblist` -ldl -lm  -lpthread [from 'build' rule]

Checking if your kit is complete...
Warning: the following files are missing in your kit:
	README.explain.txt
Please inform the author.
LD_RUN_PATH=/home/oracle/oracle/product/10.2.0/client_1/lib:/home/oracle/oracle/product/10.2.0/client_1/rdbms/lib
Using DBD::Oracle 1.34.
Using DBD::Oracle 1.34.
Using DBI 1.616 (for perl 5.008008 on x86_64-linux-thread-multi) installed in /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI/
Writing Makefile for DBD::Oracle
Writing MYMETA.yml and MYMETA.json

***  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?)
maketest.log (application/octet-stream, 2.4 KB) 
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00versions............# OCI client library version: 10.2.0.1
# database version: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
ok
t/01base................ok
t/10general.............ok
t/12impdata.............ok
t/14threads.............ok
t/15nls.................ok
t/20select..............ok
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
t/25plsql...............ok
t/26exe_array...........ok
t/28array_bind..........ok
t/30long................ok
        122/479 skipped: various reasons
t/31lob.................ok
t/31lob_extended........ok
t/32xmltype.............ok
t/34pres_lobs...........ok
t/36lob_leak............ok
        6/7 skipped: various reasons
t/38taf.................ok
t/40ph_type.............ok
t/50cursor..............ok
t/51scroll..............ok
t/55nested..............ok
t/56embbeded............ok
t/58object..............ok
t/60reauth..............skipped
        all skipped: ORACLE_USERID_2 not defined.
t/70meta................ok
t/80ora_charset.........ok
All tests successful, 4 tests and 128 subtests skipped.
Files=33, Tests=2569,  9 wallclock secs ( 4.14 cusr +  0.57 csys =  4.71 CPU)
PERL_DL_NONLAZY=1 /usr/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl

Oraperl emulation interface version 1.44 
DBD::Oracle 1.34 using OCI10.2.0.1 by Tim Bunce
DBI 1.616 by Tim Bunce

Data sources:
	
Connecting
 to '' (from command line, else uses ORACLE_SID or TWO_TASK - recommended)
 as 'gmd/gmd' (via ORACLE_USERID env var or default - recommend name/passwd@dbname)
(ORACLE_SID='GMDPH2DEV', TWO_TASK='GMDPH2DEV')
Fields:    6
Names:     	NUM_T	DATE_T	CHAR_T	ROWID_T	RAW_T	NULL_T
Lengths:   	172	76	31	21	3	4001
OraTypes:  	2	12	1	104	23	1
SQLTypes:  	8	93	12	-9104	-2	12
Scale:     	0	0	0	0	0	0
Precision: 	126	75	30	20	2	4000
Nullable:  	1	1	1	''	1	1
Est row width:	2036
Prefetch cache:   60
Data rows:
    fetch: '7.2', '09-DEC-11', 'GMD', 'AAAAECAABAAAAgiAAA', '7D', undef

Repetitive connect/open/close/disconnect:
1 2 3 4 5 6 7 8 9 10 (~0.020 seconds each)
test.pl complete.
perl_version.log (application/octet-stream, 3.8 KB) 
Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
  Platform:
    osname=linux, osvers=2.6.18-128.1.1.el5, archname=x86_64-linux-thread-multi
    uname='linux ls20-bc1-14.build.redhat.com 2.6.18-128.1.1.el5 #1 smp mon jan 26 13:58:24 est 2009 x86_64 x86_64 x86_64 gnulinux '
    config_args='-des -Doptimize=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -Dversion=5.8.8 -Dmyhostname=localhost -Dperladmin=root@localhost -Dcc=gcc -Dcf_by=Red Hat, Inc. -Dinstallprefix=/usr -Dprefix=/usr -Dlibpth=/usr/local/lib64 /lib64 /usr/lib64 -Dprivlib=/usr/lib/perl5/5.8.8 -Dsitelib=/usr/lib/perl5/site_perl/5.8.8 -Dvendorlib=/usr/lib/perl5/vendor_perl/5.8.8 -Darchlib=/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi -Dsitearch=/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi -Dvendorarch=/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi -Darchname=x86_64-linux-thread-multi -Dvendorprefix=/usr -Dsiteprefix=/usr -Duseshrplib -Dusethreads -Duseithreads -Duselargefiles -Dd_dosuid -Dd_semctl_semun -Di_db -Ui_ndbm -Di_gdbm -Di_shadow -Di_syslog -Dman3ext=3pm -Duseperlio -Dinstallusrbinperl=n -Ubincompat5005 -Uversiononly -Dpager=/usr/bin/less -isr -Dd_gethostent_r_proto -Ud_endhostent_r_proto -Ud_sethostent_r_proto -Ud_endprotoent_r_proto -Ud_setprotoent_r_proto -Ud_endservent_r_proto -Ud_setservent_r_proto -Dinc_version_list=5.8.7 5.8.6 5.8.5 -Dscriptdir=/usr/bin'
    hint=recommended, useposix=true, d_sigaction=define
    usethreads=define use5005threads=undef useithreads=define usemultiplicity=define
    useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
    use64bitint=define use64bitall=define uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='gcc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm',
    optimize='-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic',
    cppflags='-D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -I/usr/include/gdbm'
    ccversion='', gccversion='4.1.2 20080704 (Red Hat 4.1.2-44)', gccosandvers=''
    intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
    ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
    alignbytes=8, prototype=define
  Linker and Libraries:
    ld='gcc', ldflags =''
    libpth=/usr/local/lib64 /lib64 /usr/lib64
    libs=-lresolv -lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lpthread -lc
    perllibs=-lresolv -lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
    libc=, so=so, useshrplib=true, libperl=libperl.so
    gnulibc_version='2.5'
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E -Wl,-rpath,/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE'
    cccdlflags='-fPIC', lddlflags='-shared -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic'


Characteristics of this binary (from libperl): 
  Compile-time options: MULTIPLICITY PERL_IMPLICIT_CONTEXT
                        PERL_MALLOC_WRAP USE_64_BIT_ALL USE_64_BIT_INT
                        USE_ITHREADS USE_LARGE_FILES USE_PERLIO
                        USE_REENTRANT_API
  Built under linux
  Compiled at Mar 16 2009 13:47:43
  @INC:
    /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi
    /usr/lib/perl5/site_perl/5.8.8
    /usr/lib/perl5/site_perl
    /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi
    /usr/lib/perl5/vendor_perl/5.8.8
    /usr/lib/perl5/vendor_perl
    /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi
    /usr/lib/perl5/5.8.8
    .
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.