[rt-users] Failure trying to setup fulltext indices with Oracle
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... /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. Josh Narins Director of Application Development SeniorBridge 845 Third Ave 7th Floor New York, NY 10022 Tel: (212) 994-6194 Fax: (212) 994-4260 Mobile: (917) 488-6248 jnar...@seniorbridge.com seniorbridge.comhttp://www.seniorbridge.com/ [http://www.seniorbridge.com/images/seniorbridgedisclaimerTAG.gif] SeniorBridge Statement of Confidentiality: 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. 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
Re: [rt-users] Failure trying to setup fulltext indices with Oracle
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
Re: [rt-users] Failure trying to setup fulltext indices with Oracle
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 Thank you. It was installed but not configured. /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. Josh Narins Director of Application Development SeniorBridge 845 Third Ave 7th Floor New York, NY 10022 Tel: (212) 994-6194 Mobile: (917) 488-6248 Fax: (212) 994-4260 jnar...@seniorbridge.com SeniorBridge Managing Complex Chronic Care http://www.seniorbridge.com SeniorBridge Statement of Confidentiality: 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. 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
