Kbase P109096: Oracle error 03113 when the SQL contains ORDER BY clause for the SELECT query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/11/2005 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
Oracle 9i
SYMPTOM(s):
Oracle error 03113 when the SQL contains ORDER BY clause for the SELECT query
ORA-03113: end-of-file on communication channel
The error ORA-03113 is very generic
The actual error is ORA-07445 which was seen in the Oracle's alret.log file.
ORA-07445 [KKEOSL()+492]:
"exception encountered: core dump [%s] [%s] [%s] [%s] [%s] [%s]"
// *Cause: An OS exception occurred which should result in the creation of a
// core file. This is an internal error.
The DataServer log file shows the parsed SQL for the FIND 4GL query
Oracle Database version 9.2.0.4.0
The error also happen on Oracle version 9.2.0.3.0 and 9.2.0.5.0
CAUSE:
Oracle bug 2971238
FIX:
Contact Oracle Support to get the fix (9.2.0.6.0) for this bug.