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

Last updated on SEPTEMBER 02, 2016

In this Document
  Symptoms
  Changes
  Cause
  Solution
  References


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

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