{"id":206,"date":"2020-05-29T14:22:28","date_gmt":"2020-05-29T12:22:28","guid":{"rendered":"http:\/\/oracledba.fr\/?p=206"},"modified":"2020-05-29T14:46:30","modified_gmt":"2020-05-29T12:46:30","slug":"ora-00600-kslges_3-ora-27300","status":"publish","type":"post","link":"https:\/\/oracledba.fr\/?p=206","title":{"rendered":"ORA-00600 [KSLGES_3]\/ORA-27300"},"content":{"rendered":"\n<p>When using RHEL 7.2 you may encounter some database crash with the errors below:<\/p>\n\n\n\n<p>ORA-27157: OS post\/wait facility removed<br>ORA-27300: OS system dependent operation:semop failed with status: 43<br>ORA-27301: OS failure message: Identifier removed<br>ORA-27302: failure occurred at: sskgpwwait1<br>ORA-00600: internal error code, arguments: [KSLGES_3], [], [], [], [], [], [], [], [], [], [], []<br>ORA-27300: OS system dependent operation:semop failed with status: 43<br>ORA-27301: OS failure message: Identifier removed<\/p>\n\n\n\n<p>Redhat 7.2, systemd-logind service introduced a new feature to remove all IPC objects when a user fully logs out.<br>The feature is controled by the option RemoveIPC in the \/etc\/systemd\/logind.conf configuration file, see man logind.conf(5) for details.<\/p>\n\n\n\n<p>The default value for RemoveIPC in RHEL7.2 is yes.<\/p>\n\n\n\n<p>As a result, the OS may removes shared memory segments and semaphores for those users.<br>As Oracle ASM and Databases use shared memory segments for SGA, removing shared memory segments will crash the Oracle ASM and database instances.<\/p>\n\n\n\n<p>A new systemd feature was introduced in Red Hat Enterprise Linux 7.2: cleanup of all allocated inter-process communication (IPC) resources with the last session a user finishes. A session can be an administrative cron job or an interactive session. <\/p>\n\n\n\n<p>This behavior can cause daemons running under the same user, and using the same resources, to terminate unexpectedly.<\/p>\n\n\n\n<p>To work around this problem, edit the file \/etc\/systemd\/logind.conf and add the following line:<br>RemoveIPC=no<br><\/p>\n\n\n\n<p>Then, execute the following command, so that the change is put into effect:<br>systemctl restart systemd-logind.service<br>After performing these steps, daemons no longer crash in the described situation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When using RHEL 7.2 you may encounter some database crash with the errors below: 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: sskgpwwait1ORA-00600: internal error code, arguments: [KSLGES_3], [], [], [], [], [], [], [], [], [], [], []ORA-27300: OS system dependent &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/oracledba.fr\/?p=206\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;ORA-00600 [KSLGES_3]\/ORA-27300&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[72,73,74,75],"class_list":["post-206","post","type-post","status-publish","format-standard","hentry","category-errors","tag-ora-00600","tag-ora-27300","tag-ora-27301","tag-ora-27302"],"_links":{"self":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts\/206","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=206"}],"version-history":[{"count":1,"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts\/206\/revisions"}],"predecessor-version":[{"id":207,"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts\/206\/revisions\/207"}],"wp:attachment":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=206"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=206"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=206"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}