On Thu, Sep 29, 2011 at 09:00:16AM -0400, Josh Narins wrote: > We are using RT4.0.2, Oracle 10g and RHEL5. > > RT is running fine. > > I wanted to add the full text search, and this is what I got...
The CTXAPP role is tied to the Oracle Text tool. Do you have Oracle Text installed? If not, Oracle has no full text indexing. If you do have it installed, does it define a different role name? -kevin > > /home/apps/sbin/rt-setup-fulltext-index --dba system --dba-password > > ******** > [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) > [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) > [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) > [Thu Sep 29 12:37:05 2011] [warning]: DBD::Oracle::db do failed: ORA-06550: > line 1, column 7: > PLS-00201: identifier 'CTX_DDL.CREATE_PREFERENCE' must be declared > ORA-06550: line 1, column 7: > 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) > [Thu Sep 29 12:37:05 2011] [crit]: DBD::Oracle::db do failed: ORA-06550: line > 1, column 7: > PLS-00201: identifier 'CTX_DDL.CREATE_PREFERENCE' must be declared > ORA-06550: line 1, column 7: > 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) > DBD::Oracle::db do failed: ORA-06550: line 1, column 7: > PLS-00201: identifier 'CTX_DDL.CREATE_PREFERENCE' must be declared > ORA-06550: line 1, column 7: > 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.
pgprjFEGCPTk3.pgp
Description: PGP signature
-------- RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 & 27, 2011 * San Francisco, CA, USA October 18 & 19, 2011 * Washington DC, USA October 31 & November 1, 2011 * Melbourne VIC, Australia November 28 & 29, 2011 * Barcelona, Spain November 28 & 29, 2011