2. Upgrade Oracle EBS R12.1.1 to R12.1.3

Oracle E-Business Suite Upgrade to Release 12.1.3

Overview

This article provides a comprehensive guide for upgrading Oracle E-Business Suite (EBS) to Release 12.1.3. The procedure covers prerequisite patches, maintenance mode configuration, patch application, and post-upgrade validation steps.

Environment Specifications:

  • Database Version: 12.1.0.1.0

  • EBS Version: 12.1.3

Prerequisite Patches

Before beginning the upgrade process, ensure the following patches are downloaded and ready for application:

Patch IDDescription
9239089R12.AD.B.DELTA.3
9239090Oracle E-Business Suite Release 12.1.3
9239095Consolidated Online Help
9817770POST-R12.ATG_PF.B.DELTA.3 Consolidated Patch
9966055Translated Version of FNDSCSGN Not Launched

Step-by-Step Upgrade Procedure

2.1 Enable Maintenance Mode

Maintenance mode must be enabled before applying any patches to prevent user access during the upgrade process.

bash
# Source the application environment
[applmgr@fbsebs ~]$ . /u01/app/FBS/apps/apps_st/appl/APPSFBS_fbsebs.env

# Launch AD Administration
[applmgr@fbsebs ~]$ adadmin

Navigate through the AD Administration menu:

  1. Select option 5 (Change Maintenance Mode)

  2. Select option 1 (Enable Maintenance Mode)

  3. Exit AD Administration after confirmation

Verification Output:

text
Maintenance Mode is currently: [Disabled].
Successfully enabled Maintenance Mode.

2.2 Install Required Libraries (Patch 12415211)

The following steps address library compatibility issues by replacing stub libraries:

For 10.1.2 Oracle Home:

bash
[applmgr@fbsebs app]$ cd /u01/app/FBS/apps/tech_st/10.1.2/lib/
[applmgr@fbsebs lib]$ cp -p -R stubs stubsORIG
[applmgr@fbsebs lib]$ cd stubs
[applmgr@fbsebs stubs]$ cp /u01/patches/app/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .
[applmgr@fbsebs stubs]$ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
[applmgr@fbsebs stubs]$ ln -s libgcc_s.so.1 libgcc_s.so

For 10.1.3 Oracle Home:

bash
[applmgr@fbsebs stubs]$ cd /u01/app/FBS/apps/tech_st/10.1.3/lib/
[applmgr@fbsebs lib]$ cp -p -R stubs stubsORIG
[applmgr@fbsebs lib]$ cd stubs
[applmgr@fbsebs stubs]$ cp /u01/patches/app/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .
[applmgr@fbsebs stubs]$ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
[applmgr@fbsebs stubs]$ ln -s libgcc_s.so.1 libgcc_s.so

2.3 Database Preparation Before Applying Patch 9239089

Execute adgrants.sql

Copy adgrants.sql from the patch directory to the database Oracle Home:

bash
[oracle@fbsebs ~]$ cd /u01/app/FBS/db/tech_st/11.1.0/
[oracle@fbsebs 11.1.0]$ . FBS_fbsebs.env
[oracle@fbsebs 11.1.0]$ sqlplus /nolog

SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql apps

Disable Fast Validation

For 11gR1 databases, disable fast validation for PL/SQL recompilations:

bash
[oracle@fbsebs 11.1.0]$ sqlplus / as sysdba
SQL> create spfile from pfile;
SQL> shu immediate
SQL> startup
SQL> alter system set "_disable_fast_validate"=true scope=both;

Important Note: This parameter should be commented out during normal system operation after the upgrade.

2.4 Apply Patches Using adpatch Utility

Apply patches in the following sequence:

Patch 9239089

bash
[applmgr@fbsebs stubs]$ . /u01/app/FBS/apps/apps_st/appl/APPSFBS_fbsebs.env
[applmgr@fbsebs stubs]$ cd /u01/patches/app/9239089/
[applmgr@fbsebs 9239089]$ adpatch apply=yes driver=u9239089.drv

Patch 9239090

