{"id":336,"date":"2013-11-05T10:44:14","date_gmt":"2013-11-05T09:44:14","guid":{"rendered":"http:\/\/www.psinke.nl\/wordpress\/?p=336"},"modified":"2013-11-05T10:47:30","modified_gmt":"2013-11-05T09:47:30","slug":"configuring-ubuntu-12-04-higher-running-oracle-xe","status":"publish","type":"post","link":"https:\/\/www.psinke.nl\/blog\/configuring-ubuntu-12-04-higher-running-oracle-xe\/","title":{"rendered":"Configuring Ubuntu 12.04 and higher for running Oracle XE"},"content":{"rendered":"<div class=\"afa2b3b851443650502c43e85c746c1f\" data-index=\"1\" style=\"float: none; margin:0px;\">\n<script type=\"text\/javascript\"><!--\r\ngoogle_ad_client = \"ca-pub-4223201538046844\";\r\n\/* standaardblok *\/\r\ngoogle_ad_slot = \"9522527129\";\r\ngoogle_ad_width = 320;\r\ngoogle_ad_height = 50;\r\n\/\/-->\r\n<\/script>\r\n<script type=\"text\/javascript\"\r\nsrc=\"http:\/\/pagead2.googlesyndication.com\/pagead\/show_ads.js\">\r\n<\/script>\n<\/div>\n<p>After upgrading my Ubuntu, I found out the database failed to start. I got the following error:<\/p>\n<p>ORA-00845: MEMORY_TARGET not supported<\/p>\n<p>Apparently some symbolic links are modified, causing the configuration to break.<\/p>\n<p>There is a <a title=\"solution for ORA-00845: MEMORY_TARGET not supported\" href=\"https:\/\/forums.oracle.com\/message\/10279381#10279381\" target=\"_blank\">nice thread on the Oracle Support Forums<\/a> explaining how to fix this once and for all. I&#8217;ve pasted the solution here below.<\/p>\n<pre>------------------------------------------------------------------------------------------\r\nAnother solution is to <a href=\"http:\/\/askubuntu.com\/questions\/240412\/how-can-i-modify-the-default-behaviour-of-ubuntu-12-04-12-10-to-prevent-a-sy\" target=\"_blank\">prevent Ubuntu from creating the symbolic link<\/a> from \/dev\/shm to \/run\/shm by default. This is just a matter of editing \/etc\/init\/mounted-dev.conf and commenting out the line that reads:<\/pre>\n<pre># [ -e \/dev\/shm ] || ln -s \/run\/shm \/dev\/shm<\/pre>\n<pre>Then it's just a matter of adding an entry into \/etc\/fstab for the shared memory temporary file system mounted at \/dev\/shm, say for a 2 gigabyte file add:<\/pre>\n<pre>shm \/dev\/shm tmpfs size=2g 0 0<\/pre>\n<pre>NB. The really neat thing about this is that you now don't need the \/etc\/init.d\/oracle-shm fix-up script at all as described in Section 7) of <a href=\"https:\/\/forums.oracle.com\/forums\/thread.jspa?threadID=2301639&amp;start=0&amp;tstart=0\" target=\"_blank\">Oracle 11gR2 Express Edition on Linux Ubuntu 11.10 howto<\/a>. However if you have already created it you can remove it using:<\/pre>\n<pre>update-rc.d -f oracle-shm remove<\/pre>\n<pre>Then either reboot to mount the new file system, or run:<\/pre>\n<pre>rm -f \/dev\/shm\r\nmount \/dev\/shm<\/pre>\n<pre>------------------------------------------------------------------------------------------<\/pre>\n<pre><span style=\"font-family: Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif; font-size: 13px; line-height: 19px;\">I used a 1 gigabyte shared memory temporary file, and it worked fine for me.<\/span><\/pre>\n<!--CusAds0-->\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>After upgrading my Ubuntu, I found out the database failed to start. I got the following error: ORA-00845: MEMORY_TARGET not supported Apparently some symbolic links are modified, causing the configuration to break. There is a nice thread on the Oracle Support Forums explaining how to fix this once and for all. I&#8217;ve pasted the solution&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[304,6,306,305,104,303],"class_list":["post-336","post","type-post","status-publish","format-standard","hentry","category-oracle-blog","tag-memory_target","tag-oracle","tag-support","tag-symbolic-link","tag-ubuntu","tag-xe"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.psinke.nl\/blog\/wp-json\/wp\/v2\/posts\/336","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.psinke.nl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.psinke.nl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.psinke.nl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.psinke.nl\/blog\/wp-json\/wp\/v2\/comments?post=336"}],"version-history":[{"count":0,"href":"https:\/\/www.psinke.nl\/blog\/wp-json\/wp\/v2\/posts\/336\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.psinke.nl\/blog\/wp-json\/wp\/v2\/media?parent=336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.psinke.nl\/blog\/wp-json\/wp\/v2\/categories?post=336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.psinke.nl\/blog\/wp-json\/wp\/v2\/tags?post=336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}