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 -> Re: External Procedures

Re: External Procedures

From: Jusung Yang <jusungyang_at_yahoo.com>
Date: 13 Aug 2002 11:28:51 -0700
Message-ID: <42ffa8fa.0208131028.30a14f90@posting.google.com>


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

Original text of this message

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