DBD::Oracle-1.19 installation errors

------_=_NextPart_001_01C743EA.4467D759
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

To DBI support group,

=20

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.=20

=20

root@httpwas1stg:/workarea/DBI/DBD-Oracle-1.19# make test

PERL_DL_NONLAZY=3D1 /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 '', NLS_NCHAR is ''

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 =3D templob.sid

AND sess.audsid =3D userenv('sessionid') ') [for Statement "

SELECT cache_lobs + nocache_lobs AS temp_lob_count

FROM v$temporary_lobs templob,

v$session sess

WHERE sess.sid =3D templob.sid

AND sess.audsid =3D 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.

=20

=20

Stop.

=20

Thanks

=20

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=20
attachments.

************************************************************ **********


------_=_NextPart_001_01C743EA.4467D759--

Re: DBD::Oracle-1.19 installation errors

Hi not really aq problem with DBD::Oracle it is simply a permission problem
the Oracle has with the username and password that you chose to run your
test.

The user for this test must have permissions on system tables like v$session
etc. Try changing your test username/password to one with system admin
privilages.

Other than that your DBD::Oracle seem fine.

Cheers


""Pham, Tri"" wrote in message
news:FABCDD3FA9874642B38678FF038B92620E12D1AF@vo-dca-ex07.VA LUEOPTIONS.FHC1.NET...
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 '', NLS_NCHAR is ''

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.

************************************************************ **********

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"
> To: dbi-users@perl.org
> Cc: "Rahrig, Robert" ,
> Unix Sys Admin
> 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 '', NLS_NCHAR is ''
>
> 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

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

Software error:

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

For help, please send mail to this site's webmaster, giving this error
message=20
and the time and date of the error.

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"
> To: Michael Nhan
> Cc: dbi-users@perl.org, "Rahrig, Robert" ,
> Unix Sys Admin
> 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
>

Software error:

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

> 

> For help, please send mail to this site's webmaster, giving this error
> message
> and the time and date of the error.
>
>

RE: DBD::Oracle-1.19 installation errors

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.=20

Tri Pham

-----Original Message-----
From: Michael Nhan [mailto:mnhan@watson.wustl.edu]=20
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=20
just installed with? The error suggest that its detecting verion 1.14=20
module files when its expecting version 1.19 so dynloader dies due to=20
version conflict. DynaLoader isn't having a problem, its reporting the=20
problem. The problem is that there are version conflict in the=20
DBD-Oracle. There are dbd-oracle 1.14 files in the modules lib along
with=20
1.19 and its picking up missmatching version. Locate the version=20
conflicted files and update the 1.14 file with the 1.19 ones to get rid
of=20
the conflict. The problem file is probably Oracle.so , most likely the=20
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=20
installed.

Regards,

Michael


> Date: Tue, 30 Jan 2007 11:06:11 -0500
> From: "Pham, Tri"
> To: Michael Nhan
> Cc: dbi-users@perl.org, "Rahrig, Robert"
,
> Unix Sys Admin
> Subject: RE: DBD::Oracle-1.19 installation errors
>=20
> 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
>

Software error:

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

> 

> For help, please send mail to this site's webmaster, giving this error
> message
> and the time and date of the error.
>
>