-
Title
A Shareplex process errors out due to ORA-01092 -
Description
The following messages are observed in the event log with consequent termination of Shareplex process(es):
01/26/07 21:10 Process exited sp_ordr (for o.SID) [pid = 2883672] - exit(1)
01/26/07 21:10 Process launched: sp_ordr (for o.SID) [pid = 2883674]
01/31/07 22:52 Notice: ORA-01092: ORACLE instance terminated. Disconnection forced. [sp_ocap(osp)/1343508]
01/31/07 22:52 Error: Unexpected Oracle error: ORA-01092: ORACLE instance terminated. Disconnection forced. in olog.c:3235 [sp_ocap(osp)/1343508] -
Cause
Issues with database during its start.
-
Resolution
In general the ORA-01092 is observed when there are issues during database start. The Oracle alert log file need to be examined and the underlying error conditions addressed before the database can be restarted. Otherwise the error messages will keep appearing in Shareplex event log as well. Once the database issues are addressed, then Shareplex processes will be able to make connections with Oracle and the messages will not appear anymore. On a side note, it is a good practice to shutdown Shareplex prior to database shutdown and restart it only after the database has been successfully restarted.
-
Additional Information
The error ORA-01092 can be caused by a previous shutdown abort, permission issues with bdump, cdump or udump directories, missing datafiles, etc. Here is the description of the Oracle error:
ORA-01092:ORACLE instance terminated. Disconnection forced
Cause:The instance connected to was terminated abnormally, probably due to a SHUTDOWN ABORT. The current process was forced to disconnect from the instance.
Action:Examine the alert log for more details. Contact the database administrator to determine when the instance is restarted. Attempt to reconnect after the instance is running again.