Hi, gurus,
I'm trying to install the DBD::Oracle module for the Perl 5.8.8 I just
installed on Solaris9/Sparc. The 'perl Makefile.PL' and the 'make'
part looks fine, because I saw this following message:
Checking if your kit is complete...
Looks good
LD_RUN_PATH=/u01/oracle/product/10.2.0/lib32:/u01/oracle/product/
10.2.0/rdbms/lib32
Using DBD::Oracle 1.19.
Using DBD::Oracle 1.19.
Using DBI 1.56 (for perl 5.008008 on sun4-solaris) installed in /usr/
local/lib/perl5/site_perl/5.8.8/sun4-solaris/
auto/DBI/
Writing Makefile for DBD::Oracle
BUT, when I do 'make test', it seems to be failed start from the
beginning of the test. The ORA-28000 error means the account
permission denied or locked. I'm confused, I'm running the make under
root account.
Could anybody point out what I could do to fix this?
TIA,
Alan
The following is the test result:
# make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/
*.t
t/
01base................ok
t/10general.............DBI connect('','scott/tiger',...) failed:
ORA-28000: the account is locked (DBD ERROR: OCI
SessionBegin) at t/10general.t line 18
Undefined subroutine &main::BAILOUT called at t/10general.t line 21.
# Looks like your test died before it could output anything.
t/
10general.............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-33
Failed 33/33 tests, 0.00% okay
t/15nls.................DBI connect('','scott/tiger',...) failed:
ORA-28000: the account is locked (DBD ERROR: OCI
SessionBegin) at t/15nls.t line 19
t/
15nls.................ok
9/9 skipped: Unable to connect to Oracle (ORA-28000: the
account is locked (DBD ERROR: OCISessionBegin))
t/20select..............Unable to connect to Oracle (ORA-28000: the
account is locked (DBD ERROR: OCISessionBegin)
)
Tests skiped.
skipped
all skipped: no reason given
t/21nchar...............DBI connect('','scott/tiger',...) failed:
ORA-28000: the account is locked (DBD ERROR: OCI
SessionBegin) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/22nchar_al32utf8......DBI connect('','scott/tiger',...) failed:
ORA-28000: the account is locked (DBD ERROR: OCI
SessionBegin) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/22nchar_utf8..........DBI connect('','scott/tiger',...) failed:
ORA-28000: the account is locked (DBD ERROR: OCI
SessionBegin) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/23wide_db.............DBI connect('','scott/tiger',...) failed:
ORA-28000: the account is locked (DBD ERROR: OCI
SessionBegin) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/23wide_db_8bit........DBI connect('','scott/tiger',...) failed:
ORA-28000: the account is locked (DBD ERROR: OCI
SessionBegin) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/23wide_db_al32utf8....DBI connect('','scott/tiger',...) failed:
ORA-28000: the account is locked (DBD ERROR: OCI
SessionBegin) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/24implicit_utf8.......DBI connect('','scott/tiger',...) failed:
ORA-28000: the account is locked (DBD ERROR: OCI
SessionBegin) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/25plsql...............Unable to connect to Oracle (ORA-28000: the
account is locked (DBD ERROR: OCISessionBegin)
)
Tests skiped.
skipped
all skipped: no reason given
t/26exe_array...........ok 1/14DBI connect('','scott/tiger',...)
failed: ORA-28000: the account is locked (DBD ERR
OR: OCISessionBegin) at t/26exe_array.t line 28
# Looks like you planned 14 tests but only ran 1.
# Looks like your test died just after 1.
t/
26exe_array...........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-14
Failed 13/14 tests, 7.14% okay
t/30long................DBI connect('','scott/tiger',...) failed:
ORA-28000: the account is locked (DBD ERROR: OCI
SessionBegin) at t/nchar_test_lib.pl line 156
Can't connect to database: ORA-28000: the account is locked (DBD
ERROR: OCISessionBegin)
# Looks like your test died before it could output anything.
t/
30long................dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-470
Failed 470/470 tests, 0.00% okay
t/31lob.................DBI connect('','scott/tiger',...) failed:
ORA-28000: the account is locked (DBD ERROR: OCI
SessionBegin) at t/nchar_test_lib.pl line 156
You tried to plan twice! Second plan at t/31lob.t line 16
# Looks like your test died before it could output anything.
t/
31lob.................dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/40ph_type.............DBI connect('','scott/tiger',...) failed:
ORA-28000: the account is locked (DBD ERROR: OCI
SessionBegin) at t/40ph_type.t line 29
Unable to connect to Oracle (ORA-28000: the account is locked (DBD
ERROR: OCISessionBegin))
Tests skipped.
skipped
all skipped: no reason given
t/50cursor..............Unable to connect to Oracle as scott/tiger
(ORA-28000: the account is locked (DBD ERROR: O
CISessionBegin))
Tests skipped.
skipped
all skipped: no reason given
t/55nested..............Unable to connect to Oracle as scott/tiger
(ORA-28000: the account is locked (DBD ERROR: O
CISessionBegin))
Tests skipped.
skipped
all skipped: no reason given
t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped.
skipped
all skipped: no reason given
t/70meta................Unable to connect to Oracle as scott/tiger
(ORA-28000: the account is locked (DBD ERROR: O
CISessionBegin))
Tests skipped.
skipped
all skipped: no reason given
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/10general.t 255 65280 33 66 200.00% 1-33
t/26exe_array.t 255 65280 14 26 185.71% 2-14
t/30long.t 255 65280 470 940 200.00% 1-470
t/31lob.t 255 65280 9 18 200.00% 1-9
14 tests and 9 subtests skipped.
Failed 4/20 test scripts, 80.00% okay. 525/540 subtests failed, 2.78%
okay.
make: *** [test_dynamic] Error 29
