среда, 6 января 2016 г.

(RHEL 7 RemoveIPC=yes) = Database crush

ERROR
======

ORA-27157: OS post/wait facility removed
ORA-27300: OS system dependent operation:semop failed with status: 43
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwwait1

CAUSE
======


If RemoveIPC=yes is configured for systemd, interprocess communication (IPC) is terminated for a non-system user's processes when that user logs out. This setting, which is intended for laptops, can cause software problems on server systems. For example, if the user is a database software owner such as oracle for Oracle Database, this configuration can cause database installation to fail or database services to crash.



source: https://docs.oracle.com/cd/E52668_01/E67200/html/section-t51_kcn_f5.html

SOLUTION
=========

Workaround:

1. Set RemoveIPC=no in /etc/systemd/logind.conf
2. Reboot the server or restart systemd-logind as follows:
# systemctl reboot
OR 
# systemctl daemon-reload
# systemctl restart systemd-logind