Front page | perl.dbi.users |
Postings from January 2007
Re: DBD::Oracle-1.19 installation errors
Thread Previous
|
Thread Next
From:
Michael Nhan
Date:
January 30, 2007 07:05
Subject:
Re: DBD::Oracle-1.19 installation errors
Message ID:
Pine.GSO.4.62.0701300903260.2986@analysis450.gsc.wustl.edu
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
Thread Previous
|
Thread Next