{"id":3188,"date":"2012-10-10T11:02:28","date_gmt":"2012-10-10T15:02:28","guid":{"rendered":"https:\/\/pitss.org\/us\/2012\/10\/10\/reports-builder-database-connect-issue\/"},"modified":"2017-05-16T08:23:07","modified_gmt":"2017-05-16T12:23:07","slug":"reports-builder-database-connect-issue","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2012\/10\/10\/reports-builder-database-connect-issue\/","title":{"rendered":"Reports Builder Database Connect Issue"},"content":{"rendered":"<p>When using a non-default TNS_ADMIN path for Forms (set by either registry or environment variable), Reports Builder will still read from the default TNS_ADMIN path. This results in an error saying that\u00a0 Reports Builder or Reports server will not be able to open a database connection.<\/p>\n<p>This is because &#8216;%ORACLE_INSTANCE%\\config\\reports\\bin\\reports.bat&#8217; overrides any environment configurations made.<\/p>\n<p>To edit this, open the above file in a text editor, change TNS_ADMIN&#8230;<\/p>\n<p><strong>From:<\/strong><\/p>\n<p>set TNS_ADMIN=%ORACLE_INSTANCE%\\config<\/p>\n<p><strong>To:<\/strong><\/p>\n<p>set TNS_ADMIN=%TNS_ADMIN% (If you&#8217;re using an environment variable to set TNS_ADMIN)<\/p>\n<p>OR<\/p>\n<p>set TNS_ADMIN=location_of_tnsnames<\/p>\n<p><b>Restart WLS_REPORTS for the changes to take effect.<\/b><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When using a non-default TNS_ADMIN path for Forms (set by either registry or environment variable), Reports Builder will still read from the default TNS_ADMIN path. This results in an error saying that\u00a0 Reports Builder or Reports server will not be able to open a database connection. This is because &#8216;%ORACLE_INSTANCE%\\config\\reports\\bin\\reports.bat&#8217; overrides any environment configurations made. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[26,36,14],"tags":[11,16,12,37],"class_list":["post-3188","post","type-post","status-publish","format-standard","hentry","category-development","category-reports","category-resolve-issues","tag-11g","tag-11gr2","tag-error","tag-reports"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/3188","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/comments?post=3188"}],"version-history":[{"count":2,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/3188\/revisions"}],"predecessor-version":[{"id":8526,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/3188\/revisions\/8526"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=3188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=3188"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=3188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}