ORA-12805: parallel query server died unexpectedly
I got hit with the below error message when the application job runs.
ERROR at line 1:
ORA-12805: parallel query server died unexpectedly
ORA-06512: at "HONDA.CONQUEST_ELIGIBLE_FLAG_UPDATE", line 94
ORA-06512: at line 1
The alert log information shows.
ORA-07445: exception encountered: core dump [kghalf+04f8] [SIGSEGV] [Address not mapped to object] [0x4E06313931323838] [] []
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
I don't see any block corruption message in the DB however in the db i see blocks were corrupted.
SQL> select * from v$database_block_corruption;
FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------
82 1521447 98 6245292568 UNKNOWN
70 3022371 6 6245307914 UNKNOWN