{"id":99,"date":"2012-02-23T11:36:31","date_gmt":"2012-02-23T11:36:31","guid":{"rendered":"http:\/\/tomas.papp.me.uk\/?p=99"},"modified":"2012-02-23T11:40:35","modified_gmt":"2012-02-23T11:40:35","slug":"oracle-a-zamknuta-shared-memory","status":"publish","type":"post","link":"https:\/\/tomas.papp.me.uk\/?p=99","title":{"rendered":"Oracle a zamknuta shared memory"},"content":{"rendered":"<p>Ak by ste nahodou dostavali hlasku ORA-01102: cannot mount database in EXCLUSIVE mode napriek tomu, ze instancia je vypnuta je mozne, ze nieco drzi jej zdielanu pamet, ci uz instancia po pade zabudla po sebe odpratat alebo sa pokusate bezat dve rozne instancie s tym istym DB_NAME treba sa pozriet na toto<\/p>\n<p>a;) alertlog;) ten vam ukaze kde je origin chyby ORA-01102<\/p>\n<p>ALTER DATABASE MOUNT<\/p>\n<p>scumnt: failed to lock \/dba\/oracle\/product\/102\/dbs\/lkORA exclusive<\/p>\n<p>ORA-09968: scumnt: unable to lock file<br \/>\nUNIX Error: 13: Permission denied<\/p>\n<p>b;) pozriet cez PS ci naozaj nebezi ziaden proces zmienenej instancie. Dobre je tiez urobit fuser na lk a sgadef subory aby sme zistili ci ich nejaky proces nedrzi,<\/p>\n<p>c;) skontrolujte ci shared memory segmenty alebo semafory stale existuju (ipcs -b, ipcrm sa da pouzit na ich zmazanie\u00a0 )<\/p>\n<p>d;) ak ziaden proces naozaj nebezi a shared memory segmenty uz neexistuju mozme zmazat subory lk{db_name} a\u00a0 sgadef{sid}.dbf<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>pozn: tieto subory sa pouzivaju na uzamykanie zdielanej pamete, ich zmazanim oracle proces zabudne na vsetky zdielane pametove segmenty<br \/>\n<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ak by ste nahodou dostavali hlasku ORA-01102: cannot mount database in EXCLUSIVE mode napriek tomu, ze instancia je vypnuta je mozne, ze nieco drzi jej zdielanu pamet, ci uz instancia po pade zabudla po sebe odpratat alebo sa pokusate bezat dve rozne instancie s tym istym DB_NAME treba sa pozriet na toto a;) alertlog;) ten [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-99","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/99","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=99"}],"version-history":[{"count":4,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/99\/revisions"}],"predecessor-version":[{"id":104,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/99\/revisions\/104"}],"wp:attachment":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=99"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=99"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=99"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}