Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Net8 configuration for external procedures (Linux)

Net8 configuration for external procedures (Linux)

From: Vincent GRENET <vincent.grenet_at_free.fr>
Date: 2000/03/01
Message-ID: <r2gv4.8$FT1.318753@nnrp3.proxad.net>#1/1

Hi all.

I am trying to setup Net8 to call an external procedure. When I try to call the external procedure, I get the following error message:

ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "SMPIF.OUTPUTSTRING", line 0
ORA-06512: at line 1

 I set up the same configuration as described in the administration manual:

tnsnames.ora:

extproc_connection_data =
(DESCRIPTION =

    (ADDRESS = (PROTOCOL = IPC)(KEY = extproc_key))     (CONNECT_DATA = (SID = extproc_agent))   )

listener.ora:

EXTERNAL_PROCEDURE_LISTENER =
(ADDRESS_LIST =

 (ADDRESS= (PROTOCOL= IPC)(KEY= extproc_key))   )
SID_LIST_EXTERNAL_PROCEDURE_LISTENER =
(SID_LIST =

    (SID_DESC =

      (SID_NAME = extproc_agent)
      (ORACLE_HOME = /u01/app/oracle/product/8.0.5)
      (PROGRAM = extproc)

    )
  )

When I start the listener ($ lsnrctl start external_procedure_listener), I get the following error:

TNS-12546: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
  TNS-00516: Permission denied
   Linux Error: 13: Permission denied

or, the second time I start it (after stopping it):

TNS-12542: TNS:address already in use
 TNS-12560: TNS:protocol adapter error
  TNS-00512: Address already in use
   Linux Error: 98: Address already in use

I have been unable to get any information on TNS-12542, TNS-12546 and TNS-12560 error
messages.

I also checked that acess rights on /var/tmp/.oracle are correct. The UNIX domain socket is created.

Any Idea ?

My configuration is :

Linux Red Hat 5.2
Oracle 8.0.5 Received on Wed Mar 01 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US