问题描述
客户10.2.0.4 RAC环境在启动时出现ORA-7445错误。
错误信息为:
Wed Jun 27 05:10:51 2012 Starting ORACLE instance (normal) Wed Jun 27 05:11:24 2012 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Interface TYPE 1 aggr1 192.168.168.0 configured FROM OCR FOR USE AS a cluster interconnect Interface TYPE 1 bge0 172.25.145.0 configured FROM OCR FOR USE AS a public interface Picked latch-free SCN scheme 3 USING LOG_ARCHIVE_DEST_10 parameter DEFAULT VALUE AS USE_DB_RECOVERY_FILE_DEST Autotune OF undo retention IS turned ON. 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.4.0. System parameters WITH non-DEFAULT VALUES: processes = 1024 sessions = 1131 __shared_pool_size = 11895046144 __large_pool_size = 16777216 __java_pool_size = 16777216 __streams_pool_size = 16777216 spfile = /orcldata/oradata/orcl/spfileorcl.ora filesystemio_options = SetAll sga_target = 33554432000 control_files = /orcldata/oradata/orcl/control01.ctl, /orcldata/oradata/orcl/control02.ctl, /orcldata/oradata/orcl/control03.ctl db_block_size = 8192 __db_cache_size = 21592276992 compatible = 10.2.0.3.0 log_archive_format = %t_%s_%r.dbf db_file_multiblock_read_count= 16 cluster_database = TRUE cluster_database_instances= 2 db_recovery_file_dest = /orcldata/archdata db_recovery_file_dest_size= 209715200000 thread = 1 instance_number = 1 undo_management = AUTO undo_tablespace = UNDOTBS1 remote_login_passwordfile= EXCLUSIVE db_domain = dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB) local_listener = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.25.145.88)(PORT=1521))) remote_listener = LISTENERS_ORCL job_queue_processes = 10 background_dump_dest = /oracle/admin/orcl/bdump user_dump_dest = /oracle/admin/orcl/udump core_dump_dest = /oracle/admin/orcl/cdump audit_file_dest = /oracle/admin/orcl/adump db_name = orcl open_cursors = 300 pga_aggregate_target = 8388608000 Cluster communication IS configured TO USE the following interface(s) FOR this instance 192.168.168.3 Wed Jun 27 05:11:27 2012 cluster interconnect IPC version:Oracle UDP/IP (generic) IPC Vendor 1 proto 2 PMON started WITH pid=2, OS id=12150 DIAG started WITH pid=3, OS id=12152 PSP0 started WITH pid=4, OS id=12154 LMON started WITH pid=5, OS id=12156 LMD0 started WITH pid=6, OS id=12158 LMS0 started WITH pid=7, OS id=12160 LMS1 started WITH pid=8, OS id=12164 LMS2 started WITH pid=9, OS id=12168 LMS3 started WITH pid=10, OS id=12172 LMS4 started WITH pid=11, OS id=12176 LMS5 started WITH pid=12, OS id=12180 LMS6 started WITH pid=13, OS id=12184 LMS7 started WITH pid=14, OS id=12188 MMAN started WITH pid=15, OS id=12192 DBW0 started WITH pid=16, OS id=12194 DBW1 started WITH pid=17, OS id=12196 DBW2 started WITH pid=18, OS id=12198 DBW3 started WITH pid=19, OS id=12200 LGWR started WITH pid=20, OS id=12202 CKPT started WITH pid=21, OS id=12204 SMON started WITH pid=22, OS id=12206 RECO started WITH pid=23, OS id=12208 CJQ0 started WITH pid=24, OS id=12210 MMON started WITH pid=25, OS id=12212 Wed Jun 27 05:11:28 2012 starting up 1 dispatcher(s) FOR network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... MMNL started WITH pid=26, OS id=12214 Wed Jun 27 05:11:28 2012 starting up 1 shared server(s) ... Wed Jun 27 05:11:34 2012 Errors IN file /oracle/admin/orcl/bdump/orcl1_lmon_12156.trc: ORA-07445: exception encountered: core dump [kjfmact()+12] [SIGSEGV] [Address NOT mapped TO object] [0x000000D5C] [] [] USER: terminating instance due TO error 29702 Instance TERMINATED BY USER, pid = 11923复制
专家解答
导致这个ORA-7445错误的原因是由于出现了ORA-29702错误。该现象与MOS文档Bug 11684221 : ORA-29702 AND ORA-304 WHILE STARTING THE INSTANCES描述的非常相似。基本上可以认为是是CLUSTER层面出现了异常导致实例启动报错。
ORA-29702: error occurred IN Cluster GROUP Service operation Cause: An unexpected error occurred while performing a CGS operation. Action: Verify that the LMON process IS still active. Also, CHECK the Oracle LMON trace files FOR errors.复制
而随后的第二次启动并没有发生同样的问题,说明CLUSTER层面的异常只是一次性的,已经被解决。这个错误和CLUSTER的某些不正常的状态有关,不但出现概率很低,而且不会重现,可以安全的忽略掉。
最后修改时间:2019-04-14 10:54:11
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。
评论
相关阅读
Oracle DataGuard高可用性解决方案详解
孙莹
552次阅读
2025-03-26 23:27:33
Oracle RAC 一键安装翻车?手把手教你如何排错!
Lucifer三思而后行
511次阅读
2025-04-15 17:24:06
XTTS跨版本迁移升级方案(11g to 19c RAC for Linux)
zwtian
419次阅读
2025-04-08 09:12:48
墨天轮个人数说知识点合集
JiekeXu
415次阅读
2025-04-01 15:56:03
【纯干货】Oracle 19C RU 19.27 发布,如何快速升级和安装?
Lucifer三思而后行
411次阅读
2025-04-18 14:18:38
Oracle SQL 执行计划分析与优化指南
Digital Observer
411次阅读
2025-04-01 11:08:44
Oracle数据库一键巡检并生成HTML结果,免费脚本速来下载!
陈举超
370次阅读
2025-04-20 10:07:02
Oracle 19c RAC更换IP实战,运维必看!
szrsu
356次阅读
2025-04-08 23:57:08
【活动】分享你的压箱底干货文档,三篇解锁进阶奖励!
墨天轮编辑部
332次阅读
2025-04-17 17:02:24
3月“墨力原创作者计划”获奖名单公布
墨天轮编辑部
322次阅读
2025-04-15 14:48:05
TA的专栏
Java中间件
收录0篇内容
热门文章
一次Connection reset by peer的问题排查
2021-12-07 33924浏览
Java8-Stream: no instance(s) of type variable(s) R exist so that void conforms to R
2021-02-19 32349浏览
nginx: [emerg] "user" directive is not allowed here in /etc/nginx/conf.d/nginx.conf:1
2022-02-15 24257浏览
ORA-00904: "POLTYP": invalid identifier
2019-06-19 12928浏览
PageHelper排坑,处理排序失败: net.sf.jsqlparser.JSQLParserException
2022-05-19 12768浏览