-
Title
Error: OCIAttrGet failed with ORA--2 -
Description
Single Threaded Post core dumps with the following error
07/18/08 15:13 Error: process sp_opst killed due to SIGSEGV [sp_cop/8635294]
07/18/08 15:13 Error: OCIAttrGet failed with ORA--2; rpc 0. [sp_opst (for o.prod-o.prod queue p1c)/6919046]
07/18/08 15:13 Error: OCI Error: Invalid Handle [sp_opst (for o.prod-o.prod queue p1)/6919046]
07/18/08 15:13 Error: OCIAttrGet failed with ORA--2; rpc 0. [sp_opst (for o.prod-o.prod queue p1)/6919046]
07/18/08 15:13 Error: OCI Error: Invalid Handle [sp_opst (for o.prod-o.prod queue p1)/6919046]
07/18/08 15:13 Error: OCI Error: Invalid Handle [sp_opst (for o.prod-o.prod queue p1)/6919046] -
Resolution
WORKAROUND
Disable sql cache as follows.
sp_ctrl>set param SP_OPO_SQL_CACHE_DISABLE 1Reset the parameter once the issue is resolved
sp_ctrl>reset param SP_OPO_SQL_CACHE_DISABLE