Upgrade Oracle Apps R12.2 to 12.2.2

Install the oracle Applications R12.2.0 Step by Step using the following:

http://www.appsdbatraining.com/2013/09/20/oracle-apps-12-2-2-step-by-step-installation/

Upgrade R12.2.0 to 12.2.2 step by step:

Step:-1

After Installing the 12.2.0 Application, we need to start all the services.

And check the application version using the following command.

SQL> select RELEASE_NAME from FND_PRODUCT_GROUPS;

RELEASE_NAME
————————————————–
12.2.0

Step:-2

SQL> select status from v$instance;
STATUS
————
OPEN

SQL> show user
USER is “APPS”

Reset FND_SQLNET_ACCESS to ALLOW_RESTRICTED

Rapid Install sets the FND_SQLNET_ACCESS Profile option to ALLOW_ALL during an installation or upgrade. Perform the following step to verify the setting of this profile option and reset as needed:

SQL> SELECT profile_option_value FROM fnd_profile_option_values WHERE (application_id,profile_option_id) IN (SELECT application_id,profile_option_id FROM fnd_profile_options WHERE profile_option_name=’FND_SQLNET_ACCESS’);
PROFILE_OPTION_VALUE
——————————————————————————–
ALLOW_RESTRICTED

If the profile_option_value is already set to ALLOW_RESTRICTED, no further action is necessary:

If the profile_option_value is not set to ALLOW_RESTRICTED, execute the following SQL statement:

SQL>UPDATE fnd_profile_option_values SET profile_option_value=’ALLOW_RESTRICTED’ WHERE (application_id,profile_option_id) IN (SELECT application_id,profile_option_id FROM fnd_profile_options WHERE profile_option_name=’FND_SQLNET_ACCESS’);

Step:-3

Copy the Patch p17064510_R12.TXK.C_R12_GENERIC.zip to ”[applmgr@ebiz appl]$ cd /u01/ebiz/apps/oracle/PROD/fs_ne/EBSapps/patch” and change the permission & mode to apps user.

[applmgr@ebiz patch]$ adop phase=apply hotpatch=yes patches=17064510

adop exiting with status = 0 (Success)

After applying the patch we need to check weather patch is apply or not using the following cmd:SQL> select applied_patch_id, last_update_date from ad_applied_patches order by last_update_date;

Step:-4

Goto ”/u01/stage/startCD/Disk1/rapidwiz/bin” and run the following command,

[oracle@ebiz bin]$ addbptchk.sh
Enter the full path of rapidwiz location: /u01/stage
Enter $ORACLE_HOME value : /u01/ebiz/db/oracle/PROD/11.2.0
Setting ORACLE_HOME to : /u01/ebiz/db/oracle/PROD/11.2.0
Please confirm this is the correct value [y/n] :y
Enter database SID : PROD
Setting database SID to: PROD
Please confirm this is the correct SID [y/n] :y
Setting database context to: PROD_ebiz.appsdbatraining.com
Please confirm this is the correct context [y/n] :n
Enter the correct db context : PROD_ebiz.xml
Setting database context to: PROD_ebiz.xml
Please confirm this is the correct context [y/n] :y
Looking for database context file /u01/ebiz/db/oracle/PROD/11.2.0/appsutil/PROD_ebiz.xml.xml
Please confirm this is the correct file [y/n] :n
Enter the absolute path of db context file : /u01/ebiz/db/oracle/PROD/11.2.0/appsutil/PROD_ebiz.xml
Found /u01/ebiz/db/oracle/PROD/11.2.0/appsutil/PROD_ebiz.xml…
The DB version is assumed to be 11.2.0.3.
Pre-req Patch Testing Start Phase : Tue Dec 10 16:00:35 IST 2013
runProcess_1
Rapidwiz location from DB context file is /u01/stage/startCD/Disk1/rapidwiz
Copying templates to temp area
Executing Perl command:
perl -pi -e ‘s/txkTopology_R1220_DB11gR2_11202_Patches.xml/txkTopology_R1220_DB11gR2_11203.xml/g’ /u01/ebiz/db/oracle/PROD/11.2.0/temp/PROD_ebiz.xml/xmldocs/instDB.xml
Can’t open /u01/ebiz/db/oracle/PROD/11.2.0/temp/PROD_ebiz.xml/xmldocs/instDB.xml: No such file or directory.
Copying one-off patches to temp area
Copying /u01/ebiz/db/oracle/PROD/11.2.0/temp/PROD_ebiz.xml/DBInstallHome/fnd/html/txkTopology_R1220_DB11gR2.xml to /u01/ebiz/db/oracle/PROD/11.2.0/temp/PROD_ebiz.xml/cfgHome
Executing command: /u01/stage/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0//bin/java -cp /u01/ebiz/db/oracle/PROD/11.2.0/temp/PROD_ebiz.xml/DBInstallHome/fnd/../j11067593_fnd.zip:/u01/ebiz/db/oracle/PROD/11.2.0/temp/PROD_ebiz.xml/DBInstallHome/fnd/java/3rdparty/stdalone/xmlparserv2.zip -Doracle.apps.fnd.txk.env_home=/u01/ebiz/db/oracle/PROD/11.2.0/temp/PROD_ebiz.xml -Doracle.apps.fnd.txk.runtime.config=/u01/ebiz/db/oracle/PROD/11.2.0/temp/PROD_ebiz.xml/tmp/patch_runtime.xml -Doracle.apps.fnd.txk.AutobuildXML.generate=true -Doracle.apps.fnd.txk.AutobuildXML.file=/u01/ebiz/db/oracle/PROD/11.2.0/temp/PROD_ebiz.xml/tmp/patch_build.xml oracle.apps.fnd.txk.config.InstallService
Log Dir = /u01/ebiz/db/oracle/PROD/11.2.0/temp/PROD_ebiz.xml/logs [ Format=oracle.apps.fnd.txk.install%g.log ]
Using TXK patch template file :/u01/ebiz/db/oracle/PROD/11.2.0/temp/PROD_ebiz.xml/DBInstallHome/fnd/html/txkTopology_R1220_DB11gR2_11203_Patches.xml
Opatch is at the required version
All the required one-offs are present in Oracle Database Home
FINISHED Pre-req Patch Testing : Tue Dec 10 16:00:48 IST 2013

