I have not really much experience in software installation and my goal is to
install the apache webserver with mod-perl and a connection to our Oracle
database.
First, i tried to install perl-5.8.0 with DBI-1.32 and DBD-Oracle-1.12on our HPUX 11.0
with Oracle 7.3.4.
The installation of perl seemed to be straight simple as it was with DBI. DBD has
error messages in "make test" - there is no way to get connected to Oracle by
the listener. I get the error messages:
ORA-12157: TNS: Internal network communication error
or the
ORA-12154: TNS:Could not resolve service name
in spite of that sqlplus is working fine and i have no connection problems
(see the description and the details at the end).
Since last week i am looking at this problem from all sides, i tried different
installs (static : bus error) but with no success.
Has anybody experienced this problem?
Any hints and help is appreciated.
Thanks
josef
TACTIC SA
Prais, France
Using DBI 1.32 installed in /opt/perl5/lib/site_perl/5.8.0/PA-RISC2.0-thread-multi/auto/DBI Duplicate specification "S=s" for option "s"
Configuring DBD::Oracle ...
>>> Remember to actually *READ* the README file!
Especially if you have any problems.
Using Oracle in /usrora/oracle/V734
4.0.1.0.0 Oracle Unix Installer
1.0.1.0.0 Oracle On-Line Text Viewer
7.3.4.1.0 ORACLE NLS Libraries and Utilities
7.3.4.1.0 ORACLE Core Libraries
7.3.4.1.0 Oracle Common RDBMS Libraries and Utilities
7.3.4.1.0 ORACLE PL/SQL Libraries
7.3.4.1.0 ORACLE Common Libraries
7.3.4.1.0 ORACLE Common Precomp Libraries
7.3.4.1.0 ORACLE Common Network Libraries and Utilities
7.3.4.1.0 ORACLE Common Trace Libraries
7.3.4.0.0 ORACLE Common Utilities
7.3.4.0.0 ORACLE Common Libraries and Utilities
7.3.4.0.0 Platform specific Libraries and Utilities
2.3.4.0.0 SQL*Net (V2)
2.3.4.0.0 TCP/IP Protocol Adapter (V2)
1.3.2.0.0 Remote Operations
7.3.4.0.0 SLAX: parser
2.3.4.1.0 PL/SQL V2
7.3.4.1.0 Oracle7 Parallel Query option
2.3.4.0.0 Oracle Server Manager
7.3.4.1.0 Oracle7 Server (RDBMS)
1.0.0.0.1 <Database Startup> Load Files
7.3.4 Oracle Trace
7.3.4.0.0 Precomp
2.2.4.0.0 Pro*C
1.1.5.0.0 SQL*Module
1.1.5.0.0 SQL*Module for C
7.3.4.1.0 Oracle7 JDBC Drivers
3.3.4.0.0 SQL*Plus
2.2.0.5.0 Oracle7 Enterprise Backup Utility
Found rdbms/demo/ocidfn.h
Found rdbms/demo/ocidem.h
Found rdbms/demo/ociapr.h
Found rdbms/demo/ocikpr.h
Found rdbms/demo/oratypes.h
Found header files in rdbms/demo.
Found /usrora/oracle/V734/rdbms/demo/oracle.mk
Found /usrora/oracle/V734/rdbms/demo/oracle.mk
Found /usrora/oracle/V734/otrace/demo/atmoci.mk
Found /usrora/oracle/V734/precomp/demo/proc/proc.mk
Using /usrora/oracle/V734/rdbms/demo/oracle.mk
Reading /usrora/oracle/V734/rdbms/demo/oracle.mk.
Reading /usrora/oracle/V734/rdbms/lib/env_rdbms.mk.
Read a total of 598 lines from /usrora/oracle/V734/rdbms/lib/env_rdbms.mk (including
inclusions)
Read a total of 751 lines from /usrora/oracle/V734/rdbms/demo/oracle.mk (including
inclusions)
Deleted AR definition: AR=ar
Deleted LDFLAGS definition: LDFLAGS =-o $@ $(PRODUCT_LIBHOME) -L$(LIBHOME)
Deleted SHELL definition: SHELL=/bin/sh
Deleted ECHO definition: ECHO = echo
Deleted CHMOD definition: CHMOD = chmod
Deleted CFLAGS definition: CFLAGS= $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS)
$(QACCFLAGS) $(PFLAGS) $(SHARED_CFLAG) $(ENV_FLAGS)
Deleted CCFLAGS definition: CCFLAGS= $(HPCCFLAGS)
Deleted CPP definition: CPP=/usr/ccs/lbin/cpp
Deleted OPTIMIZE definition: OPTIMIZE=$(OPTIMIZE2)
Deleted ASFLAGS definition: ASFLAGS=-c $(HPCCFLAGS)
COMPXANO macro redefined by Oracle
from $(subst -xO2,,$(COMPXA))
to $(subst +O2,,$(COMPXA))
Deleted CC definition: CC=cc
COMPRONO macro redefined by Oracle
from $(subst -xO2,,$(COMPRO))
to $(CC) $(ROFLAGS) $(CDEBUG) $(CCFLAGS) $(PFLAGS) $(MAKERONO)
Deleted LD definition: LD=ld
LDFLAGS macro redefined by Oracle
from -o $@ $(PRODUCT_LIBHOME) -L$(LIBHOME)
to $(OPTIMIZE) +Ostaticprediction -o $@ $(PRODUCT_LIBHOME) -L$(LIBHOME) -L/usr/lib
Deleted LDFLAGS definition: LDFLAGS= $(OPTIMIZE) +Ostaticprediction -o $@
$(PRODUCT_LIBHOME) -L$(LIBHOME) -L/usr/lib
Deleted PERL definition: PERL = perl
SHELL macro redefined by Oracle
from /bin/sh
to /usr/bin/sh
Deleted SHELL definition: SHELL=/usr/bin/sh
Deleting ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data
because it is not already set in the environment
and it can cause ORA-01019 errors.
Deleted ORA_NLS definition: ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data
NTCONTAB macro redefined by Oracle
from ntcontab.c
to $(LIBHOME)/ntcontab.o
LINK macro redefined by Oracle
from ld $(COMPOBJS)
to cc +O2 +Ofastaccess +Oprocelim
OTHERLIBS macro redefined by Oracle
from `cat $(ORACLE_HOME)/rdbms/lib/sysliblist` $(LLAIO)
to `cat $(ORACLE_HOME)/rdbms/lib/sysliblist` $(LLAIO) $(LDSTRING)
DEVTTLIBS macro redefined by Oracle
from $(TTLIBS)
to $(NETLIBS) $(LLIBORA) $(NETLIBS) $(LLIBORA) $(LIBPLSHACK) \
$(LLIBEPC) $(CORELIBS) $(SPLIBS) $(LOCALLIBS) $(EXOSLIBS) \
`cat $(ORACLE_HOME)/rdbms/lib/sysliblist` $(SECLIBS) $(MATHLIB)
LDFLAGS macro redefined by Oracle
from $(OPTIMIZE) +Ostaticprediction -o $@ $(PRODUCT_LIBHOME) -L$(LIBHOME) -L/usr/lib
to -L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib
Deleted LDFLAGS definition: LDFLAGS=-L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib
ECHO macro redefined by Oracle
from echo
to $(ORACLE_HOME)/bin/echodo
Deleted ECHO definition: ECHO=$(ORACLE_HOME)/bin/echodo
Evaluating `cat /usrora/oracle/V734/rdbms/lib/sysliblist`
returned '-l:libcma.sl -lcl -lm -l:libcl.a'
Attempting to discover Oracle OCI build rules...
cc -O -c DBD_ORA_OBJ.c
by executing:
make -f /usrora/oracle/V734/rdbms/demo/oracle.mk build ECHODO=true ECHO=echo
GENCLNTSH='echo genclntsh' CC=echo OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE
OBJS=DBD_ORA_OBJ.o
Oracle oci build command:
echo -L/usrora/oracle/V734/lib -L/usrora/oracle/V734/rdbms/lib -o DBD_ORA_EXE
DBD_ORA_OBJ.o /usrora/oracle/V734/lib/libclient.a -lsqlnet -lncr -lsqlnet -lclient
-lcommon -lgeneric -lsqlnet -lncr -lsqlnet -lclient -lcommon -lgeneric -lepc -lnlsrtl3
-lc3v6 -lcore3 -lnlsrtl3 -lcore3 -lnlsrtl3 -l:libcma.sl -lcl -lm -l:libcl.a -lm
-lcore3 -l:libcma.sl -lcl -lm -l:libcl.a -L/usr/lib
Warning: Stripping -lcl from the link flags, because it
seems to conflict with -l:libcl.a
Warning: Oracle is built with multi-threading libraries
You will most likely need to rebuild perl from sources
with the following libraries: -lcl -lpthread
***
*** Warning: If you have trouble, see README.hpux...
you may have to build your own perl, or go hunting for libraries
***
System: perl5.008 hp-ux l1000 b.11.00 u 9000800 519706537 unlimited-user license
Compiler: cc +O2 +Onolimit -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE
-Wl,+vnocompatwarnings +z
Linker: /usr/bin/ld
Sysliblist: -lcma -lm
Oracle makefiles would have used these definitions but we override them:
CC: cc
CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS)
$(SHARED_CFLAG) $(ENV_FLAGS)
[$(GFLAG) +O2 $(CDEBUG) -Ae -DHPUX +Z -z -DSLXMX_ENABLE -DSLTS_ENABLE
-D_REENTRANT -D_PTHREADS_DRAFT4 +Ofastaccess +Oentrysched +Onolimit +ESlit +Oprocelim
+DAportable +DS2.0 +Ostatic_prediction $(QACCFLAGS) -I/usrora/oracle/V734/rdbms/demo
-I/usrora/oracle/V734/rdbms/public -I. $(LPFLAGS) $(SHARED_CFLAG) $(ENV_FLAGS)]
CLIBS: $(LOCALLIBS) $(EXOSLIBS) $(LIBBSD) $(OTHERLIBS) $(SECLIBS) $(M6LIBS)
[ -l:libcma.sl -lcl -lm -l:libcl.a -L/usr/lib ]
LDFLAGS: -L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib
[-L$(LIBHOME) -L/usrora/oracle/V734/rdbms/lib]
LDSTRING: -L/usr/lib
[-L/usr/lib]
Linking with OTHERLDFLAGS = -L/usrora/oracle/V734/lib -L/usrora/oracle/V734/rdbms/lib
/usrora/oracle/V734/lib/libclient.a -lsqlnet -lncr -lsqlnet -lclient -lcommon
-lgeneric -lsqlnet -lncr -lsqlnet -lclient -lcommon -lgeneric -lepc -lnlsrtl3 -lc3v6
-lcore3 -lnlsrtl3 -lcore3 -lnlsrtl3 -l:libcma.sl -lm -l:libcl.a -lm -lcore3
-l:libcma.sl -lm -l:libcl.a -L/usr/lib [from 'build' rule]
MakeMaker (v6.03)
Checking if your kit is complete...
Looks good
ABSTRACT_FROM => q[Oracle.pm]
AUTHOR => q[Tim Bunce ([EMAIL PROTECTED])]
DEFINE => q[]
DIR => []
EXE_FILES => [q[ora_explain]]
INC => q[-I/usrora/oracle/V734/rdbms/demo -I/usrora/oracle/V734/rdbms/public -I.
-I/usrora/oracle/V734/rdbms/demo -I/usrora/oracle/V734/rdbms/demo
-I/opt/perl5/lib/site_perl/5.8.0/PA-RISC2.0-thread-multi/auto/DBI]
NAME => q[DBD::Oracle]
OBJECT => q[$(O_FILES)]
PREREQ_PM => { DBI=>q[0] }
VERSION_FROM => q[Oracle.pm]
clean => { FILES=>q[Oracle.xsi dll.base dll.exp sqlnet.log libOracle.def ora_explain
mk.pm] }
dist => { DIST_DEFAULT=>q[clean distcheck disttest ci tardist], COMPRESS=>q[gzip
-v9], PREOP=>q[$(MAKE) -f Makefile.old distdir], SUFFIX=>q[gz] }
dynamic_lib => { OTHERLDFLAGS=>q[ -L/usrora/oracle/V734/lib
-L/usrora/oracle/V734/rdbms/lib /usrora/oracle/V734/lib/libclient.a -lsqlnet -lncr
-lsqlnet -lclient -lcommon -lgeneric -lsqlnet -lncr -lsqlnet -lclient -lcommon
-lgeneric -lepc -lnlsrtl3 -lc3v6 -lcore3 -lnlsrtl3 -lcore3 -lnlsrtl3 -l:libcma.sl -lm
-l:libcl.a -lm -lcore3 -l:libcma.sl -lm -l:libcl.a -L/usr/lib] }
Using PERL=/usr/bin/perl
LD_RUN_PATH=/usrora/oracle/V734/lib:/usrora/oracle/V734/rdbms/lib
Using DBD::Oracle 1.12.
Using DBD::Oracle 1.12.
Using DBI 1.32 installed in
/opt/perl5/lib/site_perl/5.8.0/PA-RISC2.0-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 files.
(Of course, you have read README by now anyway, haven't you?)
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp oraperl.ph blib/lib/oraperl.ph
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" <
/opt/perl5/lib/site_perl/5.8.0/PA-RISC2.0-thread-multi/auto/DBI/Driver.xst > Oracle.xsi
/usr/bin/perl /opt/perl5/lib/5.8.0/ExtUtils/xsubpp -typemap
/opt/perl5/lib/5.8.0/ExtUtils/typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
cc -c -I/usrora/oracle/V734/rdbms/demo -I/usrora/oracle/V734/rdbms/public -I.
-I/usrora/oracle/V734/rdbms/demo -I/usrora/oracle/V734/rdbms/demo
-I/opt/perl5/lib/site_perl/5.8.0/PA-RISC2.0-thread-multi/auto/DBI
-D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings +z
+O2 +Onolimit -DVERSION=\"1.12\" -DXS_VERSION=\"1.12\" +Z
"-I/opt/perl5/lib/5.8.0/PA-RISC2.0-thread-multi/CORE" Oracle.c
cc: "Oracle.xs", line 69: warning 604: Pointers are not assignment-compatible.
cc: "Oracle.xs", line 69: warning 563: Argument #1 is not the correct type.
cc: "Oracle.xs", line 79: warning 604: Pointers are not assignment-compatible.
cc: "Oracle.xs", line 79: warning 563: Argument #1 is not the correct type.
cc: "Oracle.xs", line 83: warning 604: Pointers are not assignment-compatible.
cc: "Oracle.xs", line 83: warning 563: Argument #1 is not the correct type.
cc: "Oracle.xs", line 86: warning 604: Pointers are not assignment-compatible.
cc: "Oracle.xs", line 86: warning 563: Argument #1 is not the correct type.
cc -c -I/usrora/oracle/V734/rdbms/demo -I/usrora/oracle/V734/rdbms/public -I.
-I/usrora/oracle/V734/rdbms/demo -I/usrora/oracle/V734/rdbms/demo
-I/opt/perl5/lib/site_perl/5.8.0/PA-RISC2.0-thread-multi/auto/DBI
-D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings +z
+O2 +Onolimit -DVERSION=\"1.12\" -DXS_VERSION=\"1.12\" +Z
"-I/opt/perl5/lib/5.8.0/PA-RISC2.0-thread-multi/CORE" dbdimp.c
cc: "dbdimp.c", line 85: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 327: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 327: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 667: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 667: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 783: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 783: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 785: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 785: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 786: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 786: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 788: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 788: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 851: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 851: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 911: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 911: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 975: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 975: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 985: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 985: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 1034: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 1034: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 1071: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 1071: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 1132: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 1132: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 1179: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 1179: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 1182: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 1182: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 1185: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 1185: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 1186: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 1186: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 1283: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 1283: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 1292: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 1292: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 1300: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 1300: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 1315: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 1315: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 1349: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 1349: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 1375: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 1375: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 1399: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 1399: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 1493: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 1493: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 1578: warning 604: Pointers are not assignment-compatible.
cc: "dbdimp.c", line 1578: warning 563: Argument #1 is not the correct type.
cc: "dbdimp.c", line 1935: warning 604: Pointers are not assignment-compatible.
cc -c -I/usrora/oracle/V734/rdbms/demo -I/usrora/oracle/V734/rdbms/public -I.
-I/usrora/oracle/V734/rdbms/demo -I/usrora/oracle/V734/rdbms/demo
-I/opt/perl5/lib/site_perl/5.8.0/PA-RISC2.0-thread-multi/auto/DBI
-D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings +z
+O2 +Onolimit -DVERSION=\"1.12\" -DXS_VERSION=\"1.12\" +Z
"-I/opt/perl5/lib/5.8.0/PA-RISC2.0-thread-multi/CORE" oci7.c
cc: "oci7.c", line 107: warning 604: Pointers are not assignment-compatible.
cc: "oci7.c", line 107: warning 563: Argument #1 is not the correct type.
cc: "oci7.c", line 115: warning 604: Pointers are not assignment-compatible.
cc: "oci7.c", line 115: warning 563: Argument #1 is not the correct type.
cc: "oci7.c", line 286: warning 604: Pointers are not assignment-compatible.
cc: "oci7.c", line 286: warning 563: Argument #1 is not the correct type.
cc: "oci7.c", line 333: warning 604: Pointers are not assignment-compatible.
cc: "oci7.c", line 333: warning 563: Argument #1 is not the correct type.
cc: "oci7.c", line 353: warning 604: Pointers are not assignment-compatible.
cc: "oci7.c", line 353: warning 563: Argument #1 is not the correct type.
cc: "oci7.c", line 363: warning 604: Pointers are not assignment-compatible.
cc: "oci7.c", line 363: warning 563: Argument #1 is not the correct type.
cc: "oci7.c", line 444: warning 604: Pointers are not assignment-compatible.
cc: "oci7.c", line 444: warning 563: Argument #1 is not the correct type.
cc: "oci7.c", line 529: warning 604: Pointers are not assignment-compatible.
cc: "oci7.c", line 529: warning 563: Argument #1 is not the correct type.
cc -c -I/usrora/oracle/V734/rdbms/demo -I/usrora/oracle/V734/rdbms/public -I.
-I/usrora/oracle/V734/rdbms/demo -I/usrora/oracle/V734/rdbms/demo
-I/opt/perl5/lib/site_perl/5.8.0/PA-RISC2.0-thread-multi/auto/DBI
-D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings +z
+O2 +Onolimit -DVERSION=\"1.12\" -DXS_VERSION=\"1.12\" +Z
"-I/opt/perl5/lib/5.8.0/PA-RISC2.0-thread-multi/CORE" oci8.c
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.sl
LD_RUN_PATH="/usrora/oracle/V734/lib:/usrora/oracle/V734/rdbms/lib"
/usr/bin/ld -b +vnocompatwarnings -L/usr/local/lib +s Oracle.o dbdimp.o oci7.o
oci8.o -L/usrora/oracle/V734/lib -L/usrora/oracle/V734/rdbms/lib
/usrora/oracle/V734/lib/libclient.a -lsqlnet -lncr -lsqlnet -lclient -lcommon
-lgeneric -lsqlnet -lncr -lsqlnet -lclient -lcommon -lgeneric -lepc -lnlsrtl3 -lc3v6
-lcore3 -lnlsrtl3 -lcore3 -lnlsrtl3 -l:libcma.sl -lm -l:libcl.a -lm -lcore3
-l:libcma.sl -lm -l:libcl.a -L/usr/lib -o blib/arch/auto/DBD/Oracle/Oracle.sl
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.sl
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/man3/DBD::Oracle.3
Manifying blib/man1/ora_explain.1
Manifying blib/man3/DBD::Oraperl.3
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(1, 'blib/lib', 'blib/arch')" t/*.t
t/base.......1..5
ok 1
ok 2
ok 3
ok 4
ok 5
ok
t/general....DBI
connect('','luch/upls@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=L1000)(PORT=1521))(CONNECT_DATA=(SID=GCAB)))',...)
failed: ORA-12157: TNS:erreur interne de communication du r�seau (DBD: login failed)
at t/general.t line 21
Unable to connect to Oracle (ORA-12157: TNS:erreur interne de communication du r�seau
(DBD: login failed))
Tests skiped.
1..0
skipped
all skipped: no reason given
t/long.......Unable to connect to Oracle (ORA-12157: TNS:erreur interne de
communication du r�seau (DBD: login failed))
Tests skiped.
1..0
skipped
all skipped: no reason given
t/ph_type....DBI connect('','luch/upls',...) failed: ORA-12157: TNS:erreur interne de
communication du r�seau (DBD: login failed) at t/ph_type.t line 24
Unable to connect to Oracle (ORA-12157: TNS:erreur interne de communication du r�seau
(DBD: login failed))
Tests skipped.
1..0
skipped
all skipped: no reason given
t/plsql......Unable to connect to Oracle (ORA-12157: TNS:erreur interne de
communication du r�seau (DBD: login failed))
Tests skiped.
1..0
skipped
all skipped: no reason given
t/reauth.....ORACLE_USERID_2 not defined.
Tests skiped.
1..0
skipped
all skipped: no reason given
All tests successful, 5 tests skipped.
Files=6, Tests=5, 2 wallclock secs ( 1.52 cusr + 0.14 csys = 1.66 CPU)
PERL_DL_NONLAZY=1 /usr/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl
Oraperl test application $Revision: 1.4 $
dump() better written as CORE::dump() at
/sweb/applis/DBD-Oracle-1.12/blib/lib/Oraperl.pm line 80.
Oraperl emulation interface version 1.41
DBD::Oracle 1.12 using OCI7 by Tim Bunce
DBI 1.32 by Tim Bunce
Data sources:
dbi:Oracle:GCAB
dbi:Oracle:Gestion
dbi:Oracle:L1000
Connecting
to '' (from command line, else uses ORACLE_SID or TWO_TASK - recommended)
as 'luch/upls' (via ORACLE_USERID env var or default - recommend name/passwd@dbname)
(ORACLE_SID='GCAB', TWO_TASK='')
ora_login: 12157: ORA-12157: TNS:erreur interne de communication du r�seau (DBD: login
failed)
Generally set TWO_TASK or ORACLE_SID but not both at the same time.
Try to connect to the database using an oracle tool like sqlplus
only if that works should you suspect problems with DBD::Oracle.
Try leaving dbname value empty and set dbuser to name/passwd@dbname.
Test aborted.
*** Error exit code 255
Stop.
______________________________________________________
== my system
[L1000]/tmp# uname -a
HP-UX L1000 B.11.00 U 9000/800 519706537 unlimited-user license
**************
== Oracle version
Oracle7 Server Release 7.3.4.1.0 - Production
With the parallel query option
SQL*Plus: Release 3.3.4.0.0 - Production on Mon Feb 10 12:46:00 2003
PL/SQL Release 2.3.4.1.0 - Production
***************
== perl version installed
perl-5.8.0
[L1000]/tmp# sh Configure -Dusethreads -A prepend:libswanted='cl pthread '
[L1000]/tmp# perl -V
Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration:
Platform:
osname=hpux, osvers=11.00, archname=PA-RISC2.0-thread-multi
uname='hp-ux l1000 b.11.00 u 9000800 519706537 unlimited-user license '
config_args='-A prepend:libswanted=cl pthread -Dusethreads'
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define usemultiplicity=define
useperlio=define d_sfio=undef uselargefiles=undef usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='cc', ccflags ='-D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings +z',
optimize='+O2 +Onolimit',
cppflags='-Aa -D__STDC_EXT__ -D_HPUX_SOURCE -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings'
ccversion='B.11.11.02', gccversion='', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=4
alignbytes=8, prototype=define
Linker and Libraries:
ld='/usr/bin/ld', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib
libs=-lcl -lpthread -lnsl -lnm -lndbm -lmalloc -ldld -lm -lc -lndir -lcrypt -lsec
perllibs=-lcl -lpthread -lnsl -lnm -lmalloc -ldld -lm -lc -lndir -lcrypt -lsec
libc=/lib/libc.sl, so=sl, useshrplib=false, libperl=libperl.a
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_hpux.xs, dlext=sl, d_dlsymun=undef, ccdlflags='-Wl,-E -Wl,-B,deferred '
cccdlflags='+Z', lddlflags='-b +vnocompatwarnings -L/usr/local/lib +s'
Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY USE_ITHREADS PERL_IMPLICIT_CONTEXT
Built under hpux
Compiled at Feb 10 2003 11:18:08
@INC:
/opt/perl5/lib/5.8.0/PA-RISC2.0-thread-multi
/opt/perl5/lib/5.8.0
/opt/perl5/lib/site_perl/5.8.0/PA-RISC2.0-thread-multi
/opt/perl5/lib/site_perl/5.8.0
/opt/perl5/lib/site_perl
.
**************
== DBI version
DBI-1.32
**************
== DBD-Oracle version
DBD-Oracle-1.12
[L1000]/tmp# perl Makefile.PL -m /usrora/oracle/V734/rdbms/demo/oracle.mk
[L1000]/tmp# make
[L1000]/tmp# ORACLE_USERID=scott/tiger; export ORACLE_USERID
== make test with error messages
[L1000]/tmp# make test
/usr/bin/perl /opt/perl5/lib/5.8.0/ExtUtils/xsubpp -typemap /opt/perl5/lib/5.8.0/ExtUtils/typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
cc -c -I/usrora/oracle/V734/rdbms/demo -I/usrora/oracle/V734/rdbms/public -I. -I/usrora/oracle/V734/rdbms/demo -I/usrora/oracle/V734/rdbms/demo -I/opt/perl5/lib/site_perl/5.8.0/PA-RISC2.0-thread-multi/auto/DBI -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings +z +O2 +Onolimit -DVERSION=\"1.12\" -DXS_VERSION=\"1.12\" +Z "-I/opt/perl5/lib/5.8.0/PA-RISC2.0-thread-
multi/CORE" Oracle.c
cc: "Oracle.xs", line 69: warning 604: Pointers are not assignment-compatible.
cc: "Oracle.xs", line 69: warning 563: Argument #1 is not the correct type.
cc: "Oracle.xs", line 79: warning 604: Pointers are not assignment-compatible.
cc: "Oracle.xs", line 79: warning 563: Argument #1 is not the correct type.
cc: "Oracle.xs", line 83: warning 604: Pointers are not assignment-compatible.
cc: "Oracle.xs", line 83: warning 563: Argument #1 is not the correct type.
cc: "Oracle.xs", line 86: warning 604: Pointers are not assignment-compatible.
cc: "Oracle.xs", line 86: warning 563: Argument #1 is not the correct type.
rm -f blib/arch/auto/DBD/Oracle/Oracle.sl
LD_RUN_PATH="/usrora/oracle/V734/lib:/usrora/oracle/V734/rdbms/lib" /usr/bin/ld -b +vnocompatwarnings -L/usr/local/lib +s Oracle.o dbdimp.o oci7.o oci8.o -L/usrora/oracle/V734/lib -L/usrora/oracle/V734/rdbms/lib /usrora/oracle/V734/lib/libclient.a -lsqlnet -lncr -lsqlnet -lclient -lcommon -lgeneric -lsqlnet -lncr -lsqlnet -lclient -lcommon -lgeneric -lepc -lnlsrtl3 -lc3v6 -lcore3 -lnlsrtl3 -lcore3 -lnlsrtl3 -l:libcma.sl -lm -l:libcl.a -lm -lcore3 -l:libcma.sl -lm -l:libcl.a -L/usr/lib -o blib/arch/auto/DBD/Oracle/Oracle.sl
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.sl
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/base.......ok
t/general....DBI connect('','scott/tiger',...) failed: ORA-12157: TNS:erreur interne de communication du r�seau (DBD: login failed) at t/general.t line 20
Unable to connect to Oracle (ORA-12157: TNS:erreur interne de communication du r�seau (DBD: login failed))
Tests skiped.
skipped
all skipped: no reason given
t/long.......Unable to connect to Oracle (ORA-12157: TNS:erreur interne de communication du r�seau (DBD: login failed))
Tests skiped.
skipped
all skipped: no reason given
t/ph_type....DBI connect('','scott/tiger',...) failed: ORA-12157: TNS:erreur interne de communication du r�seau (DBD: login failed) at t/ph_type.t line 24
Unable to connect to Oracle (ORA-12157: TNS:erreur interne de communication du r�seau (DBD: login failed))
Tests skipped.
skipped
all skipped: no reason given
t/plsql......Unable to connect to Oracle (ORA-12157: TNS:erreur interne de communication du r�seau (DBD: login failed))
Tests skiped.
skipped
all skipped: no reason given
t/reauth.....skipped
all skipped: no reason given
All tests successful, 5 tests skipped.
Files=6, Tests=5, 2 wallclock secs ( 1.51 cusr + 0.14 csys = 1.65 CPU)
PERL_DL_NONLAZY=1 /usr/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl
Oraperl test application $Revision: 1.4 $
dump() better written as CORE::dump() at /sweb/applis/DBD-
Oracle-1.12/blib/lib/Oraperl.pm line 80.
Oraperl emulation interface version 1.41
DBD::Oracle 1.12 using OCI7 by Tim Bunce
DBI 1.32 by Tim Bunce
Data sources:
dbi:Oracle:GCAB
dbi:Oracle:Gestion
dbi:Oracle:L1000
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@dbname)
(ORACLE_SID='GCAB', TWO_TASK='')
ora_login: 12157: ORA-12157: TNS:erreur interne de communication du r�seau (DBD: login failed)
Generally set TWO_TASK or ORACLE_SID but not both at the same time.
Try to connect to the database using an oracle tool like sqlplus
only if that works should you suspect problems with DBD::Oracle.
Try leaving dbname value empty and set dbuser to name/passwd@dbname.
Test aborted.
*** Error exit code 255
Stop.
**************
== second test with @DB added and there the the Oracle error message changes
[L1000]/tmp# ORACLE_USERID=scott/tiger@l1000; export ORACLE_USERID
[L1000]/tmp# make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/base.......ok
t/general....DBI connect('','scott/tiger@l1000',...) failed: ORA-12154: TNS:l'adresse symbolique n'a pas pu �tre r�solue (DBD: login failed) at t/general.t line 20
Unable to connect to Oracle (ORA-12154: TNS:l'adresse symbolique n'a pas pu �tre r�solue (DBD: login failed))
Tests skiped.
skipped
all skipped: no reason given
t/long.......Unable to connect to Oracle (ORA-12154: TNS:l'adresse symbolique n'a pas pu �tre r�solue (DBD: login failed))
Tests skiped.
skipped
all skipped: no reason given
t/ph_type....DBI connect('','scott/tiger@l1000',...) failed: ORA-12154: TNS:l'adresse symbolique n'a pas pu �tre r�solue (DBD: login failed) at t/ph_type.t line 24
Unable to connect to Oracle (ORA-12154: TNS:l'adresse symbolique n'a pas pu �tre r�solue (DBD: login failed))
Tests skipped.
skipped
all skipped: no reason given
t/plsql......Unable to connect to Oracle (ORA-12154: TNS:l'adresse symbolique n'a pas pu �tre r�solue (DBD: login failed))
Tests skiped.
skipped
all skipped: no reason given
t/reauth.....skipped
all skipped: no reason given
All tests successful, 5 tests skipped.
Files=6, Tests=5, 2 wallclock secs ( 1.54 cusr + 0.11 csys = 1.65 CPU)
PERL_DL_NONLAZY=1 /usr/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl
Oraperl test application $Revision: 1.4 $
dump() better written as CORE::dump() at /sweb/applis/DBD-
Oracle-1.12/blib/lib/Oraperl.pm line 80.
Oraperl emulation interface version 1.41
DBD::Oracle 1.12 using OCI7 by Tim Bunce
DBI 1.32 by Tim Bunce
Data sources:
dbi:Oracle:GCAB
dbi:Oracle:Gestion
dbi:Oracle:L1000
Connecting
to '' (from command line, else uses ORACLE_SID or TWO_TASK - recommended)
as 'scott/tiger@l1000' (via ORACLE_USERID env var or default - recommend name/passwd@dbname)
(ORACLE_SID='GCAB', TWO_TASK='')
ora_login: 12154: ORA-12154: TNS:l'adresse symbolique n'a pas pu �tre r�solue (DBD: login failed)
Generally set TWO_TASK or ORACLE_SID but not both at the same time.
Try to connect to the database using an oracle tool like sqlplus
only if that works should you suspect problems with DBD::Oracle.
Try leaving dbname value empty and set dbuser to name/passwd@dbname.
Test aborted.
*** Error exit code 255
Stop.
**************
== these are my test connections to Oracle with "sqlplus"
[L1000]/tmp# sqlplus scott/tiger
SQL*Plus: Release 3.3.4.0.0 - Production on Mon Feb 10 13:10:10 2003
Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
Connect� �:
Oracle7 Server Release 7.3.4.1.0 - Production
With the parallel query option
PL/SQL Release 2.3.4.1.0 - Production
SQL> D�connect� de Oracle7 Server Release 7.3.4.1.0 - Production
With the parallel query option
PL/SQL Release 2.3.4.1.0 - Production
-or-
[L1000]/tmp# sqlplus scott/tiger@l1000
SQL*Plus: Release 3.3.4.0.0 - Production on Mon Feb 10 13:10:32 2003
Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
Connect� �:
Oracle7 Server Release 7.3.4.1.0 - Production
With the parallel query option
PL/SQL Release 2.3.4.1.0 - Production
SQL> D�connect� de Oracle7 Server Release 7.3.4.1.0 - Production
With the parallel query option
PL/SQL Release 2.3.4.1.0 - Production
**************
== here i tested the connexion with some variations found in:
DBD-Oracle-1.12/Oracle.pm
my $dbh = DBI->connect('dbi:Oracle:host=L1000;sid=GCAB;port=1521', 'scott/tiger', '');
DBI connect('host=L1000;sid=GCAB;port=1521','scott/tiger',...) failed: ORA-12157: TNS:erreur interne de communication du r�seau (DBD: login failed) at t/general.t line 21
Unable to connect to Oracle (ORA-12157: TNS:erreur interne de communication du r�seau (DBD: login failed))
Tests skiped.
skipped
all skipped: no reason given
-or-
my $dbh = DBI->connect('dbi:Oracle:', q{scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=L1000)(PORT=1521))
(CONNECT_DATA=(SID=GCAB)))}, '');
DBI connect('','scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=L1000)
(PORT=1521))(CONNECT_DATA=(SID=GCAB)))',...) failed: ORA-12157: TNS:erreur interne de communication du r�seau (DBD: login failed) at t/general.t line 21
Unable to connect to Oracle (ORA-12157: TNS:erreur interne de communication du r�seau (DBD: login failed))
Tests skiped.
skipped
all skipped: no reason given
**************
== her is the trace in the sqlnet.log file
***********************************************************************
Fatal OSN connect error 12157, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/usrora/oracle/V734/bin/oracle)
(ARGV0=oracleGCAB)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=L1000)(USER=root))))
VERSION INFORMATION:
TNS for HPUX: Version 2.3.4.0.0 - Production
Time: 10-FEV-03 13:20:21
Tracing not turned on.
