Thanks, Philip. I was eventually aware of that while I was reading the README. I then set the ORACLE_USERID to a valid Oracle account, and a 'make realclean' before I start the whole installation over. Most of the tests went OK but I still got two (and only two) other tests failed:
# 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.............NOK 1 # Failed test 'system exit 1 should return 256' # in t/10general.t at line 31. # got: '-1' # expected: '256' t/10general.............NOK 2 # Failed test 'system exit 0 should return 0' # in t/10general.t at line 32. # got: '-1' # expected: '0' t/10general.............ok 13/33# Looks like you failed 2 tests of 33. t/ 10general.............dubious Test returned status 2 (wstat 512, 0x200) DIED. FAILED tests 1-2 Failed 2/33 tests, 93.94% okay ...... ...... Failed Test Stat Wstat Total Fail Failed List of Failed ------------------------------------------------------------------------------- t/10general.t 2 512 33 2 6.06% 1-2 4 tests and 122 subtests skipped. Failed 1/20 test scripts, 95.00% okay. 2/1925 subtests failed, 99.90% okay. make: *** [test_dynamic] Error 29 And the output of 'perl Makefile.PL', 'make', and 'perl -V' as suggested in the README: ################### # perl Makefile.PL 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/ Configuring DBD::Oracle for perl 5.008008 on solaris (sun4-solaris) Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /u01/oracle/product/10.2.0 DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR) Oracle version 10.2.0.1 (10.2) Found /u01/oracle/product/10.2.0/rdbms/demo/demo_rdbms.mk Using /u01/oracle/product/10.2.0/rdbms/demo/demo_rdbms.mk Your LD_LIBRARY_PATH env var is set to ':/usr/lib:/usr/openwin/lib:/ opt/hpnp/lib:/usr/local/sir40:/u01/oracle/product/10.2.0/lib32' Reading /u01/oracle/product/10.2.0/rdbms/demo/demo_rdbms.mk Reading /u01/oracle/product/10.2.0/rdbms/lib/env_rdbms.mk Attempting to discover Oracle OCI build rules gcc -c -o DBD_ORA_OBJ.o DBD_ORA_OBJ.c by executing: [make -f /u01/oracle/product/10.2.0/rdbms/demo/ demo_rdbms.mk build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=true OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o] Oracle oci build command: [true -xarch=v9 -L/u01/oracle/product/10.2.0/lib/ -L/u01/ oracle/product/10.2.0/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o - lclntsh `cat /u01/oracle/product/10.2.0/lib/sysliblist` -R/u01/ oracle/product/10.2.0/lib -laio -lposix4 -lkstat -lm -lthread - lpthread] Found header files in /u01/oracle/product/10.2.0/rdbms/public. Checking for functioning wait.ph System: perl5.008008 sunos 5.9 generic sun4u sparc sunw,ultra-5_10 solaris Compiler: gcc -O -fno-strict-aliasing -pipe -Wdeclaration-after- statement -I/usr/local/include -D_LARGEFILE_SOURCE - D_FILE_OFFSET_BITS=64 Linker: /usr/local/bin/ld Sysliblist: -lkstat -lnsl -lsocket -lgen -ldl -lsched Oracle makefiles would have used these definitions but we override them: CC: cc CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\ $(SHARED_CFLAG) $(USRFLAGS) [$(GFLAG) -xO3 $(CDEBUG) -Xa $(PROFILE) -xstrconst -dalign - xF $(XS) $(MR) -xildoff -errtags=yes -v -xarch=v9 -xchip=ultra3 -W2,- AKNR_S -Wd,-xsafe=unboundsym -Wc,-Qiselect-funcalign=32 -xcode=abs44 - Wc,-Qgsched-trace_late=1 -Wc,-Qgsched-T5 -xalias_level=weak - D_REENTRANT -DSS_64BIT_SERVER -DBIT64 -DMACHINE64 -K PIC -I/u01/oracle/ product/10.2.0/rdbms/demo -I/u01/oracle/product/10.2.0/rdbms/public -I/ u01/oracle/product/10.2.0/plsql/public -I/u01/oracle/product/10.2.0/ network/public -DSLMXMX_ENABLE -DSLTS_ENABLE -D_SVID_GETTOD - D_REENTRANT $(LPFLAGS) $(USRFLAGS)] LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) [-o $@ -L/u01/oracle/product/10.2.0/rdbms/lib/ -L$ (LIBHOME)] Linking with OTHERLDFLAGS = -xarch=v9 -L/u01/oracle/product/10.2.0/ lib/ -L/u01/oracle/product/10.2.0/rdbms/lib/ -lclntsh `cat /u01/ oracle/product/10.2.0/lib/sysliblist` -R/u01/oracle/product/10.2.0/lib -laio -lposix4 -lkstat -lm -lthread -lpthread [from 'build' rule] WARNING: If you have problems you may need to rebuild perl with threading enabled. 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 *** If you have problems... read all the log printed above, and the README and README.help.txt files. (Of course, you have read README by now anyway, haven't you?) ################################# # make cp Oracle.pm blib/lib/DBD/Oracle.pm cp mkta.pl blib/lib/DBD/mkta.pl cp oraperl.ph blib/lib/oraperl.ph cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h cp Oraperl.pm blib/lib/Oraperl.pm cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm /usr/local/bin/perl -p -e "s/~DRIVER~/Oracle/g" /usr/local/lib/perl5/ site_perl/5.8.8/sun4-solaris/auto/DBI/Driver.xst > Oracle.xsi /usr/local/bin/perl /usr/local/lib/perl5/5.8.8/ExtUtils/xsubpp - typemap /usr/local/lib/perl5/5.8.8/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c gcc -c -I/u01/oracle/product/10.2.0/rdbms/public -I/u01/oracle/ product/10.2.0/rdbms/demo -I/u01/oracle/product/10.2.0/rdbms/public -I/ u01/oracle/product/10.2.0/plsql/public -I/u01/oracle/product/10.2.0/ network/public -I/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/ auto/DBI -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/ usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O - DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/usr/local/lib/ perl5/5.8.8/sun4-solaris/CORE" -Wall -Wno-comment -DUTF8_SUPPORT - DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" Oracle.c gcc -c -I/u01/oracle/product/10.2.0/rdbms/public -I/u01/oracle/ product/10.2.0/rdbms/demo -I/u01/oracle/product/10.2.0/rdbms/public -I/ u01/oracle/product/10.2.0/plsql/public -I/u01/oracle/product/10.2.0/ network/public -I/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/ auto/DBI -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/ usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O - DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/usr/local/lib/ perl5/5.8.8/sun4-solaris/CORE" -Wall -Wno-comment -DUTF8_SUPPORT - DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" dbdimp.c gcc -c -I/u01/oracle/product/10.2.0/rdbms/public -I/u01/oracle/ product/10.2.0/rdbms/demo -I/u01/oracle/product/10.2.0/rdbms/public -I/ u01/oracle/product/10.2.0/plsql/public -I/u01/oracle/product/10.2.0/ network/public -I/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/ auto/DBI -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/ usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O - DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/usr/local/lib/ perl5/5.8.8/sun4-solaris/CORE" -Wall -Wno-comment -DUTF8_SUPPORT - DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" oci8.c Running Mkbootstrap for DBD::Oracle () chmod 644 Oracle.bs rm -f blib/arch/auto/DBD/Oracle/Oracle.so LD_RUN_PATH="/u01/oracle/product/10.2.0/lib32:/u01/oracle/product/ 10.2.0/rdbms/lib32" gcc -G -L/usr/local/lib Oracle.o dbdimp.o oci8.o - xarch=v9 -L/u01/oracle/product/10.2.0/lib/ -L/u01/oracle/product/ 10.2.0/rdbms/lib/ -lclntsh `cat /u01/oracle/product/10.2.0/lib/ sysliblist` -R/u01/oracle/product/10.2.0/lib -laio -lposix4 -lkstat - lm -lthread -lpthread -o blib/arch/auto/DBD/Oracle/Oracle.so \ \ chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs /usr/local/bin/perl "-Iblib/arch" "-Iblib/lib" ora_explain.PL ora_explain Extracted ora_explain from ora_explain.PL with variable substitutions. cp ora_explain blib/script/ora_explain /usr/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/ ora_explain Manifying blib/man1/ora_explain.1 Manifying blib/man3/DBD::Oracle.3 Manifying blib/man3/DBD::Oraperl.3 ############################################ # perl -V Summary of my perl5 (revision 5 version 8 subversion 8) configuration: Platform: osname=solaris, osvers=2.9, archname=sun4-solaris uname='sunos 5.9 generic sun4u sparc sunw,ultra-5_10 solaris ' config_args='-Dcc=gcc' hint=recommended, useposix=true, d_sigaction=define usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef useperlio=define d_sfio=undef uselargefiles=define usesocks=undef use64bitint=undef use64bitall=undef uselongdouble=undef usemymalloc=n, bincompat5005=undef Compiler: cc='gcc', ccflags ='-fno-strict-aliasing -pipe -Wdeclaration-after- statement -I/usr/local/include -D_LARGEFILE_SOURCE - D_FILE_OFFSET_BITS=64', optimize='-O', cppflags='-fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include' ccversion='', gccversion='3.4.6', gccosandvers='solaris2.9' intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=8, prototype=define Linker and Libraries: ld='gcc', ldflags =' -L/usr/local/lib ' libpth=/usr/local/lib /usr/lib /usr/ccs/lib libs=-lsocket -lnsl -ldb -ldl -lm -lc perllibs=-lsocket -lnsl -ldl -lm -lc libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a gnulibc_version='' Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' ' cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib' Characteristics of this binary (from libperl): Compile-time options: PERL_MALLOC_WRAP USE_LARGE_FILES USE_PERLIO Built under solaris Compiled at May 8 2007 03:46:29 @INC: /usr/local/lib/perl5/5.8.8/sun4-solaris /usr/local/lib/perl5/5.8.8 /usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris /usr/local/lib/perl5/site_perl/5.8.8 /usr/local/lib/perl5/site_perl . And result of a test of the failed 10general.t: ####################### # perl -Mblib t/10general.t 1..33 not ok 1 - system exit 1 should return 256 # Failed test 'system exit 1 should return 256' # in t/10general.t at line 31. # got: '-1' # expected: '256' not ok 2 - system exit 0 should return 0 # Failed test 'system exit 0 should return 0' # in t/10general.t at line 32. # got: '-1' # expected: '0' ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 ok 14 ok 15 ok 16 ok 17 ok 18 - tmp0=. 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001 ok 19 - tmp1=999999999990000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 ok 20 - eval error: ``DBD::Oracle::db do failed: ORA-00900: invalid SQL statement (DBD ERROR: OCIStmtExecute) [for Statement "some invalid sql statement"] at t/10general.t line 80. # '' expected 'do failed:' ok 21 - warn error: ``DBD::Oracle::db do failed: ORA-00900: invalid SQL statement (DBD ERROR: OCIStmtExecute) [for Statement "some invalid sql statement"] at t/10general.t line 80. # '' expected 'do failed:' ok 22 ok 23 ok 24 ok 25 ok 26 ok 27 ok 28 ORA_OCI = 10 (10.2.0.1) ok 29 ok 30 ok 31 ok 32 ok 33 # Looks like you failed 2 tests of 33. I then check the Oracle error code ORA-00900 in this output, it means the Procedural option was not installed for Oracle (http:// ora-00900.ora-code.com/). I'm not sure about it. Thanks again for the reply! Alan On Jun 12, 10:59 pm, [EMAIL PROTECTED] (Philip Garrett) wrote: > 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- Hide quoted text - > > - Show quoted text -