Re: External Procedures

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 13 Oct 1998 13:55:42 GMT
Message-ID: <36255af2.91913404@192.86.155.100>

A copy of this was sent to Bernd Dohr <bernd.dohr_at_quelle.de> (if that email address didn't require changing) On Tue, 13 Oct 1998 11:50:54 +0200, you wrote:

>Hy,
>
>I have to user external C-Functions from ORACLE PL/SQL , is there
>anybody out ther who have experience about the configuration og the
>tnsnames.ora and listener.ora files ??
>I have problems to configure it !
>
>Thanks
>Bernd
>

I've done it a couple of times. Here is a really simple setup:

tnsnames.ora --------------------------------------

extproc_connection_data =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = oracle81.world))     (CONNECT_DATA = (SID = extproc))
  )

eof --------------------------------------------
listener.ora ----------------------------------- LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL=IPC)(KEY=oracle81.world)) (ADDRESS= (PROTOCOL=TCP)(Host=sheepdog)(Port= 1521)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME=sheepdog.us.oracle.com) (ORACLE_HOME= /export/home/oracle81) (SID_NAME = oracle81) ) (SID_DESC = (SID_NAME = extproc) (ORACLE_HOME = /export/home/oracle81) (PROGRAM = extproc) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 ------------------- eof --------------------------------

Note that many things need to match up. some areas to note are:

extproc_connect_data in the tnsnames file is FIXED -- it must be that. If you have a default domain setup in your sqlnet.ora, then you must add that domain to the end of the extproc_connect_data (making it, for example, extproc_connect_data.world)
the KEY in the tnsnames.ora file for the IPC connection must match the KEY in the listener.ora file for the IPC connection (eg: mine are both oracle81.world)
the sid name should be extproc in the listener.ora
the program name must be extproc in the listener.ora

Hope this helps.

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities

Opinions are mine and do not necessarily reflect those of Oracle Corporation

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Oct 13 1998 - 08:55:42 CDT