Upgrade Oracle EBS R12.1.1 to 12.1.3

Document Reference:

Oracle E-Business Suite Release 12.1.3 Readme [ID 1080973.1]

Applies to: 12.1

Our Application version :12.1.1

Our Database version :11.2.0.3

Oracle Apps 12.1.3 upgrade is only possible if your system is in 12.1.1 or upper version.

Prerequisite Steps

1.   It is advisable to complete all of the following four steps before attempting to apply the 12.1.3       maintenance pack.

·         Upgrade database version to 11.2.0.3 (upgraded)

·          Upgrade to the latest Java versions

·         Upgrade iAS 10.1.3 to the latest version

·          Upgrade forms 10.1.2 to the latest version

As we are already on 12.1.1 version and upgraded to 11.2.0.3, we  have already upgraded form tier and web tier. So, no action is required for form and web tier upgrade

2.  At first make some changes in the database parameters for upgrade. You need to set the following parameters using initialization file.

recyclebin=false

_pga_max_size=104857600

_disable_fast_validate = TRUE

Use the following kind of comand to changes the mentioned three parameters.

SQL> alter system set "_disable_fast_validate"=TRUE SCOPE=BOTH;

System altered.

SQL> alter system set "_pga_max_size"=104857600 scope=both;

System altered.

                                    Or

edit the init parameter file in the database

add (_disable_fast_validate=TRUE).

pga_aggregate_target=2G

set the _pga_max_size initialization parameter to a larger value as follows: _pga_max_size=104857600
and restart your database.)

SQL> startup pfile='/u01/db_top/db/tech_st/11.2.0/dbs/initPROD.ora';

ORACLE instance started.

Total System Global Area 1068937216 bytes

Fixed Size                  2235208 bytes

Variable Size             427820216 bytes

Database Buffers          624951296 bytes

Redo Buffers               13930496 bytes

Database mounted.

Database opened.

 

Main Upgrade Patch Application

• Download the following two patches from metalink 9239089, 9239090.

•  Using autopatch utility first apply R12.AD.B.DELTA.3 Patch 9239089

Pre Install Steps as per Patch readmefile & Doc.1077769.1

(i) create a dir on $ORACLE_HOME/appustil/admin

(ii) Copy adgrants.sql from this patch directory to $ORACLE_HOME/appsutil/admin

[oracle@oracleupk admin]$ cp /u01/upgrade_12.1.3_patches/9239089/admin/adgrants.sql .

[oracle@oracleupk admin]$ ls -lrt

total 52

-rwxr-xr-x 1 oracle oinstall 53060 May  2 10:10 adgrants.sql

(iii) Set the database environment

(iv) logon to sqlplus and run adgrants.sql with apps schema password as below

sqlplus /nolog
sql> connect as sysdba
sql> @$ORACLE_HOME/appsutil/admin/adgrants.sql apps

• Disable maintanance mode using adadmin utility

• Set application environment.

• Run Patch 9239089 using adpatch

• Compile APPS schema

• Run adadmin > Compile/Reload Applications Database Entities menu >Compile APPS schema.

•  Apply patch 9239090 using adpatch

(When adrelink error chose "Yes" to continue)

• Use AutoPatch to apply the latest consolidated online help Patch 9239095 and follow the instructions in the patch readme file.

Post upgrade steps

•  Apply post-install Oracle E-Business Suite Applications Technology patches. (Required)

• Apply mandatory Patch 9817770 (9817770:R12.ATG_PF.B [POST-R12.ATG_PF.B.DELTA.3 CONSOLIDATED PATCH].)

• To not get the error :Relink of module "MSCCPP" failed, "FEMCCE","MSCNEW","MSCMON" please see if (R12: MSC Modules Error Out When Relinking with Adrelink [ID 1345788.1]) helps.

• This patch requires additional code levels to have been successfully

applied to your system before it can be applied.  These code levels,

as at the time that this patch was built, are listed below.  Please check

'My Oracle Support' to determine if any of these have been superseded

§     * R12.AD.B.delta.3

§     * R12.ATG_PF.B.delta.3

• Both the patches are already applied.

• 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

Application tier:

• As the APPLMGR user, run the environment (UNIX) or the command (WINDOWS) file for the current APPL_TOP.

[applmgr@oracleupk appl]$ . ./APPSPROD_oracleupk.env

• Run AutoConfig on the APPL_TOP

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

            [applmgr@oracleupk bin]$ pwd

            /u01/appl_top/apps/apps_st/appl/ad/12.0.0/bin

            [applmgr@oracleupk bin]$ ls admkappsutil.pl

            admkappsutil.pl

            [applmgr@oracleupk out]$ pwd

            /u01/appl_top/inst/apps/PROD_oracleupk/admin/out

            [applmgr@oracleupk out]$ ls appsutil.zip

            appsutil.zip

Database tier:

• As the ORACLE user, run the environment (UNIX) or the command (WINDOWS) file for the current ORACLE_HOME.

cd <RDBMS ORACLE_HOME>

[oracle@oracleupk 11.2.0]$ . ./PROD_oracleupk.env

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

[oracle@oracleupk PROD_oracleupk]$ cp /u01/appl_top/inst/apps/PROD_oracleupk/admin/out/appsutil.zip .

• Uncompress appsutil.zip under the <RDBMS ORACLE_HOME>.

            [oracle@oracleupk PROD_oracleupk]$ unzip -o appsutil.zip

• Run AutoConfig on the <RDBMS ORACLE_HOME>.           

[oracle@oracleupk PROD_oracleupk]$ ./adautocfg.sh

• Modify Initialization Parameters and bounce database

1. remove entry _disable_fast_validate=TRUE
2. set recyclebin=ON 

SQL> alter system set "_disable_fast_validate"=FALSE SCOPE=BOTH;

System altered.

SQL> ALTER SYSTEM SET recyclebin = ON DEFERRED;

System altered.

 Database tier and application tier:

• Re-run adpreclone.pl on the database tier and the application tier. Since updates included in Oracle E-Business Suite Release 12.1.3 were applied to the system, adpreclone must be run again to apply the updates to the clone directory structures that were used during cloning.

• Now run preclone in db tier first, then in apps tier.

[oracle@oracleupk PROD_oracleupk]$ perl adpreclone.pl dbTier

 

[applmgr@oracleupk scripts]$ perl adpreclone.pl appsTier

•          Apply the language patch of the main patch 9239090 if applicable in your environment. - Not required in our case.

•        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

•       Restart the while Apps Tier and Database Tier.

•      Login to the Oracle EBS and perform a health check of the instance. Now, start testing individual product.