Step:-5

[oracle@ebiz OPatch]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/ebiz/db/oracle/PROD/11.2.0
Central Inventory : /u01/ebiz/db/oraInventory
from : /u01/ebiz/db/oracle/PROD/11.2.0/oraInst.loc
OPatch version : 11.2.0.3.0
OUI version : 11.2.0.3.0
Log file location : /u01/ebiz/db/oracle/PROD/11.2.0/cfgtoollogs/opatch/opatch2013-12-13_12-08-16PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail”not executed
Unable to create Patch Object.
Exception occured : PatchObject constructor: Input file “/u01/ebiz/db/oracle/PROD/11.2.0/OPatch/etc/config/actions” or “/u01/ebiz/db/oracle/PROD/11.2.0/OPatch/etc/config/inventory” does not exist.
OPatch succeeded.

Step:6

[oracle@ebiz 11.2.0]$ export ORACLE_HOME=/u01/ebiz/db/oracle/PROD/11.2.0
[oracle@ebiz 11.2.0]$ export PATH=$PATH:$ORACLE_HOME/OPatch:$ORACLE_HOME/bin
[oracle@ebiz 11.2.0]$ export OBJECT_MODE=32_64

Copy,unzip,chown & chmod the following patches
1.16924879
2.17047617
3.17184721
4.17468141

[oracle@ebiz OPatch]$ cd 17468141/

[oracle@ebiz 17468141]$ which opatch
/u01/ebiz/db/oracle/PROD/11.2.0/OPatch/opatch

[oracle@ebiz 17468141]$ opatch apply online -connectString PROD:sys:sysdba
Patch 17468141 successfully applied
opatch exists with opatch succeeded.

17468141  – PL/SQL COMPILATION THROWS ERROR ORA-4063

Next we need to run the following command:
[oracle@ebiz OPatch]$ opatch lsinventory
opatch exists with opatch succeeded.

Step:-7
Shutdown the Database and Lsnrctl.
[oracle@ebiz 16924879]$ opatch apply
opatch exists with opatch succeeded.

 16924879 – CLEAN UP OBSOLETE ORACLE/QSMA SYNONYMS FROM DB 11.2

Step:-8

[oracle@ebiz 17047617]$ opatch apply
opatch exists with opatch succeeded.

17047617 – MERGE REQUEST ON TOP OF 11.2.0.3.0 FOR BUGS 15967134 12657924

Step:9

[oracle@ebiz 17184721]$ opatch apply
opatch exists with opatch succeeded.

17184721 – CLEAN UP OBSOLETE ORACLE/QSMA SYNONYMS POST INSTALL SCRIPT

Step:-10

Startup the Database and Lsnrctl.

SQL> conn /as sysdba      

SQL> @?/sqlpatch/17184721/postinstall.sql

Step:-11

Stop all the Application Services on the Run file system.
[applmgr@ebiz scripts]$ sh adstpall.sh apps/oracle123
Start up only the Weblogic AdminServer service on the Run File System.
[applmgr@ebiz scripts]$ sh adadminsrvctl.sh start

Step:-12

Copy and unzip the patch 16605855, and also change the permissions. 

