Re: External procedure

As docu in admin manaul:

the listener.ora should have the following entries for the EXTPROC process (your listener.ora) only has entries for the listener process.

Moreover, make sure the EXTPROC process is not the same user as the user who install ORACLE_HOME, no problem if it is, but it will posed a security risk.

EXTERNAL_PROCEDURE_LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL=ipc)
(KEY=extproc_key)

)
)
...
SID_LIST_EXTERNAL_PROCEDURE_LISTENER =
(SID_LIST =
(SID_DESC = (SID_NAME=extproc_agent)
(ORACLE_HOME=/oracle)
(PROGRAM=extproc)

)
)

for tnsnames.ora

extproc_connection_data = (DESCRIPTION =
(ADDRESS = (PROTOCOL=IPC)
(KEY=extproc_key)

)
(CONNECT_DATA = (SID = extproc_agent)

)

the two file's entries must match....check out the manual for further explanation. Received on Fri Jan 22 1999 - 07:28:08 CST