{"id":412,"date":"2015-01-05T22:24:16","date_gmt":"2015-01-05T21:24:16","guid":{"rendered":"http:\/\/www.psinke.nl\/blog\/?p=412"},"modified":"2015-01-05T22:24:16","modified_gmt":"2015-01-05T21:24:16","slug":"fix-linux-environment-settings-on-oracle-database-once-and-for-all","status":"publish","type":"post","link":"https:\/\/www.psinke.nl\/blog\/fix-linux-environment-settings-on-oracle-database-once-and-for-all\/","title":{"rendered":"Fix Linux environment settings on Oracle database &#8211; once and for all!"},"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>I&#8217;ve worked in so many environments where the Oracle environment\u00a0 variables are not set correctly.\u00a0 Especially all the preinstalled Virtualbox instances floating on the interwebs.<br \/>\nConsequence is that tools like sqlplus cannot be found from the command line or don&#8217;t work at all. There&#8217;s no need for that, because the solution is really, really easy. There&#8217;s a little script called <span style=\"color: #000080;\"><strong>oracle_env<\/strong><\/span> in the bin directory (usually something like <em>\/u01\/app\/oracle\/product\/11.2.0\/xe\/bin<\/em>) that sets it all right for you.<br \/>\nWhen you add the following line to the .bash_profile in your home directory, all parameters will be set when you log in.<\/p>\n<pre><em>. \/u01\/app\/oracle\/product\/11.2.0\/xe\/bin<\/em>\/oracle_env.sh<\/pre>\n<p>Don&#8217;t forget the dot and space at the beginning of the line.<\/p>\n<p>Although this information is mentioned in the installation guide, I thought it might be worth mentioning.<\/p>\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>I&#8217;ve worked in so many environments where the Oracle environment\u00a0 variables are not set correctly.\u00a0 Especially all the preinstalled Virtualbox instances floating on the interwebs. Consequence is that tools like sqlplus cannot be found from the command line or don&#8217;t work at all. There&#8217;s no need for that, because the solution is really, really easy&#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,121],"tags":[330,237,328,329,102,6,303],"class_list":["post-412","post","type-post","status-publish","format-standard","hentry","category-oracle-blog","category-tips-and-tricks","tag-bash_profile","tag-configuration","tag-database","tag-environment","tag-linux","tag-oracle","tag-xe"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.psinke.nl\/blog\/wp-json\/wp\/v2\/posts\/412","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=412"}],"version-history":[{"count":1,"href":"https:\/\/www.psinke.nl\/blog\/wp-json\/wp\/v2\/posts\/412\/revisions"}],"predecessor-version":[{"id":413,"href":"https:\/\/www.psinke.nl\/blog\/wp-json\/wp\/v2\/posts\/412\/revisions\/413"}],"wp:attachment":[{"href":"https:\/\/www.psinke.nl\/blog\/wp-json\/wp\/v2\/media?parent=412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.psinke.nl\/blog\/wp-json\/wp\/v2\/categories?post=412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.psinke.nl\/blog\/wp-json\/wp\/v2\/tags?post=412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}