DROP SYNONYM Fails With ORA-7445 [Kggmd5process] (Doc ID 1398923.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

ORA-7445 [kggmd5Process] dropping or compiling a synonym.

SQL> DROP SYNONYM MWOLAK.CONTRACTS;
ERROR:
ORA-03113: end-of-file on communication channel
Process ID: 19546294
Session ID: 266 Serial number: 3



Alert log shows the internal error ORA-7445 [kggmd5Process] :

...
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x7000001B6010004] [PC:0x1001A5284, kggmd5Process()+164] [flags: 0x0, count: 1]
Errors in file /global/hurtownia/diag/rdbms/cbtest0/CBTEST0/trace/CBTEST0_ora_19546294.trc (incident=13453):
ORA-07445: Exception encountered: CORE Dump [kggmd5Process()+164] [SIGSEGV] [ADDR:0x7000001B6010004] [PC:0x1001A5284] [Address not mapped to object] []
Incident details in: /global/hurtownia/diag/rdbms/cbtest0/CBTEST0/incident/incdir_13453/CBTEST0_ora_19546294_i13453.trc
...



Stack trace will be similar to the following:

kglComputeHash kglGetHot kglttghd kglgtbo kqlCompileSynonym kqllod kglobld kglobpn kglpim kglpin kkdllk0 kkdlGetCodeObject dsydrv opiexe ...

or

kggmd5Process kggmd5Update

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