Re: ORA-28575: unable to open RPC...

From: Gollum <nospam_at_worldonline.dk>
Date: Sun, 4 Feb 2001 23:25:22 +0100
Message-ID: <2Jkf6.23445$fa3.1281464@news010.worldonline.dk>

You need to setup the external connection agent in your listener, so the suggested action is absolutely right!

As I remember this, you need an entry in the listener's address list (in listener.ora):

    (ADDRESS= (PROTOCOL= IPC)(KEY= EXTPROC0)) and the corresponding entry in the SID LIST:

    (SID DESC =
(SID NAME= PLSExtProc)
(ORACLE HOME= /u01/app/oracle/product/V817)
(PROGRAM = extproc)

    )

In your tnsnames.ora the following entry should be found (don't change the alias name!):

    extproc connection data=

(DESCRIPTION=

            (ADDRESS LIST =
                (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))
            )
            (CONNECT DATA=(SID=PLSExtProc))
        )

HTH,
Gollum

"jurek" <jerzy.bin_at_cchbc.com> wrote in message news:3A7C5A98.61E58522_at_cchbc.com...
> Hello, can anybody help me?
> I am trying to create an external procedure, and am encountering  nothing

> but problems.
> 
> create or replace library  FUELLIB is
> 'ORACLE HOME\FUEL\fuel.dll';
> /
> Library created.
> 
> All procedures are also created, however when I try to execute 

 anything

> I get this:
> ORA-28575: unable to open RPC connection to external procedure agent
> 
> Oracle manual is useless here:
> 
> "Cause: Initialization of a network connection to the extproc agent 

 did
> not succeed.
> This can be caused by network problems, incorrect listener  configuration

> or incorrect transfer code.
> 
> Action: Check listener configuration in LISTENER.ORA and TNSNAMES.ORA 

 or

> Oracle Names Server."
> 
> I did that, and actually do not even what I should look for.
> What am I missing here?
> 
> Best regards
> Jerzy
> 
> 
> 

--

Received on Sun Feb 04 2001 - 16:25:22 CST