I need help with installing/setting up Oracle on my server.
here is the error i get when installing DBD::Oracle repeatedly. i dont know what is missing
Executing gunzip -c /tmp/.webmin/DBD-Oracle-1.23.tar.gz | tar xvf - ..
DBD-Oracle-1.23/
DBD-Oracle-1.23/README.java.txt
DBD-Oracle-1.23/t/
DBD-Oracle-1.23/t/55nested.t
DBD-Oracle-1.23/t/23wide_db.t
DBD-Oracle-1.23/t/10general.t
DBD-Oracle-1.23/t/80ora_charset.t
DBD-Oracle-1.23/t/31lob_extended.t
DBD-Oracle-1.23/t/58object.t
DBD-Oracle-1.23/t/26exe_array.t
DBD-Oracle-1.23/t/22nchar_utf8.t
DBD-Oracle-1.23/t/40ph_type.t
DBD-Oracle-1.23/t/21nchar.t
DBD-Oracle-1.23/t/22nchar_al32utf8.t
DBD-Oracle-1.23/t/14threads.t
DBD-Oracle-1.23/t/56embbeded.t
DBD-Oracle-1.23/t/51scroll.t
DBD-Oracle-1.23/t/15nls.t
DBD-Oracle-1.23/t/60reauth.t
DBD-Oracle-1.23/t/25plsql.t
DBD-Oracle-1.23/t/34pres_lobs.t
DBD-Oracle-1.23/t/23wide_db_8bit.t
DBD-Oracle-1.23/t/28array_bind.t
DBD-Oracle-1.23/t/24implicit_utf8.t
DBD-Oracle-1.23/t/nchar_test_lib.pl
DBD-Oracle-1.23/t/50cursor.t
DBD-Oracle-1.23/t/32xmltype.t
DBD-Oracle-1.23/t/23wide_db_al32utf8.t
DBD-Oracle-1.23/t/20select.t
DBD-Oracle-1.23/t/12impdata.t
DBD-Oracle-1.23/t/70meta.t
DBD-Oracle-1.23/t/31lob.t
DBD-Oracle-1.23/t/30long.t
DBD-Oracle-1.23/t/01base.t
DBD-Oracle-1.23/Oracle.ex/
DBD-Oracle-1.23/Oracle.ex/README
DBD-Oracle-1.23/Oracle.ex/sql
DBD-Oracle-1.23/Oracle.ex/bind.pl
DBD-Oracle-1.23/Oracle.ex/commit.pl
DBD-Oracle-1.23/Oracle.ex/tabinfo.pl
DBD-Oracle-1.23/Oracle.ex/ex.pl
DBD-Oracle-1.23/Oracle.ex/curref.pl
DBD-Oracle-1.23/Oracle.ex/japh
DBD-Oracle-1.23/Oracle.ex/proc.pl
DBD-Oracle-1.23/Oracle.ex/mktable.pl
DBD-Oracle-1.23/Oracle.ex/oradump.pl
DBD-Oracle-1.23/Changes
DBD-Oracle-1.23/Oracle.h
DBD-Oracle-1.23/MANIFEST
DBD-Oracle-1.23/typemap
DBD-Oracle-1.23/README-files/
DBD-Oracle-1.23/README-files/hpux/
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-588-11.11-gcc64
DBD-Oracle-1.23/README-files/hpux/Conf-Mike
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-588-10.20-gcc
DBD-Oracle-1.23/README-files/hpux/Conf-Lincoln-1.06
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-588-11.11-gcc32
DBD-Oracle-1.23/README-files/hpux/Makefile-Lincoln
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-585-11.00-cc
DBD-Oracle-1.23/README-files/hpux/Conf-Roger
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-588-11.00-gcc64
DBD-Oracle-1.23/README-files/hpux/Conf-Lincoln-1.07
DBD-Oracle-1.23/README-files/hpux/libjava.eml
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-580-10.20-cc
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-588-11.00-gcc32
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-587-11.23-cc
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-585-11.11-cc
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-588-11.23-gcc64
DBD-Oracle-1.23/README.hpux.txt
DBD-Oracle-1.23/lib/
DBD-Oracle-1.23/lib/DBD/
DBD-Oracle-1.23/lib/DBD/Oracle/
DBD-Oracle-1.23/lib/DBD/Oracle/GetInfo.pm
DBD-Oracle-1.23/lib/DBD/Oracle/Object.pm
DBD-Oracle-1.23/dbdimp.c
DBD-Oracle-1.23/README.login.txt
DBD-Oracle-1.23/README.linux.txt
DBD-Oracle-1.23/README.vms.txt
DBD-Oracle-1.23/README.win32.txt
DBD-Oracle-1.23/hints/
DBD-Oracle-1.23/hints/macos_syms.pl
DBD-Oracle-1.23/hints/svr4.pl
DBD-Oracle-1.23/hints/macos_bundle.syms
DBD-Oracle-1.23/hints/dgux.pl
DBD-Oracle-1.23/hints/macos_lib.syms
DBD-Oracle-1.23/oraperl.ph
DBD-Oracle-1.23/README.longs.txt
DBD-Oracle-1.23/README.macosx.txt
DBD-Oracle-1.23/README.win64.txt
DBD-Oracle-1.23/test.pl
DBD-Oracle-1.23/oci.def
DBD-Oracle-1.23/Todo
DBD-Oracle-1.23/Oraperl.pm
DBD-Oracle-1.23/README.help.txt
DBD-Oracle-1.23/README.explain.txt
DBD-Oracle-1.23/README
DBD-Oracle-1.23/ora_explain.PL
DBD-Oracle-1.23/README.sec.txt
DBD-Oracle-1.23/oci8.c
DBD-Oracle-1.23/README.wingcc.txt
DBD-Oracle-1.23/dbdimp.h
DBD-Oracle-1.23/ocitrace.h
DBD-Oracle-1.23/Oracle.xs
DBD-Oracle-1.23/README.sun.txt
DBD-Oracle-1.23/Oracle.pm
DBD-Oracle-1.23/dbivport.h
DBD-Oracle-1.23/README.clients.txt
DBD-Oracle-1.23/mkta.pl
DBD-Oracle-1.23/README.aix.txt
DBD-Oracle-1.23/Makefile.PL
DBD-Oracle-1.23/README.64bit.txt
DBD-Oracle-1.23/META.yml
Compiling module
Executing /usr/bin/perl Makefile.PL && make ..
Multiple copies of Driver.xst found in: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/
DBI/ /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/auto/DBI/ at Makefile.PL line 37
Using DBI 1.607 (for perl 5.008008 on i386-linux-thread-multi) installed in /usr/lib/perl5/site_perl
/5.8.8/i386-linux-thread-multi/auto/DBI/
Configuring DBD::Oracle for perl 5.008008 on linux (i386-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 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)
Found /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Using /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Looks like Oracle XE (/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk)
Reading /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Your LD_LIBRARY_PATH env var is set to ''
WARNING: Your LD_LIBRARY_PATH env var doesn't include '/usr/lib/oracle/xe/app/oracle/product/10.2.0/
server/lib' but probably needs to.
Checking for functioning wait.ph
System: perl5.008008 linux builder10.centos.org 2.6.18-53.el5 #1 smp mon nov 12 02:14:55 est 2007 i6
86 athlon i386 gnulinux
Compiler: gcc -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ss
p-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables -D_REENTRANT -D_GNU_SOU
RCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURC
E -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: /usr/bin/gcc
LDFLAGS: -g
[-g]
Linking with -L/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/ -lclntsh -lpthread
Checking if your kit is complete...
Looks good
LD_RUN_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib
Using DBD::Oracle 1.23.
Using DBD::Oracle 1.23.
Multiple copies of Driver.xst found in: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/
DBI/ /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/auto/DBI/ at Makefile.PL line 1696
Using DBI 1.607 (for perl 5.008008 on i386-linux-thread-multi) installed in /usr/lib/perl5/site_perl
/5.8.8/i386-linux-thread-multi/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?)
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/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/aut
o/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/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBI -I/usr/lib/oracle/xe/app/o
racle/product/10.2.0/server/rdbms/public/ -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -D_REENTRANT -D_GNU_
SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SO
URCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexcepti
ons -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwin
d-tables -DVERSION=\"1.23\" -DXS_VERSION=\"1.23\" -fPIC "-I/usr/lib/perl5/5.8.8/i386-linux-thread-
multi/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" Oracle.
c
gcc -c -I/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBI -I/usr/lib/oracle/xe/app/o
racle/product/10.2.0/server/rdbms/public/ -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -D_REENTRANT -D_GNU_
SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SO
URCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexcepti
ons -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwin
d-tables -DVERSION=\"1.23\" -DXS_VERSION=\"1.23\" -fPIC "-I/usr/lib/perl5/5.8.8/i386-linux-thread-
multi/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" dbdimp.
c
gcc -c -I/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBI -I/usr/lib/oracle/xe/app/o
racle/product/10.2.0/server/rdbms/public/ -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -D_REENTRANT -D_GNU_
SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SO
URCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexcepti
ons -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwin
d-tables -DVERSION=\"1.23\" -DXS_VERSION=\"1.23\" -fPIC "-I/usr/lib/perl5/5.8.8/i386-linux-thread-
multi/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" oci8.c
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib" gcc -shared -O2 -g -pipe -Wal
l -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386
-mtune=generic -fasynchronous-unwind-tables -L/usr/local/lib Oracle.o dbdimp.o oci8.o -o blib/arch/
auto/DBD/Oracle/Oracle.so \
-L/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/ -lclntsh -lpthread \
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
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" ora_explain.PL ora_explain
Extracted ora_explain from ora_explain.PL with variable substitutions.
cp ora_explain blib/script/ora_explain
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/ora_explain
Manifying blib/man1/ora_explain.1
Manifying blib/man3/DBD::Oracle.3pm
Manifying blib/man3/DBD::Oraperl.3pm
Testing module
Executing make test ..
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/ar
ch')" t/*.t
# Test loading DBI, DBD::Oracle and version
t/01base.t .............. ok
DBI connect('','scott/tiger',...) failed: ORA-12162: TNS:net service name is incorrectly specified (
DBD ERROR: OCIServerAttach) at t/10general.t line 22
Bailout called. Further testing stopped: Unable to connect to Oracle (ORA-12162: TNS:net service n
ame is incorrectly specified (DBD ERROR: OCIServerAttach))
FAILED--Further testing stopped: Unable to connect to Oracle (ORA-12162: TNS:net service name is inc
orrectly specified (DBD ERROR: OCIServerAttach))
make: *** [test_dynamic] Error 255