Forum OpenACS Q&A: Response to Oracle listener

Uh oh! During the installation process, somewhere towards the end, it asks you to configure the listener (Net8 Config). This is when that file should have been created. You could run this again (can't remember how to do this off the top of my head) or you could try making the file yourself. Here's mine:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = qfs05)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /apps/oracle/product/8.1.7)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = acs817)
      (ORACLE_HOME = /apps/oracle/product/8.1.7)
      (SID_NAME = acs817)
   )
 )

Put in your own values for HOST, ORACLE_HOME, GLOBAL_DBNAME and SID_NAME. The rest should be the same.

This file is owned by oracle:dba and the permissions are 664.