| DBMS_ALSERT.WAITONE and END OF FILE ON COMMUNICATION CHANNEL [message #57160] |
Fri, 23 May 2003 04:39 |
RCHU
Messages: 3
Registered: May 2003
|
Junior Member |
|
|
Recently we've upgraded Oracle 8.1.6 to 8.1.7 and also upgraded our Oracle database server to an HP RP7410.
We are beginning to experience a serious but intermittent problem in one of our PL/SQL stored procedures that uses DBMS_ALERT. The problem is intermittent in the sense that it does not always happen. After observation for a while, it seems to happen in the DBMS_ALERT.WAITONE after it has received a signal back from an external application. Furthermore, it seems to happen ONLY when the waiting time is long enough, such as more than 2 hours.
This problem does not occur in Oracle 8.1.6. This problem does not occur when we use DBMS_ALERT in SQL+ directly, i.e. using 2 sessions of SQL+ with one session waited for 4 hours before the 2nd session signals the alert. We also have not made any changes to our applications.
We receive the Ora-3113 error in the CLIENT application that calls the stored procedure to register the alert and wait for its signal. There is another CLIENT application that calls another stored procedure to signal the alert. It seems the signal was sent successfully. Altogether there are two CLIENT applicatons involved. Both CLIENT applications run on W2K server platform. We use the DBMS_ALERT to synchronize the execution of the two CLIENT applications.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
