Front page | perl.dbi.users |
Postings from January 2008
Greetings
I installed the Oracle Instant Client packages by rpm back in
December. Because of the install or more likely coincidentally I had
problems with corruption of the system files of the database. The
database was empty at the time and I simply rebuilt it.
I am trying now to get DBD::Oracle working. The DBI install came off
without a hitch. The DBD perl build and the make worked OK (logs are
at the end). The first attempt at testing failed. I recalled something
I had read about file permissions and the user 'oracle'. I logged in
as oracle and all the tests were successful. sqlplus works but only
for user oracle.
Is this normal? If the user is 'nobody' or 'daemon' as in a web
application, it seems doomed to fail. Should I be looking for problems
with the client installation? (I am aware of the security issues
surround access to the executables.) I've found nothing the
documentation that seems to fit.
Thanks
Mike
[root@humboldt DBD-Oracle-1.19]# perl Makefile.PL
Multiple copies of Driver.xst found in: /usr/lib64/perl5/site_perl/
5.8.0/auto/DBI/ /usr/lib64/perl5/vendor_perl/5.8.0/x86_64-linux-thread-
multi/auto/DBI/ at Makefile.PL line 35
Using DBI 1.59 (for perl 5.008 on x86_64-linux-thread-multi) installed
in /usr/lib64/perl5/site_perl/5.8.0/auto/DBI/
Configuring DBD::Oracle for perl 5.008 on linux (x86_64-linux-thread-
multi)
Remember to actually *READ* the README file! Especially if you have
any problems.
Using Oracle in /oracle/oracle/product/10.2.0/db_1
DEFINE _SQLPLUS_RELEASE = "1002000300" (CHAR)
Oracle version 10.2.0.3 (10.2)
Found /oracle/oracle/product/10.2.0/db_1/rdbms/demo/demo_rdbms.mk
Using /oracle/oracle/product/10.2.0/db_1/rdbms/demo/demo_rdbms.mk
Your LD_LIBRARY_PATH env var is set to '/oracle/oracle/product/10.2.0/
db_1/lib'
Reading /oracle/oracle/product/10.2.0/db_1/rdbms/demo/demo_rdbms.mk
Reading /oracle/oracle/product/10.2.0/db_1/rdbms/lib/env_rdbms.mk
Attempting to discover Oracle OCI build rules
gcc -c -I/oracle/oracle/product/10.2.0/db_1/rdbms/public -I/oracle/
oracle/product/10.2.0/db_1/rdbms/demo -I/oracle/oracle/product/10.2.0/
db_1/rdbms/public -I/oracle/oracle/product/10.2.0/db_1/plsql/public -I/
oracle/oracle/product/10.2.0/db_1/network/public -I/usr/lib64/perl5/
site_perl/5.8.0/auto/DBI -D_REENTRANT -D_GNU_SOURCE -
DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/
include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm
-O2 -g -pipe -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/usr/
lib64/perl5/5.8.0/x86_64-linux-thread-multi/CORE" -Wall -Wno-comment -
DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.3\"
DBD_ORA_OBJ.c
by executing: [make -f /oracle/oracle/product/10.2.0/db_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/oracle/oracle/product/10.2.0/db_1/lib/ -L/oracle/
oracle/product/10.2.0/db_1/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -
lclntsh `cat /oracle/oracle/product/10.2.0/db_1/lib/sysliblist` -ldl
-lm -lpthread]
Found header files in /oracle/oracle/product/10.2.0/db_1/rdbms/public.
Checking for functioning wait.ph
System: perl5.008 linux thor.perf.redhat.com 2.4.21-27.elsmp #1 smp
wed dec 1 21:53:57 est 2004 x86_64 x86_64 x86_64 gnulinux
Compiler: gcc -O2 -g -pipe -D_REENTRANT -D_GNU_SOURCE -
DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -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/
oracle/oracle/product/10.2.0/db_1/rdbms/demo -I/oracle/oracle/product/
10.2.0/db_1/rdbms/public -I/oracle/oracle/product/10.2.0/db_1/plsql/
public -I/oracle/oracle/product/10.2.0/db_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/oracle/oracle/product/10.2.0/db_1/rdbms//
lib32/ -L/oracle/oracle/product/10.2.0/db_1/lib32/ -L/oracle/oracle/
product/10.2.0/db_1/lib32/stubs/]
Linking with OTHERLDFLAGS = -L/oracle/oracle/product/10.2.0/db_1/lib/ -
L/oracle/oracle/product/10.2.0/db_1/rdbms/lib/ -lclntsh `cat /
oracle/oracle/product/10.2.0/db_1/lib/sysliblist` -ldl -lm -lpthread
[from 'build' rule]
LD_RUN_PATH=/oracle/oracle/product/10.2.0/db_1/lib:/oracle/oracle/
product/10.2.0/db_1/rdbms/lib
Using DBD::Oracle 1.19.
Using DBD::Oracle 1.19.
Multiple copies of Driver.xst found in: /usr/lib64/perl5/site_perl/
5.8.0/auto/DBI/ /usr/lib64/perl5/vendor_perl/5.8.0/x86_64-linux-thread-
multi/auto/DBI/ at Makefile.PL line 1635
Using DBI 1.59 (for perl 5.008 on x86_64-linux-thread-multi) installed
in /usr/lib64/perl5/site_perl/5.8.0/auto/DBI/
Writing Makefile for DBD::Oracle
*** 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?)
[root@humboldt DBD-Oracle-1.19]# make
Skip blib/lib/DBD/Oracle.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged)
Skip blib/lib/oraperl.ph (unchanged)
Skip blib/lib/DBD/mkta.pl (unchanged)
Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged)
Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged)
Skip blib/lib/Oraperl.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/mk.pm (unchanged)
Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
gcc -c -I/oracle/oracle/product/10.2.0/db_1/rdbms/public -I/oracle/
oracle/product/10.2.0/db_1/rdbms/demo -I/oracle/oracle/product/10.2.0/
db_1/rdbms/public -I/oracle/oracle/product/10.2.0/db_1/plsql/public -I/
oracle/oracle/product/10.2.0/db_1/network/public -I/usr/lib64/perl5/
site_perl/5.8.0/auto/DBI -D_REENTRANT -D_GNU_SOURCE -
DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/
include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm
-O2 -g -pipe -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/usr/
lib64/perl5/5.8.0/x86_64-linux-thread-multi/CORE" -Wall -Wno-comment -
DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.3\" Oracle.c
gcc -c -I/oracle/oracle/product/10.2.0/db_1/rdbms/public -I/oracle/
oracle/product/10.2.0/db_1/rdbms/demo -I/oracle/oracle/product/10.2.0/
db_1/rdbms/public -I/oracle/oracle/product/10.2.0/db_1/plsql/public -I/
oracle/oracle/product/10.2.0/db_1/network/public -I/usr/lib64/perl5/
site_perl/5.8.0/auto/DBI -D_REENTRANT -D_GNU_SOURCE -
DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/
include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm
-O2 -g -pipe -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/usr/
lib64/perl5/5.8.0/x86_64-linux-thread-multi/CORE" -Wall -Wno-comment -
DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.3\" dbdimp.c
dbdimp.c: In function `ora_db_login6':
dbdimp.c:463: warning: int format, different type arg (arg 8)
dbdimp.c:470: warning: int format, different type arg (arg 8)
dbdimp.c:645: warning: int format, different type arg (arg 7)
gcc -c -I/oracle/oracle/product/10.2.0/db_1/rdbms/public -I/oracle/
oracle/product/10.2.0/db_1/rdbms/demo -I/oracle/oracle/product/10.2.0/
db_1/rdbms/public -I/oracle/oracle/product/10.2.0/db_1/plsql/public -I/
oracle/oracle/product/10.2.0/db_1/network/public -I/usr/lib64/perl5/
site_perl/5.8.0/auto/DBI -D_REENTRANT -D_GNU_SOURCE -
DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/
include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm
-O2 -g -pipe -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/usr/
lib64/perl5/5.8.0/x86_64-linux-thread-multi/CORE" -Wall -Wno-comment -
DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.3\" oci8.c
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/oracle/oracle/product/10.2.0/db_1/lib:/oracle/oracle/
product/10.2.0/db_1/rdbms/lib" gcc -shared Oracle.o dbdimp.o oci8.o -
L/oracle/oracle/product/10.2.0/db_1/lib/ -L/oracle/oracle/product/
10.2.0/db_1/rdbms/lib/ -lclntsh `cat /oracle/oracle/product/10.2.0/
db_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
cp ora_explain blib/script/ora_explain
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/
ora_explain
Manifying blib/man3/DBD::Oracle.3pm
Manifying blib/man1/ora_explain.1
Manifying blib/man3/DBD::Oraperl.3pm
Thread Next