The account that is locked is the Oracle account, not the Unix account. It is probably trying to use the "default" Oracle account scott/tiger, unless you set ORACLE_USERID environment variable differently. Read the README file for instructions on how to change the Oracle credentials for testing.
- Philip -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 12, 2007 5:40 PM To: [email protected] Subject: DBD::Oracle installation - make test failed - ORA-28000: accout locked 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
