{"id":1169,"date":"2009-05-22T08:08:16","date_gmt":"2009-05-22T12:08:16","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2009\/05\/22\/how-to-upgrade-oracle-application-server-10g-r2-1012-formsreports-in-r1212i-5983622\/"},"modified":"2009-05-22T08:14:40","modified_gmt":"2009-05-22T12:14:40","slug":"how-to-upgrade-oracle-application-server-10g-r2-1012-formsreports-in-r1212i-5983622","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2009\/05\/22\/how-to-upgrade-oracle-application-server-10g-r2-1012-formsreports-in-r1212i-5983622\/","title":{"rendered":"How to Upgrade Oracle Application Server 10g R2 (10.1.2) forms\/reports in R12\/12i – 5983622"},"content":{"rendered":"

This post covers overview of Forms and Reports\u00a0Upgrade<\/strong> in Oracle Apps R12 (12.0.X) to 10.1.2.3<\/p>\n

Key Points for 10.1.2 upgrade in R12\/12i (12.0.X)<\/u><\/strong><\/p>\n

1.<\/strong>There are two ORACLE_HOMEs on Application Tier
\n10.1.2.X<\/strong> for Forms & Reports
\n10.1.3.X<\/strong> for Web Server & J2EE application<\/p>\n

2.<\/strong> By default, R12 uses Forms Servlet Architecture<\/strong>for forms requests (to know more about Forms Servlet click here<\/a> ); which uses J2EE container (JVM) in 10.1.3 ORACLE_HOME .
\n\u00a0\u00a0\u00a0\u00a0 This means one HTTP Server (Apache) in 10.1.3 ORACLE_HOME serves all HTTP, Forms and Reports requests. (HTTP Server in 10.1.2 Oracle Home is not used)<\/p>\n

You need to deploy new Forms Servlet <\/strong>(formsapp.ear)\u00a0to 10.1.3 Oracle Home\u00a0after 10.1.2 Oracle Home upgrade.<\/p>\n

3.<\/strong>Deploying new Forms Servlet to 10.1.3 Oracle HOme means deploying formsapp.ear<\/strong> file to 10.1.3 ORACLE_HOME. Use txkrun.pl -script=CfgOC4JApp<\/strong>to deploy new forms servlet in 10.1.3 Home (Metalink Note 397174.1)<\/p>\n

4.<\/strong>oc4jadmin password (for 10.1.3 HOME)\u00a0is stored in xml file $INST_TOP\/ ora\/ 10.1.3\/ j2ee\/ forms\/ config\/ system-jazn-data.xml<\/strong> , If you don’t know oc4jadmin<\/strong> password or wish to change it use steps mentioned here<\/a>\u00a0<\/p>\n

5.<\/strong> To check forms\/reports current version in R12 use
\n$ $ORACLE_HOME\/bin\/frmcmp help=y<\/strong>
\nForms 10.1 (Form Compiler) Version 10.1.2.2.0<\/strong> (Production)<\/p>\n

6.<\/strong> You need ias_admin<\/strong> password during forms and reports upgrade (default password is secret<\/strong>). Test that you can login as ias_admin\/secret<\/strong><\/p>\n

$ emctl authenticate secret
\n<\/strong>Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0\u00a0
\nCopyright (c) 1996, 2005 Oracle Corporation.\u00a0 All rights reserved.
\nsuccess
\n<\/strong>
\n__________<\/p>\n

If you get error like <\/strong>
\n$ORACLE_HOME\/bin\/emctl: \/d2\/ R12\/ ab\/ apps\/ RUP4XB6\/ apps\/ tech_st\/ 10.1.2: does not exist<\/p>\n

Fix<\/strong><\/p>\n

Open\u00a0$ORACLE_HOME\/bin\/ emctl<\/strong>, emagentdeploy.pl<\/strong>, emdctl<\/strong> and change ORACLE_HOME to correct value<\/p>\n

If you get error like
\n<\/strong>oracle.security.jazn.JAZNInitException: \/d2\/ R12\/ ab\/ apps\/ RUP4XB6\/ apps\/ tech_st\/ 10.1.2\/ sysman\/ j2ee\/ config\/ jazn-data.xml (No such file or directory)<\/p>\n

Copy $ORACLE_HOME\/sysman\/j2ee\/config\/jazn-data.xml to \/d2\/R12\/ab\/apps\/RUP4XB6\/apps\/tech_st\/10.1.2\/sysman\/j2ee\/config<\/p>\n

__________<\/p>\n

.<\/p>\n

Forms & Reports Upgrade steps in R12
\n<\/u>
\n1.<\/strong> Stop Middle Tier Services<\/p>\n

2.<\/strong>Download & install pre-req patch (conditional)
\n
\n3.<\/strong> Ensure that Inventory is pointing to right location
\n
\n4.<\/strong>Install 10.1.2.3 (5983622 – This is latest Forms & Report Patchset) using runInstaller<\/strong> from Disk1 (inside patch)
\n4.1<\/strong> Select “Oracle Application Server and Developer Suite 10g Rel 2 Software Update<\/strong>” on Select a Product to Install<\/strong> screen
\n4.2<\/strong> When prompted for ias_admin<\/strong> password on Application Server Instance Password<\/strong> screen enter secret
\n<\/strong>
\n5.<\/strong> Shutdown OPMN from 10.1.2 Home (Installer starts OPMN after upgrade)<\/p>\n

6.<\/strong> Apply additional interoperability patches<\/p>\n

7.<\/strong> Rebuild Forms & Regenerate Jar files<\/p>\n

8.<\/strong> Deploy new Forms Servlet<\/strong> to 10.1.3<\/strong> Oracle Home<\/p>\n

9.<\/strong> Start Application<\/p>\n

For Step 1-7 follow metalink note 437878.1
\nFor Step 8 follow metalink note 397174.1<\/strong>
\nFor Step 4 follow readme of patch 5983622<\/strong><\/p>\n


\nReferences<\/u><\/strong><\/p>\n