聯(lián)系：手機/微信(+86 17813235971) QQ(107644445)
標(biāo)題：ORA-600 kokasgi1故障處理(sys被重命名)
作者：惜分飛?版權(quán)所有[未經(jīng)本人同意,不得以任何形式轉(zhuǎn)載,否則有進一步追究法律責(zé)任的權(quán)利.]
接到一個客戶數(shù)據(jù)庫無法啟動的case請求,查看alert日志,發(fā)現(xiàn)錯誤是經(jīng)典的ORA-600 kokasgi1
Fri Oct 17 21:56:48 2025ALTER DATABASE OPENBeginning crash recovery of 1 threads parallel recovery started with 7 processesStarted redo scanCompleted redo scan read 30 KB redo, 24 data blocks need recoveryStarted redo application at Thread 1: logseq 3749, block 2, scn 111907926Recovery of Online Redo Log: Thread 1 Group 2 Seq 3749 Reading mem 0 Mem# 0: /u01/oradata/orcl/redo02.logCompleted redo application of 0.02MBCompleted crash recovery at Thread 1: logseq 3749, block 62, scn 111927984 24 data blocks read, 24 data blocks written, 30 redo k-bytes readThread 1 advanced to log sequence 3750 (thread open)Thread 1 opened at log sequence 3750 Current log# 3 seq# 3750 mem# 0: /u01/oradata/orcl/redo03.logSuccessful open of redo thread 1MTTR advisory is disabled because FAST_START_MTTR_TARGET is not setSMON: enabling cache recovery[2261] Successfully onlined Undo Tablespace 2.Undo initialization finished serial:0 start:4294684900 end:4294684970 diff:70 (0 seconds)Verifying file header compatibility for 11g tablespace encryption..Verifying 11g file header compatibility for tablespace encryption completedSMON: enabling tx recoveryDatabase Characterset is ZHS16GBKErrors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_2261.trc (incident=81755):ORA-00600: internal error code, arguments: [kokasgi1], [], [], [], [], [], [], [], [], [], [], []Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_81755/orcl_ora_2261_i81755.trcUse ADRCI or Support Workbench to package the incident.See Note 411.1 at My Oracle Support for error and packaging details.Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_2261.trc:ORA-00600: internal error code, arguments: [kokasgi1], [], [], [], [], [], [], [], [], [], [], []Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_2261.trc:ORA-00600: internal error code, arguments: [kokasgi1], [], [], [], [], [], [], [], [], [], [], []Error 600 happened during db open, shutting down databaseUSER (ospid: 2261): terminating the instance due to error 600Instance terminated by USER, pid = 2261 |
嘗試啟動數(shù)據(jù)庫確實報該錯誤
SQL> alter database open;alter database open*ERROR at line 1:ORA-01092: ORACLE instance terminated. Disconnection forcedORA-00600: internal error code, arguments: [kokasgi1], [], [], [], [], [], [],[], [], [], [], []Process ID: 164830Session ID: 688 Serial number: 169 |
這類錯誤恢復(fù)比較多:
ORA-600 kokasgi1故障恢復(fù)
win環(huán)境報ora-600 kokasgi1處理
再次遇到ORA-600 kokasgi1故障恢復(fù)
2022年恢復(fù)第一單ORA-600 kokasgi1
等保修改oracle SYS用戶名要求的請注意—ORA-00600 kokasgi1
重命名sys用戶引起數(shù)據(jù)庫啟動報ORA-01092 ORA-00600 kokasgi1錯誤
處理方法比較簡單,就是在數(shù)據(jù)庫啟動的過程中繞過對SYS用戶的檢查,然后把user#=0的用戶update為SYS（在后續(xù)數(shù)據(jù)庫版本中,oracle可能發(fā)現(xiàn)了該問題,直接禁止用戶級別對user$進行update操作update user$報ORA-01031錯誤）,再重啟庫即可
SQL> update user$ set name='SYS' WHERE USER#=0;1 row updated.SQL> commit;Commit complete.SQL> select user#,name from user$ WHERE USER#=0; USER# NAME---------- ------------------------------ 0 SYSSQL> alter system checkpoint;System altered.SQL> shutdown abort;ORACLE instance shut down.[oracle@oracle ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Sat Oct 18 00:36:37 2025Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL> startup mount;ORACLE instance started.Total System Global Area 1286066176 bytesFixed Size 2252904 bytesVariable Size 1157631896 bytesDatabase Buffers 117440512 bytesRedo Buffers 8740864 bytesDatabase mounted.SQL>SQL>SQL> recover database;Media recovery complete.SQL> alter database open;Database altered. |
完美處理ORA-600 kokasgi1故障,實現(xiàn)數(shù)據(jù)0丟失,業(yè)務(wù)快速恢復(fù)
浙公網(wǎng)安備 33010602011771號