<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=750303904-17052007><FONT face=vt100 size=2>Hey
everyone!</FONT></SPAN></DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100 size=2>As ive already
mentioned - i'm being forced to use Oracle for my RT 3.6.3
instance.</FONT></SPAN></DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100 size=2>Well, today i
finally got an Oracle 10g instance up and loaded the schema.Oracle file into
it.</FONT></SPAN></DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100 size=2>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=***** )</FONT></SPAN></DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100 size=2>Everything was
ok.</FONT></SPAN></DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100 size=2>While doing make
initialize-database i got this error: Unable to load DBIx::SearchBuilder
database handle for 'Oracle'.</FONT></SPAN></DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100 size=2>Realized that i
don't have DBD::Oracle installed, so i downloaded that from CPAN and installed
that.</FONT></SPAN></DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100 size=2>There were errors
during the install and i found a workaround to delete -xarch=v9 from the
Makefile. After that install finished.</FONT></SPAN></DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100 size=2>Then i followed the
Wiki and commented out</FONT> <FONT face=vt100 size=2>the insert_schema()
method call.</FONT></SPAN></DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100 size=2>But i'm still
getting errors trying to init the DB.</FONT></SPAN></DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100 size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100 size=2>This is the error i
get while doing make initialize-database :</FONT></SPAN></DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100 size=2>DSN component
'CLORAD1' is not in 'name=value' format at
/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBI.pm line 627<BR>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<BR>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.<BR>make: *** [initialize-database] Error 255</FONT></SPAN></DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100 size=2>PLEASE HELP
!!!</FONT></SPAN></DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100 size=2>Thanks in
advance,</FONT></SPAN></DIV>
<DIV><SPAN class=750303904-17052007><FONT face=vt100
size=2>Sal.</FONT></SPAN></DIV></BODY></HTML>