[20220106]ora-00600 kokasgi1.txt
–//上午看了https://www.xifenfei.com/2022/01/2022-first-recovery-ora-600-kokasgi1.html的恢复,我前一阵子也帮别人做了1次恢
–//复。作者通过特殊手段启动数据库,然后修改SYSXX为原来SYS用户。我仔细想想应该类似以前laoxiong的恢复。
–//http://www.laoxiong.net/recover-after-update-global-name.html,自己在测试环境重复看看,千万不能在生产系统做这样操作!!
1.环境:
SCOTT@book> @ver1
PORT_STRING VERSION BANNER
AAAAAKAABAAAADRAAB SYS
AAAAAKAABAAAADUAAL SYSMAN
AAAAAKAABAAAADRAAG SYSTEM
SYS@book> update user$ set name=name||’DW’ where name in( ‘SYS’,’SYSTEM’);
2 rows updated.
SYS@book> commit ;
Commit complete.
SYS@book> shutdown immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@book> startup
ORACLE instance started.
Total System Global Area 643084288 bytes
Fixed Size 2255872 bytes
Variable Size 205521920 bytes
Database Buffers 427819008 bytes
Redo Buffers 7487488 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [kokasgi1], [], [], [], [], [], [], [], [], [], [], []
Process ID: 27563
Session ID: 295 Serial number: 3
–//问题再现。
3.尝试恢复:
–//重启启动到mount状态。
SYS@book> startup mount
ORACLE instance started.
Total System Global Area 643084288 bytes
Fixed Size 2255872 bytes
Variable Size 205521920 bytes
Database Buffers 427819008 bytes
Redo Buffers 7487488 bytes
Database mounted.
$ ps -ef | grep LOCA[L]
oracle 27629 27581 0 17:10 ? 00:00:00 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
–//确定进程号27629
$ rlgdb -f -p 27629
GNU gdb (GDB) Red Hat Enterprise Linux (7.0.1-45.el5)
Copyright (C) 2009 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later
Original: https://www.cnblogs.com/lfree/p/15772063.html
Author: lfree
Title: [20220106]ora-00600 kokasgi1.txt
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/606228/
转载文章受原作者版权保护。转载请注明原作者出处!