{"id":3006,"date":"2019-03-31T21:47:33","date_gmt":"2019-03-31T19:47:33","guid":{"rendered":"http:\/\/van-maanen.com\/?p=3006"},"modified":"2019-03-31T21:47:33","modified_gmt":"2019-03-31T19:47:33","slug":"the-oracle_home","status":"publish","type":"post","link":"http:\/\/archief.van-maanen.com\/?p=3006","title":{"rendered":"The ORACLE_HOME"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Oracle needs to have a set of context variables that allow Oracle to know where the programmes are located. Upon installation, you have to check if these variabled are set. If not, you have to set them yourself. In linux, such variables can ne set in the .bash_profile file that is stored as a file in the home directory of the oracle user. This file looks like:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">export ORACLE_HOSTNAME=localhost.domain<br>export ORACLE_UNQNAME=ORCL<br>export ORACLE_BASE=\/orasoft<br>export ORACLE_HOME=\/orasoft<br>export ORACLE_SID=orcl<br>PATH=$PATH:$HOME\/bin<br>export PATH=$ORACLE_HOME\/bin:$PATH <br><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The hostname is a name of the server that can also be stored in the hosts file. This then allows the system to refer to a certain IP number that is connected to the server.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The oracle_sid is the name that is also used when one uses the tnsping command or when someone wants to set up a connection to oracle.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle needs to have a set of context variables that allow Oracle to know where the programmes are located. Upon installation, you have to check if these variabled are set. If not, you have to set them yourself. In linux, such variables can ne set in the .bash_profile file that is stored as a file [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-3006","post","type-post","status-publish","format-standard","hentry","category-nice-to-know"],"_links":{"self":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/3006","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3006"}],"version-history":[{"count":0,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/3006\/revisions"}],"wp:attachment":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3006"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3006"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3006"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}