My Oracle Support Banner

Precompiler Based Applications Crash After Upgrading To Oracle 11g (Doc ID 1364386.1)

Last updated on MARCH 04, 2022

Applies to:

Precompilers - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data
from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product.
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Symptoms

After upgrading the Client environment to 11g, existing Precompiler based appilications start receiving segmentation faults, crashes, heap corruption etc.

The stack may look like:

[1] sqlatm(0x10042bd40, 0xffffffff7fffd578, 0x10042af80, 0x1003c1360, 0x2, 0x1
[2] sqlnst(0xffffffff7c25c268, 0xa, 0x1001b1bc0, 0x6, 0xc, 0x5),
[3] sqlcmex(0x1, 0xffffffff7fffd4b0, 0x0, 0xc, 0x1003c1360, 0x0),
[4] sqlcxt(0x0, 0x1001b1c00, 0xffffffff7fffd578, 0x1001b1c04, 0x1003c1360, 0x0

or

#0 0x0089410c in sqlcln ()
#1 0x01e8e424 in sqlcmex ()
#2 0x01e8e1af in sqlcxt ()

or

7cda0824 _kill (ffbfddcc, ffbfd4ec, 1, 2, ffbfd4e8, 7f93447c) + 8
7ed4f04c skgesigCrash (ffbfddc4, 1, 4c8, 6060000, b5ee38, ffbfddc4) + 24
7ed4f70c skgesig_sigactionHandler (b, ffbfea50, ffbfddc8, 6bd9c, 0,
7f934468) + d4
7f9856fc __sighndlr (b, ffbfea50, ffbfe798, 7ed4f638, 0, 0) + c
7f97f354 call_user_handler (b, ffbfea50, ffbfe798, 0, 0, 0) + 234
7f97f504 sigacthandler (b, ffbfea50, ffbfe798, 38, 0, e8) + 64
--- called from signal handler with signal 11 (SIGSEGV) ---
7dda2e10 sqlshv (7f926234, 8, 10b100, ffbfed90, ffbfebb6, 8) + 274
7dda40c8 sqlatm (7f926234, 109c20, 109e40, ffbfed90, 8, 1) + 2e0
7dd900e4 sqlnst (7f926234, 109c20, 25f36, ba, 3, 1430) + 15d4
7dd832b8 sqlcmex (7f926234, c, ffbfed90, 0, 0, 7f6d23e8) + 458
7dd8357c sqlfx7 (1553c, 26054, 8, 1, 5c, 1) + e8

Note: You may have to disable ADR in order to avoid an ORA-24550 that is masking the real issue.

Changes

Upgraded/Migrated the Precompiler version to 11.1.0.6, 11.1.0.7, 11.2.0.1, or 11.2.0.2, from a Pre-11g version.

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.