OpenVMS: ORA-3113 Error When Using 9.2.0.8 Clients Against A 10.2.0.4 Database
(Doc ID 1175163.1)
Last updated on APRIL 14, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
After upgrading an OpenVMS 9.2.0.8 RDBMS to 10.2.0.4.3, 9.2.0.8 OpenVMS based clients are receiving intermittent ORA-3113 errors.
Event 10849 is already set and working per note 455832.1
The sql code for the failing queries is lengthy, typically more than 1500 characters.
The queries can be restarted and run without failure.
Level 16 SQL*net tracing of both client and server show that the client is sending two large packets (containing the lengthy sql query) but the server never receives the packets.
The client will hang for 9 minutes and then the client server connection is broken, returning an ORA-3113 error to the client.
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 |