{"id":491,"date":"2009-12-18T15:06:44","date_gmt":"2009-12-18T15:06:44","guid":{"rendered":"http:\/\/salientsoft.co.uk\/?p=491"},"modified":"2011-11-17T12:14:20","modified_gmt":"2011-11-17T12:14:20","slug":"toad-fails-to-connect-with-ora-12154-on-windows-7-64-bit","status":"publish","type":"post","link":"https:\/\/salientsoft.co.uk\/?p=491","title":{"rendered":"Toad fails to connect with ORA-12154 on Windows 7 64 bit"},"content":{"rendered":"<p>I hit this problem trying to connect to a local Oracle XE 10.2.0.1 database.<br \/>\nThe problem is due to a bug in Oracle&#8217;s networking layer. It cannot parse program locations containing parentheses, and by default Toad installs to &#8220;Program Files (x86)&#8221; which causes the bug.<\/p>\n<p>More details on<strong><a title=\"http:\/\/forums.oracle.com\/forums\/thread.jspa?messageID=3455198\" href=\"http:\/\/forums.oracle.com\/forums\/thread.jspa?messageID=3455198\"> OTN here<\/a>.<\/strong><\/p>\n<p>The fault is designated <strong>Bug 3807408<\/strong>, and whilst there is an Oracle patch for it,\u00a0the patch is not available for Oracle XE.<\/p>\n<p>The easy way around the problem is just to install TOAD in &#8220;Program Files&#8221; rather than &#8220;Program Files (x86)&#8221;. The different directories are purely to aid in distinguishing 32 bit applications from 64 bit ones &#8211; it does not matter where applications are installed.<\/p>\n<p>I removed and reinstalled TOAD in &#8220;Program Files&#8221; and this completely eliminated the problem. The problem would also apply to other applications which access Oracle, so worth bearing in mind.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I hit this problem trying to connect to a local Oracle XE 10.2.0.1 database. The problem is due to a bug in Oracle&#8217;s networking layer. It cannot parse program locations containing parentheses, and by default Toad installs to &#8220;Program Files (x86)&#8221; which causes the bug. More details on OTN here. The fault is designated Bug [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[63],"tags":[13,29,61,60],"_links":{"self":[{"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/491"}],"collection":[{"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=491"}],"version-history":[{"count":6,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/491\/revisions"}],"predecessor-version":[{"id":495,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/491\/revisions\/495"}],"wp:attachment":[{"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=491"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=491"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}