OpenVMS: ORA-3113 Error When Using 188.8.131.52 Clients Against A 10.2.0.4 Database
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***
After upgrading an OpenVMS 184.108.40.206 RDBMS to 10.2.0.4.3, 220.127.116.11 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms