Forum .LRN Q&A: Error:during installation "Installing OpenACS Core Services" on Oracle

Hi,
During intallation of dotLNR get the next error when it is trying create to index in Oracle. My system uses RedHat 7.2 and Oracle 8i.

* Loading data model /web/openacs/packages/acs-content-repository/sql/oracle/acs-content-repository-create.sql...

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Jan 10 10:08:04 2003
(c) Copyright 2000 Oracle Corporation.  All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
PL/SQL procedure successfully completed.
Table created.
Comment created.
Comment created.
1 row created.
1 row created.
1 row created.
............
............
............
No errors.
PL/SQL procedure successfully completed.
No errors.
*** Refreshing content type attribute views...
PL/SQL procedure successfully completed.
*** Preparing search indices...
Creating content filter preference...
PL/SQL procedure successfully completed.
create index cr_rev_content_index on cr_revisions ( content )
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: interMedia Text error:
DRG-11206: user filter command /ora8/m01/app/oracle/product/8.1.7/ctx/bin/ctxhx
could not be executed
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 78
ORA-06512: at line 1
alter index cr_rev_content_index rebuild  parameters ('sync')
*
ERROR at line 1:
ORA-29863: warning in the execution of ODCIINDEXCREATE routine
Package created.
No errors.

Suggestions or ideas?

Thank you.

This is a problem with Intermedia. I'd recommend installing the patchset to bring you up to 8.1.7.4, there are many Intermedia fixes in it.

If I remember correctly even after installing 8.1.7.4 I still had to drop and reinstall the Intermedia subsystem.  If you have access to Oracle Metalink the DocID for documentation on how to do that is in Note:131023.1. Note typo in the doc "drcrsyst.sql" should be "dr0csys.sql" and takes three parameters: CTXSYS user's password, CTXSYS tablespace (DRSYS), and temporary tablespace for the CTXSYS user (TEMP).

I also have a hazy recollection that even after the reinstallation of Intermedia the default preferences setup script does not get run.  That script is in $ORACLE_HOME/ctx/admin/defaults/drdefus.sql.