Re: Net8 configuration for external procedures (Linux)

I made some progress.

Despite the error message, the listener was started. The error message comes from a status command issued automatically after the start actual command.

I changed access rights on the unix domain socket created by the listener in /var/tmp/.oracle to 777. I no longer receive an error message from the status command.

When calling the external procedure, then, the listener responds but cannot spawn extproc because of the following error:

extprocSMSC: error in loading shared libraries libclntsh.so.1.0: cannot open shared object file: No such file or directory.

The library is in $ORACLE_HOME/lib, $ORACLE_HOME/lib is in the LD_LIBRARY_PATH environement variable. Its access rights are 755, as it should be according to the installation manual.

Guess some more work is required.

Vincent GRENET <vincent.grenet_at_free.fr> a écrit dans le message : LUAv4.348$2T5.2315313_at_nnrp3.proxad.net...
> 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 Mon Mar 06 2000 - 16:39:43 CST