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" <[EMAIL PROTECTED]>
To: Michael Nhan <[EMAIL PROTECTED]>
Cc: [email protected], "Rahrig, Robert" <[EMAIL PROTECTED]>,
Unix Sys Admin <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
Sent: Tuesday, January 30, 2007 10:05 AM
To: Pham, Tri
Cc: [email protected]; 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" <[EMAIL PROTECTED]>
To: [email protected]
Cc: "Rahrig, Robert" <[EMAIL PROTECTED]>,
Unix Sys Admin <[EMAIL PROTECTED]>
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.
[EMAIL PROTECTED]:/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
