问题描述
客户数据库在SHUTDOWN的过程中执行了取消操作,导致了ORA-600错误。
数据库版本为10.2.0.4 RAC for HP-UX,详细错误信息为:
Thu Oct 22 15:05:14 2009 Shutting down instance: further logons disabled Thu Oct 22 15:05:15 2009 Stopping background process QMNC Thu Oct 22 15:05:15 2009 Stopping background process CJQ0 Thu Oct 22 15:05:17 2009 Stopping background process MMNL Thu Oct 22 15:05:18 2009 Stopping background process MMON Thu Oct 22 15:05:19 2009 Shutting down instance (immediate) License high water mark = 8 Thu Oct 22 15:05:19 2009 Stopping Job queue slave processes, flags = 7 Thu Oct 22 15:05:19 2009 Job queue slave processes stopped Thu Oct 22 15:05:20 2009 ALTER DATABASE CLOSE NORMAL Thu Oct 22 15:05:20 2009 SMON: disabling tx recovery SMON: disabling cache recovery Thu Oct 22 15:05:21 2009 LGWR: Waiting FOR ORLs TO be archived... Thu Oct 22 15:05:36 2009 Reconfiguration started (OLD inc 2, NEW inc 4) List OF nodes: 0 1 Global Resource Directory frozen Communication channels reestablished * DOMAIN 0 valid = 1 according TO instance 0 Thu Oct 22 15:05:36 2009 Master broadcasted resource hash VALUE bitmaps Non-LOCAL Process blocks cleaned OUT Thu Oct 22 15:05:36 2009 LMS 0: 0 GCS shadows cancelled, 0 closed Thu Oct 22 15:05:36 2009 LMS 1: 0 GCS shadows cancelled, 0 closed SET master node info Submitted ALL remote-enqueue requests Dwn-cvts replayed, VALBLKs dubious ALL grantable enqueues GRANTED Thu Oct 22 15:05:36 2009 LMS 1: 2008 GCS shadows traversed, 1001 replayed Thu Oct 22 15:05:36 2009 LMS 0: 1988 GCS shadows traversed, 1034 replayed Thu Oct 22 15:05:36 2009 Submitted ALL GCS remote-cache requests Fix WRITE IN gcs resources Reconfiguration complete Thu Oct 22 15:05:51 2009 CLOSE: Error 1013 during DATABASE close Thu Oct 22 15:05:51 2009 SMON: enabling cache recovery SMON: enabling tx recovery Thu Oct 22 15:05:51 2009 ORA-1013 signalled during: ALTER DATABASE CLOSE NORMAL... Thu Oct 22 15:05:51 2009 Errors IN file /u01/app/oracle/admin/orcl3/bdump/orcl32_lns1_4678.trc: ORA-00600: internal error code, arguments: [2658], [4], [2], [], [], [], [], [] Thu Oct 22 15:05:52 2009 Trace dumping IS performing id=[cdmp_20091022150552] Thu Oct 22 15:05:52 2009 Errors IN file /u01/app/oracle/admin/orcl3/bdump/orcl32_lns1_4678.trc: ORA-00600: internal error code, arguments: [2658], [4], [2], [], [], [], [], [] Thu Oct 22 15:05:55 2009 LGWR: ORLs successfully archived Shutting down archive processes Archiving IS disabled Thu Oct 22 15:06:00 2009 ARCH shutting down ARC3: Archival stopped Thu Oct 22 15:06:05 2009 ARCH shutting down ARC2: Archival stopped Thu Oct 22 15:06:10 2009 ARCH shutting down ARC1: Archival stopped Thu Oct 22 15:06:15 2009 ARCH shutting down ARC0: Archival stopped Thu Oct 22 15:06:16 2009 Thread 2 closed at log SEQUENCE 23 Successful close OF redo thread 2复制
专家解答
可以看到,用户在执行了SHUTDOWN IMMEDIATE操作后,执行了CTRL+C取消操作,导致了ORA-1031错误,之后同一时间引发了ORA-600[2658]错误。显然这个错误的产生和用户发出的取消命令直接相关,而且最终这个命令并未生效,数据库成功的被关闭。
在MOS上查询了一下ORA-600[2658]的相关错误,发现多部分错误都出现在7.3和8.1版本上,在9i以后这个错误已经很少见了,从这一点也可以看出,导致这个错误出现的是偶然的因素,那么取消操作显然是导致这个错误的最大可能性。
数据库本身处于关闭过程中,因此这个错误没有影响,可以直接忽略掉。
最后修改时间:2019-04-14 11:05:07
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。
评论
相关阅读
Oracle RAC ASM 磁盘组满了,无法扩容怎么在线处理?
Lucifer三思而后行
939次阅读
2025-03-17 11:33:53
Oracle DataGuard高可用性解决方案详解
孙莹
399次阅读
2025-03-26 23:27:33
墨天轮个人数说知识点合集
JiekeXu
342次阅读
2025-04-01 15:56:03
XTTS跨版本迁移升级方案(11g to 19c RAC for Linux)
zwtian
333次阅读
2025-04-08 09:12:48
Oracle SQL 执行计划分析与优化指南
Digital Observer
303次阅读
2025-04-01 11:08:44
风口浪尖!诚通证券扩容采购Oracle 793万...
Roger的数据库专栏
282次阅读
2025-03-24 09:42:53
Oracle 19c RAC更换IP实战,运维必看!
szrsu
279次阅读
2025-04-08 23:57:08
切换Oracle归档路径后,不能正常删除原归档路径上的归档文件
dbaking
278次阅读
2025-03-19 14:41:51
oracle定时任务常用攻略
virvle
272次阅读
2025-03-25 16:05:19
Oracle NetSuite 客户说|健合(H&H)集团部署 Oracle NetSuite,全面提升全球运营效率
甲骨文中国
254次阅读
2025-03-28 15:00:30
TA的专栏
Java中间件
收录0篇内容
热门文章
一次Connection reset by peer的问题排查
2021-12-07 33777浏览
Java8-Stream: no instance(s) of type variable(s) R exist so that void conforms to R
2021-02-19 32308浏览
nginx: [emerg] "user" directive is not allowed here in /etc/nginx/conf.d/nginx.conf:1
2022-02-15 24213浏览
ORA-00904: "POLTYP": invalid identifier
2019-06-19 12926浏览
PageHelper排坑,处理排序失败: net.sf.jsqlparser.JSQLParserException
2022-05-19 12726浏览