{"id":647,"date":"2012-02-12T13:11:45","date_gmt":"2012-02-12T12:11:45","guid":{"rendered":"https:\/\/oracle-in-zen.de\/?p=647"},"modified":"2018-06-01T16:47:45","modified_gmt":"2018-06-01T15:47:45","slug":"ora-600-librarycachenotemptyonclose-bei-db-shutdown","status":"publish","type":"post","link":"https:\/\/oracle-in-zen.de\/?p=647","title":{"rendered":"ORA-600 [Librarycachenotemptyonclose] bei DB shutdown"},"content":{"rendered":"<p>Ein ORA-600 im alert.log versetzt einen DBA schon mal in eine &#8222;freudige&#8220; Stimmung. Doch bei einem ORA-600 [Librarycachenotemptyonclose] k\u00f6nnte man es relativ entspannt angehen lassen.<\/p>\n<p><!--more--><\/p>\n<p>Wann erscheint der Error:<\/p>\n<pre>sqlplus&gt; shutdown immediate\r\nDatabase closed.\r\nDatabase dismounted.\r\nORA-00600:internal error code, arguments: [LibraryCacheNotEmptyOnClose]<\/pre>\n<p>Auszug alert.log:<\/p>\n<pre>Errors in file D:\\oracle\\admin\\prod\\udump\\prod_ora_3688.trc:\r\nORA-00600:internal error code, arguments: [LibraryCacheNotEmptyOnClose]<\/pre>\n<p>Auszug aus trace Datei:<\/p>\n<pre>kglshu kqlnfy kscnfy ksmshu\r\nopistp_real opistp opiodr ttcpip opitsk opiino opiodr opidrv\r\nsou2o opimai_real main libc_start_main<\/pre>\n<p>&nbsp;<\/p>\n<p>Oracle beschreibt das Verhalten in\u00a0Bug 4483084 und 7572335.<\/p>\n<p>Bei\u00a0Bug 4483084 wird ein ORA-600 gemeldet, wenn nach &#8218;database close&#8216; noch Objekte im Library Cache verbleiben. Hier gilt, Zitat &#8222;The error can be safely ignored as it does not indicate a problem with the database.&#8220; Oracle Note ID\u00a0365103.1<\/p>\n<p>Bug 7572335 kann getroffen werden, wenn beim Herunterfahren noch &#8218;child cursors&#8216; als &#8218;kept&#8216; im Library Cache markiert sind. Dieser Bug ist gefixt in\u00a011.2 und 10.2.0.5. Auch gibt es one-off Fixes f\u00fcr\u00a010.2.0.4 und 11.1.0.7<\/p>\n<p>Sollte nicht sicher sein, welcher Bug auftritt, empfiehlt Oracle den Support zu verst\u00e4ndigen und die Logs bewerten zu lassen.<br \/>\n&nbsp;<\/p>\n<p>Oracle Notes im Artikel<br \/>\nID\u00a0365103.1<br \/>\nBug 4483084<br \/>\nBug 7572335<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ein ORA-600 im alert.log versetzt einen DBA schon mal in eine &#8222;freudige&#8220; Stimmung. Doch bei einem ORA-600 [Librarycachenotemptyonclose] k\u00f6nnte man es relativ entspannt angehen lassen.<\/p>\n","protected":false},"author":1,"featured_media":665,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"zakra_page_container_layout":"customizer","zakra_page_sidebar_layout":"customizer","zakra_remove_content_margin":false,"zakra_sidebar":"customizer","zakra_transparent_header":"customizer","zakra_logo":0,"zakra_main_header_style":"default","zakra_menu_item_color":"","zakra_menu_item_hover_color":"","zakra_menu_item_active_color":"","zakra_menu_active_style":"","zakra_page_header":true,"footnotes":""},"categories":[11,36],"tags":[19,32,13,37],"class_list":["post-647","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-2","category-ora","tag-10g","tag-alert","tag-database","tag-ora-2"],"_links":{"self":[{"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/posts\/647","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=647"}],"version-history":[{"count":28,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/posts\/647\/revisions"}],"predecessor-version":[{"id":650,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/posts\/647\/revisions\/650"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/media\/665"}],"wp:attachment":[{"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=647"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=647"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=647"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}