Oracle DB connection problem

Maciak_TJ · June 13, 2005, 6:41pm

I am getting an error message when I visit my website that has RT running on
it.

The logs state:

Unable to load DBIx::SearchBuilder database handle for ‘Oracle’.\nPerhaps
you’ve picked an invalid database type or spelled it incorrectly.\nCan’t
load
‘/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Orac
le.so’ for module DBD::Oracle: libclntsh.so.9.0: cannot open shared object
file: No such file or direc
tory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line
230.\n at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuild
er/Handle/Oracle.pm line 7\nCompilation failed in require at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm l
ine 7.\nBEGIN failed–compilation aborted at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm line
7.\nCompilat
ion failed in require at (eval 238) line 1.\nBEGIN failed–compilation
aborted at (eval 238) line 1.\nCompilation failed in requi
re at /opt/rt3/lib/RT.pm line 164.\n

I have not changed any configuration files since last week, and on
Thursday/Friday I was able to create the initial database
system in my oracle db. Does anyone have any advice on what I might be able
to check or try to get this to work right?
I do have the DBD::Oracle installed along with working oracle client etc. on
this machine.

Thanks,

TJ

Maciak_TJ · June 14, 2005, 3:27pm

I figured out what the problem was - turns out when I was starting apache as
“sudo /etc/init.d/httpd restart” from my own user that
the user it was running as under sudo did not have the environment variable
set for the oracle library path.

I tried this instead:

sudo su root
export LD_LIBRARY_PATH=/opt/oracle/OraHome1/lib
/etc/init.d/httpd restart

and it resolved all of my problems! Now RT is running speedily on Oracle at
our site.

T.J. Maciak

Internet/Intranet Developer
Department of IT
City of Grand Rapids
P: (616)456-3713
F: (616)456-3448From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Maciak, TJ
Sent: Monday, June 13, 2005 2:41 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Oracle DB connection problem

I am getting an error message when I visit my website that has RT running on
it.

The logs state:

Unable to load DBIx::SearchBuilder database handle for ‘Oracle’.\nPerhaps
you’ve picked an invalid database type or spelled it incorrectly.\nCan’t
load
‘/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Orac
le.so’ for module DBD::Oracle: libclntsh.so.9.0: cannot open shared object
file: No such file or direc
tory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line
230.\n at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuild
er/Handle/Oracle.pm line 7\nCompilation failed in require at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm l
ine 7.\nBEGIN failed–compilation aborted at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm line
7.\nCompilat
ion failed in require at (eval 238) line 1.\nBEGIN failed–compilation
aborted at (eval 238) line 1.\nCompilation failed in requi
re at /opt/rt3/lib/RT.pm line 164.\n

I have not changed any configuration files since last week, and on
Thursday/Friday I was able to create the initial database
system in my oracle db. Does anyone have any advice on what I might be able
to check or try to get this to work right?
I do have the DBD::Oracle installed along with working oracle client etc. on
this machine.

Thanks,

TJ

Drew_Barnes · June 14, 2005, 3:30pm

Maciak, TJ wrote:

I figured out what the problem was - turns out when I was starting
apache as “sudo /etc/init.d/httpd restart” from my own user that
the user it was running as under sudo did not have the environment
variable set for the oracle library path.

I tried this instead:

sudo su root
export LD_LIBRARY_PATH=/opt/oracle/OraHome1/lib
/etc/init.d/httpd restart

For future reference, “sudo su - root” would have accomplished the same
thing.

and it resolved all of my problems! Now RT is running speedily on
Oracle at our site.

T.J. Maciak

Internet/Intranet Developer
Department of IT
City of Grand Rapids
P: (616)456-3713
F: (616)456-3448

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] *On Behalf Of
*Maciak, TJ
Sent: Monday, June 13, 2005 2:41 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Oracle DB connection problem

I am getting an error message when I visit my website that has RT
running on it.

The logs state:

Unable to load DBIx::SearchBuilder database handle for
‘Oracle’.\nPerhaps you’ve picked an invalid database type or spelled
it incorrectly.\nCan’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.9.0: cannot open shared object
file: No such file or direc
tory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm
line 230.\n at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuild
er/Handle/Oracle.pm line 7\nCompilation failed in require at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm l
ine 7.\nBEGIN failed–compilation aborted at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm
line 7.\nCompilat
ion failed in require at (eval 238) line 1.\nBEGIN failed–compilation
aborted at (eval 238) line 1.\nCompilation failed in requi
re at /opt/rt3/lib/RT.pm line 164.\n

I have not changed any configuration files since last week, and on
Thursday/Friday I was able to create the initial database
system in my oracle db. Does anyone have any advice on what I might
be able to check or try to get this to work right?
I do have the DBD::Oracle installed along with working oracle client
etc. on this machine.

Thanks,

TJ

The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati

Erwin_Pasia · August 4, 2005, 10:40am

hi TJ,

Im also trying to connect an RT to an Oracle, schemas and tables were already created but on certain user creation its failing. Below is the error once the script is run. Would appreciate help on what Im specifically missing on the config. Thanks.

Now creating a database for RT.
…skipped as rtts_test2 is not test2 or we’re working with Oracle.
Now populating database schema.
Creating database schema.
Done setting up database schema.
Now inserting database ACLs
Now inserting RT core system objects
Checking for existing system user…not found. This appears to be a new installation.
Creating system user…[Wed Aug 3 07:45:01 2005] [crit]: Found a principal () that was neither a user nor a group

(/opt/rt3.4.2/lib/RT/Principal_Overlay.pm:127)
[Wed Aug 3 07:45:01 2005] [crit]: Can’t call method “Id” on an undefined value at /opt/rt3.4.2/lib/RT/Group_Overlay.pm line

(/opt/rt3.4.2/lib/RT.pm:285)

…

Set($DatabaseType , ‘Oracle’);
Set($DatabaseHost , ‘localhost’);
Set($DatabaseRTHost , ‘localhost’);
Set($DatabasePort , ‘1521’);
Set($DatabaseUser , ‘test2’);
Set($DatabasePassword , ‘tyson1’);
Set($DatabaseName , ‘host=localhost; sid=RTDV2’);
$ENV{TWO_TASK}=“LIVE”;

Erwin

…

I figured out what the problem was - turns out when I was starting apache as
"sudo /etc/init.d/httpd restart" from my own user that
the user it was running as under sudo did not have the environment variable
set for the oracle library path.

I tried this instead:

sudo su root
export LD_LIBRARY_PATH=/opt/oracle/OraHome1/lib
/etc/init.d/httpd restart

and it resolved all of my problems! Now RT is running speedily on Oracle at
our site.

T.J. Maciak

Internet/Intranet Developer
Department of IT
City of Grand Rapids
P: (616)456-3713
F: (616)456-3448

Start your day with Yahoo! - make it your home page