ora-7445 exception encountered: core dump [ksmpgd_init_ctx()+4] [SIGSEGV] [Address not mapped to obj

 近日对数据库告警日志进行例行巡检经常发现如下报错信息:

操作系统solaris (swap空间的重要性)


Wed Aug 17 09:11:54 CST 2016
Errors in filearsystem_p064_22926.trc:
ORA-07445: exception encountered: core dump [ksmpgd_init_ctx()+4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7FFDC00
0] [] []
Wed Aug 17 09:11:54 CST 2016
Errors in file /p054_22734.trc:
ORA-07445: exception encountered: core dump [ksmpgd_init_ctx()+4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7FFDC00
0] [] []
Wed Aug 17 09:11:54 CST 2016
Errors in file /bdump/arsystem_p084_24753.trc:
ORA-07445: exception encountered: core dump [ksmpgd_init_ctx()+4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7FFDC00
0] [] []
Wed Aug 17 09:11:54 CST 2016
Errors in file /bdump/arsystem_p114_25753.trc:
ORA-07445: exception encountered: core dump [ksmpgd_init_ctx()+4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7FFDC00
0] [] []
Wed Aug 17 09:11:54 CST 2016
Errors in file /bdump/arsystem_p104_25577.trc:
ORA-07445: exception encountered: core dump [ksmpgd_init_ctx()+4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7FFDC00
0] [] []
Wed Aug 17 09:11:54 CST 2016
Errors in file arsystem/bdump/arsystem_p014_21437.trc:
ORA-07445: exception encountered: core dump [ksmpgd_init_ctx()+4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7FFDC00
0] [] []
Wed Aug 17 09:11:54 CST 2016
Errors in file/bdump/arsystem_p130_27934.trc:
ORA-07445: exception encountered: core dump [ksmpgd_init_ctx()+4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7FFDC00
0] [] []
Wed Aug 17 09:11:54 CST 2016
Errors in file /bdump/arsystem_p074_23139.trc:
ORA-07445: exception encountered: core dump [ksmpgd_init_ctx()+4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7FFDC00
0] [] []
Wed Aug 17 09:11:54 CST 2016
Errors in file /bdump/arsystem_p034_22211.trc:
ORA-07445: exception encountered: core dump [ksmpgd_init_ctx()+4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7FFDC00
0] [] []
Wed Aug 17 09:11:54 CST 2016


查看系统日志信息报错如下:

WARNING: Sorry, no swap space to grow stack for pid 22211 (oracle)
Aug 17 09:11:47  genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 27243 (oracle)
Aug 17 09:11:47 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 22609 (oracle)
Aug 17 09:11:47 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 28314 (oracle)
Aug 17 09:11:47 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 21104 (oracle)
Aug 17 09:11:47 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 28322 (oracle)
Aug 17 09:11:47 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 28316 (oracle)
Aug 17 09:11:47 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 28320 (oracle)
Aug 17 09:11:47 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 25200 (oracle)
Aug 17 09:11:47 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 28251 (oracle)


根据报错信息查询到metalink如下:

2016/8/17 文档显示
https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrlstate=
2sb1rwfge_4 1/1
ORA-7445 [ksmpgd_init_ctx()+4] during DataPump Import (文档 ID 1333547.1)
In this Document
Symptoms
Cause
Solution
References
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore
has not been subject to an independent technical review.
APPLIES TO:
Oracle Server - Enterprise Edition - Version: 10.2.0.5.0 and later [Release: 10.2 and later ]
Information in this document applies to any platform.
SYMPTOMS
During a DataPump import the following error is generated in a parallel slave:
ORA-07445: Exception occurred: CORE Dump [ksmpgd_init_ctx()+4] [SIGSEGV] [Address not mapped to object]
[0xFFFFFFFF7FFDA000] [] []
CAUSE
The machine is out of swap space. The system error log file will show messages like:
Jun 9 00:24:54 dodona genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid
15520 (oracle)
Jun 9 00:24:54 dodona genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid
22587 (oracle)
SOLUTION
1. Increase the swap space.
In the Document 169706.1 are the different recommended values for each platform / Oracle version.
REFERENCES
NOTE:169706.1 - Oracle Database on Unix AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64 Unix Operating Systems
Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)

一般都为在并发进程p00x报错。 


增加系统的swap空间问题得到解决。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值