[rt-users] Oracle XE DB initialize error.

[Michael Methe]

Thanks!  All tests fail.  Here is the initial failure after 'make test'

-Mike M

[root at fc3-ora DBD-Oracle-1.17]# make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................Failed to load Oracle extension and/or shared
libraries:
install_driver(Oracle) failed: Can't load
'/home/mike/DBD-Oracle-1.17/blib/arch/auto/DBD/Oracle/Oracle.so' for
module DBD::Oracle: libclntsh.so.10.1: cannot open shared object file:
No such file or directory at
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
 at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at t/01base.t line 19
The remaining tests will probably also fail with the same error.

*** Please read the README and README.help.txt files for help. ***

t/01base................FAILED tests 4-5

        Failed 2/5 tests, 60.00% okay
t/10general.............install_driver(Oracle) failed: Can't load
'/home/mike/DBD-Oracle-1.17/blib/arch/auto/DBD/Oracle/Oracle.so' for
module DBD::Oracle: libclntsh.so.10.1: cannot open shared object file:
No such file or directory at
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
 at (eval 5) line 3
Compilation failed in require at (eval 5) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at /home/mike/DBD-Oracle-1.17/blib/lib/Oraperl.pm line 55
Compilation failed in require at t/10general.t line 6.
BEGIN failed--compilation aborted at t/10general.t line 6.
# Looks like your test died before it could output anything.

-----Original Message-----
From: Jesse Vincent [mailto:jesse at bestpractical.com] 
Sent: Wednesday, January 18, 2006 9:50 AM
To: Michael Methe
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Oracle XE DB initialize error.





On Wed, Jan 18, 2006 at 08:49:57AM -0500, Michael Methe wrote:
> I am installing RT on Fedora Core 3 which has Oracle 10g Express on 
> it. When I run:
>  
> make initialize-database
>  
> I get:
>  
> /usr/bin/perl //usr/local/rt/sbin/rt-setup-database --action init 
> --dba rt --prompt-for-dba-password Unable to load DBIx::SearchBuilder 
> database handle for 'Oracle'. Perhaps you've picked an invalid 
> database type or spelled it incorrectly.
> Can't load
>
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/
> Oracle.so' for module DBD::Oracle: libclntsh.so.10.1: cannot open
shared
> object file: No such file or directory at
> /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.


Right there, that says you didn't install DBD::Oracle correctly.
Download a fresh copy from search.cpan.org and run:

perl Makefile.PL
make 
make test
# ONLY if make test passes
make install

Then try again.

>  at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm
> line 6
> Compilation failed in require at 
> /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm 
> line 6. BEGIN failed--compilation aborted at
> /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm
line
> 6.
> Compilation failed in require at (eval 184) line 1.
> BEGIN failed--compilation aborted at (eval 184) line 1.
> Compilation failed in require at //usr/local/rt/sbin/rt-setup-database
> line 86.
> make: *** [initialize-database] Error 255
>  
> I have done some searching but I am unable to make any progress on 
> this one.  One issue is when I install DBD::Oracle via CPAN, I am told

> it is up to date.  When I do a testdeps I am told by RT that it is 
> missing. This is rather confusing.  I am using version 1.17 of 
> DBD::Oracle.
>  
> Thanks
>  
> -Mike M

> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> 
> Download a free sample chapter of RT Essentials from O'Reilly Media at

> http://rtbook.bestpractical.com
> 
> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and 
> San Francisco - Find out more at 
> http://bestpractical.com/services/training.html

--