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 FEBRUARY 03, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.4 and laterInformation in this document applies to any platform.
***Checked for relevance on 09-Apr-2013***
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 |
| This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. |