ORA-12801: error signaled in parallel query server P001 ORA-00600: internal error code, arguments: [kxspoac : EXL 1], [32], [1], [], …

Oracle Version Affected :
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

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 there was no conflict in the application

1.Download the patch zip file


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

Category: DatabaseExadataLinux


Leave a Reply

Article by: Shadab Mohammad