Upgrade Oracle Applications to 12.0.4


Oracle Applications Release 12 update 4 (12.0.4) is available now.  This post covers top level steps for upgrading Oracle Applications R12 (12.0.0, 12.0.1, 12.0.2, 12.0.3) to latest patchset i.e. 12.0.4

Key Points for Upgrade to 12.0.4
1. You can upgrade to 12.0.4 directly from following releases 11.5.8, 11.5.9 (Base, Update1 and Update2), 11.5.10 (Base, Update1 and Upadte2), R 12 (Base, 12.0.1, 12.0.2, 12.0.3)

2. Patch Number for 12.0.4 is 6435000  (Apply this patch if you are upgrading from R12 i.e. 12.0.0, 12.0.1, 12.0.2 or 12.0.3)

3. If you are upgrading from R12 (12.0.1, 12.0.2, 12.0.3), first apply R12.AD.A.DELTA.4 (6510214).

4. After applying 12.0.4 patch (6435000) apply consolidated online help patch (6400100) and apply other functional patches (depending on product you are using) as per Metalink Note # 465776.1 and read me of patch 6435000

5. After application of 12.0.4 patch bring database context to 12.0.4 code
–Build appsutil.zip on application tier
–Copy appsutil.zip to dataabse tier
–Run Autoconfig on database tier

6. 12.0.4 is also called as Release 12 Update 4 or RUP4 and cumulative patchset (include 12.0.1, 12.0.2, 12.0.3)

Related Docs/Metalink Notes
556312.1  Now Available: Oracle E-Business Suite Release 12.0.4
549389.1  Oracle Applications Release Notes, Release 12.0.4
465776.1  Oracle E-Business Suite 12.0.4 Release Update Pack Readme
402310.1  Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Linux (32-bit)
Read Me of Patch 6400100
Read Me of Patch 6510214

If you any queries on this post, Kindly leave a comment so that it can be useful to everyone.

Upgrade Oracle Apps 11i to R12/12i (12.0.4) – Key Points

This post covers overview/top level steps to upgrade Oracle Applications (E-Business Suite) 11i (11.5.8,11.5.9,11.5.10) to R12/12i (12.0.4).
   This post is useful to understand upgrade from Apps DBA point of view and does NOT cover any functional steps in upgrade process.

If you want to know what is changed in R12 (like technical difference between 11i & R12 Click Here or new TOP INST_TOP click here )

If you are already on R12 (12.0.0, 12.0.1, 12.0.2 or 12.0.3) and wish to upgrade to 12.0.4  Check Steps Here

Key points with regard to upgrade

- You can upgrade to R12/12i (12.0.4) ONLY from release 11.5.8, 11.5.9.X or 11.5.10.X (For any previous release like 11.5.7 , upgrade them to 11.5.10.2 first)

- You can upgrade database to version 10.2.X during upgrade (11.5.8, 11.5.9.X, 11.5.10.X) or BEFORE R12 upgrade (only for 11.5.9.X and 11.5.10.X)

.
Upgrade is broadly divided in to three steps
–Preupgrade Step (lay down file system for R12 using rapidwiz/RapidInstall)
–Upgrade Step (Upgrade database to 10gR2 (if not already upgraded), apply R12.AD.A on R12 APPL_TOP and apply 12.0.4 patch database portion only)
–Post Upgrade step (Run rapidwiz/RapidInstall one more time to configure and start services on R12).


A. Pre-Upgrade Process
1.Layout file system for R12 using rapidwiz with option as upgrade.

Run rapidwiz from R12 software >> Select option “Upgrade to Oracle Applications Release 12“  (Check Figure)

In Select Upgrade Action screen select “Create Upgrade File System” (Check Figure).

Follow further screens and installer will install R12 file system (This step will NOT configure and start services in R12, It will only install R12 files)

Note* There are other preupgrade steps as well like migrate backup, TUMS (optional), OATM, convert to multi org, gather stats and functional preupgrade steps (Detailed step by step upgrade doc coming soon …)


