Extproc & shared server mode

From: Dmitry Pavlov <dmitry.pavlov_at_gmail.com>
Date: 8 Mar 2005 02:28:03 -0800
Message-ID: <1110277683.245392.64050@z14g2000cwz.googlegroups.com>

Hi, All!

I ask for your help in such situation:
I have Oracle 9.2 and a package with external procedures on C. Procedures from external DLL don't run in Shared server mode (but OK in dedicated mode)

When I try to call external procedure in shared server mode, I receive this error:
ORA-28575: unable to open RPC connection to external procedure agent

I found an advice to solve this problem: run a separate listener for external procedures. Author said, that it works perfectly in Oracle 8.1, but it didn't works for me, neither by IPC nor by TCP (but still OK in dedicated mode).
What can I do to fix that? Great thanks in advance for your advices.

                  regards,
			                   Dmitry

Fragment of tnsnames.ora:

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = XYZZY))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
(SERVER = SHARED)

    )
  )

Fragment of listener.ora:

ELIST =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = XYZZY))
    )
  )

SID_LIST_ELIST =
  (SID_LIST =
    (SID_DESC =
(PROGRAM = ExtProc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(ENVS = "EXTPROC_DLLS=ANY")

    )
  ) Received on Tue Mar 08 2005 - 04:28:03 CST