For background info:
It's a Sun Solaris 2.6 with perl 5.005_03 installed, and DBI 1.29 installed
successfully.
The is an oracle client installed and up on the machine.
Since the Oracle client is version 8.0.5 I had to comment out the two lines in
oci8.c to get perl Makefile.PL to work.
The environment has ORACLE_HOME=/foa2/app/oracle/product/8.0.5
and ORACLE_SID=kms_prod
which I am positive that both are correct.
You can use sqlplus on the machine to successfully connect to the database.
Here is the output I'm getting from make test
PERL_DL_NONLAZY=1 /web/perl/5.005_03/bin/perl -Iblib/arch -Iblib/lib
-I/web/perl/5.005_03/lib/sun4-solaris -I/web/perl/5.005_03/lib -e 'use Test::Harness
qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/base..............ok
t/general...........DBI->connect() failed: ORA-01034: ORACLE not available (DBD ERROR:
OCISessionBegin) at t/general.t line 20
Unable to connect to Oracle (ORA-01034: ORACLE not available (DBD ERROR:
OCISessionBegin))
Tests skiped.
skipping test on this platform
t/long..............Unable to connect to Oracle (ORA-01034: ORACLE not available (DBD
ERROR: OCISessionBegin))
Tests skiped.
skipping test on this platform
t/ph_type...........DBI->connect() failed: ORA-01034: ORACLE not available (DBD ERROR:
OCISessionBegin) at t/ph_type.t line 24
Unable to connect to Oracle (ORA-01034: ORACLE not available (DBD ERROR:
OCISessionBegin))
Tests skipped.
skipping test on this platform
t/plsql.............Unable to connect to Oracle (ORA-01034: ORACLE not available (DBD
ERROR: OCISessionBegin))
Tests skiped.
skipping test on this platform
t/reauth............skipping test on this platform
All tests successful, 5 tests skipped.
Files=6, Tests=5, 2 wallclock secs ( 1.49 cusr + 0.47 csys = 1.96 CPU)
PERL_DL_NONLAZY=1 /web/perl/5.005_03/bin/perl -Iblib/arch -Iblib/lib
-I/web/perl/5.005_03/lib/sun4-solaris -I/web/perl/5.005_03/lib test.pl
Oraperl test application $Revision: 1.4 $
Oraperl emulation interface version 1.41
DBD::Oracle 1.12 using OCI8 by Tim Bunce
DBI 1.29 by Tim Bunce
Data sources:
dbi:Oracle:CARES
dbi:Oracle:CARESLIVE
dbi:Oracle:CARESTEST
dbi:Oracle:DNS
dbi:Oracle:DNSdev
dbi:Oracle:DNSdev2
dbi:Oracle:DNSqa
dbi:Oracle:DNSstage
dbi:Oracle:EKNOWS1
dbi:Oracle:EXTPROC_CONNECTION_DATA
dbi:Oracle:IADBJOB
dbi:Oracle:IADEV
dbi:Oracle:IADEVJOB
dbi:Oracle:IAPROD
dbi:Oracle:KMS_DEV
dbi:Oracle:KMS_DEVL
dbi:Oracle:KMS_PROD
dbi:Oracle:KMS_SNAP
dbi:Oracle:KMS_TEST
dbi:Oracle:KMS_TRG
dbi:Oracle:KMS_TST
dbi:Oracle:PSPMT
dbi:Oracle:WNKNOWS
dbi:Oracle:Y2K1_BEQ
dbi:Oracle:ardev
dbi:Oracle:ddev
dbi:Oracle:wcase8i
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='kms_prod', TWO_TASK='')
ora_login: 1034: ORA-01034: ORACLE not available (DBD ERROR: OCISessionBegin)
ORACLE_SID or TWO_TASK possibly not right, or server not running.
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
Also, if you set ORACLE_USERID=readonly@kms_prod/readonly in the environment you see
basically the same output only the Oracle error changes to ORA: 12154 Unable to
resolve service name.
There is a cold fusion server successfully using this oracle client, and it is a
product db that I'm sure is up and accessible, so I'm really looking for some
direction in what else to try.
Thanks!
Jennifer
