Re: DBD Oracle 1.20 ORA-24334 Error

Thanks John, if you need me to run any debugging on Solaris or anything
let
me know.
I would suspect also that it is OS related.

On the premise instant client and also tried to run perl Makefile.PL -V
9.2
& with -v 10.2.0.4

The only thing that is out of place is this compile a warning is thrown
when
the make command is run

gcc -c -I/home/bmpe/bmpadme/instantclient_10_2/sdk/include
-I/opt/perl586/lib/site_perl/5.8.6/sun4-solaris-thread-multi/auto/DBI
-D_REENTRANT -fno-strict-aliasing -pipe -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.21\"
-DXS_VERSION=\"1.21\" -fPIC
"-I/opt/perl586/lib/5.8.6/sun4-solaris-thread-multi/CORE" -Wall
-Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.4\"
dbdimp.c
dbdimp.c: In function `ora_st_execute_array':
dbdimp.c:3269: warning: unused variable `sv2'

Full output of the make,

Not sure if that would be the culperate. If I remember correctly I
removed it in 1.22 as it was a memory leak source. Try getting rid of it
and see what happens?


ux11:/home/bmpe/bmpadme/DBD-Oracle-1.21 > make
Skip blib/lib/DBD/Oracle.pm (unchanged)
Skip blib/lib/DBD/mkta.pl (unchanged)
Skip blib/lib/oraperl.ph (unchanged)
Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged)
Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged)
Skip blib/lib/Oraperl.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged)
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
gcc -c -I/home/bmpe/bmpadme/instantclient_10_2/sdk/include
-I/opt/perl586/lib/site_perl/5.8.6/sun4-solaris-thread-multi/auto/DBI
-D_REENTRANT -fno-strict-aliasing -pipe -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.21\"
-DXS_VERSION=\"1.21\" -fPIC
"-I/opt/perl586/lib/5.8.6/sun4-solaris-thread-multi/CORE" -Wall
-Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.4\"
DBD_ORA_OBJ.c
gcc -c -I/home/bmpe/bmpadme/instantclient_10_2/sdk/include
-I/opt/perl586/lib/site_perl/5.8.6/sun4-solaris-thread-multi/auto/DBI
-D_REENTRANT -fno-strict-aliasing -pipe -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.21\"
-DXS_VERSION=\"1.21\" -fPIC
"-I/opt/perl586/lib/5.8.6/sun4-solaris-thread-multi/CORE" -Wall
-Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.4\"
Oracle.c
*gcc -c -I/home/bmpe/bmpadme/instantclient_10_2/sdk/include
-I/opt/perl586/lib/site_perl/5.8.6/sun4-solaris-thread-multi/auto/DBI
-D_REENTRANT -fno-strict-aliasing -pipe -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.21\"
-DXS_VERSION=\"1.21\" -fPIC
"-I/opt/perl586/lib/5.8.6/sun4-solaris-thread-multi/CORE" -Wall
-Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.4\"
dbdimp.c
dbdimp.c: In function `ora_st_execute_array':
dbdimp.c:3269: warning: unused variable `sv2'*
gcc -c -I/home/bmpe/bmpadme/instantclient_10_2/sdk/include
-I/opt/perl586/lib/site_perl/5.8.6/sun4-solaris-thread-multi/auto/DBI
-D_REENTRANT -fno-strict-aliasing -pipe -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.21\"
-DXS_VERSION=\"1.21\" -fPIC
"-I/opt/perl586/lib/5.8.6/sun4-solaris-thread-multi/CORE" -Wall
-Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.4\"
oci8.c
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/home/bmpe/bmpadme/instantclient_10_2" gcc -G
-L/usr/local/lib
DBD_ORA_OBJ.o Oracle.o dbdimp.o oci8.o -o
blib/arch/auto/DBD/Oracle/Oracle.so
-L/home/bmpe/bmpadme/instantclient_10_2 -lclntsh
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
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


On Sun, Apr 5, 2009 at 8:05 AM, <scoles@xxxxxxxxxxx> wrote:

I tested it and I got the correct values back
Looking at the error you are now getting in 10gen that is an OS related
error This is the basic check that we can fork subprocesses and wait for
the status after having connected to Oracle

It is only suppose to run on solaris if the oci is gt 9.

In your case this is true but your DB is 9.2 which leads me to thing it
is the combination of 9.2 db and solaris that is the root cause.

You might not have a work around for this. I am able to get this to
work
on windos and linux without any problem

I will look a little further though.

Cheers
John Scoles


Have been trying to get a good install all day for DBD 1.21 / DBD1.22
on
Solaris 5.8, it installs now.
However it still fails on the TEST_ORA table.

As I said I tried it on my Windows box using Activestate/ppm which
queried
the TEST_ORA table successfully

The latest Solaris build I used was as follows

instantclient-*10.2.0.4.0* 32bit* - this seems to be the version of
instant
client that works*
perl, v5.8.6 built for sun4-solaris-thread-multi
SunOS 5.8
Oracle 9.2.0.8.0
DBD 1.21

After running a sucessful perl Makefile.PL, make, then make test I
read
the
following post by John

http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg32950.html

I then ran the make install and re-tried my sample test but still the
issue
occurs, otherwsise standard SQL works fine.

