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

1: Error:during installation "Installing OpenACS Core Services" on Oracle

Posted by Angel Romero on 01/10/03 02:00 PM

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.

2: Re: Error:during installation "Installing OpenACS Core Services" on Oracle (response to 1)

Posted by C. R. Oldham on 01/10/03 03:33 PM

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.