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=.
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001
ok 19 -
tmp1=999999999990000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
ok 20 - eval error: ``DBD::Oracle::db do failed: ORA-00900: invalid
SQL statement (DBD ERROR: OCIStmtExecute) [for Statement "some invalid
sql statement"] at t/10general.t line 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 = 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...@xxxxxxxxxxx (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';

$| = 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" <sco...@xxxxxxxxxxx>
To: <dbi-us...@xxxxxxxx>; <liuh...@xxxxxxxxx>
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: <liuh...@xxxxxxxxx>
To: <dbi-us...@xxxxxxxx>
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/lib32'
Reading /u01/oracle/product/10.2.0/rdbms/demo/demo_rdbms.mk
Reading /u01/oracle/product/10.2.0/rdbms/lib/env_rdbms.mk

Attempting to discover Oracle OCI build rules
gcc -c -o DBD_ORA_OBJ.o DBD_ORA_OBJ.c
by executing: [make -f /u01/oracle/product/10.2.0/rdbms/demo/
demo_rdbms.mk build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh'
CC=true OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o]
Oracle oci build command:
[true -xarch=v9 -L/u01/oracle/product/10.2.0/lib/ -L/u01/
oracle/product/10.2.0/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -
lclntsh `cat /u01/oracle/product/10.2.0/lib/sysliblist` -R/u01/
oracle/product/10.2.0/lib -laio -lposix4 -lkstat -lm -lthread -
lpthread]

Found header files in /u01/oracle/product/10.2.0/rdbms/public.

Checking for functioning wait.ph

System: perl5.008008 sunos 5.9 generic sun4u sparc sunw,ultra-5_10
solaris
Compiler: gcc -O -fno-strict-aliasing -pipe -Wdeclaration-after-
statement -I/usr/local/include -D_LARGEFILE_SOURCE -
D_FILE_OFFSET_BITS=64
Linker: /usr/local/bin/ld
Sysliblist: -lkstat -lnsl -lsocket -lgen -ldl -lsched
Oracle makefiles would have used these definitions but we override
them:
CC: cc
CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) -xO3 $(CDEBUG) -Xa $(PROFILE) -xstrconst -dalign -
xF $(XS) $(MR) -xildoff -errtags=yes -v -xarch=v9 -xchip=ultra3 -W2,-
AKNR_S -Wd,-xsafe=unboundsym -Wc,-Qiselect-funcalign=32 -xcode=abs44 -
Wc,-Qgsched-trace_late=1 -Wc,-Qgsched-T5 -xalias_level=weak -
D_REENTRANT -DSS_64BIT_SERVER -DBIT64 -DMACHINE64 -K PIC -I/u01/oracle/
product/10.2.0/rdbms/demo -I/u01/oracle/product/10.2.0/rdbms/public -I/
u01/oracle/product/10.2.0/plsql/public -I/u01/oracle/product/10.2.0/
network/public -DSLMXMX_ENABLE -DSLTS_ENABLE -D_SVID_GETTOD -
D_REENTRANT $(LPFLAGS) $(USRFLAGS)]
LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
[-o $@ -L/u01/oracle/product/10.2.0/rdbms/lib/ -L$
(LIBHOME)]
Linking with OTHERLDFLAGS = -xarch=v9 -L/u01/oracle/product/10.2.0/
lib/ -L/u01/oracle/product/10.2.0/rdbms/lib/ -lclntsh `cat /u01/
oracle/product/10.2.0/lib/sysliblist` -R/u01/oracle/product/10.2.0/lib
-laio -lposix4 -lkstat -lm -lthread -lpthread [from 'build' rule]

WARNING: If you have problems you may need to rebuild perl with
threading enabled.
Checking if your kit is complete...
Looks good
LD_RUN_PATH=/u01/oracle/product/10.2.0/lib32:/u01/oracle/product/
10.2.0/rdbms/lib32
Using DBD::Oracle 1.19.
Using DBD::Oracle 1.19.
Using DBI 1.56 (for perl 5.008008 on sun4-solaris) installed in /usr/
local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBI/
Writing Makefile for DBD::Oracle

