{"id":9080,"date":"2017-05-10T14:41:08","date_gmt":"2017-05-10T18:41:08","guid":{"rendered":"https:\/\/pitss.org\/us\/?p=9080"},"modified":"2018-05-22T12:37:22","modified_gmt":"2018-05-22T16:37:22","slug":"potential-issues-connecting-forms-6i-oracle-database-12c","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2017\/05\/10\/potential-issues-connecting-forms-6i-oracle-database-12c\/","title":{"rendered":"Potential Issues When Connecting Forms 6i with Oracle Database 12c"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;3.0.51&#8243; custom_padding=&#8221;0px||0px|&#8221;][et_pb_row custom_padding=&#8221;0px|||&#8221; custom_margin=&#8221;0px||0px|&#8221; background_position_1=&#8221;top_left&#8221; background_repeat_1=&#8221;no-repeat&#8221; admin_label=&#8221;row&#8221; _builder_version=&#8221;3.3.1&#8243;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;no-repeat&#8221;][et_pb_text _builder_version=&#8221;3.3.1&#8243; border_style=&#8221;solid&#8221;]<\/p>\n<p>In the past few years, Oracle has released its latest version of Oracle Database: version 12c. Oracle Database 12c contains all the latest features, bug fixes, and security patches. Many applications built on Oracle Forms, ADF, APEX, or even non-Oracle applications rely on a connection to an Oracle database to query, insert, and update data.<\/p>\n<p>When an Oracle database is upgraded to 12c, it is important to also upgrade or modernize your application to the latest version in order to decrease the possibility of compatibility issues occurring between your application(s) and your 12c Oracle database.<\/p>\n<p>[\/et_pb_text][et_pb_divider color=&#8221;#e2e2e2&#8243; divider_position=&#8221;center&#8221; disabled_on=&#8221;on|on|off&#8221; admin_label=&#8221;Divider&#8221; _builder_version=&#8221;3.2&#8243; custom_css_main_element=&#8221;margin-bottom:30px !important;&#8221;][\/et_pb_divider][et_pb_text admin_label=&#8221;Text&#8221; _builder_version=&#8221;3.0.51&#8243; custom_margin=&#8221;||30px|&#8221;]<\/p>\n<h3><strong>What you&#8217;ll learn in this article:<\/strong><\/h3>\n<p><strong style=\"font-size: 16px; padding-right: 5px; background-color: #ffffff; color: #abd25e;\">\u2713<\/strong>\u00a0Issues encountered when connecting to a 12c Oracle database<br \/> <strong style=\"font-size: 16px; padding-right: 5px; background-color: #ffffff; color: #abd25e;\">\u2713<\/strong><span style=\"font-size: 16px; background-color: #ffffff;\">\u00a0<\/span><span style=\"font-size: 16px;\">The reason these errors occur<br \/> <\/span><strong style=\"font-size: 16px; padding-right: 5px; background-color: #ffffff; color: #abd25e;\">\u2713<\/strong><span style=\"font-size: 16px; background-color: #ffffff;\">\u00a0<\/span><span style=\"font-size: 16px;\">Workarounds that may fix these errors<br \/> <\/span><strong style=\"font-size: 16px; padding-right: 5px; background-color: #ffffff; color: #abd25e;\">\u2713<\/strong><span style=\"font-size: 16px; background-color: #ffffff;\">\u00a0How to make your Forms application safe and secure<\/span><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding=&#8221;40px|40px|30px|40px&#8221; background_position_1=&#8221;top_left&#8221; background_repeat_1=&#8221;no-repeat&#8221; admin_label=&#8221;Row&#8221; _builder_version=&#8221;3.0.51&#8243; background_color=&#8221;#006bb3&#8243;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;no-repeat&#8221;][et_pb_text admin_label=&#8221;Text&#8221; _builder_version=&#8221;3.0.106&#8243; background_color=&#8221;#006bb3&#8243; background_layout=&#8221;dark&#8221;]<\/p>\n<h2 style=\"font-size: 30px! important;\"><strong>Fill out the form below to access this blog post.<\/strong><\/h2>\n<p>[\/et_pb_text][et_pb_code admin_label=&#8221;Code&#8221; module_class=&#8221;white-text&#8221; _builder_version=&#8221;3.3.1&#8243;][ninja_form id=37][\/et_pb_code][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding=&#8221;0px||0px|&#8221; custom_margin=&#8221;30px||30px|&#8221; background_position_1=&#8221;top_left&#8221; background_repeat_1=&#8221;no-repeat&#8221; _builder_version=&#8221;3.3.1&#8243;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;no-repeat&#8221;][et_pb_cta title=&#8221;Relying on legacy Oracle Forms applications? &#8221; button_url=&#8221;https:\/\/pitss.org\/solutions\/legacy-application-modernization\/&#8221; button_text=&#8221;LEGACY APPLICATION MODERNIZATION&#8221; _builder_version=&#8221;3.0.52&#8243; background_color=&#8221;#222222&#8243; custom_button=&#8221;on&#8221; button_font=&#8221;Abel|||on|&#8221; text_orientation=&#8221;left&#8221; custom_padding=&#8221;45px|50px|45px|50px&#8221; border_style=&#8221;solid&#8221;]Have you considered modernizing your legacy Oracle Forms applications? PITSS can help your business keep up with the latest technology and bring your systems into the modern world.<br \/>\n[\/et_pb_cta][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the past few years, Oracle has released its latest version of Oracle Database: version 12c. Oracle Database 12c contains all the latest features, bug fixes, and security patches. Many applications built on Oracle Forms, ADF, APEX, or even non-Oracle applications rely on a connection to an Oracle database to query, insert, and update data. [&hellip;]<\/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":"<p>In the past few years, Oracle has released its latest version of Oracle Database: version 12c. Oracle Database 12c contains all the latest features, bug fixes, and security patches. Many applications built on Oracle Forms, ADF, APEX, or even non-Oracle applications rely on a connection to an Oracle database to query, insert, and update data. When an Oracle database is upgraded to 12c, it is important to also upgrade or modernize your application to the latest version in order to decrease the possibility of compatibility issues occurring between your application(s) and your 12c Oracle database. For Oracle Forms, Oracle has certified Forms version 11gR2 (11.1.2.2.x) and 12c (12.2.x) with Oracle Database 12c as Oracle has tested the compatibility between these versions, and both work successfully together. Without upgrading your Oracle Forms application to the latest version, the odds of running into errors when connecting an older Oracle Forms application to a 12c database increases.<\/p><p>For example, with Oracle Forms version 6i, the following issues have been encountered when trying to connect to a 12c Oracle database (or even to an 11g database):<\/p><blockquote><ul><li>Errors such as ORA-3113 and ORA-28040 during authentication<\/li><li>SQL*Plus hanging issues when using a SQL*Plus client from Oracle Forms 6i to connect to an 11gR2 or 12c database<\/li><li>The possibility that a user may be asked to re-authenticate upon accessing a new form in the same application if the user was able to log in successfully<\/li><\/ul><\/blockquote><p>The reason for these errors is because Oracle Forms 6i is meant to run on older Oracle Database versions which are no longer supported. Newer Oracle Database versions such as 11gR2 and 12c contain newer features and settings which were not tested against older Forms versions because the older releases were replaced by newer versions of Oracle Forms. As newer versions of Oracle Forms are released, older releases are taken out of support.<\/p><p>There have been reports that some workarounds have been known to fix some of the issues noted above. However, they are neither recommended nor supported by Oracle. Some workarounds may even lower the security of your Oracle database. The following workarounds have been reported to work, but there are no guarantees if they will work. Some users reported that they either needed to create new configuration files, restart the database several times temporarily in restricted mode, or even re-configure database instances from scratch:<\/p><blockquote><ul><li>Configure \"SQLNET.ALLOWED_LOGON_VERSION_SERVER=8\" and \"SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8\" in sqlnet.ora<\/li><li>Setting the parameter \"SEC_CASE_SENSITIVE_LOGIN\" to FALSE<\/li><li>Setting the system parameters, JOB_QUEUE_PROCESSES and AQ_TM_PROCESSES, to 0<\/li><li>Changing the database character set to WE8MSWIN1252 using \"ALTER DATABASE CHARACTER SET INTERNAL_USE WE8MSWIN1252; or changing the character set to a UTF8 character set such as AL32UTF8<\/li><\/ul><\/blockquote><p>The above workarounds may work, but there is a possibility that they may not fix all problems when connecting an Oracle Forms 6i application with Oracle Database 12c. These will need to be carefully tested in a development or test environment before they are rolled out to production. PITSS will not be held responsible for any problems which happen as a result of implementing any of these workarounds to get Oracle Forms 6i to work with Oracle Database 12c due to Forms 6i being out of support for about a decade.<\/p><p>The safest, most secure, and best approach to have your Forms application work with the latest and greatest release of Oracle Database (version 12c) is to either upgrade to the latest version of Oracle Forms (also version 12c), or modernize it to a newer technology. PITSS has the expertise to upgrade your Oracle Forms application to the latest release which is compatible with the latest release of Oracle Database as well as to digitally transform your Forms application to a more robust technology.<\/p><p><a href=\"https:\/\/pitss.org\/solutions\/digital-transformation-strategy\/\">Contact PITSS today to learn more on how we can digitally transform your Forms application to the modern world.<\/a><\/p>","_et_gb_content_width":"","footnotes":""},"categories":[22,14],"tags":[12,23,27,7],"class_list":["post-9080","post","type-post","status-publish","format-standard","hentry","category-forms","category-resolve-issues","tag-error","tag-forms","tag-oracle-database","tag-pitss-con"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/9080","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=9080"}],"version-history":[{"count":16,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/9080\/revisions"}],"predecessor-version":[{"id":11351,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/9080\/revisions\/11351"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=9080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=9080"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=9080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}