Pre-Application Steps:

  1. Edit $AD_TOP/bin/adrelinknew.sh

  2. Replace the existing CPP_LDFLAGS line:

    bash
    CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh'

    With:

    bash
    CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh -Wl,--noinhibit-exec'

  3. Run adadmin to relink application executables

Apply the Patch:

bash
[applmgr@fbsebs 9239089]$ cd /u01/patches/app/9239090/
[applmgr@fbsebs 9239090]$ adpatch apply=yes driver=u9239090.drv

Note: This patch may take considerable time depending on system hardware.

Patch 9239095

bash
[applmgr@fbsebs 9239090]$ cd /u01/patches/app/9239095/
[applmgr@fbsebs 9239095]$ adpatch apply=yes driver=u9239095.drv

Patch 9817770

bash
[applmgr@fbsebs 9239095]$ cd /u01/patches/app/9817770/
[applmgr@fbsebs 9817770]$ adpatch apply=yes driver=u9817770.drv

Patch 9966055

bash
[applmgr@fbsebs 9817770]$ cd /u01/patches/app/9966055/
[applmgr@fbsebs 9966055]$ adpatch apply=yes driver=u9966055.drv

2.5 Post-Upgrade Steps

2.5.1 Recreate appsutil on Application Tier

bash
[applmgr@fbstes ~]$ cd $APPL_TOP
[applmgr@fbstes ~]$ . APPSFBS_fbstes.env
[applmgr@fbstes ~]$ perl $AD_TOP/bin/admkappsutil.pl

Output Location: /u01/app/FBS/inst/apps/FBS_fbstes/admin/out/appsutil.zip

2.5.2 Copy appsutil.zip to Database Tier

bash
[oracle@fbstes ~]$ . FBS_fbstes.env
[oracle@fbstes ~]$ cd $ORACLE_HOME
[oracle@fbstes 11.1.0]$ mv appsutil.zip appsutil.zip_orig
[oracle@fbstes 11.1.0]$ cp /u01/app/FBS/inst/apps/FBS_fbstes/admin/out/appsutil.zip .
[oracle@fbstes 11.1.0]$ unzip -o appsutil.zip

Recreate Context File on Database Tier

bash
[oracle@fbsebs ~]$ cd $ORACLE_HOME/appsutil/bin
[oracle@fbsebs bin]$ perl adbldxml.pl appsuser=apps appspasswd=apps

Provide the following information when prompted:

  • Database Server Hostname: fbsebs

  • Database Server Port: 1531

  • Database SID: FBS

  • Display Variable: fbsebs:0.0

2.5.3 Run AutoConfig on Database Tier

bash
[oracle@fbsebs bin]$ adautocfg.sh

2.5.4 Run AutoConfig on Application Tier

bash
[applmgr@fbsebs ~]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@fbsebs scripts]$ adautocfg.sh

2.6 Validate the New EBS Version

Verify the upgrade was successful by querying the database:

sql
SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
--------------------------------------------------
12.1.3

Troubleshooting: Forms Not Opening

If forms fail to open after the upgrade:

  1. Stop application tier services

  2. Run adadmin to regenerate JAR files

  3. Compile all forms:

    bash
    cd $ORACLE_HOME/forms/lib
make -f ins_forms.mk install

Reference Documentation

DocumentID
Oracle E-Business Suite Release 12.1.3 ReadmeDoc ID 1080973.1
Applying Patch 9239090 Failed During Relink of FEMCCEDoc ID 1303269.1
Relink of ENCACN/WICMEX/WICMLX Fails on EL 6Doc ID 1583440.1
Database Preparation Guidelines for EBS 12.1 UpgradeDoc ID 761570.1

Important Notes

  1. Maintenance Mode: Always ensure maintenance mode is enabled during patching and disabled for normal operations.

  2. Fast Validation Parameter: The _disable_fast_validate=TRUE parameter is temporary and should be removed after the upgrade completes.

  3. Time Consideration: The upgrade patch (9239090) can be time-consuming; plan accordingly.

  4. Backups: Consider taking full backups before starting the upgrade process.

No comments:

Post a Comment

Subscribe to: Posts (Atom)