Actually, Oracle was not the problem. Through many hours of head banging
and hair pulling, me and an associate finally figured out that it was the C
program which was the problem. The program was opening a socket but not
closing it so I was running out of connections.
Oracle was not actually giving me an error message but I was requesting
url's with my C program and getting error connects back. Thought I was
overloading the listener but that was not the case.
I appreciate the input.
thanks
-----Original Message-----
Sent: Tuesday, July 17, 2001 4:16 AM
To: Multiple recipients of list ORACLE-L
Kempf
What is your external procedure doing?.
We have seen this problem when trying to use external procedures to run
remote unix commands.
The solution was to have a seperate external procedure listener which you
can start seperately from the standard listener(you may already be ding
this), and then start it either from cron, or as a background job using
nohup and &.
Simply starting it from the command line did not work...it fell over when
that session was logged out.
John
> -----Original Message-----
> From: Kempf, Reed [SMTP:[EMAIL PROTECTED]]
> Sent: 10 July 2001 00:46
> To: Multiple recipients of list ORACLE-L
> Subject: RE: callout listener and external procedure issue
>
> Thanks for the insight, unfortunately I am passing parameters into my
> external procedure and returning a numreric value which is passed onto the
> rest of my plsql routines.
>
> Here is my c function:
> -- ************* START OF FUNCTION CHECK_FAQ ************************
> -- This procedure references an IN variable for the external C function
> -- RetrieveURL and maps the library in the database which points to
> -- the C external procedure to be run. This external function will
> -- return an integer value for the request time (positive number) or
> -- an error code (negative number).
> -- *************
>
> FUNCTION check_faq
> (RetrieveURL IN VARCHAR2,
> timeout IN BINARY_INTEGER)
> RETURN BINARY_INTEGER
> AS
> LANGUAGE C
> NAME "rnt_url"
> LIBRARY MY_C_LIB
> PARAMETERS (
> RetrieveURL string,
> timeout int);
>
> I have to restart my callout listener to have my program successfully run.
>
>
>
> -----Original Message-----
> Sent: Monday, July 09, 2001 5:20 PM
> To: Multiple recipients of list ORACLE-L
>
>
> "Kempf, Reed" wrote:
> >
> > Hello gurus,
> >
> > I have written a plsql package which incorporates an external C
> procedure
> > and therefore utilizes a callout listener and am having problems with
> the
> > callout listener losing connection in the middle of my program
> >
> > Has anyone out there had any sort of similar problems using an external
> > procedure and a callout listener and if so is there a patch or
> workaround
> > for this.
> >
> > Here is my listener.ora file:
> >
> > # LISTENER.ORA Network Configuration File:
> > /opt/oracle/product/8.1.7/network/admin/listener.ora
> > # Generated by Oracle configuration tools.
> >
> > LISTENER_1 =
> > (DESCRIPTION_LIST =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS =
> > (PROTOCOL = TCP)
> > (HOST = weaklink)
> > (PORT = 1521))
> > )
> > )
> > )
> >
> > CALLOUT =
> > (ADDRESS_LIST =
> > (ADDRESS =
> > (PROTOCOL=IPC)
> > (KEY=EXTPROC)
> > )
> > )
> >
> > SID_LIST_LISTENER_1 =
> > (SID_LIST =
> > (SID_DESC =
> > (SID_NAME = WEAKLINK)
> > (ORACLE_HOME = /opt/oracle/product/8.1.7)
> > )
> > )
> >
> > SID_LIST_CALLOUT =
> > (SID_LIST =
> > (SID_DESC =
> > (SID_NAME = CALLOUT)
> > (ORACLE_HOME = /opt/oracle/product/8.1.7)
> > (PROGRAM = /opt/oracle/product/8.1.7/bin/extproc)
> > )
> > )
> >
> > Reed
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Kempf, Reed
> > INET: [EMAIL PROTECTED]
> >
>
> Reed,
>
> Don't know how it works in your case but remember that external
> procedures are dynamically loaded. If you are using static variables,
> they may be reset anytime. The reason may be that your proc is flushed
> out of memory, then called back.
> --
> Regards,
>
> Stephane Faroult
> Oriole Corporation
> Voice: +44 (0) 7050-696-269
> Fax: +44 (0) 7050-696-449
> Performance Tools & Free Scripts
> --------------------------------------------------------------
> http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
> --------------------------------------------------------------
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Stephane Faroult
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kempf, Reed
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kempf, Reed
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
