{"id":278,"date":"2019-12-02T20:58:01","date_gmt":"2019-12-02T19:58:01","guid":{"rendered":"http:\/\/anjo.pt\/wp\/keyword-oracle\/?p=278"},"modified":"2019-12-02T21:00:58","modified_gmt":"2019-12-02T20:00:58","slug":"install-oracle-locator-in-oracle-19c","status":"publish","type":"post","link":"https:\/\/anjo.pt\/keyword-oracle\/2019\/12\/02\/install-oracle-locator-in-oracle-19c\/","title":{"rendered":"Install Oracle Locator in Oracle 19c"},"content":{"rendered":"\n<p>The documentation lacks a lot concerning this free feature. Only it says that was part of Oracle Multimedia which is now desupported, but Oracle Locator continues to be supported.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2019\/12\/image-1024x91.png\" alt=\"\" class=\"wp-image-279\" width=\"480\" height=\"42\" srcset=\"https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2019\/12\/image-1024x91.png 1024w, https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2019\/12\/image-300x27.png 300w, https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2019\/12\/image-768x68.png 768w, https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2019\/12\/image.png 1054w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><figcaption><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/spatl\/oracle-locator.html#GUID-EC6DEA23-8FD7-4109-A0C1-93C0CE3D6FF2\">https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/spatl\/oracle-locator.html#GUID-EC6DEA23-8FD7-4109-A0C1-93C0CE3D6FF2<\/a><\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2019\/12\/image-1-1024x243.png\" alt=\"\" class=\"wp-image-280\" width=\"485\" height=\"114\" srcset=\"https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2019\/12\/image-1-1024x243.png 1024w, https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2019\/12\/image-1-300x71.png 300w, https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2019\/12\/image-1-768x182.png 768w, https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2019\/12\/image-1.png 1119w\" sizes=\"auto, (max-width: 485px) 100vw, 485px\" \/><figcaption><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/upgrd\/behavior-changes-deprecated-desupport-oracle-database.html#GUID-BABC1C60-EA07-4EBE-8C67-B69B59E4F742\">https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/upgrd\/behavior-changes-deprecated-desupport-oracle-database.html#GUID-BABC1C60-EA07-4EBE-8C67-B69B59E4F742<\/a><\/figcaption><\/figure>\n\n\n\n<p>Well, after some try and error, checking scripts and so on, here is the simple installation of Oracle Locator in Oracle 19c, container architecture:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">-- Connect sys to the Root container (CDB$ROOT) and run:\nSQL&gt; @?\/md\/admin\/catmdloc.sql\n\n-- Then connect to the PDB where you need Oracle Locator and run again:\nSQL&gt; alter session set container=MY_PDB \nSQL&gt; @?\/md\/admin\/catmdloc.sql<\/pre>\n\n\n\n<p>And that&#8217;s it. The script creates the MDSYS user without authentication, it uses the SYSAUX tablespace and creates a directory pointing to  $ORACLE_HOME\/md\/admin  and then tables, including external tables with sharing=object.<\/p>\n\n\n\n<p>So, it is easier than before, no need to first create tablespace or user as it was the case in previous releases.<\/p>\n\n\n\n<p>If you don&#8217;t run the script first on the root container, you&#8217;ll get errors regarding the external tables with sharing=object. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>The documentation lacks a lot concerning this free feature. Only it says that was part of Oracle Multimedia which is now desupported, but Oracle Locator continues to be supported. Well, after some try and error, checking scripts and so on, here is the simple installation of Oracle Locator in Oracle 19c, container architecture: &#8212; Connect [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39,45],"tags":[48,49],"class_list":{"0":"post-278","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-oracle-19c","7":"category-oracle-locator","8":"tag-oracle-19c","9":"tag-oracle-multimedia","10":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/278","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=278"}],"version-history":[{"count":3,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/278\/revisions"}],"predecessor-version":[{"id":284,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/278\/revisions\/284"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=278"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}