<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Microsoft Sans Serif";
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:vt100;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hmm, not sure at this point. Someone else who is more familiar
with the initialize-database part of the install will have to assist. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:navy'>
<hr size=3 width="100%" noshade style='color:#E6550E' align=center>
</span></div>
</div>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="100%"
style='width:100.0%;border-collapse:collapse'>
<tr>
<td width="40%" valign=top style='width:40.0%;padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:9.0pt;font-family:"Microsoft Sans Serif","sans-serif";
color:#587076'>Justin Brodley <br>
Supervisor of DataCenter Infrastructure <br>
SumTotal Systems, Inc.</span></b><span style='font-size:9.0pt;font-family:
"Microsoft Sans Serif","sans-serif";color:#587076'> (Nasdaq: <a
href="http://quotes.nasdaq.com/asp/summaryquote.asp?symbol=SUMT"
title="http://quotes.nasdaq.com/asp/summaryquote.asp?symbol=SUMT"><span
style='color:#587076'>SUMT</span></a>)<br>
110-110th Ave NE Suite 700<br>
Bellevue, WA 98004 </span><span style='font-family:"Calibri","sans-serif";
color:navy'><o:p></o:p></span></p>
</td>
<td width="40%" valign=top style='width:40.0%;padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:7.5pt;font-family:"Microsoft Sans Serif","sans-serif";
color:#587076'>OFFICE</span></b><span style='font-size:9.0pt;font-family:
"Microsoft Sans Serif","sans-serif";color:#587076'> +1 425 637 1506<br>
</span><b><span style='font-size:7.5pt;font-family:"Microsoft Sans Serif","sans-serif";
color:#587076'>FAX</span></b><span style='font-size:9.0pt;font-family:"Microsoft Sans Serif","sans-serif";
color:#587076'> +1 425 455 3071<br>
</span><b><span style='font-size:7.5pt;font-family:"Microsoft Sans Serif","sans-serif";
color:#587076'>MOBILE</span></b><span style='font-size:9.0pt;font-family:
"Microsoft Sans Serif","sans-serif";color:#587076'> +1 425 753 7033<br>
</span><b><span style='font-size:7.5pt;font-family:"Microsoft Sans Serif","sans-serif";
color:#587076'>EMAIL</span></b><span style='font-size:9.0pt;font-family:"Microsoft Sans Serif","sans-serif";
color:#587076'> <a href="mailto:jbrodley@sumtotalsystems.com"
title="mailto:jbrodley@sumtotalsystems.com">jbrodley@sumtotalsystems.com</a></span><span
style='font-size:9.0pt;font-family:"Microsoft Sans Serif","sans-serif";
color:#587076'><o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:7.5pt;font-family:"Microsoft Sans Serif","sans-serif";
color:#587076'>MSN </span></b><u><span style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:blue'><a
href="msnim:chat?contact=justin_brodley@hotmail.com"
title="msnim:chat?contact=justin_brodley@hotmail.com"><span style='font-size:
9.0pt;font-family:"Microsoft Sans Serif","sans-serif"'>justin_brodley</span></a></span></u><span
style='font-family:"Calibri","sans-serif";color:navy'><o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:navy'> </span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>The content of this communication is considered SumTotal
Confidential, and should not be shared with anyone outside of SumTotal, either
electronically or verbally, without the express permission of the author(s).<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Baytalskiy, Sal
[mailto:Sal.Baytalskiy@AIG.com] <br>
<b>Sent:</b> Thursday, May 17, 2007 10:47 AM<br>
<b>To:</b> Justin Brodley; rt-users@lists.bestpractical.com<br>
<b>Subject:</b> RE: [rt-users] Desperately ned Oracle help<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif";
color:blue'>The Oracle readme said that the DB needs to be prepared.</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif";
color:blue'>So i ran the schema.Oracle file via the SQLPlus and it inserted all
the tables and indexes.</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif";
color:blue'>So i now have the database setup, just empty. No data.</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif";
color:blue'>Then, while running the 'make initialize-database' there's a step
in that script to insert the schema. Since i already did that - i commented it
out, just like the Wiki suggests.</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif";
color:blue'>So that step should be skipped and it should just try to insert the
required data into the DB.</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif";
color:blue'>And that's where i'm stuck at this point.</span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif";
color:blue'>After some googling i found that i might have a problem with the
DBD::Oracle. Apparently it tried installing that module as a 64-bit.</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif";
color:blue'>But my Perl is 32-bit. This seems to be a common occurence.</span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif";
color:blue'>Here's what i'm getting when trying to run 'make
initialize-database' :</span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif";
color:blue'>/usr/bin/perl //usr/local/rt3_ora/sbin/rt-setup-database --action
init --dba mwpoc --prompt-for-dba-password<br>
Unquoted string "error" may clash with future reserved word at
/usr/local/rt3_ora/etc/RT_SiteConfig.pm line 286.<br>
In order to create or update your RT database,this script needs to connect to
your Oracle instance on clorad1.aig.com as mwpoc.<br>
Please specify that user's database password below. If the user has no database<br>
password, just press return.</span><o:p></o:p></p>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif";
color:blue'>Password: <br>
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','mwpoc',...) 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 mwpoc: 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</span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif";
color:blue'>The hostname where oracle Db is running is clorad1.aig.com.
Instance/Service name is CLORAD1.</span><o:p></o:p></p>
<blockquote style='margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<p class=MsoNormal><o:p> </o:p></p>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=2 width="100%" align=center>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> Justin Brodley
[mailto:jbrodley@sumtotalsystems.com] <br>
<b>Sent:</b> Thursday, May 17, 2007 1:40 PM<br>
<b>To:</b> Baytalskiy, Sal; rt-users@lists.bestpractical.com<br>
<b>Subject:</b> RE: [rt-users] Desperately ned Oracle help</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I would make sure the variable is set everywhere, the initial
data is imported with the schema, that you commented out. Out of curiosity why
are you commenting out the “schema” the only reason you would do
this is if the database was already created with all the appropriate tables.
Our oracle guys just setup the RT user as per the oracle readme and then we
just ran initialize-database and it created the rest. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:navy'>Justin Brodley<o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Baytalskiy, Sal
[mailto:Sal.Baytalskiy@AIG.com] <br>
<b>Sent:</b> Thursday, May 17, 2007 10:34 AM<br>
<b>To:</b> Justin Brodley; rt-users@lists.bestpractical.com<br>
<b>Subject:</b> RE: [rt-users] Desperately ned Oracle help<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif";
color:blue'>Thanks a lot, Justin!!!</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif";
color:blue'>This is very valuable info!</span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif";
color:blue'>However, i'm not at that step yet. I've just built RT with Oracle
support and was trying to run 'make initialize-database'</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif";
color:blue'>I've commented out the 'insert_schema()' method call, cause schema
is already in place.</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif";
color:blue'>I was expecting the thing to insert the initial RT data into the
DB. But that's where it was failing.</span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif";
color:blue'>Do you think i should set the variable you mentioned in the shell
and try running it again?</span><o:p></o:p></p>
<blockquote style='margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<p class=MsoNormal><o:p> </o:p></p>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=2 width="100%" align=center>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <b>On Behalf Of </b>Justin
Brodley<br>
<b>Sent:</b> Thursday, May 17, 2007 1:20 PM<br>
<b>To:</b> Baytalskiy, Sal; rt-users@lists.bestpractical.com<br>
<b>Subject:</b> RE: [rt-users] Desperately ned Oracle help</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Sal- It has to do with Apache and your CGI handler not knowing
the oracle parameters. We use Fast CGI on Redhat connecting to a remote Oracle
servers. I had to add the following lines to my httpd.conf file:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'># RT STUFF FOR APACHE<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>SetEnv LD_LIBRARY_PATH /u01/app/oracle/product/10.2.0/client_1/lib<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>SetEnv ORACLE_HOME /u01/app/oracle/product/10.2.0/client_1<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>SetEnv ORACLE_SID rt<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>SetEnv TWO_TASK rt<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>(change above variables to your implementation)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>In Httpd conf I also had to change the initialization string for
Fastcgi, this is the line in my config.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout 120
-processes 4 -initial-env
LD_LIBRARY_PATH=/u01/app/oracle/product/10.2.0/client_1/lib -initial-env
ORACLE_HOME=/u01/app/oracle/product/10.2.0/client1 -initial-env ORACLE_SID=rt
-initial-env TWO_TASK=rt<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Some of this might be a bit excessive but I was trying
everything and spent a ton of time on the fastcgi and apache websites trying to
figure this out. Once this was all completed I was successful in getting DBI
Searchbuilder working. This took about a 12 hours of research and trial and
error on my part, and I’ve meant to go back and put this information in
the wiki but haven’t had a chance. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> Justin Brodley<o:p></o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <b>On Behalf Of </b>Baytalskiy,
Sal<br>
<b>Sent:</b> Wednesday, May 16, 2007 9:49 PM<br>
<b>To:</b> rt-users@lists.bestpractical.com<br>
<b>Subject:</b> [rt-users] Desperately ned Oracle help<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>Hey
everyone!</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>As
ive already mentioned - i'm being forced to use Oracle for my RT 3.6.3
instance.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>Well,
today i finally got an Oracle 10g instance up and loaded the schema.Oracle file
into it.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>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=***** )</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>Everything
was ok.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>While
doing make initialize-database i got this error: Unable to load DBIx::SearchBuilder
database handle for 'Oracle'.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>Realized
that i don't have DBD::Oracle installed, so i downloaded that from CPAN and
installed that.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>There
were errors during the install and i found a workaround to delete -xarch=v9
from the Makefile. After that install finished.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>Then
i followed the Wiki and commented out</span> <span style='font-size:10.0pt;
font-family:"vt100","serif"'>the insert_schema() method call.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>But
i'm still getting errors trying to init the DB.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>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.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>This
is the error i get while doing make initialize-database :</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>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</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>PLEASE
HELP !!!</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>Thanks
in advance,</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>Sal.</span><o:p></o:p></p>
</div>
</blockquote>
</blockquote>
</div>
</body>
</html>