On Jun 20, 6:45 am, [EMAIL PROTECTED] (John Scoles) wrote:
> We can add that to the ReadMEs or as a warning in the test.
>
> I do not see a place for it in the POD though.
>
> You have any preferance??
>
> True this does seem to crop up from time to time on the list but people
> usually figure it out quite quickly.
>
> Cheers
>
>
>
> ----- Original Message -----
> From: "Paul Gallagher" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, June 19, 2007 11:56 PM
> Subject: Re: DBD::Oracle installation - make test failed - ORA-28000: accout
> locked
>
> > the scott/tiger account has been locked on installation as a default
> > since some versions ago.
>
> > it maybe you just need to make sure the account is unlocked before
> > running the test.
>
> > sqlplus scott/tiger
>
> > if you cannot get in, do an "update user scott account unlock"
>
> > regards,
> > paul
> > On 6/13/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >> 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- Hide quoted text -
>
> - Show quoted text -
Thanks for all your replies. I've successfully installed DBD::Oracle
by skipping a test as John suggested and also assigning the Oracle
environment variables manually.
Alan
