Re: Net8 configuration for external procedures (Linux)

Tom,

the problem is the same with the actual database SID.

The 'TNS-12546: TNS:permission denied' message makes me think it's some problem related to access rights, but I've been unable to find any problem like that.
The 'TNS-12542: TNS:address already in use' makes me think something is listening on that port after the listener was started.

Now I'm getting short on ideas...

Thanks anyway
Vincent

Tom Zamani <tomz_at_redflex.com.au> a écrit dans le message : 89k9fg$93j$1_at_perki.connect.com.au...
> 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