Re: DBD::Oracle on Oracle 11g 64 bit fedora 10
On Thu, 2009-03-26 at 10:48 -0500, Scott T. Hildreth wrote:
> On Thu, 2009-03-26 at 11:45 -0400, John Scoles wrote:
> >
> > Scott T. Hildreth wrote:
> > > On Thu, 2009-03-26 at 06:49 -0400, John Scoles wrote:
> > >
> > >> Scott T. Hildreth wrote:
> > >>
> > >>> On Mon, 2009-01-19 at 20:26 +, Russell, Gordon wrote:
> > >>>
> > >>>
> > Hi. I am hoping someone can look over this install info and tell me if
> > it is all ok?
> >
> > I am having some worries with a new install of fedora 10.
> > I also installed oracle 11.1.0.7.
> > I have the latest DBI and am installing DBD Oracle 1.22. Note I have
> > used DBD and Oracle for many many years.
> > I have a 64 bit environment, UTF8 database and linux, with 32 bit
> > compatibility libraries installed only to make the oracle installer
> > tests happy.
> >
> >
> >
> > >>> Gordon,
> > >>>
> > >>> Did you ever resolve this? We are moving to 11g now and I am having
> > >>> the same issue. I originally thought it was a 11g client => 10g db
> > >>> problem, but I can reproduce it trying to compile DBD::Oracle using a
> > >>> 11g db. Oracle 11.1.0.7.0 is installed on SUSE Linux Enterprise Server
> > >>> 10 (x86_64).
> > >>>
> > >>> Thanks,
> > >>> Scott.
> > >>>
> > >>>
> > >>>
> > In short, it works but produces some test errors. Not sure if I should
> > just ignore them!
> > Plenty of information follows... any suggestions appreciated.
> >
> > When building DBD Oracle, the tests come up with 3 fails:
> > Test Summary Report
> > ---
> > t/26exe_array (Wstat: 512 Tests: 14 Failed: 2)
> > Failed tests: 11, 14
> > Non-zero exit status: 2
> >
> >
> > >> I have raised this many time with Oracle as I think it is a bug on the
> > >> 11g side as no code has changed. They of course say it is DBD::Oracle
> > >> fault. It might have to do with space, buffering or permissions
> > >> unfortunately I do not have steady access to an 11 db to do more
> > >> extensive testing.
> > >>
> > >
> > > John, are you specifically talking about the exe_array here? Just for
> > > the record all my tests pass, except the plsql test in 31lob.t
> > >
> > >
> >
> > Yes that is the case I was talking about the exe_array. I wonder it
> > there is a patch difference in your two Oracles or you have some
> > different settings?
>
> I can have the DBA send me what patches have been applied, if you like.
> I am going to debug the 31lob.t test some more, I will report back my
> findings.
It is definitely a 11g client issue. I can use a 10g client, connecting
to a 11g db and the test works fine. Our DBA had me declare local vars
inside the plsql test, just testing different things, so my statement is
a little different; same problem,
ok 1 - returned valid locator
ok 2 - returned valid locator
ok 3 - returned valid locator
ok 4 - returned length
ok 5 - returned written value
DBD::Oracle::st execute failed: ORA-24813: cannot send or receive an
unsupported LOB (DBD ERROR: OCIStmtExecute) [for Statement "declare xlen number
; xlob blob; B xlob := ?; xlen := DBMS_LOB.GETLENGTH( xlob ); END;" with
ParamValues: :p1=undef, :p2=OCILobLocatorPtr=SCALAR(0xa5b490)] at t/31lob.t
line 108.
at t/31lob.t line 108
not ok 6 - returned length via PL/SQL
Errors in file :
OCI-21500: internal error code, arguments: [kghufree_06], [0x00100AF68], [0],
[0], [0], [], [], []
Errors in file :
OCI-21500: internal error code, arguments: [kghufree_06], [0x00100AF68], [0],
[0], [0], [], [], []
>
> >
> > cheers
> > t/30long(Wstat: 512 Tests: 30 Failed: 0)
> > Non-zero exit status: 2
> > Parse errors: Bad plan. You planned 479 tests but ran 30.
> > t/31lob (Wstat: 256 Tests: 6 Failed: 1)
> > Failed test: 6
> > Non-zero exit status: 1
> > Parse errors: Bad plan. You planned 9 tests but ran 6.
> >
> > The actual errors are:
> > t/26exe_array...
> > Dubious, test returned 2 (wstat 512, 0x200)
> > Failed 2/14 subtests
> > t/30longpanic: sv_len_utf8 cache 10240 real 81920 for
> > 1234
> > t/31lob.DBD::Oracle::st execute failed: ORA-24813:
> > cannot send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute)
> > [for Statement "BEGIN ? := DBMS_LOB.GETLENGTH( ? ); END;" with
> > ParamValues: :p1=undef, :p2=OCILobLocatorPtr=SCALAR(0x19cb018)] at
> > t/31lob.t line 108.
> >
> > Installing it anyway seems ok, but running:
> > my $dbh = DBI->connect_cached('dbi:Oracle:sid',username,password,{
> > RaiseError=> 1,
> > PrintError=> 0,
> > ShowErrorStatement=> 1,
> > AutoCommit=> 0,
> > ora_verbose=>6
> >
Re: DBD::Oracle on Oracle 11g 64 bit fedora 10
On Thu, 2009-03-26 at 11:45 -0400, John Scoles wrote:
>
> Scott T. Hildreth wrote:
> > On Thu, 2009-03-26 at 06:49 -0400, John Scoles wrote:
> >
> >> Scott T. Hildreth wrote:
> >>
> >>> On Mon, 2009-01-19 at 20:26 +, Russell, Gordon wrote:
> >>>
> >>>
> Hi. I am hoping someone can look over this install info and tell me if
> it is all ok?
>
> I am having some worries with a new install of fedora 10.
> I also installed oracle 11.1.0.7.
> I have the latest DBI and am installing DBD Oracle 1.22. Note I have
> used DBD and Oracle for many many years.
> I have a 64 bit environment, UTF8 database and linux, with 32 bit
> compatibility libraries installed only to make the oracle installer
> tests happy.
>
>
>
> >>> Gordon,
> >>>
> >>> Did you ever resolve this? We are moving to 11g now and I am having
> >>> the same issue. I originally thought it was a 11g client => 10g db
> >>> problem, but I can reproduce it trying to compile DBD::Oracle using a
> >>> 11g db. Oracle 11.1.0.7.0 is installed on SUSE Linux Enterprise Server
> >>> 10 (x86_64).
> >>>
> >>> Thanks,
> >>> Scott.
> >>>
> >>>
> >>>
> In short, it works but produces some test errors. Not sure if I should
> just ignore them!
> Plenty of information follows... any suggestions appreciated.
>
> When building DBD Oracle, the tests come up with 3 fails:
> Test Summary Report
> ---
> t/26exe_array (Wstat: 512 Tests: 14 Failed: 2)
> Failed tests: 11, 14
> Non-zero exit status: 2
>
>
> >> I have raised this many time with Oracle as I think it is a bug on the
> >> 11g side as no code has changed. They of course say it is DBD::Oracle
> >> fault. It might have to do with space, buffering or permissions
> >> unfortunately I do not have steady access to an 11 db to do more
> >> extensive testing.
> >>
> >
> > John, are you specifically talking about the exe_array here? Just for
> > the record all my tests pass, except the plsql test in 31lob.t
> >
> >
>
> Yes that is the case I was talking about the exe_array. I wonder it
> there is a patch difference in your two Oracles or you have some
> different settings?
I can have the DBA send me what patches have been applied, if you like.
I am going to debug the 31lob.t test some more, I will report back my
findings.
>
> cheers
> t/30long(Wstat: 512 Tests: 30 Failed: 0)
> Non-zero exit status: 2
> Parse errors: Bad plan. You planned 479 tests but ran 30.
> t/31lob (Wstat: 256 Tests: 6 Failed: 1)
> Failed test: 6
> Non-zero exit status: 1
> Parse errors: Bad plan. You planned 9 tests but ran 6.
>
> The actual errors are:
> t/26exe_array...
> Dubious, test returned 2 (wstat 512, 0x200)
> Failed 2/14 subtests
> t/30longpanic: sv_len_utf8 cache 10240 real 81920 for
> 1234
> t/31lob.DBD::Oracle::st execute failed: ORA-24813:
> cannot send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute)
> [for Statement "BEGIN ? := DBMS_LOB.GETLENGTH( ? ); END;" with
> ParamValues: :p1=undef, :p2=OCILobLocatorPtr=SCALAR(0x19cb018)] at
> t/31lob.t line 108.
>
> Installing it anyway seems ok, but running:
> my $dbh = DBI->connect_cached('dbi:Oracle:sid',username,password,{
> RaiseError=> 1,
> PrintError=> 0,
> ShowErrorStatement=> 1,
> AutoCommit=> 0,
> ora_verbose=>6
>
> })
> Produces:
> OCINlsEnvironmentVariableGet(871,0,93,0,2)=SUCCESS
> OCINlsEnvironmentVariableGet(871,0,94,0,2)=SUCCESS
> OCINlsEnvCreate(1b8c5d0,THREADED |
> OBJECT,3,0,0,0,0,0,0,871,871)=SUCCESS
> OCIHandleAlloc(1c06220,1b8c5d8,OCI_HTYPE_ERROR,0,0)=SUCCESS
> charset id=871, name=UTF8, ncharset id=871, name=UTF8 (csid:
> utf8=871 al32utf8=873)
> OCIHandleAlloc(1c06220,1b8c5e0,OCI_HTYPE_SERVER,0,0)=SUCCESS
> OCIHandleAlloc(1c06220,1b8c5e8,OCI_HTYPE_SVCCTX,0,0)=SUCCESS
> OCIServerAttach(1c45608, 1c44e68, "sid", 3,
> mode=DEFAULT,0)=SUCCESS
> OCIAttrSet(1c44d90,OCI_HTYPE_SVCCTX,1c45608,0,6,1c44e68)=SUCCESS
> OCIHandleAlloc(1c06220,1b8c5f0,OCI_HTYPE_SESSION,0,0)=SUCCESS
>
> OCIAttrSet(1c81838,OCI_HTYPE_SESSION,1a1d348,8,22,1c44e68)=SUCCESS
>
> OCIAttrSet(1c81838,OCI_HTYPE_SESSION,1917d08,6,23,1c44e68)=SUCCESS
> OCISessionBegin(1c44d90,1c44e68,1c81838,1,mode=DEFAULT 0)=SUCCESS
> OCIAttrSet(1c44d90,OCI_HTYPE_SVCCTX,1c81838,0,7,1c44e68)=SUCCESS
> "DBI::db=HASH(0x1919710)" is not exported by the DBD::Oracle module
> >>>
Re: DBD::Oracle on Oracle 11g 64 bit fedora 10
Scott T. Hildreth wrote:
On Thu, 2009-03-26 at 06:49 -0400, John Scoles wrote:
Scott T. Hildreth wrote:
On Mon, 2009-01-19 at 20:26 +, Russell, Gordon wrote:
Hi. I am hoping someone can look over this install info and tell me if it is
all ok?
I am having some worries with a new install of fedora 10.
I also installed oracle 11.1.0.7.
I have the latest DBI and am installing DBD Oracle 1.22. Note I have used DBD
and Oracle for many many years.
I have a 64 bit environment, UTF8 database and linux, with 32 bit compatibility
libraries installed only to make the oracle installer tests happy.
Gordon,
Did you ever resolve this? We are moving to 11g now and I am having
the same issue. I originally thought it was a 11g client => 10g db
problem, but I can reproduce it trying to compile DBD::Oracle using a
11g db. Oracle 11.1.0.7.0 is installed on SUSE Linux Enterprise Server
10 (x86_64).
Thanks,
Scott.
In short, it works but produces some test errors. Not sure if I should just
ignore them!
Plenty of information follows... any suggestions appreciated.
When building DBD Oracle, the tests come up with 3 fails:
Test Summary Report
---
t/26exe_array (Wstat: 512 Tests: 14 Failed: 2)
Failed tests: 11, 14
Non-zero exit status: 2
I have raised this many time with Oracle as I think it is a bug on the
11g side as no code has changed. They of course say it is DBD::Oracle
fault. It might have to do with space, buffering or permissions
unfortunately I do not have steady access to an 11 db to do more
extensive testing.
John, are you specifically talking about the exe_array here? Just for
the record all my tests pass, except the plsql test in 31lob.t
Yes that is the case I was talking about the exe_array. I wonder it
there is a patch difference in your two Oracles or you have some
different settings?
cheers
t/30long(Wstat: 512 Tests: 30 Failed: 0)
Non-zero exit status: 2
Parse errors: Bad plan. You planned 479 tests but ran 30.
t/31lob (Wstat: 256 Tests: 6 Failed: 1)
Failed test: 6
Non-zero exit status: 1
Parse errors: Bad plan. You planned 9 tests but ran 6.
The actual errors are:
t/26exe_array...
Dubious, test returned 2 (wstat 512, 0x200)
Failed 2/14 subtests
t/30longpanic: sv_len_utf8 cache 10240 real 81920 for 1234
t/31lob.DBD::Oracle::st execute failed: ORA-24813: cannot send or receive
an unsupported LOB (DBD ERROR: OCIStmtExecute) [for Statement "BEGIN ? :=
DBMS_LOB.GETLENGTH( ? ); END;" with ParamValues: :p1=undef,
:p2=OCILobLocatorPtr=SCALAR(0x19cb018)] at t/31lob.t line 108.
Installing it anyway seems ok, but running:
my $dbh = DBI->connect_cached('dbi:Oracle:sid',username,password,{
RaiseError=> 1,
PrintError=> 0,
ShowErrorStatement=> 1,
AutoCommit=> 0,
ora_verbose=>6
})
Produces:
OCINlsEnvironmentVariableGet(871,0,93,0,2)=SUCCESS
OCINlsEnvironmentVariableGet(871,0,94,0,2)=SUCCESS
OCINlsEnvCreate(1b8c5d0,THREADED | OBJECT,3,0,0,0,0,0,0,871,871)=SUCCESS
OCIHandleAlloc(1c06220,1b8c5d8,OCI_HTYPE_ERROR,0,0)=SUCCESS
charset id=871, name=UTF8, ncharset id=871, name=UTF8 (csid: utf8=871
al32utf8=873)
OCIHandleAlloc(1c06220,1b8c5e0,OCI_HTYPE_SERVER,0,0)=SUCCESS
OCIHandleAlloc(1c06220,1b8c5e8,OCI_HTYPE_SVCCTX,0,0)=SUCCESS
OCIServerAttach(1c45608, 1c44e68, "sid", 3, mode=DEFAULT,0)=SUCCESS
OCIAttrSet(1c44d90,OCI_HTYPE_SVCCTX,1c45608,0,6,1c44e68)=SUCCESS
OCIHandleAlloc(1c06220,1b8c5f0,OCI_HTYPE_SESSION,0,0)=SUCCESS
OCIAttrSet(1c81838,OCI_HTYPE_SESSION,1a1d348,8,22,1c44e68)=SUCCESS
OCIAttrSet(1c81838,OCI_HTYPE_SESSION,1917d08,6,23,1c44e68)=SUCCESS
OCISessionBegin(1c44d90,1c44e68,1c81838,1,mode=DEFAULT 0)=SUCCESS
OCIAttrSet(1c44d90,OCI_HTYPE_SVCCTX,1c81838,0,7,1c44e68)=SUCCESS
"DBI::db=HASH(0x1919710)" is not exported by the DBD::Oracle module
Can't continue after import errors at ./demo.pl line 7
BEGIN failed--compilation aborted at ./demo.pl line 15.
OCITransRollback(1c44d90,1c44e68,mode=DEFAULT 0)=SUCCESS
OCISessionEnd(1c44d90,1c44e68,1c81838,mode=DEFAULT 0)=SUCCESS
OCIServerDetach(1c45608,1c44e68,mode=DEFAULT,0)=SUCCESS
OCIHandleFree(1c81838,OCI_HTYPE_SESSION)=SUCCESS
OCIHandleFree(1c45608,OCI_HTYPE_SERVER)=SUCCESS
OCIHandleFree(1c44d90,OCI_HTYPE_SVCCTX)=SUCCESS
OCIHandleFree(1c44e68,OCI_HTYPE_ERROR)=SUCCESS
Looking through the makefile and running ldd on the .so file it seems to have
only used the 64 bit oracle libraries
Let me know if I can add anything.
Thanks
Gordon.
Napier University is the best modern university in Scotland* and number one in
Scotland for graduate employability**
(*Guardian University Guide 2009)
(**HESA 2008)
This message is intended for t
Re: DBD::Oracle on Oracle 11g 64 bit fedora 10
On Thu, 2009-03-26 at 06:49 -0400, John Scoles wrote:
> Scott T. Hildreth wrote:
> > On Mon, 2009-01-19 at 20:26 +, Russell, Gordon wrote:
> >
> >> Hi. I am hoping someone can look over this install info and tell me if it
> >> is all ok?
> >>
> >> I am having some worries with a new install of fedora 10.
> >> I also installed oracle 11.1.0.7.
> >> I have the latest DBI and am installing DBD Oracle 1.22. Note I have used
> >> DBD and Oracle for many many years.
> >> I have a 64 bit environment, UTF8 database and linux, with 32 bit
> >> compatibility libraries installed only to make the oracle installer tests
> >> happy.
> >>
> >>
> >
> > Gordon,
> >
> > Did you ever resolve this? We are moving to 11g now and I am having
> > the same issue. I originally thought it was a 11g client => 10g db
> > problem, but I can reproduce it trying to compile DBD::Oracle using a
> > 11g db. Oracle 11.1.0.7.0 is installed on SUSE Linux Enterprise Server
> > 10 (x86_64).
> >
> > Thanks,
> > Scott.
> >
> >
> >> In short, it works but produces some test errors. Not sure if I should
> >> just ignore them!
> >> Plenty of information follows... any suggestions appreciated.
> >>
> >> When building DBD Oracle, the tests come up with 3 fails:
> >> Test Summary Report
> >> ---
> >> t/26exe_array (Wstat: 512 Tests: 14 Failed: 2)
> >> Failed tests: 11, 14
> >> Non-zero exit status: 2
> >>
> I have raised this many time with Oracle as I think it is a bug on the
> 11g side as no code has changed. They of course say it is DBD::Oracle
> fault. It might have to do with space, buffering or permissions
> unfortunately I do not have steady access to an 11 db to do more
> extensive testing.
John, are you specifically talking about the exe_array here? Just for
the record all my tests pass, except the plsql test in 31lob.t
> >> t/30long(Wstat: 512 Tests: 30 Failed: 0)
> >> Non-zero exit status: 2
> >> Parse errors: Bad plan. You planned 479 tests but ran 30.
> >> t/31lob (Wstat: 256 Tests: 6 Failed: 1)
> >> Failed test: 6
> >> Non-zero exit status: 1
> >> Parse errors: Bad plan. You planned 9 tests but ran 6.
> >>
> >> The actual errors are:
> >> t/26exe_array...
> >> Dubious, test returned 2 (wstat 512, 0x200)
> >> Failed 2/14 subtests
> >> t/30longpanic: sv_len_utf8 cache 10240 real 81920 for
> >> 1234
> >> t/31lob.DBD::Oracle::st execute failed: ORA-24813: cannot
> >> send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute) [for
> >> Statement "BEGIN ? := DBMS_LOB.GETLENGTH( ? ); END;" with ParamValues:
> >> :p1=undef, :p2=OCILobLocatorPtr=SCALAR(0x19cb018)] at t/31lob.t line 108.
> >>
> >> Installing it anyway seems ok, but running:
> >> my $dbh = DBI->connect_cached('dbi:Oracle:sid',username,password,{
> >> RaiseError=> 1,
> >> PrintError=> 0,
> >> ShowErrorStatement=> 1,
> >> AutoCommit=> 0,
> >> ora_verbose=>6
> >>
> >> })
> >> Produces:
> >> OCINlsEnvironmentVariableGet(871,0,93,0,2)=SUCCESS
> >> OCINlsEnvironmentVariableGet(871,0,94,0,2)=SUCCESS
> >> OCINlsEnvCreate(1b8c5d0,THREADED |
> >> OBJECT,3,0,0,0,0,0,0,871,871)=SUCCESS
> >> OCIHandleAlloc(1c06220,1b8c5d8,OCI_HTYPE_ERROR,0,0)=SUCCESS
> >>charset id=871, name=UTF8, ncharset id=871, name=UTF8 (csid:
> >> utf8=871 al32utf8=873)
> >> OCIHandleAlloc(1c06220,1b8c5e0,OCI_HTYPE_SERVER,0,0)=SUCCESS
> >> OCIHandleAlloc(1c06220,1b8c5e8,OCI_HTYPE_SVCCTX,0,0)=SUCCESS
> >> OCIServerAttach(1c45608, 1c44e68, "sid", 3, mode=DEFAULT,0)=SUCCESS
> >> OCIAttrSet(1c44d90,OCI_HTYPE_SVCCTX,1c45608,0,6,1c44e68)=SUCCESS
> >> OCIHandleAlloc(1c06220,1b8c5f0,OCI_HTYPE_SESSION,0,0)=SUCCESS
> >> OCIAttrSet(1c81838,OCI_HTYPE_SESSION,1a1d348,8,22,1c44e68)=SUCCESS
> >> OCIAttrSet(1c81838,OCI_HTYPE_SESSION,1917d08,6,23,1c44e68)=SUCCESS
> >> OCISessionBegin(1c44d90,1c44e68,1c81838,1,mode=DEFAULT 0)=SUCCESS
> >> OCIAttrSet(1c44d90,OCI_HTYPE_SVCCTX,1c81838,0,7,1c44e68)=SUCCESS
> >> "DBI::db=HASH(0x1919710)" is not exported by the DBD::Oracle module
> >> Can't continue after import errors at ./demo.pl line 7
> >> BEGIN failed--compilation aborted at ./demo.pl line 15.
> >> OCITransRollback(1c44d90,1c44e68,mode=DEFAULT 0)=SUCCESS
> >> OCISessionEnd(1c44d90,1c44e68,1c81838,mode=DEFAULT 0)=SUCCESS
> >> OCIServerDetach(1c45608,1c44e68,mode=DEFAULT,0)=SUCCESS
> >> OCIHandleFree(1c81838,OCI_HTYPE_SESSION)=SUCCESS
> >> OCIHandleFree(1c45608,OCI_HTYPE_SERVER)=SUCCESS
> >> OCIHandleFree(1c44d90,OCI_HTYPE_SVCCTX)=SUCCESS
> >> OCIHandleFree(1c44e68,OCI_HTYPE_ERROR)=SUCCESS
> >>
> >> Looking through the makefile and running ldd on the .so file it seems to
> >> have only used the 64 bit oracle libraries
> >> Let me know if I can add an
Re: DBD::Oracle on Oracle 11g 64 bit fedora 10
Scott T. Hildreth wrote:
On Mon, 2009-01-19 at 20:26 +, Russell, Gordon wrote:
Hi. I am hoping someone can look over this install info and tell me if it is
all ok?
I am having some worries with a new install of fedora 10.
I also installed oracle 11.1.0.7.
I have the latest DBI and am installing DBD Oracle 1.22. Note I have used DBD
and Oracle for many many years.
I have a 64 bit environment, UTF8 database and linux, with 32 bit compatibility
libraries installed only to make the oracle installer tests happy.
Gordon,
Did you ever resolve this? We are moving to 11g now and I am having
the same issue. I originally thought it was a 11g client => 10g db
problem, but I can reproduce it trying to compile DBD::Oracle using a
11g db. Oracle 11.1.0.7.0 is installed on SUSE Linux Enterprise Server
10 (x86_64).
Thanks,
Scott.
In short, it works but produces some test errors. Not sure if I should just
ignore them!
Plenty of information follows... any suggestions appreciated.
When building DBD Oracle, the tests come up with 3 fails:
Test Summary Report
---
t/26exe_array (Wstat: 512 Tests: 14 Failed: 2)
Failed tests: 11, 14
Non-zero exit status: 2
I have raised this many time with Oracle as I think it is a bug on the
11g side as no code has changed. They of course say it is DBD::Oracle
fault. It might have to do with space, buffering or permissions
unfortunately I do not have steady access to an 11 db to do more
extensive testing.
t/30long(Wstat: 512 Tests: 30 Failed: 0)
Non-zero exit status: 2
Parse errors: Bad plan. You planned 479 tests but ran 30.
t/31lob (Wstat: 256 Tests: 6 Failed: 1)
Failed test: 6
Non-zero exit status: 1
Parse errors: Bad plan. You planned 9 tests but ran 6.
The actual errors are:
t/26exe_array...
Dubious, test returned 2 (wstat 512, 0x200)
Failed 2/14 subtests
t/30longpanic: sv_len_utf8 cache 10240 real 81920 for 1234
t/31lob.DBD::Oracle::st execute failed: ORA-24813: cannot send or receive
an unsupported LOB (DBD ERROR: OCIStmtExecute) [for Statement "BEGIN ? :=
DBMS_LOB.GETLENGTH( ? ); END;" with ParamValues: :p1=undef,
:p2=OCILobLocatorPtr=SCALAR(0x19cb018)] at t/31lob.t line 108.
Installing it anyway seems ok, but running:
my $dbh = DBI->connect_cached('dbi:Oracle:sid',username,password,{
RaiseError=> 1,
PrintError=> 0,
ShowErrorStatement=> 1,
AutoCommit=> 0,
ora_verbose=>6
})
Produces:
OCINlsEnvironmentVariableGet(871,0,93,0,2)=SUCCESS
OCINlsEnvironmentVariableGet(871,0,94,0,2)=SUCCESS
OCINlsEnvCreate(1b8c5d0,THREADED | OBJECT,3,0,0,0,0,0,0,871,871)=SUCCESS
OCIHandleAlloc(1c06220,1b8c5d8,OCI_HTYPE_ERROR,0,0)=SUCCESS
charset id=871, name=UTF8, ncharset id=871, name=UTF8 (csid: utf8=871
al32utf8=873)
OCIHandleAlloc(1c06220,1b8c5e0,OCI_HTYPE_SERVER,0,0)=SUCCESS
OCIHandleAlloc(1c06220,1b8c5e8,OCI_HTYPE_SVCCTX,0,0)=SUCCESS
OCIServerAttach(1c45608, 1c44e68, "sid", 3, mode=DEFAULT,0)=SUCCESS
OCIAttrSet(1c44d90,OCI_HTYPE_SVCCTX,1c45608,0,6,1c44e68)=SUCCESS
OCIHandleAlloc(1c06220,1b8c5f0,OCI_HTYPE_SESSION,0,0)=SUCCESS
OCIAttrSet(1c81838,OCI_HTYPE_SESSION,1a1d348,8,22,1c44e68)=SUCCESS
OCIAttrSet(1c81838,OCI_HTYPE_SESSION,1917d08,6,23,1c44e68)=SUCCESS
OCISessionBegin(1c44d90,1c44e68,1c81838,1,mode=DEFAULT 0)=SUCCESS
OCIAttrSet(1c44d90,OCI_HTYPE_SVCCTX,1c81838,0,7,1c44e68)=SUCCESS
"DBI::db=HASH(0x1919710)" is not exported by the DBD::Oracle module
Can't continue after import errors at ./demo.pl line 7
BEGIN failed--compilation aborted at ./demo.pl line 15.
OCITransRollback(1c44d90,1c44e68,mode=DEFAULT 0)=SUCCESS
OCISessionEnd(1c44d90,1c44e68,1c81838,mode=DEFAULT 0)=SUCCESS
OCIServerDetach(1c45608,1c44e68,mode=DEFAULT,0)=SUCCESS
OCIHandleFree(1c81838,OCI_HTYPE_SESSION)=SUCCESS
OCIHandleFree(1c45608,OCI_HTYPE_SERVER)=SUCCESS
OCIHandleFree(1c44d90,OCI_HTYPE_SVCCTX)=SUCCESS
OCIHandleFree(1c44e68,OCI_HTYPE_ERROR)=SUCCESS
Looking through the makefile and running ldd on the .so file it seems to have
only used the 64 bit oracle libraries
Let me know if I can add anything.
Thanks
Gordon.
Napier University is the best modern university in Scotland* and number one in
Scotland for graduate employability**
(*Guardian University Guide 2009)
(**HESA 2008)
This message is intended for the addressee(s) only and should not be read,
copied or disclosed to anyone else outwith the University without the
permission of the sender.
It is your responsibility to ensure that this message and any attachments are
scanned for viruses or other defects. Napier University does not accept
liability for any loss or damage which may result from this email or any
attachment, or for errors or omissions arising after it was sent
RE: DBD::Oracle on Oracle 11g 64 bit fedora 10
from what i've seen if ANY 32bit library found in the path
(LD_LIBRARY_PATH/LIB) causes
the process fails back to 32 bit behaviour
Just as a test I have a processor which is 64bit and when I load in 64bit
(Oracle Type 2 Oracle Call Interface) libraries the performance more than
doubles
My 2 cents
Martin
__
Verzicht und Vertraulichkeitanmerkung / Disclaimer and confidentiality note
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung
fuer den Inhalt uebernehmen.
This message is confidential and may be privileged. If you are not the intended
recipient, we kindly ask you to please inform the sender. Any unauthorised
dissemination or copying hereof is prohibited. This message serves for
information purposes only and shall not have any legally binding effect. Given
that e-mails can easily be subject to manipulation, we can not accept any
liability for the content provided.
> From: g.russ...@napier.ac.uk
> To: shild...@scotth.emsphone.com
> CC: dbi-users@perl.org
> Date: Wed, 25 Mar 2009 21:07:53 +0000
> Subject: RE: DBD::Oracle on Oracle 11g 64 bit fedora 10
>
>
> Hi.
> No still no good solution. However it doesnt seem to make any difference.
> I have been running this in a production server without error for 2 months
> now.
> I downloaded the development version directly, and I couldnt see any real
> difference in the messages, and thus I stuck with the released version.
>
> Let me know if you many any discoveries.
> Gordon.
>
>
> From: Scott T. Hildreth [shild...@scotth.emsphone.com]
> Sent: 25 March 2009 19:44
> To: Russell, Gordon
> Cc: dbi-users@perl.org
> Subject: Re: DBD::Oracle on Oracle 11g 64 bit fedora 10
>
> On Mon, 2009-01-19 at 20:26 +, Russell, Gordon wrote:
> >
> > Hi. I am hoping someone can look over this install info and tell me if it
> > is all ok?
> >
> > I am having some worries with a new install of fedora 10.
> > I also installed oracle 11.1.0.7.
> > I have the latest DBI and am installing DBD Oracle 1.22. Note I have used
> > DBD and Oracle for many many years.
> > I have a 64 bit environment, UTF8 database and linux, with 32 bit
> > compatibility libraries installed only to make the oracle installer tests
> > happy.
> >
>
> Gordon,
>
> Did you ever resolve this? We are moving to 11g now and I am having
> the same issue. I originally thought it was a 11g client => 10g db
> problem, but I can reproduce it trying to compile DBD::Oracle using a
> 11g db. Oracle 11.1.0.7.0 is installed on SUSE Linux Enterprise Server
> 10 (x86_64).
>
> Thanks,
> Scott.
>
> > In short, it works but produces some test errors. Not sure if I should just
> > ignore them!
> > Plenty of information follows... any suggestions appreciated.
> >
> > When building DBD Oracle, the tests come up with 3 fails:
> > Test Summary Report
> > ---
> > t/26exe_array (Wstat: 512 Tests: 14 Failed: 2)
> > Failed tests: 11, 14
> > Non-zero exit status: 2
> > t/30long(Wstat: 512 Tests: 30 Failed: 0)
> > Non-zero exit status: 2
> > Parse errors: Bad plan. You planned 479 tests but ran 30.
> > t/31lob (Wstat: 256 Tests: 6 Failed: 1)
> > Failed test: 6
> > Non-zero exit status: 1
> > Parse errors: Bad plan. You planned 9 tests but ran 6.
> >
> > The actual errors are:
> > t/26exe_array...
> > Dubious, test returned 2 (wstat 512, 0x200)
> > Failed 2/14 subtests
> > t/30longpanic: sv_len_utf8 cache 10240 real 81920 for
> > 1234
> > t/31lob.DBD::Oracle::st execute failed: ORA-24813: cannot
> > send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute) [for
> > Statement "BEGIN ? := DBMS_LOB.GETLENGTH( ? ); END;" with ParamValues:
> > :p1=undef, :p2=OCILobLocatorPtr=SCALAR(0x19cb018)] at t/31lob.t line 108.
> >
> > Installing it anyway seems ok, but running:
> > my $dbh = DBI->connect_cached('dbi:Oracle:sid',username,password,{
> > RaiseError=> 1,
> > PrintError=> 0,
> > ShowErrorStatement=> 1,
> > AutoCommit=> 0,
> > ora_verbose=>6
> >
RE: DBD::Oracle on Oracle 11g 64 bit fedora 10
Hi.
No still no good solution. However it doesnt seem to make any difference.
I have been running this in a production server without error for 2 months now.
I downloaded the development version directly, and I couldnt see any real
difference in the messages, and thus I stuck with the released version.
Let me know if you many any discoveries.
Gordon.
From: Scott T. Hildreth [shild...@scotth.emsphone.com]
Sent: 25 March 2009 19:44
To: Russell, Gordon
Cc: dbi-users@perl.org
Subject: Re: DBD::Oracle on Oracle 11g 64 bit fedora 10
On Mon, 2009-01-19 at 20:26 +, Russell, Gordon wrote:
>
> Hi. I am hoping someone can look over this install info and tell me if it is
> all ok?
>
> I am having some worries with a new install of fedora 10.
> I also installed oracle 11.1.0.7.
> I have the latest DBI and am installing DBD Oracle 1.22. Note I have used DBD
> and Oracle for many many years.
> I have a 64 bit environment, UTF8 database and linux, with 32 bit
> compatibility libraries installed only to make the oracle installer tests
> happy.
>
Gordon,
Did you ever resolve this? We are moving to 11g now and I am having
the same issue. I originally thought it was a 11g client => 10g db
problem, but I can reproduce it trying to compile DBD::Oracle using a
11g db. Oracle 11.1.0.7.0 is installed on SUSE Linux Enterprise Server
10 (x86_64).
Thanks,
Scott.
> In short, it works but produces some test errors. Not sure if I should just
> ignore them!
> Plenty of information follows... any suggestions appreciated.
>
> When building DBD Oracle, the tests come up with 3 fails:
> Test Summary Report
> ---
> t/26exe_array (Wstat: 512 Tests: 14 Failed: 2)
> Failed tests: 11, 14
> Non-zero exit status: 2
> t/30long(Wstat: 512 Tests: 30 Failed: 0)
> Non-zero exit status: 2
> Parse errors: Bad plan. You planned 479 tests but ran 30.
> t/31lob (Wstat: 256 Tests: 6 Failed: 1)
> Failed test: 6
> Non-zero exit status: 1
> Parse errors: Bad plan. You planned 9 tests but ran 6.
>
> The actual errors are:
> t/26exe_array...
> Dubious, test returned 2 (wstat 512, 0x200)
> Failed 2/14 subtests
> t/30longpanic: sv_len_utf8 cache 10240 real 81920 for 1234
> t/31lob.DBD::Oracle::st execute failed: ORA-24813: cannot
> send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute) [for Statement
> "BEGIN ? := DBMS_LOB.GETLENGTH( ? ); END;" with ParamValues: :p1=undef,
> :p2=OCILobLocatorPtr=SCALAR(0x19cb018)] at t/31lob.t line 108.
>
> Installing it anyway seems ok, but running:
> my $dbh = DBI->connect_cached('dbi:Oracle:sid',username,password,{
> RaiseError=> 1,
> PrintError=> 0,
> ShowErrorStatement=> 1,
> AutoCommit=> 0,
> ora_verbose=>6
>
> })
> Produces:
> OCINlsEnvironmentVariableGet(871,0,93,0,2)=SUCCESS
> OCINlsEnvironmentVariableGet(871,0,94,0,2)=SUCCESS
> OCINlsEnvCreate(1b8c5d0,THREADED |
> OBJECT,3,0,0,0,0,0,0,871,871)=SUCCESS
> OCIHandleAlloc(1c06220,1b8c5d8,OCI_HTYPE_ERROR,0,0)=SUCCESS
>charset id=871, name=UTF8, ncharset id=871, name=UTF8 (csid: utf8=871
> al32utf8=873)
> OCIHandleAlloc(1c06220,1b8c5e0,OCI_HTYPE_SERVER,0,0)=SUCCESS
> OCIHandleAlloc(1c06220,1b8c5e8,OCI_HTYPE_SVCCTX,0,0)=SUCCESS
> OCIServerAttach(1c45608, 1c44e68, "sid", 3, mode=DEFAULT,0)=SUCCESS
> OCIAttrSet(1c44d90,OCI_HTYPE_SVCCTX,1c45608,0,6,1c44e68)=SUCCESS
> OCIHandleAlloc(1c06220,1b8c5f0,OCI_HTYPE_SESSION,0,0)=SUCCESS
> OCIAttrSet(1c81838,OCI_HTYPE_SESSION,1a1d348,8,22,1c44e68)=SUCCESS
> OCIAttrSet(1c81838,OCI_HTYPE_SESSION,1917d08,6,23,1c44e68)=SUCCESS
> OCISessionBegin(1c44d90,1c44e68,1c81838,1,mode=DEFAULT 0)=SUCCESS
> OCIAttrSet(1c44d90,OCI_HTYPE_SVCCTX,1c81838,0,7,1c44e68)=SUCCESS
> "DBI::db=HASH(0x1919710)" is not exported by the DBD::Oracle module
> Can't continue after import errors at ./demo.pl line 7
> BEGIN failed--compilation aborted at ./demo.pl line 15.
> OCITransRollback(1c44d90,1c44e68,mode=DEFAULT 0)=SUCCESS
> OCISessionEnd(1c44d90,1c44e68,1c81838,mode=DEFAULT 0)=SUCCESS
> OCIServerDetach(1c45608,1c44e68,mode=DEFAULT,0)=SUCCESS
> OCIHandleFree(1c81838,OCI_HTYPE_SESSION)=SUCCESS
> OCIHandleFree(1c45608,OCI_HTYPE_SERVER)=SUCCESS
> OCIHandleFree(1c44d90,OCI_HTYPE_SVCCTX)=SUCCESS
> OCIHandleFree(1c44e68,OCI_HTYPE_ERROR)=SUCCESS
>
> Looking through the makefile and running ldd on the .so file it seems to have
> only used the 64 bit oracle libra
Re: DBD::Oracle on Oracle 11g 64 bit fedora 10
On Mon, 2009-01-19 at 20:26 +, Russell, Gordon wrote:
>
> Hi. I am hoping someone can look over this install info and tell me if it is
> all ok?
>
> I am having some worries with a new install of fedora 10.
> I also installed oracle 11.1.0.7.
> I have the latest DBI and am installing DBD Oracle 1.22. Note I have used DBD
> and Oracle for many many years.
> I have a 64 bit environment, UTF8 database and linux, with 32 bit
> compatibility libraries installed only to make the oracle installer tests
> happy.
>
Gordon,
Did you ever resolve this? We are moving to 11g now and I am having
the same issue. I originally thought it was a 11g client => 10g db
problem, but I can reproduce it trying to compile DBD::Oracle using a
11g db. Oracle 11.1.0.7.0 is installed on SUSE Linux Enterprise Server
10 (x86_64).
Thanks,
Scott.
> In short, it works but produces some test errors. Not sure if I should just
> ignore them!
> Plenty of information follows... any suggestions appreciated.
>
> When building DBD Oracle, the tests come up with 3 fails:
> Test Summary Report
> ---
> t/26exe_array (Wstat: 512 Tests: 14 Failed: 2)
> Failed tests: 11, 14
> Non-zero exit status: 2
> t/30long(Wstat: 512 Tests: 30 Failed: 0)
> Non-zero exit status: 2
> Parse errors: Bad plan. You planned 479 tests but ran 30.
> t/31lob (Wstat: 256 Tests: 6 Failed: 1)
> Failed test: 6
> Non-zero exit status: 1
> Parse errors: Bad plan. You planned 9 tests but ran 6.
>
> The actual errors are:
> t/26exe_array...
> Dubious, test returned 2 (wstat 512, 0x200)
> Failed 2/14 subtests
> t/30longpanic: sv_len_utf8 cache 10240 real 81920 for 1234
> t/31lob.DBD::Oracle::st execute failed: ORA-24813: cannot
> send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute) [for Statement
> "BEGIN ? := DBMS_LOB.GETLENGTH( ? ); END;" with ParamValues: :p1=undef,
> :p2=OCILobLocatorPtr=SCALAR(0x19cb018)] at t/31lob.t line 108.
>
> Installing it anyway seems ok, but running:
> my $dbh = DBI->connect_cached('dbi:Oracle:sid',username,password,{
> RaiseError=> 1,
> PrintError=> 0,
> ShowErrorStatement=> 1,
> AutoCommit=> 0,
> ora_verbose=>6
>
> })
> Produces:
> OCINlsEnvironmentVariableGet(871,0,93,0,2)=SUCCESS
> OCINlsEnvironmentVariableGet(871,0,94,0,2)=SUCCESS
> OCINlsEnvCreate(1b8c5d0,THREADED |
> OBJECT,3,0,0,0,0,0,0,871,871)=SUCCESS
> OCIHandleAlloc(1c06220,1b8c5d8,OCI_HTYPE_ERROR,0,0)=SUCCESS
>charset id=871, name=UTF8, ncharset id=871, name=UTF8 (csid: utf8=871
> al32utf8=873)
> OCIHandleAlloc(1c06220,1b8c5e0,OCI_HTYPE_SERVER,0,0)=SUCCESS
> OCIHandleAlloc(1c06220,1b8c5e8,OCI_HTYPE_SVCCTX,0,0)=SUCCESS
> OCIServerAttach(1c45608, 1c44e68, "sid", 3, mode=DEFAULT,0)=SUCCESS
> OCIAttrSet(1c44d90,OCI_HTYPE_SVCCTX,1c45608,0,6,1c44e68)=SUCCESS
> OCIHandleAlloc(1c06220,1b8c5f0,OCI_HTYPE_SESSION,0,0)=SUCCESS
> OCIAttrSet(1c81838,OCI_HTYPE_SESSION,1a1d348,8,22,1c44e68)=SUCCESS
> OCIAttrSet(1c81838,OCI_HTYPE_SESSION,1917d08,6,23,1c44e68)=SUCCESS
> OCISessionBegin(1c44d90,1c44e68,1c81838,1,mode=DEFAULT 0)=SUCCESS
> OCIAttrSet(1c44d90,OCI_HTYPE_SVCCTX,1c81838,0,7,1c44e68)=SUCCESS
> "DBI::db=HASH(0x1919710)" is not exported by the DBD::Oracle module
> Can't continue after import errors at ./demo.pl line 7
> BEGIN failed--compilation aborted at ./demo.pl line 15.
> OCITransRollback(1c44d90,1c44e68,mode=DEFAULT 0)=SUCCESS
> OCISessionEnd(1c44d90,1c44e68,1c81838,mode=DEFAULT 0)=SUCCESS
> OCIServerDetach(1c45608,1c44e68,mode=DEFAULT,0)=SUCCESS
> OCIHandleFree(1c81838,OCI_HTYPE_SESSION)=SUCCESS
> OCIHandleFree(1c45608,OCI_HTYPE_SERVER)=SUCCESS
> OCIHandleFree(1c44d90,OCI_HTYPE_SVCCTX)=SUCCESS
> OCIHandleFree(1c44e68,OCI_HTYPE_ERROR)=SUCCESS
>
> Looking through the makefile and running ldd on the .so file it seems to have
> only used the 64 bit oracle libraries
> Let me know if I can add anything.
>
> Thanks
> Gordon.
>
>
> Napier University is the best modern university in Scotland* and number one
> in Scotland for graduate employability**
> (*Guardian University Guide 2009)
> (**HESA 2008)
>
> This message is intended for the addressee(s) only and should not be read,
> copied or disclosed to anyone else outwith the University without the
> permission of the sender.
> It is your responsibility to ensure that this message and any attachments are
> scanned for viruses or other defects. Napier University does not accept
> liability for any loss or damage which may result from this email or any
> attachment, or for errors or omissions arising after it was sent. Email is
> not a secure medium. Email entering the University's system is subject to
> routine monitoring and filtering by the University.
> Napi
