In certain instances, the following ORA-600 errors can arise on Oracle 11.x or later - Possible Causes/Solution are mentioned below - please check for relevance in your particular scenario.
=================
DESCRIPTION:
A failed attempt to free a chunk of memory results in this ORA-600 error. Further investigation reveals that, this chunk header is neither "recreatable" nor "freeable".
and therefore generate this exception.
ORA-600 [17402]
===============
DESCRIPTION:
ORA-600[17402] is indicative of a Memory Heap Corruption.
ORA-600 [17183]
===============
DESCRIPTION:
Memory is checked to ensure that it is "freeable". If doing so causes a failure, this shall geenerating this ORA-600 exception. This also results in Memory Corruption and causes no Data Corruption.
Possible Causes - Require further investigation and RCA:
ORA-600 [kghfre2]
=================
DESCRIPTION:
A failed attempt to free a chunk of memory results in this ORA-600 error. Further investigation reveals that, this chunk header is neither "recreatable" nor "freeable".
and therefore generate this exception.
ORA-600 [17402]
===============
DESCRIPTION:
ORA-600[17402] is indicative of a Memory Heap Corruption.
ORA-600 [17183]
===============
DESCRIPTION:
Memory is checked to ensure that it is "freeable". If doing so causes a failure, this shall geenerating this ORA-600 exception. This also results in Memory Corruption and causes no Data Corruption.
Possible Causes - Require further investigation and RCA:
- Improper/Unpatched OS Stack
- Improper/Incorrectly configured VM/LPAR Memory Configuration
- Hardware Memory Issues
- SGA/PGA/UGA Memory Shortage/Exhaustion
- Increase the SGA/PGA Memory Areas
- Perform full hardware diagnostics on the Memory Hardware
- Check the OS Stack for latest Patch levels
