Edit listener_ifile.ora

You need to configure the database TNS listener to allow OWB to communicate with the database. Instead of making all the required changes in the listener.ora file, which is overwritten when you run Autoconfig, make the changes in the listener_ifile.ora file, which is called from listener.ora.

Check variable $TNS_ADMIN for the location of listener.ora. The file listener_ifile.ora is in the same location.

Edit listener_ifile.ora to make TNS listener-related changes. For example, if the database SID is xyz22:

SID_LIST_xyz22 =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = xyz22)
      (ORACLE_HOME= /slot/ems6636/oracle/xyz22db/11.2.0)
      (SID_NAME = xyz22)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = lshdb.your_company.com)
      (ORACLE_HOME= /slot/ems6636/oracle/xyz22db/11.2.0)
      (SID_NAME = xyz22)
    )
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /slot/ems6636/oracle/xyz22db/11.2.0)
      (PROGRAM = extproc)
    )
  )