Re: Unable to run IPC

Looks like you have hit a reserved word. You need to configure an extra IPC block using external procedures. The IPC key is as far as I know: EXTPROC. Normally the IPC key should equal the SID, you seem to have done that. In that case, regrettably your SID needs to be changed.

Hth,

Sybrand Bakker, Oracle DBA

nilendu_at_my-dejanews.com wrote in message <7h9gu1$47n$1_at_nnrp1.deja.com>...
>Hi All,
>I have Oracle8i database installed on NT machine.I am using Names Server
>(without DDO) to connect to my database.
>Now I have to call some external DLLs for which I have to have IPC
>connection.
>What I have done is:
>(1) Through NetAssist, I configured listener.Listener listens to a TCP
>connection(address of my server),which is working OK.
>Then I configured Listener,for IPC connection.I have given EXTPROC0 as
>key.And EXTPROC as the SID of the IPC database.
>
>So my listener.ora looks like this:
>
>------------------------------
>Listener.ora----------------------------------
>LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521))
> (PROTOCOL_STACK =
> (PRESENTATION = TTC)
> (SESSION = NS)
> )
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> (PROTOCOL_STACK =
> (PRESENTATION = TTC)
> (SESSION = NS)
> )
> )
> )
>
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = names)
>#NAMES is my name server database#
> (ORACLE_HOME = d:\orant\product\ora81)
> (SID_NAME = names)
> )
> (SID_DESC =
> (PROGRAM = EXTPROC)
> (SID_NAME = EXTPROC)
> )
> )
>
>--------------------------------------------------------------
>Now when I call the External Procedure from Worksheet,it shows me an
>error :
>
>ORA-28575 : Unable to open RPC connection to external procedure agent
>
>Now I don't have EXTPROCAGENT listen in my SERVICES.
>Earlier with 8.0.5 EXTPROCAGENT used to be on the Services.
>
>Anybody has any clue to offer?
>TIA,
>Nilendu
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Tue May 11 1999 - 11:38:33 CDT