Urgent request or help from our dbi-user community:
I have tried 7 different ways to reinstall DBI-1.43 and DBD-1.15 for
Perl 5.6.1 on the HPUX 11, Oracle 9.2.0, Apache Server, since 7 AM this
morning. They all failed with two types of DBI or DBD errors.
(Type I)
After running a Perl script to test the Database connection, I received:
11/06/04 18:47:21 Start Test_Perl.pl
DBI connect('our_db_inst_name','db_user_name',...) failed: ERROR
OCIEnvInit at /Our_path/perl5/Another_path/Our_db.pm line 52
Our_DB_Name database not available => ERROR OCIEnvInit
(Type II)
After running a Perl script to test the Database connection, I received:
11/06/04 18:32:49 Start Test_Perl.pl
install_driver(Oracle) failed: Can't load
'/Our_path/apache/perl/lib/site_perl/5.6.1/PA-RISC2.0-thread-multi/auto/
DBD/
Oracle/Oracle.sl' for module DBD::Oracle: No such file or directory at
/Our_path/apache/perl/lib/5.6.1/PA-RISC2.0-thre
ad-multi/DynaLoader.pm line 206.
at (eval 4) line 3
Compilation failed in require at (eval 4) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /Our_path/perl5/Another_path/Our_db.pm line 52
Here is the example of 1st step to build our DBI:
Our_machine:/Our_path/tmp/DBI/DBI-1.43> perl Makefile.PL
*** You are using a perl configured with threading enabled.
*** You should be aware that using multiple threads is
*** not recommended for production environments.
*** Note:
The optional PlRPC-modules (RPC::PlServer etc) are not installed.
If you want to use the DBD::Proxy driver and DBI::ProxyServer
modules, then you'll need to install the RPC::PlServer,
RPC::PlClient,
Storable and Net::Daemon modules. The CPAN Bundle::DBI may help you.
You can install them any time after installing the DBI.
You do *not* need these modules for typical DBI usage.
Optional modules are available from any CPAN mirror, in particular
http://search.cpan.org/
http://www.perl.com/CPAN/modules/by-module
http://www.perl.org/CPAN/modules/by-module
ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module
Creating DBI::PurePerl test variant: t/zvpp_01basics.t
Creating DBI::PurePerl test variant: t/zvpp_02dbidrv.t
Creating DBI::PurePerl test variant: t/zvpp_03handle.t
Creating DBI::PurePerl test variant: t/zvpp_04mods.t
Creating DBI::PurePerl test variant: t/zvpp_05thrclone.t
Creating DBI::PurePerl test variant: t/zvpp_06attrs.t
Creating DBI::PurePerl test variant: t/zvpp_07kids.t
Creating DBI::PurePerl test variant: t/zvpp_08keeperr.t
Creating DBI::PurePerl test variant: t/zvpp_09trace.t
Creating DBI::PurePerl test variant: t/zvpp_10examp.t
Creating DBI::PurePerl test variant: t/zvpp_15array.t
Creating DBI::PurePerl test variant: t/zvpp_20meta.t
Creating DBI::PurePerl test variant: t/zvpp_30subclass.t
Creating DBI::PurePerl test variant: t/zvpp_40profile.t
Creating DBI::PurePerl test variant: t/zvpp_41prof_dump.t
Creating DBI::PurePerl test variant: t/zvpp_42prof_data.t
Creating DBI::PurePerl test variant: t/zvpp_50dbm.t
Creating DBI::PurePerl test variant: t/zvpp_60preparse.t
Creating DBI::PurePerl test variant: t/zvpp_80proxy.t
Checking if your kit is complete...
Looks good
Warning: prerequisite Test::More failed to load: Can't locate
Test/More.pm in @INC (@INC contains: lib /Our_path/apach
/Our_path/lib/5.6.1/PA-RISC2.0-thread-multi
/Our_path/apache/perl/lib/5.6.1/PA-RISC2.0-thread-multi
/Our_path/apache/pe
rl/lib/5.6.1
/Our_path/apache/perl/lib/site_perl/5.6.1/PA-RISC2.0-thread-multi
/Our_path/apache/perl/lib/site_perl/5
.6.1/PA-RISC2.0-thread-multi /Our_path/apache/perl/lib/site_perl/5.6.1
/Our_path/apache/perl/lib/site_perl/5.6.1/PA-
RISC2.0-thread-multi /Our_path/apache/perl/lib/site_perl/5.6.1
/Our_path/apache/perl/lib/site_perl /local0/tmp/auto_
build/hppa2.0-hp-hpux-11.x/obj/hppa2.0-hp-hpux-11.x/perl-build/perl56/li
b/5.6.1/PA-RISC2.0-thread-multi /local0/tmp/auto
_build/hppa2.0-hp-hpux-11.x/obj/hppa2.0-hp-hpux-11.x/perl-build/perl56/l
ib/5.6.1 /local0/tmp/auto_build/hppa2.0-hp-hpux-
11.x/obj/hppa2.0-hp-hpux-11.x/perl-build/perl56/lib/site_perl/5.6.1/PA-R
ISC2.0-thread-multi /local0/tmp/auto_build/hppa2
.0-hp-hpux-11.x/obj/hppa2.0-hp-hpux-11.x/perl-build/perl56/lib/site_perl
/5.6.1 /local0/tmp/auto_build/hppa2.0-hp-hpux-11
.x/obj/hppa2.0-hp-hpux-11.x/perl-build/perl56/lib/site_perl .) at (eval
8) line 3.
I see you're using perl 5.006001 on PA-RISC2.0-thread-multi, okay.
Remember to actually *read* the README file!
Use 'make' to build the software (dmake or nmake on Windows).
Then 'make test' to execute self tests.
Then 'make install' to install the DBI and then delete this working
directory before unpacking and building any DBD::* drivers.
Writing Makefile for DBI
George Hsia
SBC Services, Inc.
2600 Camino Ramon,
San Ramon, CA 94583
USA