DBD::Oracle::db prepare failed: ORA-24334: no descriptor for this
position
(DBD ERROR: OCIParamGet) [for Statement "select * from TEST_ORA"] at
./popAMAError.pl line 34.

The output from 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.............# Failed test (t/10general.t at line 36)
t/10general.............NOK 1# got: '-1'

# expected: '256'
# Failed test (t/10general.t at line 37)
# got: '-1'
# expected: '0'
t/10general.............ok 33/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
t/12impdata.............ok

t/14threads.............ok

t/15nls.................ok

t/20select..............ok

t/21nchar............... Database and client versions and character
sets:
Database 9.2.0.8.0 CHAR set is US7ASCII (Non-Unicode), NCHAR set is
AL16UTF16 (Unicode)
Client 10.2.0.4 NLS_LANG is '<unset>', NLS_NCHAR is '<unset>'
t/21nchar...............ok

t/22nchar_al32utf8......ok

t/22nchar_utf8..........ok

t/23wide_db.............skipped
all skipped: Database character set is not Unicode
t/23wide_db_8bit........skipped
all skipped: Database character set is not Unicode
t/23wide_db_al32utf8....skipped
all skipped: Database character set is not Unicode
t/24implicit_utf8.......ok

t/25plsql...............ok 42/82(DBI::errstr undefined)

t/25plsql...............FAILED test 43

Failed 1/82 tests, 98.78% okay
t/26exe_array...........ok

t/28array_bind..........ok

t/30long................ok

122/470 skipped: various reasons
t/31lob.................ok

t/32xmltype.............ok

t/34pres_lobs...........ok

t/40ph_type.............ok 3/19 Placeholder behaviour for ora_type=1
(the
default) varies with Oracle version.
Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x
Your system doesn't. If that seems odd, let us know.
t/40ph_type.............ok

t/50cursor..............ok

t/51scroll..............ok

t/55nested..............ok

t/56embbeded............ok

t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped.
skipped
all skipped: no reason given
t/70meta................ok

t/80ora_charset.........ok 8/14# Failed test (t/80ora_charset.t at
line
83)
# got: '?'
# expected: '°'
t/80ora_charset.........NOK 9# Failed test (t/80ora_charset.t at
line
84)
# got: '?'
# expected: '°'
t/80ora_charset.........ok 12/14# Failed test (t/80ora_charset.t
at
line
83)
# got: '?'
# expected: '°'
t/80ora_charset.........NOK 13# Failed test (t/80ora_charset.t at
line
84)
t/80ora_charset.........NOK 14# got: '?'

# expected: '°'
# Looks like you failed 4 tests of 14.
t/80ora_charset.........dubious

Test returned status 4 (wstat 1024, 0x400)
DIED. FAILED tests 9-10, 13-14
Failed 4/14 tests, 71.43% okay
Failed Test Stat Wstat Total Fail Failed List of Failed

-------------------------------------------------------------------------------
t/10general.t 2 512 33 2 6.06% 1-2
t/25plsql.t 82 1 1.22% 43
t/80ora_charset.t 4 1024 14 4 28.57% 9-10 13-14
4 tests and 122 subtests skipped.
Failed 3/28 test scripts, 89.29% okay. 7/2033 subtests failed, 99.66%
okay.
make: *** [test_dynamic] Error 2


On Fri, Apr 3, 2009 at 11:46 AM, Jamie Nicholson
<jamie.nicholson@xxxxxxxxx>wrote:

Tried this using Oracle 1.21 on my Windoze PC and it works.
Looks like I'm off to upgrade the Oracle Client as per option 2 in
this
archive

http://www.nntp.perl.org/group/perl.dbi.users/2008/04/msg32777.html







.

Relevant Pages

  • DBD::Oracle 1.19 tests core against Oracle 10.2.0.1 - Solaris build
    ... I'm trying to get DBD::Oracle to work on Solaris 9 but I'm getting core ... Configuring DBD::Oracle for perl 5.008008 on solaris ... Oracle version 10.2.0.1 ... Failed 13/14 tests, 7.14% okay ...
    (perl.dbi.users)
  • RE: Accessing oracle from windows 2000
    ... platforms (with caveats and issues that will be outlined below. ... I use DBD::Oracle when using an Oracle data source. ... You need to have the Oracle client installed -- and licensed -- on your ... while ago (after the Perl 5.6.x timeframe and before 5.8.x timeframe). ...
    (perl.dbi.users)
  • Re: DBD::Oracle / Instant Client segfaults
    ... I've been doing some more tests concerning this issue and it seems that it only appears with the combination of Oracle Instant client libraries, Perl configured with -Dusemymalloc on RHEL 3. ... When i run the script with the 'use Digest::SHA1;' line commented ...
    (perl.dbi.users)
  • Re: DBD::Oracle - problem with support for objects.
    ... causes perl to crash with a segmentation fault. ... Have you tried using a client that matches the server? ... cannot tell if you are running to a local or remote oracle. ... reproduced it using a local TNS style connection. ...
    (perl.dbi.users)
  • Re: DBD::Oracle 1.19 tests core against Oracle 10.2.0.1 - Solaris build
    ... Seems Solaris has been a problem for a while. ... Configuring DBD::Oracle for perl 5.008008 on solaris ... Oracle version 10.2.0.1 ... Failed 13/14 tests, 7.14% okay ...
    (perl.dbi.users)