-
Title
Event_log shows errors ORA-1092 or ORA-01092 -
Description
The following types of errors are seen in the event log when ORA-1092 occurred:
11/21/07 01:40 Error: 12070 - OCITransCommit failed with ORA-1092. [sp_opst(osp)/23904]11/21/07 01:40 Notice: ORA-01092: ORACLE instance terminated. Disconnection forced. [sp_opst(osp)/23907]
11/21/07 01:40 Error: Unexpected Oracle error: ORA-01092: ORACLE instance terminated. Disconnection forced. (object name: OWNER.TABLE_NAME) [sp_opst (for o.SID1-o.SID2 queue queue_name)/23907]
11/21/07 01:40 Notice: ORA-01092: ORACLE instance terminated. Disconnection forced. [sp_opst(osp)/23884]
11/21/07 01:40 Notice: ORA-01092: ORACLE instance terminated. Disconnection forced. [sp_opst(osp)/23888] -
Cause
Most likely the database was shutdown with abort option.
-
Resolution
The error generally occurs when the database is shutdown with abort option. Some of the other reasons are incorrect permissions on BDUMP, UDUMP and CDUMP directories or missing datafiles. The Shareplex processes will usually relaunch on their own so there should not be any lingering issue. Hence there may not be any action required on the part of the user. The Shareplex processes associated with the error are Capture and Read on source and Post on target.
-
Additional Information
If the processes do continue to run into this error and show no sign of progress, then Support can be contacted for further investigation.