{"id":379,"date":"2020-07-16T15:27:14","date_gmt":"2020-07-16T13:27:14","guid":{"rendered":"https:\/\/anjo.pt\/keyword-oracle\/?p=379"},"modified":"2020-07-16T15:27:17","modified_gmt":"2020-07-16T13:27:17","slug":"oracle-11-1-on-windows-ora-02778","status":"publish","type":"post","link":"https:\/\/anjo.pt\/keyword-oracle\/2020\/07\/16\/oracle-11-1-on-windows-ora-02778\/","title":{"rendered":"Oracle 11.1 on Windows &#8211; ORA-02778"},"content":{"rendered":"\n<p>I&#8217;ve a funny challenge these days:<\/p>\n\n\n\n<p>Recover a Oracle 11.1.0.6 on Windows installation. I&#8217;ve all files in an external drive and I&#8217;m trying to make the DB to run on my laptop.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>I&#8217;ve copied to my local disk;<\/li><li>Added the entries to the registry that found necessary<\/li><li>Re-created the Inventory<\/li><li>Re-created a init file with correct locations from the spfile<\/li><\/ul>\n\n\n\n<p>Now I had still had the error:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSQL&gt; startup nomount\nORA-02778: Name given for the log directory is invalid\n<\/pre><\/div>\n\n\n<p>Nothing on the logs, all directories mentioned on pfile exist and are writable. <\/p>\n\n\n\n<p>I&#8217;ve downloaded the <a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/sysinternals\/downloads\/procmon\" target=\"_blank\">Microsoft ProcessMonitor<\/a>, configured to trace only Oracle company processes and looked what it tried to read.<\/p>\n\n\n\n<p>Finally I found the culprit: %ORACLE_HOME%\\RDBMS\\<strong>log<\/strong> was missing. Just the log subfolder.<\/p>\n\n\n\n<p>This was during the xcopy to the local disk, I excluded all &#8220;log&#8221; files, as there were some huge ones. Unfortunately it also excluded this folder. Now looks better:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; startup nomount\nORACLE instance started.\n\nTotal System Global Area 1720328192 bytes\nFixed Size                  2130160 bytes\nVariable Size             989859600 bytes\nDatabase Buffers          721420288 bytes\nRedo Buffers                6918144 bytes\nSQL&gt;\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve a funny challenge these days: Recover a Oracle 11.1.0.6 on Windows installation. I&#8217;ve all files in an external drive and I&#8217;m trying to make the DB to run on my laptop. I&#8217;ve copied to my local disk; Added the entries to the registry that found necessary Re-created the Inventory Re-created a init file with [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,60],"tags":[],"class_list":{"0":"post-379","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-oracle-11g","7":"category-windows","8":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/379","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=379"}],"version-history":[{"count":1,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/379\/revisions"}],"predecessor-version":[{"id":380,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/379\/revisions\/380"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}