On Saturday morning, our non-Exadata 11.5.10.2 EBS instance running on 10.2.0.4 would prompt users trying to log in with the error message "Oracle error &ERRNO: &REASON has been detected in &ROUTINE." Obviously that's not right, and it forced the DBAs to bounce the Apache web services to clear the error but every week or two the error message would return requiring that Apache bounce to clear it. Oracle suggested that our solution was applying patch 6823287 for the bug that we started encountering, or a workaround is to set the initialization parameter session_cached_cursors=0.
I'll give you an update on if this resolves our issue, as the bug doesn't say it has been reproduced in our DB version, but I wanted to put this out into the community now in case others start to experience this error. As an aside, I say "start to experience" for a reason since we've made few changes to this instance, none of them major, but years after being upgraded from 11.5.9 this started to creep up out of the blue for no reasons we can determine.
No comments:
Post a Comment