Re: unable to open RPC connection to external procedure agent

From: Khalid Eidoo <rogers_at_rogers.com>
Date: Thu, 27 Jun 2002 10:54:09 -0400
Message-ID: <iGFS8.9304$T33.1545260@news20.bellglobal.com>

Hi Rauf,

I made the changes you suggested, however I am still having problems with the listener. I restarted the listener (./lsnrctl stop FORSYS; ./lsnrctl start FORSYS), and the extproc part appears to start, but I am unable to get an RPC connection. Based on the suggestions I understood from your response, my .ora files look like this:

# LISTENER.ORA Network Configuration File: /home/oracle/config/9.0.1/listener.ora
# Generated by Oracle configuration tools.

FORSYS =
(DESCRIPTION_LIST =

  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = forsys.terida.com)(PORT = 1521))   )
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = ipc)(KEY = extproc))   )
)
SAVE_CONFIG_ON_STOP_FORSYS = TRUE SID_LIST_FORSYS =
   (SID_LIST =

      (SID_DESC =
         (GLOBAL_DBNAME = forsys.terida.com)

  (ORACLE_HOME = /opt/oracle/product/9.0.1)   (SID_NAME = forsys)

      )
      (SID_DESC =
         (SID_NAME = extproc)
         (ORACLE_HOME = /opt/oracle/product/9.0.1)
  (PROGRAM = extproc)
      )

   )

# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora # Generated by Oracle configuration tools.

FORSYS =
(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = forsys.terida.com)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = forsys.terida.com)

)

)

extproc_connection_data =

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))

(CONNECT_DATA=(SID=extproc)))
Received on Thu Jun 27 2002 - 09:54:09 CDT