*** If you have problems...
read all the log printed above, and the README and
README.help.txt files.
(Of course, you have read README by now anyway, haven't you?)

#################################
# make
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp mkta.pl blib/lib/DBD/mkta.pl
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
/usr/local/bin/perl -p -e "s/~DRIVER~/Oracle/g" /usr/local/lib/perl5/
site_perl/5.8.8/sun4-solaris/auto/DBI/Driver.xst > Oracle.xsi
/usr/local/bin/perl /usr/local/lib/perl5/5.8.8/ExtUtils/xsubpp -
typemap /usr/local/lib/perl5/5.8.8/ExtUtils/typemap -typemap typemap
Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
gcc -c -I/u01/oracle/product/10.2.0/rdbms/public -I/u01/oracle/
product/10.2.0/rdbms/demo -I/u01/oracle/product/10.2.0/rdbms/public -I/
u01/oracle/product/10.2.0/plsql/public -I/u01/oracle/product/10.2.0/
network/public -I/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/
auto/DBI -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/
usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -
DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/usr/local/lib/
perl5/5.8.8/sun4-solaris/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -
DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" Oracle.c
gcc -c -I/u01/oracle/product/10.2.0/rdbms/public -I/u01/oracle/
product/10.2.0/rdbms/demo -I/u01/oracle/product/10.2.0/rdbms/public -I/
u01/oracle/product/10.2.0/plsql/public -I/u01/oracle/product/10.2.0/
network/public -I/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/
auto/DBI -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/
usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -
DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/usr/local/lib/
perl5/5.8.8/sun4-solaris/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -
DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" dbdimp.c
gcc -c -I/u01/oracle/product/10.2.0/rdbms/public -I/u01/oracle/
product/10.2.0/rdbms/demo -I/u01/oracle/product/10.2.0/rdbms/public -I/
u01/oracle/product/10.2.0/plsql/public -I/u01/oracle/product/10.2.0/
network/public -I/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/
auto/DBI -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/
usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -
DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/usr/local/lib/
perl5/5.8.8/sun4-solaris/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -
DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" oci8.c
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/u01/oracle/product/10.2.0/lib32:/u01/oracle/product/
10.2.0/rdbms/lib32" gcc -G -L/usr/local/lib Oracle.o dbdimp.o oci8.o -
xarch=v9 -L/u01/oracle/product/10.2.0/lib/ -L/u01/oracle/product/
10.2.0/rdbms/lib/

...

read more »- Hide quoted text -

- Show quoted text -


.

Relevant Pages

  • Compiling and running DBD for Oracle 10g without installing Oracle
    ... I recently had to compile the DBD modules for Oracle 10g on machines, ... perl, DBI etc. of recent enough version ... Oracle 10g installation disk for your architecture (available at ...
    (perl.dbi.users)
  • Compiling and running DBD for Oracle 10g without installing Oracle
    ... I recently had to compile the DBD modules for Oracle 10g on machines, ... perl, DBI etc. of recent enough version ... Oracle 10g installation disk for your architecture (available at ...
    (perl.dbi.users)
  • Asp.net/vb and Oracle
    ... setup on other machines where I have installed the Oracle 9i client, ... Oracle 9.0 odbc drivers will connect to my oracle database when debugging. ... Oracle client and networking components were not found. ... later client software installation. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: CBO & different execution plans
    ... a SQL statement in a packaged application that was taking excessively ... long to execute - roughly 3.4 seconds per execution and the packaged ... The problem in this case had to do with Oracle picking ... Providing a hint to Oracle to use ...
    (comp.databases.oracle.server)
  • RE: Asp.net/vb and Oracle
    ... Oracle Provider for OLE DB components, as well as the orcle Data Provider for ... setup on other machines where I have installed the Oracle 9i client, ... Oracle client and networking components were not found. ... later client software installation. ...
    (microsoft.public.dotnet.framework.aspnet)