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
