Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: External Procedures
Well, that's why you should compare all 3 *.ora files on both servers
as I had suggested. The problem will become apparent when you do that.
Did you see PLSExtProc from lsnrctl services? That's the one external
procedure needs. Look up the listener.ora and see if something like
the following is there. I cut this from your posted listener.ora by
the way.
> >LISTENER =
> > (DESCRIPTION_LIST =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = asp1)(PORT = 1521))
> > )
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> > )
> > )
> > )
> >
> >SID_LIST_LISTENER =
> > (SID_LIST =
> > (SID_DESC =
> > (SID_NAME = PLSExtProc)
> > (ORACLE_HOME = /oracle/8.1.7)
> > (PROGRAM = extproc)
> > )
> > When I did tnsping I am getting No Listener error. > When I go into lsnrctl services then I do not see this service enabled > but I see all the other services avalable for asp, stars and stars_d. > How can start the EXTPROC_CONNECTION_DATA service on the problem > machine??Received on Tue Aug 13 2002 - 13:28:51 CDT