Re: Can't call external C procedure from oracle

From: Jusung Yang <JusungYang_at_yahoo.com>
Date: 11 Jan 2003 01:32:06 -0800
Message-ID: <130ba93a.0301110132.74a692e2@posting.google.com>

It is best not to manually edit the net configuration files, especially if you are not familiar with SQL*NET. Slightest error in the files can give you a lot of headache. I don't rememeber ever have to, well maybe once or twice, edit that particular entry for the external procedure connection. Here is a sample of the listener.ora and tnsnames.ora, just follow the format and you should be fine. Also, check that the domain name in sqlnet.ora is same as the one in tnsnames.ora.

listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = earth)(PORT = 1521))
      )

)
)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = athena)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = athena)

    )
  )

tnsnames.ora

ATHENA =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = earth)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = athena)

    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

Jusung Yang

"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/>
> 
> 
> 
> --

Received on Sat Jan 11 2003 - 03:32:06 CST