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