B. Upgrade Process
2.Migrate database to 10gR2 – This step is required if you have not upgraded your database with 11i itself. Use ORACLE_HOME (10.2 on database tier) which came as part of R12 upgrade (Create Upgrade file system above in preupgrade step)

 Also check following Metalink Notes

403339.1 – Oracle 10g R2 Database preperation Guidelines for Oracle E-Business Suite R12 Upgrade
396009.1 - Database initialization parameters for Oracle apps R12

3. Put your Apps into database in to maintenance mode
4.Run adpatch 6604842 (on R12 appl_top, environment variable at this stage should point to R12 APPL_TOP and ORACLE_HOME in application tier should point to FORMS (10.1.2) in R12) to upgrade AD product of R12 to 12.0.4 (Patch 6604842 is available as R12.AD.A)

5. Run 12.0.4 patch 6394500(u6394500.drv ) which is under $AU_TOP/patch/115/driver (on R12/12.0.4 APPL_TOP). Note* You have to apply this patch on 12.0.4  APPL_TOP.

Apply this with nocopyportion and nogenerateportionas copy and generate portion is already available as part of R12 install done above in preupgarde step.

Apply/Upgrade to 12.0.4 using

adpatch options=nocopyportion,nogenerateportion

6.  Disable maintenance mode

C. Post Upgrade Process
Database and database listener should be up at this stage.

7. Run Rapid Install one more time (with different option check figure) to configure and start services on R12/12i.

Run rapidwiz one more time
Select option “Upgrade to Oracle Applications Release 12“  (Check Figure)

In Select Upgrade Action screen select “Configure Upgraded Release 12 Instance” (This select is different from selection in Pre-Upgrade Step).

Change file name as shown in figure to your new $APPL_TOP/admin/$CONTEXT_NAME.xml (R12)
There are other finishing tasks which are out of scope of this post like backup, reset password, setup client machines (java plugin), printers, workflow notification mailer and various functional steps
Related  Docs
399362.1 E-Business Suite Release 12 Upgrade Sizing and Best Practices
396009.1 Database Initialization Parameter for Oracle Applications R12
Stay tuned for more on Oracle Apps R12/12i upgrade from release 11i

If you think any queries on this post, Kindly leave a comment so that it can be useful to everyone.

Difference between Oracle Apps 11i and R12 (Technical)

Database:
Database Version in 11i (11.5.9 & 11.5.10) was 9i Rel 2 where as in Release 12 its 10g R2 (10.2.0.2)

Application Tier:
Tech Stack in Application Tier consist of iAS(1.0.2.2.2) & Developer 6i (Forms & Reports 8.0.6) but in Applications R12 it is build on Fusion Middleware (10g Web Server and 10g Forms & Reports)

Sub component in Application Tier
A) HTTP Server or Web Server in R12 is Version 10.1.3 which is built on Apache version 1.3.34. In apps 11i it is Version 1.0.2.2.2 built on Apache Version 1.3.19
B) Jserv in apps 11i is replaced by OC4J (mod_jserv is replaced by mod_oc4j)
C) Forms Version 6i in Apps 11i is replaced by Forms 10.1.2.0.2 in R12
D) Reports Version 6i in Apps 11i is replaced by Reports 10.1.2.0.2 in R12
E) JDBC version is changed from version 9 in apps 11i to version 10.2.0 in Apps R12
F) modplsql or mod_pls is removed from Apps R12 (What will happen to my mod plsql applications- coming soon* )
G) Java processes use JDK/JRE version 1.5.0 in R12 against JDK version 1.3.1 or 1.4.2 in Apps 11i
H) For various environment variable changes check below picture.

I) New top INSTANCE_TOP added in Release 12 for configuration and log files.

Related:

If you think I missed any Technical changes in Release 12, Kindly leave a comment so that it can be useful to everyone.

Upgrade of Oracle Applications Version R12.1.1 to R12.1.3

