Front page | perl.dbi.users |
Postings from January 2007
RE: DBD::Oracle-1.19 installation errors
Thread Previous
|
Thread Next
From:
Pham, Tri
Date:
January 30, 2007 18:53
Subject:
RE: DBD::Oracle-1.19 installation errors
Message ID:
FABCDD3FA9874642B38678FF038B92620E12D478@vo-dca-ex07.VALUEOPTIONS.FHC1.NET
Michael,
Thank you very much. I found the file "Oracle.pm" locate in
/usr/opt/perl5/lib/5.8.2/aix-thread-multi/DBD directory hard coded
"DBD::Oracle-1.14" within the file. I replace the file newer version in
the download file and it is worked.
Tri Pham
-----Original Message-----
From: Michael Nhan [mailto:mnhan@watson.wustl.edu]
Sent: Tuesday, January 30, 2007 12:12 PM
To: Pham, Tri
Cc: dbi-users@perl.org; Rahrig, Robert; Unix Sys Admin
Subject: RE: DBD::Oracle-1.19 installation errors
Hi,
Is the cgi script using the same perl which the new dbd-oracle 1.19 was
just installed with? The error suggest that its detecting verion 1.14
module files when its expecting version 1.19 so dynloader dies due to
version conflict. DynaLoader isn't having a problem, its reporting the
problem. The problem is that there are version conflict in the
DBD-Oracle. There are dbd-oracle 1.14 files in the modules lib along
with
1.19 and its picking up missmatching version. Locate the version
conflicted files and update the 1.14 file with the 1.19 ones to get rid
of
the conflict. The problem file is probably Oracle.so , most likely the
make install was not able to overwrite it. Try deleting it manually and
doing another make install in the DBD-Oracl-1.19 to get the file
installed.
Regards,
Michael
> Date: Tue, 30 Jan 2007 11:06:11 -0500
> From: "Pham, Tri" <Tri.Pham@valueoptions.com>
> To: Michael Nhan <mnhan@watson.wustl.edu>
> Cc: dbi-users@perl.org, "Rahrig, Robert"
<Robert.Rahrig@valueoptions.com>,
> Unix Sys Admin <UnixSysAdmin2@valueoptions.com>
> Subject: RE: DBD::Oracle-1.19 installation errors
>
> Michael,
>
> Thank you for your respond. My DBA gave me the user/password, the
> "make test" and "make install" were completed with no error but I got
> the new error when I try execute the cgi script. The errors are
related
> to DynaLoader module. The DynaLoader module version 1.04, it come with
> new Perl 5.8.2.
>
> httpwas1stg:/usr/WebSphere/ihs/htdocs/voice/mbhp> ./dcMBHPChecks.cgi
> <h1>Software error:</h1>
> <pre>install_driver(Oracle) failed: DBD::Oracle object version 1.19
does
> not match bootstrap parameter 1.14 at
> /usr/opt/perl5/lib/5.8.2/aix-thread-multi/DynaLoader.pm line 249.
> Compilation failed in require at (eval 10) line 3.
>
> at dcFunctions.pl line 762
> </pre>
> <p>
> For help, please send mail to this site's webmaster, giving this error
> message
> and the time and date of the error.
>
> </p>
> [Mon Jan 29 16:58:20 2007] dcMBHPChecks.cgi: install_driver(Oracle)
> failed: DBD::Oracle object version 1.19 does not match bootstrap
> parameter 1.14 at
> /usr/opt/perl5/lib/5.8.2/aix-thread-multi/DynaLoader.pm line 249.
> [Mon Jan 29 16:58:20 2007] dcMBHPChecks.cgi: Compilation failed in
> require at (eval 10) line 3.
> [Mon Jan 29 16:58:20 2007] dcMBHPChecks.cgi:
> [Mon Jan 29 16:58:20 2007] dcMBHPChecks.cgi: at dcFunctions.pl line
762
>
> I appreciate for your help.
>
> Thanks,
>
> Tri Pham
>
> -----Original Message-----
> From: Michael Nhan [mailto:mnhan@watson.wustl.edu]
> Sent: Tuesday, January 30, 2007 10:05 AM
> To: Pham, Tri
> Cc: dbi-users@perl.org; Rahrig, Robert; Unix Sys Admin
> Subject: Re: DBD::Oracle-1.19 installation errors
>
> Hi,
>
> Speak with your dba and ask to he/she to grant the user you are using
in
>
> the db permission to select on v$session.
>
> Regards,
> Michael
>
>
>> Date: Mon, 29 Jan 2007 16:13:04 -0500
>> From: "Pham, Tri" <Tri.Pham@valueoptions.com>
>> To: dbi-users@perl.org
>> Cc: "Rahrig, Robert" <Robert.Rahrig@valueoptions.com>,
>> Unix Sys Admin <UnixSysAdmin2@valueoptions.com>
>> Subject: DBD::Oracle-1.19 installation errors
>>
>> To DBI support group,
>>
>>
>>
>> I try to install DBD::Oracle-1.19 on our IBM AIX 5.3 server. Perl
>> 5.82. I got these errors when I run the command "make test". I
already
>> ran "perl Makefile.PL" and "make" which have no error. I appreciate
> for
>> your help.
>>
>>
>>
>> root@httpwas1stg:/workarea/DBI/DBD-Oracle-1.19# make test
>>
>> PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
>> "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
>>
>> t/01base................ok
>>
>>
>> t/10general.............ok
>>
>>
>> t/15nls.................ok
>>
>>
>> t/20select..............ok
>>
>>
>> t/21nchar............... Database and client versions and character
>> sets:
>>
>> Database 9.2.0.1.0 CHAR set is US7ASCII (Non-Unicode), NCHAR set is
>> AL16UTF16 (Unicode)
>>
>> Client 9.2.0.1 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
>>
>>
>> t/26exe_array...........ok
>>
>>
>> t/30long................ok
>>
>>
>> 122/470 skipped: various reasons
>>
>> t/31lob.................ok 8/9DBD::Oracle::db selectrow_array failed:
>> ORA-00942: table or view does not exist (DBD ERROR: error possibly
> near
>> <*> indicator at char 103 in '
>>
>> SELECT cache_lobs + nocache_lobs AS temp_lob_count
>>
>> FROM v$temporary_lobs templob,
>>
>> <*>v$session sess
>>
>> WHERE sess.sid = templob.sid
>>
>> AND sess.audsid = userenv('sessionid') ') [for Statement "
>>
>> SELECT cache_lobs + nocache_lobs AS temp_lob_count
>>
>> FROM v$temporary_lobs templob,
>>
>> v$session sess
>>
>> WHERE sess.sid = templob.sid
>>
>> AND sess.audsid = userenv('sessionid') "] at t/31lob.t line 58.
>>
>> # Failed test (t/31lob.t at line 166)
>>
>> # got: undef
>>
>> # expected: '0'
>>
>> t/31lob.................NOK 9# Looks like you failed 1 tests of 9.
>>
>>
>> t/31lob.................dubious
>>
>>
>> Test returned status 1 (wstat 256, 0x100)
>>
>> DIED. FAILED test 9
>>
>> Failed 1/9 tests, 88.89% okay
>>
>> t/40ph_type.............ok
>>
>>
>> t/50cursor..............ok
>>
>>
>> t/55nested..............ok
>>
>>
>> t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped.
>>
>> skipped
>>
>> all skipped: no reason given
>>
>> t/70meta................ok
>>
>>
>> Failed Test Stat Wstat Total Fail Failed List of Failed
>>
>>
>
------------------------------------------------------------------------
>> -------
>>
>> t/31lob.t 1 256 9 1 11.11% 9
>>
>> 4 tests and 122 subtests skipped.
>>
>> Failed 1/20 test scripts, 95.00% okay. 1/935 subtests failed, 99.89%
>> okay.
>>
>> make: 1254-004 The error code from the last command is 2.
>>
>>
>>
>>
>>
>> Stop.
>>
>>
>>
>> Thanks
>>
>>
>>
>> Tri Pham
>>
>>
>>
>>
**********************************************************************
>> This email and any files transmitted with it are confidential and
>> intended solely for the use of the individual or entity to whom they
>> are addressed. If you have received this email in error please
notify
>> the sender by email, delete and destroy this message and its
>> attachments.
>>
>>
**********************************************************************
>>
>>
>
> ---//---
> "He who learns must suffer. And even in our sleep,
> pain that cannot forget, falls drop by drop upon the heart;
> and, in our own despair, against our will,
> comes wisdom to us by the awful grace of God."
> --- Aeschylus
>
>
---//---
"He who learns must suffer. And even in our sleep,
pain that cannot forget, falls drop by drop upon the heart;
and, in our own despair, against our will,
comes wisdom to us by the awful grace of God."
--- Aeschylus
Thread Previous
|
Thread Next