Re: Can't call external C procedure from oracle

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 10 Jan 2003 20:41:48 -0800
Message-ID: <92eeeff0.0301102041.6e0b83a@posting.google.com>

"Fez Panwaskar" <panwaskarf_at_logica.com> wrote in message news:<1042212819.681262_at_ernani.logica.co.uk>...
> I'm trying to set-up a simple c dll external procedure call as described
> in the oracle
> documentation. But I recieve the following error message:
>
> ORA-28575: unable to open RPC connection to external procedure agent
> ORA-06512: at "PDADMIN.SQ", line 0
> ORA-06512: at line 4
>
> I All suggestions point the error being related to the Listener.ora file
> set-up and
> yet I have followed the example instruction to the letter.
> Has anyone come across this error?
>
> Here is the update to the Listener file:
> SID LIST LISTENER =
> (SID LIST =
> (SID DESC =
> (SID NAME = extproc)
> (ORACLE HOME = d:\oracle\ora81)
> (PROGRAM = d:\oracle\ora81\bin\<filename>)
> )
> )
>
> And the tnsnames:
> extproc connection data.<domain name> =
> (DESCRIPTION =
> (ADDRESS LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = /* Hostname */)(PORT = 1521))
> )
> (CONNECT DATA =
> (SID = extproc)
> )
> )
>
> I've then created a library and a function calling the external
> procedure. But
> on calling the procedure I recieve the above mentioned error message.
>
> Under 'tnsping' I cannot ping the extproc connection data.<domain name>
> the name cannot be resolved.
>
> If anyone has come across this problem can you please advise?
> Regards,
>
> Fez Panwaskar
> Space & Defence Division
>
> Logica
>
> Tel: +44 (0)137 27 59100
>
> Fax: +44 (0)137 27 59133
>
> panwaskarf_at_logica.com
>
> <http://www.logica.com/>
>
>
>
> --

These are the entries from my machine which work ok,

Listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS_LIST = 
        (ADDRESS = (PROTOCOL = TCP)(HOST = <HOST>)(PORT = 1521))
        (ADDRESS = (PROTOCOL = TCP)(HOST = <HOST>)(PORT = 1526))                
        (ADDRESS = (PROTOCOL = IPC)(KEY = ExtProc))
      )      

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =

      (SID_DESC =
         (SID_NAME = <SID>)
      )
      (SID_DESC =
         (SID_NAME = ExtProc)
         (PROGRAM = ExtProc)
      ) 

  )

tnsnames.ora
EXTPROC_CONNECTION_DATA.<DOMAIN> =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))     )
    (CONNECT_DATA =
      (SID = ExtProc)
    )
  )

Regards
/Rauf Sarwar Received on Fri Jan 10 2003 - 22:41:48 CST