Re: DBD::Oracle-1.19 installation errors
- From: mnhan@xxxxxxxxxxxxxxxx (Michael Nhan)
- Date: Tue, 30 Jan 2007 09:04:48 -0600 (CST)
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@xxxxxxxxxxxxxxxx>
To: dbi-users@xxxxxxxx
Cc: "Rahrig, Robert" <Robert.Rahrig@xxxxxxxxxxxxxxxx>,
Unix Sys Admin <UnixSysAdmin2@xxxxxxxxxxxxxxxx>
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
.
- References:
- DBD::Oracle-1.19 installation errors
- From: Tri Pham
- DBD::Oracle-1.19 installation errors
- Prev by Date: Re: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server
- Next by Date: Re: installing DBD-Informix on fedora 6
- Previous by thread: Re: DBD::Oracle-1.19 installation errors
- Next by thread: RE: DBD::Oracle-1.19 installation errors
- Index(es):
Relevant Pages
|
|
