且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

11.2.0.3 数据库 ORA-00600 [4:kgstmLdiToEpochTs]

更新时间:2022-08-20 21:46:59

报错如下:
Wed Jun 24 23:10:07 2015
Archived Log entry 8345 added for thread 1 sequence 8345 ID 0x2d60d16c dest 1:
Wed Aug 25 05:17:58 1976
Errors in file /home/oracle/product/diag/rdbms/sndbp/sndb/trace/sndb_mmon_33405.trc  (incident=50137):
ORA-00600: internal error code, arguments: [4:kgstmLdiToEpochTs], [1], [], [], [], [], [], [], [], [], [], []
Incident details in: /home/oracle/product/diag/rdbms/sndbp/sndb/incident/incdir_50137/sndb_mmon_33405_i50137.trc
Wed Aug 25 05:17:58 1976
Errors in file /home/oracle/product/diag/rdbms/sndbp/sndb/trace/sndb_mman_4935.trc:
ORA-01513: invalid current time returned by operating system
MMAN (ospid: 4935): terminating the instance due to error 1513
Wed Aug 25 05:17:58 1976
opiodr aborting process unknown ospid (28754) as a result of ORA-1092
Wed Aug 25 05:17:58 1976
opiodr aborting process unknown ospid (23140) as a result of ORA-1092
Wed Aug 25 05:17:58 1976
ORA-1092 : opitsk aborting process
Wed Aug 25 05:17:58 1976
System state dump requested by (instance=1, osid=4935 (MMAN)), summary=[abnormal instance termination].
System State dumped to trace file /home/oracle/product/diag/rdbms/sndbp/sndb/trace/sndb_diag_4929.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Wed Aug 25 05:18:08 1976
Instance terminated by MMAN, pid = 4935
Thu Jun 25 10:14:47 2015

可以看到时间有一个大量的向回改的过程,日志显示为1976年,报错MOS解释如下:

CHANGES

In the scenario where this problem happened there was a power outage and somehow the operating system clock got misconfigured.

CAUSE

The operating system date and time changed.

SOLUTION

Correct the operating system date and time and re-start the instance.

所以向回改时间需要注意,尽量关闭数据库,同时等到当前时间超过原有时间后启动数据库