ORA-00600: internal error code, arguments: [kokasgi1]

最新推荐文章于 2024-07-31 10:17:32 发布
最新推荐文章于 2024-07-31 10:17:32 发布
阅读量888 收藏 3
点赞数 1
分类专栏： oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/jycjyc/article/details/110368727
版权

模拟修改sys用户，窗口1：

Last login: Tue Nov 24 11:11:10 2020 from 192.168.52.1
[root@saperp ~]# su - oracle
Last login: Tue Nov 24 11:11:13 CST 2020 on pts/4
[oracle@saperp ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 30 09:53:51 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1252663296 bytes
Fixed Size                  2252824 bytes
Variable Size             436211688 bytes
Database Buffers          805306368 bytes
Redo Buffers                8892416 bytes
Database mounted.
Database opened.
SQL> select rowid ,name from user$ where name like 'SYS%';

ROWID              NAME
------------------ ------------------------------
AAAAAKAABAAAADRAAB SYS
AAAAAKAABAAAADTAAA SYSDBA
AAAAAKAABAAAADSAAN SYSMAN
AAAAAKAABAAAADRAAG SYSTEM

SQL> update user$ set name=name||'DW' where name in( 'SYS','SYSTEM');

2 rows updated.

SQL> commit;

Commit complete.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1252663296 bytes
Fixed Size                  2252824 bytes
Variable Size             436211688 bytes
Database Buffers          805306368 bytes
Redo Buffers                8892416 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [kokasgi1], [], [], [], [], [], [],
[], [], [], [], []
Process ID: 2139
Session ID: 85 Serial number: 3


SQL> startup mount
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1252663296 bytes
Fixed Size                  2252824 bytes
Variable Size             436211688 bytes
Database Buffers          805306368 bytes
Redo Buffers                8892416 bytes
Database mounted.

新开窗口2：

[oracle@saperp ~]$ ps -ef|grep LOCAL
oracle     2327   1943  0 09:57 ?        00:00:00 oracleerp (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle     2332   2238  0 09:57 pts/2    00:00:00 grep --color=auto LOCAL
[oracle@saperp ~]$ gdb $ORACLE_HOME/bin/oracle 2327
GNU gdb (GDB) Red Hat Enterprise Linux 7.6.1-115.el7
Copyright (C) 2013 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu".
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>...
Reading symbols from /home/db/oracle/product/11.2.0/db_1/bin/oracle...(no debugging symbols found)...done.
Attaching to program: /home/db/oracle/product/11.2.0/db_1/bin/oracle, process 2327
Reading symbols from /home/db/oracle/product/11.2.0/db_1/lib/libodm11.so...(no debugging symbols found)...done.
Loaded symbols for /home/db/oracle/product/11.2.0/db_1/lib/libodm11.so
Reading symbols from /home/db/oracle/product/11.2.0/db_1/lib/libcell11.so...done.
Loaded symbols for /home/db/oracle/product/11.2.0/db_1/lib/libcell11.so
Reading symbols from /home/db/oracle/product/11.2.0/db_1/lib/libskgxp11.so...(no debugging symbols found)...done.
Loaded symbols for /home/db/oracle/product/11.2.0/db_1/lib/libskgxp11.so
Reading symbols from /lib64/librt.so.1...Reading symbols from /usr/lib/debug/usr/lib64/librt-2.17.so.debug...done.
done.
Loaded symbols for /lib64/librt.so.1
Reading symbols from /home/db/oracle/product/11.2.0/db_1/lib/libnnz11.so...(no debugging symbols found)...done.
Loaded symbols for /home/db/oracle/product/11.2.0/db_1/lib/libnnz11.so
Reading symbols from /home/db/oracle/product/11.2.0/db_1/lib/libclsra11.so...done.
Loaded symbols for /home/db/oracle/product/11.2.0/db_1/lib/libclsra11.so
Reading symbols from /home/db/oracle/product/11.2.0/db_1/lib/libdbcfg11.so...(no debugging symbols found)...done.
Loaded symbols for /home/db/oracle/product/11.2.0/db_1/lib/libdbcfg11.so
Reading symbols from /home/db/oracle/product/11.2.0/db_1/lib/libhasgen11.so...done.
Loaded symbols for /home/db/oracle/product/11.2.0/db_1/lib/libhasgen11.so
Reading symbols from /home/db/oracle/product/11.2.0/db_1/lib/libskgxn2.so...(no debugging symbols found)...done.
Loaded symbols for /home/db/oracle/product/11.2.0/db_1/lib/libskgxn2.so
Reading symbols from /home/db/oracle/product/11.2.0/db_1/lib/libocr11.so...done.
Loaded symbols for /home/db/oracle/product/11.2.0/db_1/lib/libocr11.so
Reading symbols from /home/db/oracle/product/11.2.0/db_1/lib/libocrb11.so...done.
Loaded symbols for /home/db/oracle/product/11.2.0/db_1/lib/libocrb11.so
Reading symbols from /home/db/oracle/product/11.2.0/db_1/lib/libocrutl11.so...done.
Loaded symbols for /home/db/oracle/product/11.2.0/db_1/lib/libocrutl11.so
Reading symbols from /lib64/libaio.so.1...Reading symbols from /lib64/libaio.so.1...(no debugging symbols found)...done.
(no debugging symbols found)...done.
Loaded symbols for /lib64/libaio.so.1
Reading symbols from /lib64/libdl.so.2...Reading symbols from /usr/lib/debug/usr/lib64/libdl-2.17.so.debug...done.
done.
Loaded symbols for /lib64/libdl.so.2
Reading symbols from /lib64/libm.so.6...Reading symbols from /usr/lib/debug/usr/lib64/libm-2.17.so.debug...done.
done.
Loaded symbols for /lib64/libm.so.6
Reading symbols from /lib64/libpthread.so.0...Reading symbols from /usr/lib/debug/usr/lib64/libpthread-2.17.so.debug...done.
done.
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
Loaded symbols for /lib64/libpthread.so.0
Reading symbols from /lib64/libnsl.so.1...Reading symbols from /usr/lib/debug/usr/lib64/libnsl-2.17.so.debug...done.
done.
Loaded symbols for /lib64/libnsl.so.1
Reading symbols from /lib64/libc.so.6...Reading symbols from /usr/lib/debug/usr/lib64/libc-2.17.so.debug...done.
done.
Loaded symbols for /lib64/libc.so.6
Reading symbols from /lib64/ld-linux-x86-64.so.2...Reading symbols from /usr/lib/debug/usr/lib64/ld-2.17.so.debug...done.
done.
Loaded symbols for /lib64/ld-linux-x86-64.so.2
Reading symbols from /usr/lib64/libnuma.so.1...Reading symbols from /usr/lib64/libnuma.so.1...(no debugging symbols found)...done.
(no debugging symbols found)...done.
Loaded symbols for /usr/lib64/libnuma.so.1
Reading symbols from /ogg/19c/libgcc_s.so.1...Missing separate debuginfo for /ogg/19c/libgcc_s.so.1
(no debugging symbols found)...done.
Loaded symbols for /ogg/19c/libgcc_s.so.1
Reading symbols from /lib64/libnss_files.so.2...Reading symbols from /usr/lib/debug/usr/lib64/libnss_files-2.17.so.debug...done.
done.
Loaded symbols for /lib64/libnss_files.so.2
Reading symbols from /home/db/oracle/product/11.2.0/db_1/lib/libnque11.so...(no debugging symbols found)...done.
Loaded symbols for /home/db/oracle/product/11.2.0/db_1/lib/libnque11.so
0x00007ffff57f9700 in __read_nocancel () at ../sysdeps/unix/syscall-template.S:81
81      T_PSEUDO (SYSCALL_SYMBOL, SYSCALL_NAME, SYSCALL_NARGS)
Missing separate debuginfos, use: debuginfo-install libaio-0.3.109-13.el7.x86_64 numactl-libs-2.0.12-3.el7.x86_64
(gdb) b kokiasg
Breakpoint 1 at 0x14af088
(gdb) c
Continuing.

Breakpoint 1, 0x00000000014af088 in kokiasg ()
此时回到窗口1

SQL> alter database open;

--此时系统挂住，其实已经open了。

新开窗口3，执行update恢复:

[oracle@saperp ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 30 09:58:10 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select status from v$instance;

STATUS
------------
OPEN

SQL> select rowid ,name from user$ where name like 'SYS%';

ROWID              NAME
------------------ ------------------------------
AAAAAKAABAAAADTAAA SYSDBA
AAAAAKAABAAAADRAAB SYSDW
AAAAAKAABAAAADSAAN SYSMAN
AAAAAKAABAAAADRAAG SYSTEMDW

SQL> update user$ set name='SYS' where name='SYSDW';

1 row updated.

SQL> update user$ set name='SYSTEM' where name='SYSTEMDW';

1 row updated.

SQL> commit;

Commit complete.
 

回到窗口2,退出gdb

(gdb) quit
A debugging session is active.

        Inferior 1 [process 2327] will be detached.

Quit anyway? (y or n) y
Detaching from program: /home/db/oracle/product/11.2.0/db_1/bin/oracle, process 2327
[oracle@saperp ~]$ 

回到窗口1：open已经完成，正常启停

Database altered.

SQL> select rowid ,name from user$ where name like 'SYS%';

ROWID              NAME
------------------ ------------------------------
AAAAAKAABAAAADRAAB SYS
AAAAAKAABAAAADTAAA SYSDBA
AAAAAKAABAAAADSAAN SYSMAN
AAAAAKAABAAAADRAAG SYSTEM

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1252663296 bytes
Fixed Size                  2252824 bytes
Variable Size             436211688 bytes
Database Buffers          805306368 bytes
Redo Buffers                8892416 bytes
Database mounted.
Database opened.
SQL> 

 

 

参考:https://sqlora.blog.csdn.net/article/details/106721292

 

好记忆不如烂笔头abc
关注
专栏目录
ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch]
perfeader
02-21 2020
问题描述：数据库alert日志报ORA-00600错误，只在数据库收集统计信息的时候报这个错误。从trace文件可以看到就是在收集某一张表统计信息出现问题。在我的数据库环境中，单实例，RAC都出现了这个问题。在MOS提过SR后，Oracle给出了解决办法。12C很多数据库都会遇到该问题，这里记录一下解决过程。   数据库版本：12.2.0.1.0 系统：CentOS Linux releas...
ORA-00600: internal error code, arguments: [4137]/ [4136]
24号信仰
08-01 5700
现象描述： xx系统oracle数据库11.2.0.4 反复重启： 后台日志报错如下： SMON: enabling cache recovery Undo initialization finished serial:0 start:173950654 end:173950754 diff:100 (1 seconds) ...
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr]错误处理
cloud0912的博客
05-01 379
机器断电以后，重新启动报如下错误：[oracle@zhuxg ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Wed May 1 11:28:4...
ORA-00600 internal error code, arguments [25026]
最新发布
u014332621的博客
07-31 790
最近，在一个oracle数据库中出现了ORA-00600: internal error code, arguments: [25026]的报错。报错如下：这是一个特殊的oracle数据库，程序那边为了管理空间方便，设计了不断新增表空间的自动程序。导致几年的时间，表空间已经有6万7个了。我们当前所使用的数据库版本是12.1.0.1.0。Document Display (oracle.com)这个版本的bug比较多，我查了下MSO,发现有如下的文档，即表空间达到65535个，可能会触发这个bug。针对这个问
ORA-00600: internal error code, arguments: [kgl-no-mutex-held]
weixin_34245082的博客
11-27 251
一.环境 windows oracle 11.2.0.4 RAC 二.问题现象 1.连接数据库后，无法查询 2.报错信息：ORA-00600: internal error code, arguments: [600], [ORA-00600: internal error code, arguments: [kgl-no-mutex-held], [0x...
[20190531]ORA-600 kokasgi1故障模拟与恢复.txt
05-31 437
[20190531]ORA-600 kokasgi1故障模拟与恢复.txt --//昨天看链接:http://www.xifenfei.com/2019/05/ora-600-kok...
ORA-00600: internal error code, arguments: [kkdc1prc:BadType]
kevinyu998的博客
04-12 476
可能是表问题，转给产品处理了，让他们手动执行故障sql看看效果，下班后反馈找到问题了，表结构被修改导致，无人认领。
ORA-00600: internal error code, arguments: [4137], [4.10.646], [0], [0]
S1156578253的博客
07-21 420
问题描述： 生产数据库current状态的redo文件丢失，恢复后数据库可以打开，但是alert日志文件里面报ORA-00600错误。 Wed Jul 21 03:19:43 2021 Starting background process CJQ0 Wed Jul 21 03:19:43 2021 CJQ0 started with pid=27, OS id=6443 SMON: Parallel transaction recovery slave got internal error SMON.
ORA-00600: internal error code, arguments [4194]错误
05-25
NULL 博文链接：https://gembler.iteye.com/blog/346242
p8922013_10204_Linux-x86-64.zipORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [17059
08-21
描述中提到的 "ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [17059], [0X93953434]" 是一个Oracle数据库内部错误代码，表示遇到了无法处理的系统级异常。ORA-00600错误通常涉及到数据库的内部一致性问题，这可能是...
记一次报错ORA-00600: internal error code, arguments: [kdsgrp1]，解决索引坏块问题！
zhongxiayeyu的博客
10-28 6412
记一次报错ORA-00600: internal error code, arguments: [kdsgrp1]，解决索引坏块问题！ 【原创】作者：仲夏夜雨 数据库版本：Oracle 10.2.0.5，RAC集群。 同事找我问数据库问题，客户那边网站点击按添加钮显示error如下图。 现象一： Java程序报错ORA-00600: internal error code, arguments:...
ORA-00600: internal error code, arguments: [kcm_headroom_warn_1]
君子不怨天的博客
06-16 2188
一台老物理服务器搬迁，启动操作系统后尝试启动数据库报错。看这个日志我们可以发现日期明显不对，跟当前时间相差八年。查询MOS，因为时间相差过大导致数据库scn号出了问题，数据库无法启动，需要修改操作系统时间。
ORA-00600: internal error code, arguments: [KGL-heap-size-exceeded]
Du.的博客
12-30 3447
ORA-00600: internal error code, arguments: [KGL-heap-size-exceeded]
[20190531]ORA-600 kokasgi1故障模拟与恢复(后续).txt
weixin_34318956的博客
06-01 223
[20190531]ORA-600 kokasgi1故障模拟与恢复(后续).txt--//http://blog.itpub.net/267265/viewspace-2646340/=>[20190531]ORA-600 kokasgi1故障模拟与恢复.txt--//后续有一些恢复没做,补充测试看看.--//先更正链接http://blog.itpub.net/267265/viewspa...
ORA-00600: internal error code, arguments
kevinyu998的博客
10-15 1754
查找MOS文档：ORA-00600: internal error code, arguments: [kcnibrUpdate] report during Managed recovery (MRP) (Doc ID 2798541.1)操作结束后继续rman操作recover database操作正常。通过rman将11g异机升级到19c时，应用归档时报错，报错如下。
ORA-00600: internal error code, arguments: [kcbr_apply_change_11], [], [], [], [], [], [], [], [], [
雨花石
05-21 909
详细参考：https://www.yuhuashi.info/post/96.html 今天群里有个人说DG 不同步，报了如下的报错信息： Tracedumpingisperformingid=[cdmp_20180521121823] Recovereddatafilestoaconsistentstateatchange38169016 Errorsinfi...
ORA-00600: internal error code, arguments: [kdBlkCheckError]
weixin_30580341的博客
06-20 893
ORA-00600: internal error code, arguments: [kdBlkCheckError] Table of Contents 1. 现象 2. 分析 3. 故障处理 1 现象 在数据库宕机前出现ORA-00600错误。 日志内容如下： ORA-01595: error freeing ex...
ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], [], [], [], [], []...
weixin_34417635的博客
11-19 1676
继续上篇的tab$被清空(ORA-600 16703故障解析—tab$表被清空),导致数据库启动异常的caseORA-600 16703报错 数据库日志分析数据库open成功同时报ORA-7445 kokeicbegin和ORA-600 kzrini:!uprofile错误 再次启动数据库直接报ORA-600 16703错误 这里有一个其他现象,就...
ORA-00600: internal error code, arguments: [keltnfy-ldmInit]
D_MIC的专栏
07-18 633
原因是：服务器hostname没有正确配置，通过hostname命令得到的主机名无法ping通，Oracle10g认为主机无法达到所以启动数据库报错。原来昨天有人更改了主机名，检查一下本机的hosts文件，发现因为修改主机名的时候没有把hosts文件对应的主机名做对应的修改，从而引发这个错误。 解决方法： 将hostname添加到/etc/hosts文件中，重新启动数据库。
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值