[applmgr@ebiz patch]$ adop phase=apply patches=16605855 hotpatch=yes

adop exiting with status = 0 (Success)

Step:-13

Start all the Application Services on the Run file system.
[applmgr@ebiz scripts]$ sh adstrtall.sh apps/oracle123

Step:-14

Apply the 12.2.2 AD and TXK Release Update Packs

If you are upgrading from Release 11i, 12.0.x, or 12.1.x to Release 12.2.2 and have already applied the latest AD and TXK Release Update Packs (the same or higher release version than mentioned in this readme), you can skip this section. The minimum required release versions for AD and TXK upgrading to Release 12.2.2 are R12.AD.C.Delta.2 and R12.TXK.C.Delta.2. To apply the Release 12.2.2 AD and TXK Release Update Packs, see Document 1560906.1, Applying the Release 12.2.2 AD and TXK Release Update Packs.

Apply the 12.2.2 Suite-Wide Release Update Pack

Download and unzip Oracle Applications DBA 12.2.2 Product Release Update Pack (R12.AD.C.Delta.2),Patch 15955263.

Usage:
a. Create $ORACLE_HOME/appsutil/admin on the database server.
b. Copy the higher version of adgrants.sql (UNIX) to $ORACLE_HOME/appsutil/admin.
c. Set the environment to point to ORACLE_HOME on the database server.
d. Use SQL*Plus to run the script:

UNIX:
$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPLSYS

cd 15955263

$ adop phase=prepare
$ adop phase=apply

Step:-15

Download and apply phase for R12.TXK.C.DELTA.2 Patch 15946788.

cd 15946788

$ adop phase=apply

Note: R12.AD.C.DELTA.2 and R12.TXK.C.DELTA.2 must be applied in the same online patching cycle, without merging.

Step:-16

Complete the online patching cycle by running the following commands in the order shown.

$ adop phase=finalize

After that we need to shutdown all the Application & Services
$ adop phase=cutover
$ adop phase=cleanup

Step:-17

Having applied the Release 12.2.2 AD and TXK Release Update Packs, you can now proceed to apply the 12.2.2 Suite-Wide Release Update Pack.

Start an online patching cycle.
$ adop phase=prepare2.

Apply Oracle E-Business Suite Release 12.2.2 Patch 16207672 and Oracle E-Business Suite Release 12.2.2 Online Help Patch 16207673.
$ adop phase=apply patches=16207672,16207673

or cd 16207672
adop phase=apply

and cd 16207673
adop phase=apply

Step:-18

Instantiate the Oracle HTTP Server configuration files ssl.conf and mod_wl_ohs.conf.
Source the patch edition environment file:
$ .$PATCH_BASE/EBSapps/appl/APPS$CONTEXT_NAME.env
$ $ADJVAPRG oracle.apps.ad.autoconfig.InstantiateFile \
-e $CONTEXT_FILE \
-d $FND_TOP/admin/driver/ohstmpl.drv \
-tmpl $FND_TOP/admin/template/ssl_conf_FMW.tmp
$ $ADJVAPRG oracle.apps.ad.autoconfig.InstantiateFile \
-e $CONTEXT_FILE \
-d $FND_TOP/admin/driver/ohstmpl.drv \
-tmpl $FND_TOP/admin/template/mod_wl_ohs_conf_FMW.tmp

Complete the online patching cycle by running the following commands in the order shown.
Source the run edition environment file:
$RUN_BASE/EBSapps/appl/APPS$CONTEXT_NAME.env
$ adop phase=finalize
$ adop phase=cutover
$ adop phase=cleanup

Step:-19

Post-Update Steps

After Upgrade

SQL> select RELEASE_NAME from FND_PRODUCT_GROUPS;

RELEASE_NAME
————————————————–
12.2.2

——-BEFORE YOU EXECUTE BELOW STEP MAKE SURE YOU HAVE atleast 75gb ADDITIONAL FREE SPACE——————-
In my case I was already having 100Gb mount point space, After Installation of R12.2.0 the mount is 54GB occupied,
But after Upgrade this mount got increased to 60GB and when I was executing the below step it error ed out saying
there is lack of space. and Suggesting me to add another 35GB to the existing mount point. So have atleast 150GB
mount point space for installation and upgrade of R12.2.2 application.
—————————————————————————————————————
Synchronize file systems:

Synchronize the file systems using the command shown below. This action will copy the new run edition code and configuration to the —-other file system, to help the next online patching cycle complete faster.

$ adop phase=fs_clone

This finishes the Upgrade of R12.2.0 to R12.2.2

Ref:
Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1)

Oracle E-Business Suite Applications DBA (AD) Release Notes for Release 12.2 (Doc ID 1376487.1)

 

 

 

 

 

Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."