All tests fail for any other than user 'oracle'

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

.

Relevant Pages

  • Re: Adding RAM
    ... About Oracle, I currently use Mysql for my TM databases but I have been ... Limited to a 4GB database but that should be adequate ... The rpm is easy to install and you get a nice tutorial to ... Here's the link to the Oracle-10g + Compiere installation on SuSE ...
    (alt.os.linux.suse)
  • Re: Upgrade 8i to 9i --- multiple oracle_base !!!!!!
    ... > it's own system owning account. ... > 1) Install one copy of the latest version of SQL-Backtrack into its own ... completely separate from any Oracle directories. ... > 2) Shutdown and cold backup both databases. ...
    (comp.databases.oracle.server)
  • Re: ORA-01031
    ... I Installed Oracle Instant Client as instructed by ORACLE in the ... 'Application Account' which is not an oracle account. ... Then you have to ask yourself what password you put in when you install ...
    (comp.databases.oracle.misc)
  • RE: :Oracle install problem On Solaris 8
    ... I tried to reinstall the Oracle client. ... To: Hemanth Kumar; Michael Nhan ... Subject: RE::Oracle install problem On Solaris 8 ...
    (perl.dbi.users)
  • RE: Problems to Install Oracle Client 10g over Red Hat AS 3.0update3
    ... Oracle 10g R1 DB go out of memory once in a while goes for a toss till it ... "General Red Hat Linux discussion list" ... Problems to Install Oracle Client 10g over Red Hat AS 3.0update3 ...
    (RedHat)