PROC Command Produces A Huge Core Dump And Hangs After Migrating From Oracle 9i to Oracle 11g 11.2 (Doc ID 1350551.1)

Last updated on OCTOBER 05, 2015

Applies to:

Precompilers - Version 11.2.0.1 and later
Information in this document applies to any platform.
*** Checked for relevance on 5th Oct 2015***

Symptoms

After migrating from 9i (9.2.0.x) to 11.2.0.1, the proc command hangs and produces a huge core dump, no *.lis or *.c files were generated.

The process status "ps -ef | grep proc" shows proc process is running and "top" command shows proc on top of the list.

The following command hangs:

fscn% proc PARSE=PARTIAL code=ANSI_C sqlcheck=full userid=/ iname=vingcard

Pro*C/C++: Release 11.2.0.1.0 - Production on Thu Jul 28 16:11:56 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

System default option values taken from: /slice1/software/product/11.2.0/precomp/admin/pcscfg.cfg
...

Changes

The Database software was upgraded from 9i to 11.2.

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