ORA-07445: exception encountered: core dump [hshget1()+120] [SIGSEGV] (Doc ID 1331237.1)

Last updated on JUNE 16, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 04-Apr-2013***

Symptoms

When attempting to run utlirp.sql after applying a patch per <Note: 1063604.1>, the following error occurs.

ORA-07445: exception encountered: core dump [hshget1()+120] [SIGSEGV] [ADDR:0x18] [PC:0x108BD2B38] [Stack Overflow]


The trace file for the error shows a current sql and call stack like below:

----- Current SQL Statement for this session (sql_id=d5hvupqu7h7rg) -----
ALTER PACKAGE "SYS"."DBMS_UTILITY" COMPILE BODY REUSE SETTINGS


----- Call Stack Trace -----

... hshget1 hshget phnrrd_resolve_rhs_  designator phnr_resolve ph2exp ph2of1 ph2exp ph2dcl ph2its ph2blo ph2obl ph2sbo ph2its ph2blo ph2obl ph2sbo ph2its ph2blo ph2obl ph2uni ph2dr2 ph2drv phpsem phpcmp pcicmp0 kkxcmp0 rpiswu2 kkxcmp kkpalt opiexe opiosq0 opiodr rpidrus ...



In similar cases, the call stack may look like:

... hshget1 hshget2 hshget hshgot ph2got ph2gbi ph2dr2 ph2drv phpsem phpcmp pcisem2 kkxsem opitca kksFullTypeCheck rpiswu2 kksSetBindType kksfbc opiexe ...


Because the issue involves invalid objects, also errors like the next could be encountered for simple sql statements:

ORA-06544: PL/SQL: internal error, arguments: [2603], [], [], [], [], [], [], []
ORA-06553: PLS-707: unsupported construct or internal error [2603]


Trace files for the above may report next additional internal errors:

ORA-00600: internal error code, arguments: [4406], [0xB051FA488], [0xB051FAE88], [2], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [16204], [], [], [], [], [], [], [], [], [], [], []

 

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