ORA-07445 [kpufdesc()+872] ORA-22303 and ORA-1403 (Doc ID 1380614.1)

Last updated on DECEMBER 08, 2014

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Below ORA-7445 error shows in the alert log file

ORA-07445: exception encountered: core dump [kpufdesc()+872] [SIGSEGV] [Address not mapped to object] [0x000000021] [] []
ORA-22303: type "SYS"."ALERT_TYPE" not found


May also see the following messages with the ORA-7445 in the alert log file

ORA-1403 encountered when generating server alert SMG-4120
ORA-1403 encountered when generating server alert SMG-4121


Also please check the invalid objects

SQL> col object_name for a40
SQL> set lines 150 pages 500
SQL> select object_name,object_type, status,owner from dba_objects where status = 'INVALID' order by owner,object_type,object_name;

ALERT_QUE                   QUEUE INVALID SYS
AQ$_ALERT_QT_E              QUEUE INVALID SYS
AQ$_KUPC$DATAPUMP_QUETAB_E  QUEUE INVALID SYS
ALERT_QUE$1                  RULE INVALID SYS
ALERT_QUE$1              RULE SET INVALID SYS
ALERT_QUE_N              RULE SET INVALID SYS
ALERT_QUE_R              RULE SET INVALID SYS
ALERT_QT                    TABLE INVALID SYS
AQ$ALERT_QT                  VIEW INVALID SYS
AQ$_ALERT_QT_F               VIEW INVALID SYS


ALERT_QUE is invalid in the database

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