Oracle ASM Instances and Oracle database instances are crash on RHEL7.2 that "translated from MoS article" set Removeipc=yes

Source: Internet
Author: User



Removeipc=yes RHEL7.2 will crash the Oracle ASM instance and Oracle database instance, and the problem will also be in the use of the shared Memory Segment (SHM) or semaphores (SEM) Occurs in the application.
From:
Alert:setting Removeipc=yes on Redhat 7.2 crashes ASM and Database Instances as well as any application that Uses a Share D Memory Segment (SHM) or semaphores (SEM) (document ID 2081410.1)



Suitable for:
Oracle Database-standard Edition
Oracle database-enterprise Edition
Linux x86-64
Linux x86




Describe:
In RHEL7.2, the Systemd-logind service introduces a new feature that removes all IPC objects after a user exits the OS completely.
This attribute is controlled by the REMOVEIPC option in the/etc/systemd/logind.conf parameter file. See More Man logind.conf (5)



In RHEL7.2, the default value for REMOVEIPC is yes



Therefore, when the last Oracle or grid user exits, the operating system will remove the user's shared memory segments and semaphores



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



Please refer to Redhat bug 1264533-https://bugzilla.redhat.com/show_bug.cgi?id=1264533






Occurrence (not knowing what to translate into more appropriate)
This issue affects all applications that use the shared memory segments and semaphores, so both Oracle ASM instances and Oracle Database instances are affected.



Oracle Linux 7.2 Avoids this problem by explicitly setting REMOVEIPC as No,oracle Linux7.2 in the/etc/systemd/logind.conf configuration file.
But if the/etc/systemd/logind.conf file was modified before OS upgrade, then Yum/update would write a correct configuration file (Removeipc=no), The profile name is Logind.conf.rpmnew, and the failures described in this article will occur if the user uses the original configuration file.
To avoid this problem, be sure to edit the logind.conf file and set the Removeipc=no after the OS upgrade. This is documented in the Oracle Linux 7.2 Release Notes.






Symptoms:


1) Installing 11.2 and 12c GI/CRS fails, because ASM crashes towards the end of the installation.
2) Upgrading to 11.2 and 12c GI/CRS fails.
3) After Redhat Linux is upgraded to 7.2, 11.2 and 12c ASM and database instances crash.


Systemd-logind Remove the IPC objects may occur at any time, the performance of the failure can be very different, the following is a few examples of failure


Most common error that occurs is that the following is found in the asm or database alert.log:
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

The second observed error occurs during installation and upgrade when asmca fails with the following error:
KFOD-00313: No ASM instances available. CSS group services were successfully initilized by kgxgncin
KFOD-00105: Could not open pfile '[email protected]'

The third observed error occurred during installation and upgrade:
Creation of ASM password file failed. Following error occurred: Error in Process: /u01/app/12.1.0/grid/bin/orapwd

 Enter password for SYS:

OPW-00009: Could not establish connection to Automatic Storage Management instance

2015/11/20 21:38:45 CLSRSC-184: Configuration of ASM failed
2015/11/20 21:38:46 CLSRSC-258: Failed to configure and start ASM

The fourth observed error is the following message is found in the /var/log/messages file around the time that asm or database instance crashed:
Nov 20 21:38:43 testc201 kernel: traps: oracle[24861] trap divide error
ip:3896db8 sp:7ffef1de3c40 error:0 in oracle[400000+ef57000] 


Workaround:
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




Patch:
Migrating from RHEL7.2 to Oracle Linux7.2 can solve this problem.
If migrating to Oracle Linux7.2 is not possible, please use the workaround above






History:
This article was created on November 23, 2015.



Oracle ASM Instances and Oracle database instances are crash on RHEL7.2 that "translated from MoS article" set Removeipc=yes


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.