My Oracle Support Banner

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 later
Information 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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.