SuperCluster: Critical Issue ESS_7 ORA-600 [RWOROFPRFASTUNPACKROWSETS:OOBP] alone or combined with other ORA-600 errors possible with cell version 12.1.2.3.0 and above

Asset ID:	1-72-2196717.1
Update Date:	2017-11-03
Keywords:

Solution Type Problem Resolution Sure

Solution 2196717.1 : SuperCluster: Critical Issue ESS_7 ORA-600 [RWOROFPRFASTUNPACKROWSETS:OOBP] alone or combined with other ORA-600 errors possible with cell version 12.1.2.3.0 and above

Applies to:

Oracle SuperCluster M7 Hardware - Version All Versions and later
Oracle SuperCluster T5-8 Half Rack - Version All Versions and later
Oracle SuperCluster T5-8 Full Rack - Version All Versions and later
SPARC SuperCluster T4-4 Half Rack - Version All Versions and later
SPARC SuperCluster T4-4 - Version All Versions and later
Information in this document applies to any platform.

Symptoms

Please note: Even if you are not seeing these errors the steps in the solution section should be considered mandatory if you are running on storage cell version 12.1.2.3.0 to 12.2.x

ORA-600 [RWOROFPRFASTUNPACKROWSETS:OOBP]
ORA-600 [kcfis_dump_app_state
ORA-600 [kcfis_dump_global_context_all
ORA-600 [qesrCopyOrigRowsetOpns()+480]
ORA-600 [kxhrHash()+64]

Changes

Upgrade to or deploy on SuperCluster with storage cell version 12.1.2.3.0 to 12.2.x

Cause

Bug 24706134 - ORA-600 [RWOROFPRFASTUNPACKROWSETS:OOBP] OCCURRENCE

Solution

Disable byte swap optimization, for the 12.1.2.3.x offload servers, on the storage cells immediately via cellcli and set a parameter in the storage cell cellinit.ora file to make the modification persistent across reboots.

Note: Even though we are disabling what is title and optimization you should not notice any discernible performance impacts from doing this.

[root@orlm7cel01 ~]# cellcli -e list offloadgroup
SYS_121232_160721 running <==modify only the SYS_12X not any 11 ones you may have running
SYS_112331_150818 running

Take the name of the offload group above and place it in the command below

cellcli -e alter cell offloadgroupEvents = "immediate
cellsrv.cellsrv_setparam('_cell_disable_byte_swap_optimization',TRUE)" ,
offloadGroupName=SYS_121232_160721" ;

Modify the cellinit.ora file to make it persistent across reboots

vi $OSSCONF/cellinit.ora

_cell_disable_byte_swap_optimization=TRUE

References

<BUG:24706134> - ORA-600 [RWOROFPRFASTUNPACKROWSETS:OOBP] OCCURRENCE
<NOTE:1452277.1> - SuperCluster Critical Issues

Attachments

This solution has no attachment