1

Topic: ORA-7445

Good afternoon, colleagues!
Oracle Linux Server release 6.4 AND Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
Recently in  there was an error ORA-07445: exception encountered: core dump [kkorminl () +306] [SIGSEGV] [ADDR:0x7FFFB98B8FE8] [PC:0x9541BA4] [Address not mapped to object] [] .
[spoiler] *** 2017-09-26 22:00:41.874
*** SESSION ID: (21.27901 2017-09-26 22:00:41.875
*** CLIENT ID:() 2017-09-26 22:00:41.875
*** SERVICE NAME:(SYS$USERS) 2017-09-26 22:00:41.875
*** MODULE NAME:(DBMS_SCHEDULER) 2017-09-26 22:00:41.875
*** ACTION NAME:(ORA$AT_SQ_SQL_SW_37727) 2017-09-26 22:00:41.875
Dump continued from file: /u01/app/oracle/diag/rdbms/xxi/xxi/trace/xxi_j006_5737.trc
ORA-07445: exception encountered: core dump [kkorminl () +306] [SIGSEGV] [ADDR:0x7FFF42F78FE8] [PC:0x9541BA4] [Address not mapped to object] []
[/spoiler]
But most of all I am am disturbed here by this situation (already there were 2 cases, in  about it anything is not present), see more low.

PROCEDURE LO_Reg
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
DBMS_ALERT.Register (' XXX ');
END LO_Reg;
ORA-04029: error ORA-7445 occurred when querying Fixed TAble/VIEW
ORA-06512: at "SYS.DBMS_ALERT", line 78
ORA-06512: at "SYS.DBMS_ALERT", line 102
ORA-06512: at "XXX.LO_REG", line 4
SQL> SELECT count (*) FROM X$KGLOB;
ORA-04029: error ORA-7445 occurred when querying Fixed Table/View

In  does not form, in  it is pure.
DB restart helps, but it not an output for .
Access on a metalink is not had, in view of greed of a manual.
Colleagues, whether there was at somebody something similar?
To what it can be connected?

2

Re: ORA-7445

lexus_gm;
Bug 18732628 : ORA-4029: ERROR ORA-7445 OCCURRED WHEN QUERYING FIXED TABLE/VIEW
To solve the issue, use any of below alternatives:
1) Apply patch set 12.1.0.2
- OR -
2) Apply interim Patch 17820741 , if available for your platform and (PSU) patch level
But, "there are no pinches - there are no animated cartoons" ()

3

Re: ORA-7445

Kind  - Eh;
Thanks for the information!