热门标签
热门文章
- 1【1】SpringMVC前瞻、回顾MVC
- 2NLP岗实习面试经验分享及示例代码_nlp实习面经
- 3Python基础之MySql数据库交互_python系统设计数据的存储和处理,通过什么与mysql交互。
- 4牛客网--数独_数独是一个我们都非常熟悉的经典游戏,运用计算机我们可以很快地解开数独难题,现在
- 5Mac使用Microsoft Remote Desktop远程控制Win10电脑_remote desktop for mac 端口号
- 6用树莓派获取传感器数据通过Onenet云平台（物模型）传输至微信小程序（上）_onenet 物模型api
- 7SpringBoot+Vue websocket上传文件进度条，带断开连接后处理（心跳）-前端-2_springboot vue3上传文件进度条
- 8Hive常用命令之MSCK REPAIR TABLE命令概述
- 9人工智能预测模型：从基础到先进
- 10Linux AHCI驱动分析之设备初始化_libahci的入口函数
当前位置: 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
推荐阅读
相关标签
