<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)">
<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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-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-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
-->
</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><!--ppd1000037--><!--ppd1000035-->
<div class=WordSection1>
<p class=MsoNormal>We are using RT4.0.2, Oracle 10g and RHEL5.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>RT is running fine.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I wanted to add the full text search, and this is what I got…<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>> /home/apps/sbin/rt-setup-fulltext-index --dba system
--dba-password ********<o:p></o:p></p>
<p class=MsoNormal>[Thu Sep 29 12:37:05 2011] [debug]: RT's GnuPG libraries
couldn't successfully read your configured GnuPG home directory
(/home/apps/builds/rt/rt-4.0.2/var/data/gpg). PGP support has been disabled
(/home/apps/sbin/../lib/RT/Config.pm:579)<o:p></o:p></p>
<p class=MsoNormal>[Thu Sep 29 12:37:05 2011] [warning]: DBD::Oracle::db do
failed: ORA-01919: role 'CTXAPP' does not exist (DBD ERROR: error possibly near
<*> indicator at char 6 in 'GRANT <*>CTXAPP TO rt_user') [for
Statement "GRANT CTXAPP TO rt_user"] at /home/apps/sbin/rt-setup-fulltext-index
line 609. (/home/apps/sbin/rt-setup-fulltext-index:609)<o:p></o:p></p>
<p class=MsoNormal>[Thu Sep 29 12:37:05 2011] [warning]: DBD::Oracle::db do
failed: ORA-04042: procedure, function, package, or package body does not exist
(DBD ERROR: error possibly near <*> indicator at char 24 in 'GRANT
EXECUTE ON CTXSYS.<*>CTX_DDL TO rt_user') [for Statement "GRANT
EXECUTE ON CTXSYS.CTX_DDL TO rt_user"] at
/home/apps/sbin/rt-setup-fulltext-index line 609.
(/home/apps/sbin/rt-setup-fulltext-index:609)<o:p></o:p></p>
<p class=MsoNormal>[Thu Sep 29 12:37:05 2011] [warning]: DBD::Oracle::db do
failed: ORA-06550: line 1, column 7:<o:p></o:p></p>
<p class=MsoNormal>PLS-00201: identifier 'CTX_DDL.CREATE_PREFERENCE' must be
declared<o:p></o:p></p>
<p class=MsoNormal>ORA-06550: line 1, column 7:<o:p></o:p></p>
<p class=MsoNormal>PL/SQL: Statement ignored (DBD ERROR: error possibly near
<*> indicator at char 6 in 'begin <*>ctx_ddl.create_preference(:p1,
:p2); end;') [for Statement "begin ctx_ddl.create_preference(?, ?);
end;"] at /home/apps/sbin/rt-setup-fulltext-index line 546.
(/home/apps/sbin/rt-setup-fulltext-index:546)<o:p></o:p></p>
<p class=MsoNormal>[Thu Sep 29 12:37:05 2011] [crit]: DBD::Oracle::db do
failed: ORA-06550: line 1, column 7:<o:p></o:p></p>
<p class=MsoNormal>PLS-00201: identifier 'CTX_DDL.CREATE_PREFERENCE' must be
declared<o:p></o:p></p>
<p class=MsoNormal>ORA-06550: line 1, column 7:<o:p></o:p></p>
<p class=MsoNormal>PL/SQL: Statement ignored (DBD ERROR: error possibly near
<*> indicator at char 6 in 'begin <*>ctx_ddl.create_preference(:p1,
:p2); end;') [for Statement "begin ctx_ddl.create_preference(?, ?);
end;"] at /home/apps/sbin/rt-setup-fulltext-index line 546.
(/home/apps/sbin/../lib/RT.pm:340)<o:p></o:p></p>
<p class=MsoNormal>DBD::Oracle::db do failed: ORA-06550: line 1, column 7:<o:p></o:p></p>
<p class=MsoNormal>PLS-00201: identifier 'CTX_DDL.CREATE_PREFERENCE' must be
declared<o:p></o:p></p>
<p class=MsoNormal>ORA-06550: line 1, column 7:<o:p></o:p></p>
<p class=MsoNormal>PL/SQL: Statement ignored (DBD ERROR: error possibly near
<*> indicator at char 6 in 'begin <*>ctx_ddl.create_preference(:p1,
:p2); end;') [for Statement "begin ctx_ddl.create_preference(?, ?);
end;"] at /home/apps/sbin/rt-setup-fulltext-index line 546.<o:p></o:p></p>
<p class=MsoNormal><o:p></o:p></p>
</div>
<br /><br />
<P><FONT size=2 face=Verdana><STRONG>Josh Narins</STRONG></FONT><BR><FONT size=1 face=Verdana>Director of Application Development<BR>SeniorBridge</FONT></P>
<P><FONT size=1 face=Verdana>845 Third Ave<br/>
7th Floor<BR>New York, NY 10022 <br/>
Tel:
(212) 994-6194 <br/>
Fax: (212) 994-4260 <br/>
Mobile: (917) 488-6248<BR>jnarins@seniorbridge.com<BR><A
href="http://www.seniorbridge.com/">seniorbridge.com</A></FONT><BR><BR><IMG
border=0 hspace=0 alt=SeniorBridge align=baseline
src="http://www.seniorbridge.com/images/seniorbridgedisclaimerTAG.gif"></P></FONT><br /><br />
<HR style="HEIGHT: 1px">
<FONT size=1 face=Verdana><FONT color=silver><STRONG>SeniorBridge Statement of
Confidentiality:</STRONG> The contents of this email message are intended for
the exclusive use of the addressee(s) and may contain confidential or privileged
information. Any dissemination, distribution or copying of this email by an
unintended or mistaken recipient is strictly prohibited. In said event, kindly
reply to the sender and destroy all entries of this message and any attachments
from your system. Thank you.</FONT></FONT></body>
</html>