Post core dumps due to ORA-04088: error during execution of trigger '<name>'
event_log:
Notice: process sp_opst killed due to SIGBUS; (core file = <path>/core.## was not generated) [sp_cop/<pid>]
Error: process sp_opst killed due to SIGBUS [sp_cop/<pid>]
opo log with full debug turned on:
08-07-07 13:40:26.807956 28338 4 ORA-04088: error during execution of trigger '<OWNER>.<TRIGGER_NAME>'
Enabled triggers for all users.
Resolution1:
set param sp_opo_debug_flag 0x1f0021ff on target
Find "ORA-04088: error during execution of trigger '<name>'" entry in *opo*.log
disable trigger:
1. disable trigger if target is reporting instance.
Resolution 2:
Manually add wrapper OR Execute sp_add_trigger.sql to prevent triggers from being fired for shareplex.
Use sp_add_trigger.sql when you cannot disable triggers on target objects, such as for peer-to-peer and high-availability configurations. This script changes the triggers so that they ignore the SharePlex Oracle user associated with the Post process, but fire for all other users. Please refer to Admin Guide section "Using the SharePlex trigger scripts" page # 454 for more information on this script.
