[rt-users] Desperately ned Oracle help

[Baytalskiy, Sal]

Hey everyone!
As ive already mentioned - i'm being forced to use Oracle for my RT 3.6.3
instance.
Well, today i finally got an Oracle 10g instance up and loaded the
schema.Oracle file into it.
Did the ./configure for RT(./configure --prefix=/usr/local/rt3_ora
--with-db-type=Oracle --with-db-host=clorad1.example.com --with-db-port=1521
--with-db-rt-host=localhost --with-db-dba=rtusr --with-db-database=clorad1
--with-db-rt-user=rtusr --with-db-rt-pass=***** )
 
Everything was ok.
 
While doing make initialize-database i got this error: Unable to load
DBIx::SearchBuilder database handle for 'Oracle'.
 
Realized that i don't have DBD::Oracle installed, so i downloaded that from
CPAN and installed that.
There were errors during the install and i found a workaround to delete
-xarch=v9 from the Makefile. After that install finished.
 
Then i followed the Wiki and commented out the insert_schema() method call.
 
But i'm still getting errors trying to init the DB.
 
 
Test suggested by the Wiki (TWO_TASK=FOO perl -MDBI -le
'DBI->connect("DBI:Oracle:", "rt3", "rt3")') seems to be successful. Or at
least it doesn't give any errors.
 
This is the error i get while doing make initialize-database :
 
DSN component 'CLORAD1' is not in 'name=value' format at
/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBI.pm line 627
DBI connect('CLORAD1;port=1521','rtusr',...) failed: Can't connect using
this syntax without specifying a HOST and one of SID INSTANCE_NAME SERVER
SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103
Failed to connect to dbi:Oracle:CLORAD1;port=1521 as rtusr: Can't connect
using this syntax without specifying a HOST and one of SID INSTANCE_NAME
SERVER SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103,
<STDIN> line 1.
make: *** [initialize-database] Error 255
 
 
PLEASE HELP !!!
 
Thanks in advance,
Sal.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070516/b4704f01/attachment.htm>