RHEL 7.2 ORA-27300 ORA-27301 Database Crash
发表于:2025-01-22 作者:千家信息网编辑
千家信息网最后更新 2025年01月22日,一、环境描述:操作系统RHEL 7.2数据库ORACLE 12.2.0.1生产系统二、官方文档解决方法APPLIES TO:Oracle Database - Enterprise Edition -
千家信息网最后更新 2025年01月22日RHEL 7.2 ORA-27300 ORA-27301 Database Crash
一、环境描述:
操作系统RHEL 7.2
数据库ORACLE 12.2.0.1
生产系统
二、官方文档解决方法
APPLIES TO:Oracle Database - Enterprise Edition - Version 9.2.0.1 and laterInformation in this document applies to any platform.***Checked for relevance on 29-Jun-2012***SYMPTOMSDatabase instance crashed due to following errors:ORA-27300: OS system dependent operation:semctl failed with status: 22ORA-27301: OS failure message: Invalid argumentORA-27302: failure occurred at: sskgpwrm1ORA-27157: OS post/wait facility removedORA-27300: OS system dependent operation:semop failed with status: 36ORA-27301: OS failure message: Identifier removedORA-27302: failure occurred at: sskgpwwait1CAUSEThe semaphores used by Oracle have been inadvertendly removedThe errors are signalling that something happened at the OS level with shared memory and/or semaphores. The semaphore sets could be removed manually, or they could be dying for some reason due to a hardware error.Either when remounting the /dev/shm or You may want to check for any possibility of a user dba using the "ipcrm" command to kill the semaphores (accidentally) since the error ora-27301 (OS failure message: Identifier removed) suggests that. Also, it could have been a bad memory stick or something else at the OS level. Someone could also have removed the shared memory segments at the OS level for some specific reason, or by accident. Most likely something had removed the shared memory and semaphore sets in use by 'oracle'. This can only be done by a root-level user or 'oracle' itself who owns the resources. If someone logged in as root and removed all IPC resources, Oracle would crash when it lost the allocated shared memory/semaphores.Note: This issue can happen on different platform, but in case you encounter the issue in RHEL7.2, then please also check below RHEL7.2 specific information.In RHEL7.2 operating system setting RemoveIPC=YES crashes the database.The default value for RemoveIPC in RHEL7.2 is YES. Workaround : 1) Set RemoveIPC=no in /etc/systemd/logind.conf if it is not in that file 2) Reboot the server or restart systemd-logind as follows: # systemctl daemon-reload # systemctl restart systemd-logind OR Migrate to Oracle Linux 7.2 resolves the problem.
系统
操作系统
官方
数据
数据库
文档
方法
环境
生产
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
软件开发项目如何聊
阿里云服务器申请解锁
仓储管理系统数据库课程设计心得
山东软件开发免安装
上海现代软件开发注意事项
互联网科技跨国集团公司
哈工大网络安全辛老师
软件开发前景怎么样啊
常用医学数据库管理系统有哪些
在金融部门从事软件开发
网络安全多维动态风险评估
韶关物流配货软件开发
nist物联网网络安全标准
成都软件开发驻场哪家专业
停车场创建数据库
学校维护网络安全情况
调研网络安全信息工作
百度软件开发详细设计文档
mysql数据库技术试卷
国外工控网络安全公司
arma3服务器如何更改兵种
网络安全情况综述
黎明杀机网络连接不上服务器
数据库架构师和大数据架构师
access数据库限制
苏州创业园 软件开发
之讯网络技术有限公司官网
题库软件开发申报材料
软件开发原则和目标
工业交换机服务器 公司