重命名sys使用者引起資料庫啟動報ORA-01092 ORA-00600 kokasgi1錯誤

聯系：手機/微信([phone]) QQ(107644445)

标題：重命名sys使用者引起資料庫啟動報ORA-01092 ORA-00600 kokasgi1錯誤

作者：惜分飛©版權所有[未經本人同意,不得以任何形式轉載,否則有進一步追究法律責任的權利.]

有客戶和我回報,他們為了防止有人使用sys使用者進行登入,對sys使用者進行了重命名,具體操作語句為:

update user $ set name = 'THISISSYS' where user #=0;

然後重新開機資料庫發現資料庫無法正常啟動,報ORA-01092 ORA-00600 kokasgi1錯誤

[[email protected] ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 7 14:40:28 2020 Copyright (c) 1982, 2009, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup mount; ORACLE instance started. Total System Global Area 6881345536 bytes Fixed Size 2214056 bytes Variable Size 4227860312 bytes Database Buffers         2617245696 bytes Redo Buffers               34025472 bytes Database mounted. SQL> alter database open ; alter database open * ERROR at line 1: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00600: internal error code, arguments: [kokasgi1], [], [], [], [], [], [],[], [], [], [], [] Process ID: 6269 Session ID: 530 Serial number: 3

以前寫過處理過類似問題,參見:ORA-600 kokasgi1故障恢複,通過特殊處理,資料庫open之後,對其user#=0的使用者修改為SYS.

[[email protected] ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 7 14:52:09 2020 Copyright (c) 1982, 2009, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup mount; ORACLE instance started. Total System Global Area 6881345536 bytes Fixed Size 2214056 bytes Variable Size 4227860312 bytes Database Buffers         2617245696 bytes Redo Buffers               34025472 bytes Database mounted. SQL> alter database open ; Database altered. SQL> select name from user $ where user #=0; NAME ------------------------------ THISISSYS SQL> update user $ set name = 'SYS' where user #=0; 1 row updated. SQL> commit ; Commit complete. SQL> shutdown abort; ORACLE instance shut down. SQL> startup; ORACLE instance started. Total System Global Area 6881345536 bytes Fixed Size 2214056 bytes Variable Size 4227860312 bytes Database Buffers         2617245696 bytes Redo Buffers               34025472 bytes Database mounted. Database altered.

至此恢複完成,再次sys是oracle内部預設的超級使用者,系統很多調用在程式中寫死的sys.,對其使用者不能進行重命名操作.