Shulou(Shulou.com)06/01 Report--

An instance of 11204 library on centos7.2 is crash. Check alert and find the following:

Wed Sep 21 00:00:11 2016Errors in file / apps/oracle/diag/rdbms/xberp/xberp/trace/xberp_ckpt_17537.trc:ORA-27157: OS post/wait facility removedORA-27300: OS system dependent operation:semop failed with status: 43ORA-27301: OS failure message: Identifier removedORA-27302: failure occurred at: sskgpwwait1Wed Sep 21 00:00:11 2016Errors in file / apps/oracle/diag/rdbms/xberp/xberp/trace/xberp_dbrm_17523.trc:ORA-27157: OS post/wait facility removedORA-27300 : OS system dependent operation:semop failed with status: 43ORA-27301: OS failure message: Identifier removedORA-27302: failure occurred at: sskgpwwait1Wed Sep 21 00:00:11 2016Errors in file / apps/oracle/diag/rdbms/xberp/xberp/trace/xberp_mman_17527.trc:ORA-27157: OS post/wait facility removedORA-27300: OS system dependent operation:semop failed with status: 43ORA-27301: OS failure message: Identifier removedORA-27302: failure occurred at: sskgpwwait1Wed Sep 21 00:00:11 2016Errors in file / apps/oracle/diag/ Rdbms/xberp/xberp/trace/xberp_j002_14570.trc:ORA-27157: OS post/wait facility removedORA-27300: OS system dependent operation:semop failed with status: 43ORA-27301: OS failure message: Identifier removedORA-27302: failure occurred at: sskgpwwait1CKPT (ospid: 17537): terminating the instance due to error 27157Wed Sep 21 00:00:11 2016Errors in file / apps/oracle/diag/rdbms/xberp/xberp/trace/xberp_j000_14566.trc:ORA-27157: OS post/wait facility removedORA-27300: OS system dependent operation : semop failed with status: 43ORA-27301: OS failure message: Identifier removedORA-27302: failure occurred at: sskgpwwait1Instance terminated by CKPT Pid = 17537Errors in file / apps/oracle/diag/rdbms/xberp/xberp/trace/xberp_ckpt_17537.trc: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: 43ORA-27301: OS failure message: Identifier removedORA-27302: failure occurred at: sskgpwwait1Wed Sep 21 10:20:34 2016

Description:

In centos7.2, systemd-logind Services introduces a new feature: when a user exits os completely, remove loses all IPC objects.

This feature is controlled by the RemoveIPC option in the / etc/systemd/logind.conf parameter file.

In centos7.2, the default value for RemoveIPC is yes

Therefore, when the last oracle or Grid user exits, the operating system will remove the shared memory segments and semaphores of that user

Because Oracle ASM and database use shared memory segments, remove shared memory segments will crash Oracle ASM and database instances.

Oracle Linux7.2 avoids this problem by explicitly setting RemoveIPC to no,Oracle Linux7.2 in the / etc/systemd/logind.conf configuration file

Workaround solution:

1) Set RemoveIPC=no in / etc/systemd/logind.conf

2) Reboot the server or restart systemd-logind as follows:

# systemctl daemon-reload

# systemctl restart systemd-logind

These errors are related to os, and there is documentation on mos that may refer to:

ALERT: Setting RemoveIPC=yes on Redhat 7.2Crashes ASM and Database Instances as Well as Any Application That Uses a Shared Memory Segment (SHM) or Semaphores (SEM) (document ID 2081410.1)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.