问题描述
10.2.0.2 RAC的ASM实例,出现这两个错误并导致实例的崩溃。
错误信息为:
Thu Apr 12 18:55:42 2007 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Interface TYPE 1 lan901 192.168.0.0 configured FROM OCR FOR USE AS a cluster interconnect Interface TYPE 1 lan900 198.5.1.0 configured FROM OCR FOR USE AS a public interface Picked latch-free SCN scheme 3 USING LOG_ARCHIVE_DEST_1 parameter DEFAULT VALUE AS /u01/app/oracle/product/10.2.0/db_1/dbs/arch Autotune OF undo retention IS turned off. LICENSE_MAX_USERS = 0 SYS auditing IS disabled ksdpec: called FOR event 13740 prior TO event GROUP initialization Starting up ORACLE RDBMS Version: 10.2.0.2.0. System parameters WITH non-DEFAULT VALUES: large_pool_size = 12582912 instance_type = asm cluster_database = TRUE instance_number = 2 remote_login_passwordfile= EXCLUSIVE background_dump_dest = /u01/app/oracle/admin/+ASM/bdump user_dump_dest = /u01/app/oracle/admin/+ASM/udump core_dump_dest = /u01/app/oracle/admin/+ASM/cdump asm_diskstring = /hpap/rdsk/* asm_diskgroups = DATE, AEG2_CTL, CTL, DATA, AEG2_DATA Cluster communication is configured to use the following interface(s) for this instance 192.168.0.112 Thu Apr 12 18:55:43 2007 cluster interconnect IPC version:Oracle UDP/IP (generic) IPC Vendor 1 proto 2 PMON started with pid=2, OS id=26298 DIAG started with pid=3, OS id=26300 PSP0 started with pid=4, OS id=26302 LMON started with pid=5, OS id=26304 LMD0 started with pid=6, OS id=26306 LMS0 started with pid=7, OS id=26308 MMAN started with pid=8, OS id=26310 DBW0 started with pid=9, OS id=26313 LGWR started with pid=10, OS id=26316 CKPT started with pid=11, OS id=26321 SMON started with pid=12, OS id=26324 RBAL started with pid=13, OS id=26353 GMON started with pid=14, OS id=26380 Thu Apr 12 18:55:44 2007 Errors in file /u01/app/oracle/admin/+ASM/bdump/+asm2_ckpt_26321.trc: ORA-07445: exception encountered: core dump [$cold_kslgetsl()+1424] [SIGSEGV] [Address not mapped to object] [0x3FFFFFFF812FA310] [] [] Thu Apr 12 18:55:44 2007 lmon registered with NM - instance id 2 (internal mem no 1) Thu Apr 12 18:55:44 2007 Errors in file /u01/app/oracle/admin/+ASM/bdump/+asm2_ckpt_26321.trc: ORA-00081: address range [0x60000000000A7D70, 0x60000000000A7D74) is not readable ORA-07445: exception encountered: core dump [$cold_kslgetsl()+1424] [SIGSEGV] [Address not mapped to object] [0x3FFFFFFF812FA310] [] [] Thu Apr 12 18:55:45 2007 Reconfiguration started (old inc 0, new inc 6) ASM instance List of nodes: 0 1 Global Resource Directory frozen Communication channels reestablished * allocate domain 1, invalid = TRUE * domain 1 valid = 1 according to instance 0 * allocate domain 2, invalid = TRUE * domain 2 valid = 1 according to instance 0 * allocate domain 3, invalid = TRUE * domain 3 valid = 1 according to instance 0 * allocate domain 4, invalid = TRUE * domain 4 valid = 1 according to instance 0 Thu Apr 12 18:55:45 2007 Master broadcasted resource hash value bitmaps Non-local Process blocks cleaned out Thu Apr 12 18:55:45 2007 LMS 0: 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 Apr 12 18:55:45 2007 LMS 0: 0 GCS shadows traversed, 0 replayed Thu Apr 12 18:55:45 2007 Submitted all GCS remote-cache requests Fix write in gcs resources Reconfiguration complete Thu Apr 12 18:55:45 2007 Errors in file /u01/app/oracle/admin/+ASM/udump/+asm2_ora_26212.trc: ORA-00600: internal error code, arguments: [1403], [], [], [], [], [], [], [] Thu Apr 12 18:55:46 2007 USER: terminating instance due to error 81 Instance terminated by USER, pid = 26212复制
专家解答
可以看到,ASM实例刚刚启动,就由于ORA-7445[$cold_kslgetsl]错误和ORA-600[1403]错误以及ORA-81错误导致了实例被中止。
虽然ORA-7445对应的错误在MOS上几乎没有记载,不过ORA-600[1403]错误在10.2.0.2的RAC版本上有明确的bug记载:Bug 5128575 RAC install of 10.2.0.2 does not update libknlopt.a on all nodes。导致问题的原因是由于在按照10.2.0.2时,一个库文件libknlopt.a没有拷贝到远端站点并编译到oracle可执行文件中,导致远端节点出现DUMP的情况,可能出现的错误包括ORA-600[1403]和ORA-81等。
解决该问题的方法是拷贝$ORACLE_HOME/rdbms/lib/libknlopt.a文件到所有远端站点,然后在远端站点重新编辑oracle可执行文件make -f ins_rdbms.mk ioracle。
最后修改时间:2019-04-14 11:04:01
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。
评论
相关阅读
【纯干货】Oracle 19C RU 19.27 发布,如何快速升级和安装?
Lucifer三思而后行
668次阅读
2025-04-18 14:18:38
Oracle RAC 一键安装翻车?手把手教你如何排错!
Lucifer三思而后行
629次阅读
2025-04-15 17:24:06
Oracle数据库一键巡检并生成HTML结果,免费脚本速来下载!
陈举超
538次阅读
2025-04-20 10:07:02
【活动】分享你的压箱底干货文档,三篇解锁进阶奖励!
墨天轮编辑部
485次阅读
2025-04-17 17:02:24
【ORACLE】记录一些ORACLE的merge into语句的BUG
DarkAthena
482次阅读
2025-04-22 00:20:37
一页概览:Oracle GoldenGate
甲骨文云技术
464次阅读
2025-04-30 12:17:56
【ORACLE】你以为的真的是你以为的么?--ORA-38104: Columns referenced in the ON Clause cannot be updated
DarkAthena
452次阅读
2025-04-22 00:13:51
火焰图--分析复杂SQL执行计划的利器
听见风的声音
408次阅读
2025-04-17 09:30:30
3月“墨力原创作者计划”获奖名单公布
墨天轮编辑部
371次阅读
2025-04-15 14:48:05
OR+DBLINK的关联SQL优化思路
布衣
348次阅读
2025-05-05 19:28:36
TA的专栏
Java中间件
收录0篇内容
热门文章
一次Connection reset by peer的问题排查
2021-12-07 34186浏览
Java8-Stream: no instance(s) of type variable(s) R exist so that void conforms to R
2021-02-19 32433浏览
nginx: [emerg] "user" directive is not allowed here in /etc/nginx/conf.d/nginx.conf:1
2022-02-15 24322浏览
ORA-00904: "POLTYP": invalid identifier
2019-06-19 12944浏览
PageHelper排坑,处理排序失败: net.sf.jsqlparser.JSQLParserException
2022-05-19 12837浏览