Intermittent ORA-28576 Error

From: <bobmansk_at_chestnet.com>
Date: Wed, 24 Feb 1999 20:33:43 GMT
Message-ID: <7b1nn6$86s$1@nnrp1.dejanews.com>

All:

I am currently experiencing an intermittent ORA-28576 error. We are using Oracle 8.0.5 database server with Oracle Web Application Server 3.0. We are using an extproc to handle authentication. Occasionally we get “ORA-28576: lost RPC connection to external procedure agent” as an error.

I defined the extproc in the LISTENER.ORA as:

(SID_DESC =
(SID_NAME = extproc)
(ORACLE_HOME = /dbms1/oracle/product/8.0.5)
(PROGRAM = extproc)

    )

And in the TNSNAMES.ORA as:

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS =

       (PROTOCOL=IPC)
       (KEY=extproc)

    )
    (CONNECT_DATA=
(SID=extproc)

  )

To get this error, I rapidly bounce around from one page to another within the application. As I go from page to page, I always call the extproc authentication module. Within ˝ minute, I will get the error. If I take my time and pause a few seconds on each page, I could go all day with out getting the error. I suspect this error may have something to do with the “Max session idle time” for the PL/SQL Cartridge (currently set to 0) and additional setting in the LISTENER.ORA: STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 But this is just a hunch.

Does anyone have any ideas what could be causing this and possible solutions?

Thank You in advance!

Sincerely,

Bob Mansk

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 24 1999 - 14:33:43 CST