ORA-07445: exception encountered: core dump [hshget1()+120] [SIGSEGV]
(Doc ID 1331237.1)
Last updated on JULY 15, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
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 ...
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]
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], [], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [16204], [], [], [], [], [], [], [], [], [], [], []
Changes
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 |