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 +0000, 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/30long................panic: 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.
> >>>> Napier University is a registered Scottish charity. Registration number
> >>>> SC018373
> >>>>
> >>>>
> >>>>
> >>>>
