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/pro duct/
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

RE: DBD::Oracle installation - make test failed - ORA-28000: accout locked

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: liuhang@gmail.com [mailto:liuhang@gmail.com]=20
Sent: Tuesday, June 12, 2007 5:40 PM
To: dbi-users@perl.org
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=3D/u01/oracle/product/10.2.0/lib32:/u01/oracle/p roduct/
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=3D1 /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

Re: DBD::Oracle installation - make test failed - ORA-28000: accout locked

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/lib 32'
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/pro duct/
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/pr oduct/
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=.
000000000000000000000000000000000000000000000000000000000000 000000000000000000000000000000000000000000000000000000000000 0000000001
ok 19 -
tmp1=9999999999900000000000000000000000000000000000000000000 000000000000000000000000000000000000000000000000000000000000 00000000000
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, Philip.Garr...@manheim.com (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: liuh...@gmail.com [mailto:liuh...@gmail.com]
> Sent: Tuesday, June 12, 2007 5:40 PM
> To: dbi-us...@perl.org
> 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/pro duct/
> 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 -

Re: DBD::Oracle installation - make test failed - ORA-28000: accout locked

seems this is a bug in the code when dealing with Solaris. So I would just
ignore it for now

here is a link to it

http://www.nntp.perl.org/group/perl.dbi.dev/2006/01/msg4401. html

I will see if I can patch DBD.Oracle and then forward it on.


----- Original Message -----
From:
To:
Sent: Wednesday, June 13, 2007 2:41 PM
Subject: Re: DBD::Oracle installation - make test failed - ORA-28000: accout
locked


> 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/lib 32'
> 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/pro duct/
> 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/pr oduct/
> 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=.
> 000000000000000000000000000000000000000000000000000000000000 000000000000000000000000000000000000000000000000000000000000 0000000001
> ok 19 -
> tmp1=9999999999900000000000000000000000000000000000000000000 000000000000000000000000000000000000000000000000000000000000 00000000000
> 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, Philip.Garr...@manheim.com (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: liuh...@gmail.com [mailto:liuh...@gmail.com]
>> Sent: Tuesday, June 12, 2007 5:40 PM
>> To: dbi-us...@perl.org
>> 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/pro duct/
>> 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 -
>
>
>

Re: DBD::Oracle installation - make test failed - ORA-28000: accout locked

Opps checkeing the error msg and the code seems I have already fixed that
one a while back so it might be like this one

http://www.nntp.perl.org/group/perl.dbi.users/2006/11/msg304 63.html

Same client as you so it might be a bug in Oracle client???

Cannot test directly but I will see if I can patch for 10 clients and it you
could test it would be great

cheers
John Scoles
----- Original Message -----
From: "John Scoles"
To: ;
Sent: Thursday, June 14, 2007 6:38 AM
Subject: Re: DBD::Oracle installation - make test failed - ORA-28000: accout
locked


> seems this is a bug in the code when dealing with Solaris. So I would just
> ignore it for now
>
> here is a link to it
>
> http://www.nntp.perl.org/group/perl.dbi.dev/2006/01/msg4401. html
>
> I will see if I can patch DBD.Oracle and then forward it on.
>
>
> ----- Original Message -----
> From:
> To:
> Sent: Wednesday, June 13, 2007 2:41 PM
> Subject: Re: DBD::Oracle installation - make test failed - ORA-28000:
> accout locked
>
>
>> 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/lib 32'
>> 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/pro duct/
>> 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/pr oduct/
>> 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=.
>> 000000000000000000000000000000000000000000000000000000000000 000000000000000000000000000000000000000000000000000000000000 0000000001
>> ok 19 -
>> tmp1=9999999999900000000000000000000000000000000000000000000 000000000000000000000000000000000000000000000000000000000000 00000000000
>> 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, Philip.Garr...@manheim.com (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: liuh...@gmail.com [mailto:liuh...@gmail.com]
>>> Sent: Tuesday, June 12, 2007 5:40 PM
>>> To: dbi-us...@perl.org
>>> 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/pro duct/
>>> 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 -
>>
>>
>>
>
>

Re: DBD::Oracle installation - make test failed - ORA-28000: accout locked

Try this patch on 10general.t and see what comes up.

It should skip the test.

I do not have access to a solaris box so it is going to be a hit or miss
sort of thing.

Cheers


use DBD::Oracle qw(ORA_OCI);
unshift @INC ,'t';
require 'nchar_test_lib.pl';

$| = 1;

plan tests => 33;

my $dsn = oracle_test_dsn();
my $dbuser = $ENV{ORACLE_USERID} || 'scott/tiger';
++my $dbh = DBI->connect($dsn, $dbuser, '');

unless($dbh) {
BAILOUT("Unable to connect to Oracle ($DBI::errstr)\nTests skiped.\n");
exit 0;
}

my($sth, $p1, $p2, $tmp);
SKIP: {
skip "not unix-like", 2 unless $Config{d_semctl};
++ skip "solaris with OCI>9.x", 2 unless ($^O eq "solaris") and
(scalar(ORA_OCI) ge 10);

# basic check that we can fork subprocesses and wait for the status
# after having connected to Oracle

is system("exit 1;"), 1<<8, 'system exit 1 should return 256';
is system("exit 0;"), 0, 'system exit 0 should return 0';

}

----- Original Message -----
From: "John Scoles"
To: ;
Sent: Thursday, June 14, 2007 6:38 AM
Subject: Re: DBD::Oracle installation - make test failed - ORA-28000: accout
locked


> seems this is a bug in the code when dealing with Solaris. So I would just
> ignore it for now
>
> here is a link to it
>
> http://www.nntp.perl.org/group/perl.dbi.dev/2006/01/msg4401. html
>
> I will see if I can patch DBD.Oracle and then forward it on.
>
>
> ----- Original Message -----
> From:
> To:
> Sent: Wednesday, June 13, 2007 2:41 PM
> Subject: Re: DBD::Oracle installation - make test failed - ORA-28000:
> accout locked
>
>
>> 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/lib 32'
>> 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/pro duct/
>> 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/pr oduct/
>> 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=.
>> 000000000000000000000000000000000000000000000000000000000000 000000000000000000000000000000000000000000000000000000000000 0000000001
>> ok 19 -
>> tmp1=9999999999900000000000000000000000000000000000000000000 000000000000000000000000000000000000000000000000000000000000 00000000000
>> 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, Philip.Garr...@manheim.com (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: liuh...@gmail.com [mailto:liuh...@gmail.com]
>>> Sent: Tuesday, June 12, 2007 5:40 PM
>>> To: dbi-us...@perl.org
>>> 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/pro duct/
>>> 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 -
>>
>>
>>
>
>

Re: DBD::Oracle installation - make test failed - ORA-28000: accout locked

Thanks for all the replies, John.

I tried to use your patch of 10general.t, it did skip the first two
tests so no more complaints about the wrong return values from exit.
But the test 20 and 21 still failed, the errors seem to be Oracle
doesn't have the Procedural option installed (http://ora-00900.ora-
code.com/). I'm not sure what that means.

The output of the test of new patch of 10general.t is as the
following:

# perl -Mblib t/10general.t
Name "main::Config" used only once: possible typo at t/10general.t
line 28.
1.33
ok 1 # skip not unix-like
ok 2 # skip not unix-like
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=3D.
000000000000000000000000000000000000000000000000000000000000 000000000000000=
0000000000000000000000000000000000000000000000000000001
ok 19 -
tmp1=3D99999999999000000000000000000000000000000000000000000 000000000000000=
0000000000000000000000000000000000000000000000000000000000
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 82.
# '' 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 82.
# '' expected 'do failed:'
ok 22
not ok 23
# Failed test in t/10general.t at line 88.
not ok 24
# Failed test in t/10general.t at line 89.
# got: undef
# expected: '900'
ok 25
ok 26
ok 27
ok 28
ORA_OCI =3D 10 (10.2.0.1)
ok 29
ok 30
ok 31
ok 32
ok 33
# Looks like you failed 2 tests of 33.



On Jun 14, 6:49 am, sco...@pythian.com (John Scoles) wrote:
> Try this patch on 10general.t and see what comes up.
>
> It should skip the test.
>
> I do not have access to a solaris box so it is going to be a hit or miss
> sort of thing.
>
> Cheers
>
> use DBD::Oracle qw(ORA_OCI);
> unshift @INC ,'t';
> require 'nchar_test_lib.pl';
>
> $| =3D 1;
>
> plan tests =3D> 33;
>
> my $dsn =3D oracle_test_dsn();
> my $dbuser =3D $ENV{ORACLE_USERID} || 'scott/tiger';
> ++my $dbh =3D DBI->connect($dsn, $dbuser, '');
>
> unless($dbh) {
> BAILOUT("Unable to connect to Oracle ($DBI::errstr)\nTests skiped.\n");
> exit 0;
>
> }
>
> my($sth, $p1, $p2, $tmp);
> SKIP: {
> skip "not unix-like", 2 unless $Config{d_semctl};
> ++ skip "solaris with OCI>9.x", 2 unless ($^O eq "solaris") and
> (scalar(ORA_OCI) ge 10);
>
> # basic check that we can fork subprocesses and wait for the status
> # after having connected to Oracle
>
> is system("exit 1;"), 1<<8, 'system exit 1 should return 256';
> is system("exit 0;"), 0, 'system exit 0 should return 0';
>
>
>
> }
> ----- Original Message -----
> From: "John Scoles"
> To: ;
> Sent: Thursday, June 14, 2007 6:38 AM
> Subject: Re: DBD::Oracle installation - make test failed - ORA-28000: acc=
out
>
> locked
>
> > seems this is a bug in the code when dealing with Solaris. So I would j=
ust
> > ignore it for now
>
> > here is a link to it
>
> >http://www.nntp.perl.org/group/perl.dbi.dev/2006/01/msg4401 .html
>
> > I will see if I can patch DBD.Oracle and then forward it on.
>
> > ----- Original Message -----
> > From:
> > To:
> > Sent: Wednesday, June 13, 2007 2:41 PM
> > Subject: Re: DBD::Oracle installation - make test failed - ORA-28000:
> > accout locked
>
> >> 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=3D1 /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
> >> ------------------------------------------------------------ ----------=
-----=AD----
> >> 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 =3D "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/lib 32'
> >> 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=3Decho ECHO=3Decho GENCLNTSH=3D'echo gencln=
tsh'
> >> CC=3Dtrue OPTIMIZE=3D CCFLAGS=3D EXE=3DDBD_ORA_EXE OBJS=3DDBD_ORA_OBJ.=
o]
> >> Oracle oci build command:
> >> [true -xarch=3Dv9 -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=3D64
> >> 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=3Dyes -v -xarch=3Dv9 -xchip=3Dultra3 =
-W2,-
> >> AKNR_S -Wd,-xsafe=3Dunboundsym -Wc,-Qiselect-funcalign=3D32 -xcode=3Da=
bs44 -
> >> Wc,-Qgsched-trace_late=3D1 -Wc,-Qgsched-T5 -xalias_level=3Dweak -
> >> 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 =3D -xarch=3Dv9 -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=3D/u01/oracle/product/10.2.0/lib32:/u01/oracle/p roduct/
> >> 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=3D64 -O -
> >> DVERSION=3D\"1.19\" -DXS_VERSION=3D\"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=3D\"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=3D64 -O -
> >> DVERSION=3D\"1.19\" -DXS_VERSION=3D\"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=3D\"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=3D64 -O -
> >> DVERSION=3D\"1.19\" -DXS_VERSION=3D\"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=3D\"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=3D"/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=3Dv9 -L/u01/oracle/product/10.2.0/lib/ -L/u01/oracle/product/
> >> 10.2.0/rdbms/lib/ =20
>
> ...
>
> read more =BB- Hide quoted text -
>
> - Show quoted text -

Re: DBD::Oracle installation - make test failed - ORA-28000: accoutlocked

On 14/06/07 11:38, John Scoles wrote:
> seems this is a bug in the code when dealing with Solaris. So I would
> just ignore it for now
>
> here is a link to it
>
> http://www.nntp.perl.org/group/perl.dbi.dev/2006/01/msg4401. html

The above URL points to a posting of mine in which I report a
bug in the the test suite, and provide a fix. This fix was
incorporated into the released version of DBI 1.50.

It is the fixed test which is now failing. As the code says,
the purpose of the test is

# basic check that we can fork subprocesses and wait for the status

>> 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'

The result of the test suggests that we cannot Fork subprocesses
and wait for the status. 'perldoc -f system' says:

Return value of -1 indicates a failure to start the program
(inspect $! for the reason).

Something is very seriously wrong if system('exit 0;') is failing.

I am afraid I do not have the time to investigate this myself at
the moment, but it does need investigating. A good start would be
to modify the test to print the value of $! after the failure.

--
Charles Jardine - Computing Service, University of Cambridge
cj10@cam.ac.uk Tel: +44 1223 334506, Fax: +44 1223 334679

Re: DBD::Oracle installation - make test failed - ORA-28000: accout locked

On Jun 15, 8:32 am, c...@cam.ac.uk (Charles Jardine) wrote:
> On 14/06/07 11:38, John Scoles wrote:
>
> > seems this is a bug in the code when dealing with Solaris. So I would
> > just ignore it for now
>
> > here is a link to it
>
> >http://www.nntp.perl.org/group/perl.dbi.dev/2006/01/msg4401 .html
>
> The above URL points to a posting of mine in which I report a
> bug in the the test suite, and provide a fix. This fix was
> incorporated into the released version of DBI 1.50.
>
> It is the fixed test which is now failing. As the code says,
> the purpose of the test is
>
> # basic check that we can fork subprocesses and wait for the status
>
> >> 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'
>
> The result of the test suggests that we cannot Fork subprocesses
> and wait for the status. 'perldoc -f system' says:
>
> Return value of -1 indicates a failure to start the program
> (inspect $! for the reason).
>
> Something is very seriously wrong if system('exit 0;') is failing.
>
> I am afraid I do not have the time to investigate this myself at
> the moment, but it does need investigating. A good start would be
> to modify the test to print the value of $! after the failure.
>
> --
> Charles Jardine - Computing Service, University of Cambridge
> c...@cam.ac.uk Tel: +44 1223 334506, Fax: +44 1223 334679

Thanks to Charles and John.

I then took this as a bug and went ahead to have the DBD installed.
Seems now it recognizes the DBD module, but my script met another
problem about connection: ORA-12154: TNS:could not resolve the connect
identifier specified (DBD ERROR: OCIServerAttach). I guess it's a
problem in the Oracle installation or configuration itself and will
seek for solutions in other groups I guess.

Thanks again, and please let me know if you have suggestions or
updates.

Alan

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, liuhang@gmail.com 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/pro duct/
> 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
>
>

Re: DBD::Oracle installation - make test failed - ORA-28000: accout locked

--BOKacYhQ+x31HxR3
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On 2007-06-20 11:56:22 +0800, Paul Gallagher wrote:
> the scott/tiger account has been locked on installation as a default
> since some versions ago.
>=20
> it maybe you just need to make sure the account is unlocked before
> running the test.
>=20
> sqlplus scott/tiger
>=20
> if you cannot get in, do an "update user scott account unlock"

If you do so, you probably should also change the password.

Or you can use a completely different account, possibly on a remote
machine.

In any case, if the account you want to use is not scott/tiger, you must
set the environment variable

ORACLE_USERID=3Duser/password@instance

before make test.

hp

--=20
_ | Peter J. Holzer | If I wanted to be "academically correct",
|_|_) | Sysadmin WSR | I'd be programming in Java.
| | | hjp@wsr.ac.at | I don't, and I'm not.
__/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users

--BOKacYhQ+x31HxR3
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGeN9EMdFfQa64PCwRAkCeAJ4gYHN3ZLKzdaUw35dBVEiTJFY8QwCe JnTY
IH/MMYcIIOEztu5qTTuNkAI=
=Vqox
-----END PGP SIGNATURE-----

--BOKacYhQ+x31HxR3--

Re: DBD::Oracle installation - make test failed - ORA-28000: accout locked

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"
To:
Cc:
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, liuhang@gmail.com 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/pro duct/
>> 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
>>
>>
>

Re: DBD::Oracle installation - make test failed - ORA-28000: accout locked

On Jun 20, 6:45 am, sco...@pythian.com (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"
> To:
>
> Cc:
> Sent: Tuesday, June 19, 2007 11:56 PM
> Subject: Re: DBD::Oracle installation - make test failed - ORA-28000: acc=
out
> 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, liuh...@gmail.com 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=3D/u01/oracle/product/10.2.0/lib32:/u01/oracle/p roduct/
> >> 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=3D1 /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
> >> ------------------------------------------------------------ ----------=
-----=AD----
> >> 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