Forum OpenACS Q&A: interMedia error on install

Collapse
1: interMedia error on install
Posted by Michael Olan on 09/05/02 08:46 PM
I installed OACS and during "loading the package model" the following errors occurred: 
Loading data model /apps/web/dotlrn/packages/acs-content-
repository/sql/oracle/acs-content-repository-create.sql... 

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-50704: Net8 listener is not running or cannot start external 
procedures
ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 54
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

create index cr_rev_attribute_index on cr_revision_attributes ( 
attributes )
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: interMedia Text error:
DRG-50704: Net8 listener is not running or cannot start external 
procedures
ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 54
ORA-06512: at line 1

alter index cr_rev_attribute_index rebuild parameters ('sync')
*
ERROR at line 1:
ORA-29863: warning in the execution of ODCIINDEXCREATE routine
create index cr_doc_filter_index on cr_doc_filter ( content )
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: interMedia Text error:
DRG-50704: Net8 listener is not running or cannot start external 
procedures
ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 54
ORA-06512: at line 1
I remember having trouble with interMedia back with ACS 3.x but don't remember how to fix it. Can anyone fill me in on what to look for? I have Oracle 8.1.6 installed on Slackware. All other steps of the install were ok, and everything seems to work, except of course full text searches.
Collapse
2: Response to interMedia error on install (response to 1)
Posted by C. R. Oldham on 09/05/02 09:00 PM

Michael,

Intermedia communicates with the rest of Oracle via extproc, and extproc is only available via Net8 and an Oracle listener. Do you have Net8 configured? Below is a copy of my listener.ora file.

BTW there are lots of bugs in 8.1.6 Intermedia. You might consider upgrading to 8.1.7, though that is a non-trivial upgrade (it generally has taken me about a day, depending on the speed of the machine). If you do upgrade, don't try to do a automated database migration. The JRE will run out of RAM and Linux's OOM support will kill it off. You have to do it by hand. 

# LISTENER.ORA Network Configuration File: /u01/app/oracle/product/8.1.7/network
/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION = 
        (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
      )
    (DESCRIPTION =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/8.1.7)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = yourservicename)
      (ORACLE_HOME = /u01/app/oracle/product/8.1.7)
      (SID_NAME = orcl)
    )
  )