Forum OpenACS Q&A: Response to interMedia error on install

Collapse
Posted by C. R. Oldham on

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)
    )
  )