Last updated on SEPTEMBER 02, 2017
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 9.2.0.7 [Release 9.2]Information in this document applies to any platform.
Symptoms
Multiple Errors seen including several trace files generated consecutively and persistently as referenced in the ALERT.LOG.
- User performance degrades during these same periods of time
- Several client connection or network error messages are seen during this time period
Reviewing the ALERT.LOG and trace files you fill find references similar or identical to the following:
ORA-20000: ORU-10015: error:3 waiting for pipe message.
ORA-06512: at "SYS.DBMS_ALERT", line 148
ORA-06512: at "SYS.DBMS_ALERT", line 281
ORA-06512: at line ...
Changes
It is difficult to tell if the connection problems are the source or the symptom of the problem:
That stated the multiple trace files and connection issues are seen together leading to not only the obvious connection problems, but the less understandable performance problems.
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms