Repeated ORA-01002 messages in CRSD oraagent Trace File
(Doc ID 2504425.1)
Last updated on MAY 15, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 to 18.3.0.0.0 [Release 12.2 to 18]Information in this document applies to any platform.
Symptoms
crsd_oraagent_oracle.trc (inside <oracle base>/diag/crs/<HOSTNAME>/crs/trace location) have repeatedly logging below messages every 10 minutes
2018-12-17 08:29:47.547 : USRTHRD:1708279552: {0:11:2} ORA-01002: fetch out of sequence
2018-12-17 08:29:47.713 : USRTHRD:1708279552: {0:11:2} ORA-01002: fetch out of sequence
2018-12-17 08:39:47.740 : USRTHRD:1708279552: {0:11:2} ORA-01002: fetch out of sequence
2018-12-17 08:39:48.076 : USRTHRD:1708279552: {0:11:2} ORA-01002: fetch out of sequence
2018-12-17 08:39:48.152 : USRTHRD:1708279552: {0:11:2} ORA-01002: fetch out of sequence
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |