Hi,

Iím trying to install a software application on a Win2k system. the application makes use of Oracle 9.2 & Oracle's external procedure functions.

Iím not familiar w/ external procedures and Iíve hit a snag relating to configuration of the listener.ora file

The software installation instructions have a step for verifying whether the extproc listener is correctly configured.

step 1. log into your db as dba & execute the %oracle_home%\plsql\demo\dbgextp script.
this step works. package, library and package body are created.

step 2. start an external procedure process, via: execute debug_extproc.startup_extproc_agent

at this point I get an error: ORA-28575: RPC connection with external procedure cannot opened

google indicates that this likely means the listener.ora file is not configured properly. This is not surprising since Iím not exactly sure what Iím doing in this area.

Iíve appended copies of my listener.ora & my tnsnames.ora files, and I was wondering if anyone knew how to fix the problem.

TIA

************************************************** **************
# TNSNAMES.ORA Network Configuration File: E:\oracle\product\9.2.0\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

INST1_HTTP.X.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = RPMDL01)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

TEST.X.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = RPMDL01)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST)
)
)

PROD2.X.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = RPMDL01)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PROD2)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY=EXTPROC))
)
(CONNECT_DATA =
(SID = EXTPROC)
(PRESENTATION = R0)
)
)
# LISTENER.ORA Network Configuration File: E:\oracle\product\9.2.0\network\admin\listener.ora
# Generated by Oracle configuration tools.

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

MOLECULES2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)

SID_LIST_MOLECULES2 =
(SID_LIST =
(SID_DESC =
(SID_NAME= EXTPROC)
(ORACLE_HOME = E:\oracle\product\9.2.0)
(PROGRAM = EXTPROC)
(ENVS="EXTPROC_DLLS=ANY")
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = TEST)
(ORACLE_HOME = E:\oracle\product\9.2.0)
(SID_NAME = TEST)
)
(SID_DESC =
(GLOBAL_DBNAME = PROD2)
(ORACLE_HOME = E:\oracle\product\9.2.0)
(SID_NAME = PROD2)
)
)

LOG_DIRECTORY_MOLECULES2=E:\MD5
LOG_FILE_MOLECULES2=extproc.log