Oracle XE DB initialize error

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

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.

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

-Mike M

[root@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.From: Jesse Vincent [mailto:jesse@bestpractical.com]

Sent: Wednesday, January 18, 2006 9:50 AM
To: Michael Methe
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Oracle XE DB initialize error.

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

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/D
BD/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

And perhaps re-install your Oracle client.

How are the ORACLE_HOME and other Orc-specific environment variables
accessed during install? I dunno, but they will surely be needed…?

Then try again.

And if you get it working, please let us know so I too can have a go :slight_smile:

Yours, cowardly,

Lee