11.2.0.3 資料庫 ORA-00600 [4:kgstmLdiToEpochTs]
報錯如下:
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解釋如下:
所以向回改時間需要注意,儘量關閉資料庫,同時等到當前時間超過原有時間後啟動資料庫
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.所以向回改時間需要注意,儘量關閉資料庫,同時等到當前時間超過原有時間後啟動資料庫
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7728585/viewspace-1711623/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle資料庫11.2.0.3升級到11.2.0.4Oracle資料庫
- 資料庫不能startup nomount ora-00600資料庫
- oracle 資料庫從10.2.0.4升級到11.2.0.3Oracle資料庫
- 資料庫版本升級(upgrade 9.2.0.1 to11.2.0.3)資料庫
- 11gR2 手動建立資料庫(11.2.0.3)資料庫
- 資料庫4資料庫
- oracle資料庫升級11.2.0.3升級到11.2.0.4Oracle資料庫
- oracle 11.2.0.3 rac資料庫線上新增ASM儲存空間Oracle資料庫ASM
- 資料庫雜談(4)資料庫
- MySQL資料庫管理4MySql資料庫
- 資料庫啟動遭遇ORA-00600: [keltnfy-ldmInit]資料庫
- 4 管理資料庫例項和叢集資料庫資料庫
- 4 為效能配置資料庫資料庫
- Neo4j資料庫資料庫
- Rails 4資料庫操作大全AI資料庫
- 資料庫不能啟動,有ORA-00600問題: internal error code資料庫Error
- [Mysql] 4.Mysql 建立資料庫MySql資料庫
- db4o物件資料庫物件資料庫
- 4, 手工建立資料庫(筆記)資料庫筆記
- Oracle資料庫同步技術4Oracle資料庫
- 探索Oracle之資料庫升級二 11.2.0.3升級到11.2.0.4完整步驟Oracle資料庫
- 資料庫實現原理#4(Hash Join)資料庫
- oracle學習(4) -資料庫檔案Oracle資料庫
- MYSQL預設有4個資料庫MySql資料庫
- 11.2.0.3 MRP程式異常終止 ORA-00600 krr_assemble_cv_3
- 資料庫週刊18│4月資料庫排行;PG是最好的資料庫;TiDB 4.0新特性資料庫TiDB
- 通過RMAN遷移資料並升級資料庫10.2.0.3->11.2.0.3【相同位數與平臺版】資料庫
- 某省電信行業公司資料庫ORA-00600 [15160]處理行業資料庫
- 遇到用toad 監控資料庫時的ora-00600 [17281] 錯誤資料庫
- ORA-00600: [kpoodp:kpodpfin_30] 資料庫升級 11.2.0.1.0->11.2.0.3.0資料庫
- 探索Oracle之資料庫升級三 回退升級操作(11.2.0.4Downgrade 11.2.0.3)Oracle資料庫
- 11.2.0.3 ASM例項出現ORA-4031導致資料庫歸檔失敗ASM資料庫
- 4 配置Oracle資料庫自動啟動Oracle資料庫
- S/4 HANA 中的資料庫鎖策略資料庫
- 4、MySQL建立資料庫(CREATE DATABASE語句)MySql資料庫Database
- 圖資料庫Neo4j入門資料庫
- 資料庫實驗4:JDBC&ODBC資料庫JDBC
- Neo4j 圖資料庫基礎資料庫