Re: Extproc & shared server mode

On 8 Mar 2005 02:28:03 -0800, "Dmitry Pavlov" <dmitry.pavlov_at_gmail.com> wrote:

>
>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.

First of all:
Look up the error message manual at http://tahiti.oracle.com and follow up the advice given there. Do NOT post without having read the error message in the manual and having tried to follow up it's advice.

Secondly: IIRC the external procedure facility doesn't support MTS in 8i, but this might have been changed.
Did you verify the listener you configured is actually running? Did you set up/change the mts_dispatcher parameter for this listener? If so, did you restart the database and/or verify the listener actually does have a dispatcher running for the IPC protocol? Could you post the output of the following commands in lsnrctl status <your listener name>
services <your listener name>

--
Sybrand Bakker, Senior Oracle DBA