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 -
