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

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
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s