"Error: Unexpected Oracle error: ORA-03135: connection lost contact"
説明
event_log showed the following error for read and capture Error: Unexpected Oracle error: ORA-03135: connection lost contact. in sp_ordr.c:1264 [sp_ordr(osp)/24942] Process exited sp_ordr (for o.spcaprod) [pid = 24942] - exit(1) Notice: ORA-03135: connection lost contact. [sp_ocap(osp)/24936] Error: Unexpected Oracle error: ORA-03135: connection lost contact. in olog.c:3235 [sp_ocap(osp)/24936] sp_ctrl>status showed capture stopped due to error and read stopped due to error
原因
This happened because oracle was bounced while shareplex was running.
対策
Bouncing shareplex and manually starting read and capture resolved the issue. To prevent this issue in the future, make sure to first stop shareplex, then bounce oracle, then start shareplex. Don't bounce oracle while shareplex is running.
