{"id":4931,"date":"2014-02-26T10:33:24","date_gmt":"2014-02-26T15:33:24","guid":{"rendered":"https:\/\/pitss.org\/us\/?p=4931"},"modified":"2017-09-05T15:22:29","modified_gmt":"2017-09-05T19:22:29","slug":"tnsnames-ora-location-mapping","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2014\/02\/26\/tnsnames-ora-location-mapping\/","title":{"rendered":"How to Map tnsnames.ora to a Different Location for Forms and Reports"},"content":{"rendered":"

[et_pb_section fb_built=”1″ custom_padding=”0px||50px|” admin_label=”section” _builder_version=”3.0.51″][et_pb_row custom_padding=”0px|||” _builder_version=”3.0.51″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″ _builder_version=”3.0.47″ parallax=”off” parallax_method=”on”][et_pb_text _builder_version=”3.0.64″ custom_margin=”||30px|”]<\/p>\n

How to Map tnsnames.ora to a Different Location for Forms and Reports<\/h1>\n

By default in every Oracle Forms and Reports 11g (and 11gR2) deployment, the application(s) look for the TNS connection details inside the tnsnames.ora location in %ORACLE_INSTANCE%\\config ($ORACLE_INSTANCE\/config in Unix). An example location could be C:\\Oracle\\Middleware\\asinst_1\\config.<\/p>\n

If you need to deploy to a seperate tnsnames.ora location such as a network drive or in the same location as your Oracle database (only if one is installed in the same environment as WebLogic), you will need to follow these steps to configure this deployment.<\/p>\n

[\/et_pb_text][et_pb_divider color=”#e2e2e2″ show_divider=”on” divider_position=”center” _builder_version=”3.0.51″ custom_css_main_element=”margin-bottom:30px !important;”][\/et_pb_divider][et_pb_text _builder_version=”3.0.51″ custom_margin=”||30px|”]<\/p>\n

What you’ll learn in this article:<\/strong><\/h3>\n

\u2713<\/strong> How to map tnsnames.ora to a different location for Oracle Forms and Reports
\u2713<\/strong> Instructions for both Windows and Unix<\/span><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding=”40px|40px|30px|40px” background_color=”#006bb3″ background_position_1=”top_left” background_repeat_1=”no-repeat” _builder_version=”3.0.51″][et_pb_column type=”4_4″ _builder_version=”3.0.47″ parallax=”off” parallax_method=”on” background_position=”top_left” background_repeat=”no-repeat”][et_pb_text background_layout=”dark” _builder_version=”3.0.64″ background_color=”#006bb3″]<\/p>\n

Fill out this form to get immediate access to the article.
\n<\/strong><\/h2>\n

[\/et_pb_text][et_pb_code module_class=”white-text” _builder_version=”3.0.67″][ninja_form id=23][\/et_pb_code][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

How to Map tnsnames.ora to a Different Location for Forms and Reports By default in every Oracle Forms and Reports 11g (and 11gR2) deployment, the application(s) look for the TNS connection details inside the tnsnames.ora location in %ORACLE_INSTANCE%\\config ($ORACLE_INSTANCE\/config in Unix). An example location could be C:\\Oracle\\Middleware\\asinst_1\\config. If you need to deploy to a seperate […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"By default in every Oracle Forms and Reports 11g (and 11gR2) deployment, the application(s) look for the TNS connection details inside the tnsnames.ora location <\/span><\/span>in %ORACLE_INSTANCE%\\config ($ORACLE_INSTANCE\/config in Unix). An example location could be C:\\Oracle\\Middleware\\asinst_1\\config.\r\n\r\nIf you need to deploy to a seperate tnsnames.ora location such as a network drive or in the same location as your Oracle database (only if one is installed in the same environment as WebLogic), you will need to follow these steps to configure this deployment:\r\n\r\nSystem Environment Variables<\/u><\/strong>\r\n\r\nFor Windows:<\/strong>\r\n

    \r\n \t
  1. Go to your Computer Properties (Right-click on Computer and select Properties)<\/li>\r\n \t
  2. Select \u201cAdvanced system settings\u201d<\/li>\r\n \t
  3. Select \u201cEnvironment Variables\u2026\u201d<\/li>\r\n \t
  4. If not set already, create a new System Environment variable called TNS_ADMIN. For the value, please specify the directory you wish to deploy tnsnames.ora. NOTE: If the directory is in a network drive, please map the network drive to a disk drive such as S:\\ for example.<\/li>\r\n \t
  5. Click OK three times to save the changes.<\/li>\r\n<\/ol>\r\nFor Linux\/Unix:<\/strong>\r\n
      \r\n \t
    1. Go to $HOME and open up .bash_profile in a text editor<\/li>\r\n \t
    2. If not present already, create a new environment variable called TNS_ADMIN. For the value, please specify the directory you wish to deploy tnsnames.ora. NOTE: Make sure you export this environment variable.<\/li>\r\n \t
    3. Save and close the file.<\/li>\r\n \t
    4. To start using the new variable, close your terminal (SSH) window and start a new terminal window.<\/li>\r\n<\/ol>\r\nForms<\/u><\/strong>\r\n
        \r\n \t
      1. Navigate to %DOMAIN_HOME%\\config\\fmwconfig\\servers\\WLS_FORMS\\applications\\formsapp_11.1.2\\config ($DOMAIN_HOME\/config\/fmwconfig\/servers\/WLS_FORMS\/applications\/formsapp_11.1.2\/config in Unix) and open up any environment files (.env) you are using for your application.<\/li>\r\n \t
      2. Look for the environment variable TNS_ADMIN. For the value, please specify the directory you wish to deploy tnsnames.ora.<\/li>\r\n \t
      3. Save and close the file.<\/li>\r\n<\/ol>\r\nNOTE: You do NOT need to restart the WLS_FORMS WebLogic server.\r\n\r\nReports<\/u><\/strong>\r\n\r\nIMPORTANT: Before running steps 5-7, make sure nobody is logged into the Forms and Reports application(s).\r\n
          \r\n \t
        1. Navigate to %ORACLE_INSTANCE%\\config\\OPMN\\opmn ($ORACLE_INSTANCE\/config\/OPMN\/opmn in Unix) and open up opmn.xml (NOTE: Please make a backup first.)<\/li>\r\n \t
        2. Look for the environment variable TNS_ADMIN. For the value, please specify the directory you wish to deploy tnsnames.ora.<\/li>\r\n \t
        3. Save and close the file.<\/li>\r\n \t
        4. Open up Command Prompt and navigate to %ORACLE_INSTANCE%\\bin ($ORACLE_INSTANCE\/bin in Unix).<\/li>\r\n \t
        5. Reload OPMN: opmnctl reload<\/li>\r\n \t
        6. Stop OPMN: opmnctl stopall<\/li>\r\n \t
        7. Start OPMN: opmnctl startall<\/li>\r\n<\/ol>\r\nTo test, remove (but do not delete) the tnsnames.ora from %ORACLE_INSTANCE%\\config ($ORACLE_INSTANCE\/config). Try running a form and report from your application(s) to make sure that you do not get any TNS errors. If your application runs successfully, the above configurations have been applied successfully.","_et_gb_content_width":"","footnotes":""},"categories":[22,4,36,19,10],"tags":[11,16,41,23,54,37],"class_list":["post-4931","post","type-post","status-publish","format-standard","hentry","category-forms","category-install-config","category-reports","category-unix-linux","category-windows","tag-11g","tag-11gr2","tag-configuration","tag-forms","tag-opmn","tag-reports"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/4931","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\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/comments?post=4931"}],"version-history":[{"count":9,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/4931\/revisions"}],"predecessor-version":[{"id":9986,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/4931\/revisions\/9986"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=4931"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=4931"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=4931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}