External Procedures w/ O8i on Linux

From: Knut Lassmann <k.lassmann_at_q-bus.de>
Date: 24 Nov 1999 08:09:08 -0600
Message-ID: <383BF1C9.F0BF5978@q-bus.de>

Hi folks,

I have problems getting my external procedures work. I created a shared

library using C, then created an alias for the library and finally the

external procedure in the database. When I try to execute the procedure

I get ORA-28575: unable to open RPC connection to external procedure agent.

I know that I have to edit my listener.ora and tnsnames.ora files to

support external procedures, so here are my files:

# listener.ora

CONNECT_TIMEOUT_LISTENER = 0 LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(PROTOCOL_STACK =

        (PRESENTATION = TTC)
        (SESSION = NS)
      )

)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1526))
(PROTOCOL_STACK =

        (PRESENTATION = TTC)
        (SESSION = NS)
      )

    )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = ikarusdb)
(ORACLE_HOME = /usr/local/oracle/OraHome)
(SID_NAME = ORCL)

    (SID_DESC =
(SID_NAME = extproc)
(ORACLE_HOME = /usr/local/oracle/OraHome)
(PROGRAM = extproc))

    )
  )

# tnsnames.ora

IKARUSDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ikarus)(PORT = 1521))
    )
    (CONNECT_DATA =
(SID = ORCL)

    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ikarus)(PORT = 1521))
    )
    (CONNECT_DATA =
(SID = extproc)

    )
  )

Any idea, what I did wrong?

Thanx in advance

Knut

|                                                                  |
|    Knut Lassmann                   Email: K.lassmann_at_q-bus.de    |
|    q~bus Mediatektur GmbH          Fon:   390 489 186            |
|    Salzufer 13F                    Fax:   390 489 140            |
|    10587 Berlin                                                  |
|                                                                  |
--------------------------------------------------------------------

Received on Wed Nov 24 1999 - 08:09:08 CST