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 09, 2013

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms