Oracle Version Affected : 12.1.0.2
OS : OEL 6 Update 7, x64
This error is related to Parallel Query and we encountered it many times, once on test and once on production. The solution is to apply below patch
Patch 19201867: SR12.2PX_HYBRID_LOAD – TRC – ORA-600 [KXSPOAC : EXL 1]
It is due to a bug, as mentioned in Oracle Support site
Bug 19201867 – Parallel slave process fails with ORA-600 [kxspoac : EXL 1] (Doc ID 19201867.8)
You can search the patch from Oracle support website and download it specific to your PSU. We had to apply for Proactive BP 12.1.0.2.160419
The patch has to be applied in the Oracle DB home and all instances under that DB home need to be stopped before applying the patch. Since we were already on the BP 12.1.0.2.160419 there was no conflict in the application
1.Download the patch zip file
p19201867_12102160419DBEngSysandDBIM_Linux-x86-64.zip
2. Unzip the patch in directory
$ unzip -d <PATCH_TOP_DIR> p19201867_12102160419DBEngSysandDBIM_Linux-x86-64.zip
3. Run Pre-requsite check
$ cd <PATCH_TOP_DIR>/19201867 $ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
If no conflicts found proceed further, if there is some conflict open SR with Oracle to investigate further
4. Stop all databases on both nodes under the Oracle Home to where you are applying the patch
5. Apply the patch $ opatch apply 6. Verify application $ opatch lsinventory | grep 19201867