After Installation of Oracle Applications R12.1.1,I have upgraded to R12.1.3 Successfully in my Servers.
The following patches are required and download from the Oracle Support as per their environment.
In this Note I have added some more patches for avoiding the feature errors and for avoiding  invalid objects.
Before going to proceed please check the metal ink Note Oracle E-Business Suite Release 12.1.3 Readme [ID 1080973.1].



Required patches:
p9239089_R12.AD.B_R12_LINUX.zip
p10349415_R12.AD.B_R12_GENERIC.zip (Optional)
p9239090_R12_LINUX_1of6.zip
p9239090_R12_LINUX_2of6.zip
p9239090_R12_LINUX_3of6.zip
p9239090_R12_LINUX_4of6.zip
p9239090_R12_LINUX_5of6.zip
p9239090_R12_LINUX_6of6.zip
p9239095_R12_GENERIC.zip
p9822544_R12.MSC.B_R12_GENERIC.zip(Optional)


Post update patches are :
p9966055_R12.FND.B_R12_GENERIC.zip
p9817770_R12.ATG_PF.B_R12_LINUX.zip


The following information will provide upgradation process for Ooracle Applications R12.1.1 to R12.1.3.


Step1: Run adadmin and put Maintenance Mode


Step2: Apply Prerequisite R12.AD.B.DELTA.3 Patch 9239089
Do the following Tasks before going to apply the Patch R12.AD.B.DELTA.3 Patch 9239089


Run the adgrants.sql script as a user that can connect as SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.


Usage:
1.Create $ORACLE_HOME/appsutil/admin on the database server.


2.Copy adgrants.sql (UNIX) from this patch directory to $ORACLE_HOME/appsutil/admin.Or, copy adgrants_nt.sql (Windows) from this patch directory to %ORACLE_HOME%\appsutil\admin.


3.Set the environment to point to ORACLE_HOME on the database server.


4.Use SQL*Plus to run the script:


UNIX:
$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql <APPS schema name>


Step3: Apply R12.AD.B_R12_GENERIC.zip Patch 10349415


Step4: Apply Oracle E-Business Suite Release 12.1.3 Patch 9239090


Step5:. Apply Oracle E-Business Suite Online Help for 12.1.3 Release Update Pack patch 9239095


Step6:.Apply Patch 9822544 for Advanced Supply Chain Planning. (Optional).This patch fixes the issue of collecting resource requirements of OPM batches WIP warehouse does not belong to resource warehouse.


Step7: Apply post Update Patches:


–Apply mandatory Patch 9817770 (9817770:R12.ATG_PF.B [POST-R12.ATG_PF.B.DELTA.3 CONSOLIDATEDPATCH].)


–Apply mandatory Patch 9966055 (9966055:R12.FND.B [TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED].)


After you have upgraded to Oracle E-Business Suite Release 12.1.3, perform the following post-update steps to update all database tier nodes with the code level, provided by Oracle E-Business Suite Release 12.1.3.



Step8: Run Application  and Database Environment files.


@Application Tier:


    Run AutoConfig on the APPL_TOP.
    Run the admkappsutil.pl utility to create the file appsutil.zip in the <INST_TOP>/admin/out directory.


perl <AD_TOP>/bin/admkappsutil.pl


@Database Tier:


Copy or FTP the appsutil.zip file to the <RDBMS ORACLE_HOME>. Uncompress appsutil.zip under the <RDBMS ORACLE_HOME>.


    cd <ORACLE_HOME>
    unzip -o appsutil.zip
    Run AutoConfig on the <RDBMS ORACLE_HOME>.


Step9:. Run adpreclone.pl on the database tier and the application tier


    perl adpreclone.pl dbTier
    perl adpreclone.pl appsTier


Step10: Disable Maintenance Mode using adadmin and check the version using following sql statement.


SQL> select release_name from fnd_product_groups;
RELEASE_NAME
--------------------------------------------------
12.1.3