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

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

Re: Net8 configuration for external procedures (Linux)

From: Tom Zamani <tomz_at_redflex.com.au>
Date: 2000/03/02
Message-ID: <89k9fg$93j$1@perki.connect.com.au>#1/1

 extproc_connection_data =
   (DESCRIPTION =

     (ADDRESS = (PROTOCOL = IPC)(KEY = The actual  SID))
     (CONNECT_DATA = (SID = extproc_agent))

Tom

Vincent GRENET <vincent.grenet_at_free.fr> wrote in message news:r2gv4.8$FT1.318753_at_nnrp3.proxad.net...
> 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 Thu Mar 02 2000 - 00:00:00 CST

Original text of this message

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