{"id":987,"date":"2013-10-15T11:47:32","date_gmt":"2013-10-15T16:47:32","guid":{"rendered":"http:\/\/osric.com\/chris\/accidental-developer\/?p=987"},"modified":"2013-11-14T12:10:37","modified_gmt":"2013-11-14T17:10:37","slug":"toad-and-oracle-home","status":"publish","type":"post","link":"https:\/\/osric.com\/chris\/accidental-developer\/2013\/10\/toad-and-oracle-home\/","title":{"rendered":"Toad and Oracle Home"},"content":{"rendered":"<p>I recently upgraded work PC. One of the bigger hassles was setting up <a href=\"http:\/\/www.quest.com\/toad\/\">Toad<\/a> and my Oracle connections again.<\/p>\n<p><strong>Steps (and mis-steps) I took:<\/strong><\/p>\n<ul>\n<li>I downloaded an Instant Client from the <a href=\"http:\/\/www.oracle.com\/technetwork\/database\/features\/instant-client\/index-097480.html\">Oracle Instant Client Downloads<\/a><\/li>\n<li>I selected a 32-bit client because I recall that Toad is picky about that, and a 10.2 client. I picked 10.2 primarily because I think that is what I had before, but also because I had downloaded a 64-bit 12.1 client that definitely did not work.<\/li>\n<li>I copied it to my computer: C:\\oracle\\instantclient_10_2. That location is arbitrary&#8211;you should be able to save it anywhere.<\/li>\n<li>I added an ORACLE_HOME environment variable (although this appears to have been unnecessary):<br \/>\n<code>C:\\&gt; SET ORACLE_HOME=C:\\oracle\\instantclient_10_2<\/code><\/li>\n<li>\nI copied my old tnsnames.ora file to the same folder.<\/li>\n<li>Start Toad<\/li>\n<\/ul>\n<p><strong>Error!<\/strong><br \/>\n&#8220;No valid Oracle Client found. Please note that Toad only supports 32 bit Oracle Client installations. Please view the release notes for additional system requirements.&#8221;<\/p>\n<p>When I try to select a client from the installed clients menu, another error:<br \/>\n&#8220;You do not have any Oracle homes installed!&#8221;<\/p>\n<p>I had to add the client to the PATH environment variable. There are a couple ways you can do this:<\/p>\n<ul>\n<li><code>C:\\&gt; PATH=%PATH%;C:\\oracle\\instantclient_10_2<\/code><\/li>\n<li>Go to <em>Control Panel<\/em> &#8212; <em>System<\/em> &#8212; <em>Advanced System Settings<\/em> &#8212; <em>Environment Variables<\/em> &#8212; <em>System Variables<\/em> &#8212; <em>Edit<\/em><\/li>\n<\/ul>\n<p>Toad then started without the error, but also did not recognize my tnsnames.ora file.<\/p>\n<p>First I tried adding the TNS_ADMIN environment variable via the command-line:<br \/>\n<code>C:\\&gt; SET TNS_ADMIN=C:\\oracle\\instantclient_10_2<\/code><\/p>\n<p>For whatever reason, that did not solve the problem. I could echo the value back with echo %TNS_ADMIN%, but it did not appear under Environment Variables in the Control Panel.<\/p>\n<p>I added TNS_ADMIN as a user environment variable in the Control Panel, restarted Toad, and then it recognized my tnsnames.ora file.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Steps to install an Oracle Instant Client, a tnsnames.ora file, and set the appropriate environment variables to connect to an Oracle database with Toad.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[282],"tags":[274,315],"class_list":["post-987","post","type-post","status-publish","format-standard","hentry","category-oracle-2","tag-oracle","tag-toad"],"_links":{"self":[{"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/posts\/987","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/comments?post=987"}],"version-history":[{"count":9,"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/posts\/987\/revisions"}],"predecessor-version":[{"id":1019,"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/posts\/987\/revisions\/1019"}],"wp:attachment":[{"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/media?parent=987"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/categories?post=987"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/tags?post=987"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}