热门标签
热门文章
- 1GPT、Claude、Gemini全系列模型免费白嫖方法_chatgpt镜像
- 2谷粒商城笔记+踩坑（8）——仓库管理_谷粒商城获取spu规格
- 3用于文本去重（相似度计算）的Simhash算法学习及python实现（持续学习中）_simhash算法实例
- 4【leetcode面试经典150题】32.串联所有单词的子串（C++）
- 5【定时同步系列5】Farrow内插器结构原理和MATLAB实现_定时同步内插
- 62024年前端面试真题汇总-3月持续更新中 先收藏慢慢看！（Vue 小程序 css ES6 React 校招大厂真题、高级前端进阶等）_小程序面试题2023
- 7linux mysql dengl_mysql 高性能压力测试
- 8python绘制热力图
- 9探秘Unity ML-StableDiffusion：将AI艺术带入游戏开发的新篇章
- 10各行业都爱用什么编程语言开发？
当前位置: article > 正文
ORA-27301: OS failure message: No buffer space available
作者：2023面试高手 | 2024-04-13 09:57:26
赞
踩
ora-27301
os: centos 7.4
db: oracle 12.2.0.1
规划如下:
testcluster1-scan.peiyongbin.com
192.168.56.141
192.168.56.142
192.168.56.143
node1 node2
vip 192.168.56.131 192.168.56.132
pub(eth0) 192.168.56.121 192.168.56.122
priv(eth1) 192.168.156.121 192.168.156.122
priv(eth2) 192.168.156.131 192.168.156.132
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
问题
通过 sqlplus 连接到 rdbms 实例,提示实例未启动,随后 startup,但是报错
# su - oracle $ echo $ORACLE_SID orcl01 $ ps -fu oracle |sort oracle 12187 1 0 Apr26 ? 00:00:40 ora_pmon_orcl01 oracle 12191 1 0 Apr26 ? 00:01:02 ora_psp0_orcl01 oracle 12207 1 2 Apr26 ? 01:02:04 ora_vktm_orcl01 oracle 12216 1 0 Apr26 ? 00:00:15 ora_gen0_orcl01 oracle 12220 1 0 Apr26 ? 00:00:05 ora_mman_orcl01 oracle 12228 1 0 Apr26 ? 00:03:10 ora_diag_orcl01 oracle 12232 1 0 Apr26 ? 00:00:56 ora_dbrm_orcl01 oracle 12236 1 0 Apr26 ? 00:03:49 ora_vkrm_orcl01 oracle 12240 1 0 Apr26 ? 00:00:30 ora_ping_orcl01 oracle 12244 1 0 Apr26 ? 00:00:04 ora_acms_orcl01 oracle 12248 1 0 Apr26 ? 00:18:50 ora_dia0_orcl01 $ sqlplus / as sysdba; SQL*Plus: Release 12.1.0.2.0 Production on Sun Apr 28 08:40:33 2019 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DG_DATA01/orcl0/spfileorcl0.ora' ORA-17503: ksfdopn:2 Failed to open file +DG_DATA01/orcl0/spfileorcl0.ora ORA-00603: ORACLE server session terminated by fatal error ORA-27504: IPC error creating OSD context ORA-27300: OS system dependent operation:sendmsg failed with status: 105 ORA-27301: OS failure message: No buffer space available ORA-27302: failure occurred at: sskgxpsnd2
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
切换到 grid 查看
# su - grid $ echo $ORACLE_SID +ASM1 $ sqlplus / as sysasm SQL*Plus: Release 12.1.0.2.0 Production on Sun Apr 28 08:45:54 2019 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Real Application Clusters and Automatic Storage Management options SQL> show parameter memory; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ memory_max_target big integer 1076M memory_target big integer 1076M
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
$ crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DG_DATA01.dg ONLINE ONLINE node1 STABLE ONLINE ONLINE node2 STABLE ora.DG_FRA.dg ONLINE ONLINE node1 STABLE ONLINE ONLINE node2 STABLE ora.LISTENER.lsnr ONLINE ONLINE node1 STABLE ONLINE ONLINE node2 STABLE ora.asm ONLINE ONLINE node1 Started,STABLE ONLINE ONLINE node2 Started,STABLE ora.net1.network ONLINE ONLINE node1 STABLE ONLINE ONLINE node2 STABLE ora.ons ONLINE ONLINE node1 STABLE ONLINE ONLINE node2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE node2 STABLE ora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE node1 STABLE ora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE node1 STABLE ora.MGMTLSNR 1 ONLINE ONLINE node1 169.254.123.21 192.1 68.156.131 192.168.1 56.121,STABLE ora.cvu 1 ONLINE ONLINE node1 STABLE ora.mgmtdb 1 ONLINE ONLINE node1 Open,STABLE ora.node1.vip 1 ONLINE ONLINE node1 STABLE ora.node2.vip 1 ONLINE ONLINE node2 STABLE ora.oc4j 1 ONLINE ONLINE node1 STABLE ora.orcl0.db 1 ONLINE ONLINE node1 Open,STABLE 2 ONLINE ONLINE node2 Open,STABLE ora.scan1.vip 1 ONLINE ONLINE node2 STABLE ora.scan2.vip 1 ONLINE ONLINE node1 STABLE ora.scan3.vip 1 ONLINE ONLINE node1 STABLE --------------------------------------------------------------------------------
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
分析
查看 alert_orcl01.log 日志
Sat Apr 27 01:30:08 2019 skgxpvfynet: mtype: 61 process 16114 failed because of a resource problem in the OS. The OS has most likely run out of buffers (rval: 4) Errors in file /u01/app/oracle/diag/rdbms/orcl0/orcl01/trace/orcl01_ora_16115.trc (incident=38427): ORA-00603: ORACLE server session terminated by fatal error ORA-27504: IPC error creating OSD context ORA-27300: OS system dependent operation:sendmsg failed with status: 105 ORA-27301: OS failure message: No buffer space available ORA-27302: failure occurred at: sskgxpsnd2 Sat Apr 27 01:30:08 2019 opiodr aborting process unknown ospid (16115) as a result of ORA-603 Errors in file /u01/app/oracle/diag/rdbms/orcl0/orcl01/trace/orcl01_ora_16114.trc (incident=38428): ORA-00603: ORACLE server session terminated by fatal error ORA-27504: IPC error creating OSD context ORA-27300: OS system dependent operation:sendmsg failed with status: 105 ORA-27301: OS failure message: No buffer space available ORA-27302: failure occurred at: sskgxpsnd2 Sat Apr 27 04:44:41 2019 skgxpvfynet: mtype: 61 process 25588 failed because of a resource problem in the OS. The OS has most likely run out of buffers (rval: 4) Errors in file /u01/app/oracle/diag/rdbms/orcl0/orcl01/trace/orcl01_m000_25588.trc (incident=38429): ORA-00603: ORACLE server session terminated by fatal error ORA-27504: IPC error creating OSD context ORA-27300: OS system dependent operation:sendmsg failed with status: 105 ORA-27301: OS failure message: No buffer space available ORA-27302: failure occurred at: sskgxpsnd2 opidrv aborting process M000 ospid (25588) as a result of ORA-603 Sat Apr 27 06:34:20 2019 skgxpvfynet: mtype: 61 process 5653 failed because of a resource problem in the OS. The OS has most likely run out of buffers (rval: 4) Errors in file /u01/app/oracle/diag/rdbms/orcl0/orcl01/trace/orcl01_m000_5653.trc (incident=38430): ORA-00603: ORACLE server session terminated by fatal error ORA-27504: IPC error creating OSD context ORA-27300: OS system dependent operation:sendmsg failed with status: 105 ORA-27301: OS failure message: No buffer space available ORA-27302: failure occurred at: sskgxpsnd2 opidrv aborting process M000 ospid (5653) as a result of ORA-603 Sat Apr 27 06:34:22 2019 Process m000 died, see its trace file Sat Apr 27 06:34:27 2019 skgxpvfynet: mtype: 61 process 5672 failed because of a resource problem in the OS. The OS has most likely run out of buffers (rval: 4) Errors in file /u01/app/oracle/diag/rdbms/orcl0/orcl01/trace/orcl01_m001_5672.trc (incident=38431): ORA-00603: ORACLE server session terminated by fatal error ORA-27504: IPC error creating OSD context ORA-27300: OS system dependent operation:sendmsg failed with status: 105 ORA-27301: OS failure message: No buffer space available ORA-27302: failure occurred at: sskgxpsnd2 opidrv aborting process M001 ospid (5672) as a result of ORA-603 Process m001 died, see its trace file Sat Apr 27 06:34:56 2019 skgxpvfynet: mtype: 61 process 5780 failed because of a resource problem in the OS. The OS has most likely run out of buffers (rval: 4) Errors in file /u01/app/oracle/diag/rdbms/orcl0/orcl01/trace/orcl01_j001_5780.trc (incident=38432): ORA-00603: ORACLE server session terminated by fatal error ORA-27504: IPC error creating OSD context ORA-27300: OS system dependent operation:sendmsg failed with status: 105 ORA-27301: OS failure message: No buffer space available ORA-27302: failure occurred at: sskgxpsnd2 opidrv aborting process J001 ospid (5780) as a result of ORA-603 Sat Apr 27 06:34:58 2019 Process J001 died, see its trace file Sat Apr 27 06:34:58 2019 kkjcre1p: unable to spawn jobq slave process Sat Apr 27 06:34:58 2019 Errors in file /u01/app/oracle/diag/rdbms/orcl0/orcl01/trace/orcl01_cjq0_12778.trc: Sat Apr 27 16:26:51 2019 Process m000 died, see its trace file Process m000 died, see its trace file Process m000 died, see its trace file Process m000 died, see its trace file Sat Apr 27 16:29:50 2019 kkjcre1p: unable to spawn jobq slave process Sat Apr 27 16:29:50 2019 Errors in file /u01/app/oracle/diag/rdbms/orcl0/orcl01/trace/orcl01_cjq0_12778.trc: Process J000 died, see its trace file Sat Apr 27 16:29:52 2019 kkjcre1p: unable to spawn jobq slave process Sat Apr 27 16:29:52 2019 Errors in file /u01/app/oracle/diag/rdbms/orcl0/orcl01/trace/orcl01_cjq0_12778.trc: Process m000 died, see its trace file Process J000 died, see its trace file
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DG_DATA01/orcl0/spfileorcl0.ora'
ORA-17503: ksfdopn:2 Failed to open file +DG_DATA01/orcl0/spfileorcl0.ora
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:sendmsg failed with status: 105
ORA-27301: OS failure message: No buffer space available
ORA-27302: failure occurred at: sskgxpsnd2
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
查看文档后需要做如下调整:
- 增加 vm.min_free_kbytes 参数，值为物理内存的0.4%。（例如8g内存，vm.min_free_kbytes=810241024*0.004=33554）
- 修改 lo mtu 为 16436 .临时修改 ifconfig lo mtu 16436 或者永久修改 vi /etc/sysconfig/network-scripts/ifcfg-lo 的 MTU=16436
参考:
声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/2023面试高手/article/detail/415756
推荐阅读
相关标签
