Hello there
I am pretty new in the Linux area and I am trying to install DBD:Oracle
on this platform. It tries to reach a 9i database (all tests were
directed to 9i on Linux and/or win2k).
I can connect directly in sqlplus to the remote platform as well as to
the local one.
Thank you for your help.
I posted a small amount of output, i could post more in case I omitted
relevant facts.
Regards, Radu Caulea
Some output of the compilation is here:
--- test sqlplus
sqlplus [EMAIL PROTECTED]
SQL*Plus: Release 9.2.0.1.0 - Production on Ma Dec 3 21:46:39 2002
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL>
COUNT(*)
----------
63
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 -
Production
---
[root@zebra root]# perl -v
This is perl, v5.8.0 built for i386-linux-thread-multi
---
---
Running 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('','[EMAIL PROTECTED]',...) failed:
ORA-00604: error
occurred at recursive SQL level 1
ORA-00922: missing or invalid option (DBD ERROR: OCISessionBegin) at
t/general.t line 20
Unable to connect to Oracle (ORA-00604: error occurred at recursive SQL
level 1
ORA-00922: missing or invalid option (DBD ERROR: OCISessionBegin))
Tests skiped.
---
All tests successful, 5 tests skipped.
Files=6, Tests=5, 2 wallclock secs ( 0.82 cusr + 0.11 csys = 0.93
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
/root/.cpan/build/DBD-Oracle-1.12/blib/lib/Oraperl.pm line 80.
Oraperl emulation interface version 1.41
DBD::Oracle 1.12 using OCI8 by Tim Bunce
DBI 1.32 by Tim Bunce
Data sources:
dbi:Oracle:EXTPROC_CONNECTION_DATA
dbi:Oracle:GATE.TAFORA
dbi:Oracle:INST1_HTTP
Connecting
to '' (from command line, else uses ORACLE_SID or TWO_TASK -
recommended)
as '[EMAIL PROTECTED]' (via ORACLE_USERID env var or default -
recommend name/passwd@dbname)
(ORACLE_SID='aleph', TWO_TASK='')
ora_login: 604: ORA-00604: error occurred at recursive SQL level 1
ORA-00911: invalid character (DBD ERROR: OCISessionBegin)
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.
make: *** [test_dynamic] Error 255
/usr/bin/make test -- NOT OK
Running make install
make test had returned bad status, won't install without force
Radu Caulea, TAFORA
Senior Oracle Consultant
www.tafora.fr
