Oracle Apps 12.2.3 Installation

Installation:

First we need to Install Oracle Enterprise Linux using the following url
http://www.appsdbatraining.com/2013/01/26/oracle-enterprise-linux-5-7-installation/

Next we need to download Oracle E-Business Suite Release 12.2 Media Pack for Linux x86-64-bit software from  https://edelivery.oracle.com/EPD/Download/get_form?egroup_aru_number=17075454

A1

 

 

 

 

 

 

 

 

Download following zip files:

Zips

 

 

 

 

 

 

 

 

 

We need to create the user and group as following:

[root@ebiz1 ~]# hostname
ebiz1.appsdbatraining.com
[root@ebiz1 ~]# hostname -i
192.168.1.88
[root@ebiz1 ~]# groupadd dba
[root@ebiz1 ~]# useradd -g dba oracle
[root@ebiz1 ~]# useradd -g dba applmgr
[root@ebiz1 ~]# mkdir -p /u01/ebiz/db
[root@ebiz1 ~]# mkdir -p /u01/ebiz/apps
[root@ebiz1 ~]# chown -R oracle:dba /u01/ebiz/db
[root@ebiz1 ~]# chown -R applmgr:dba /u01/ebiz/apps

We need to copy the all above zip files into /u01/Stage/ and change the permission to oracle:dba and change the
mode(chmod 775 /u01/zipfiles)

Create the oraInventory Directory as following:
[root@ebiz1 ~]# mkdir -p /u01/db/oraInventory
[root@ebiz1 ~]# chown -R oracle:dba /u01/ebiz/db/oraInventory
[root@ebiz1 ~]# chmod -R 775 /u01/ebiz/db/oraInventory

goto /etc and edit the oraInst.loc file and set the oraInventory location as following:

[root@apps etc]# vi oraInst.loc
inventory_loc=/u01/db/oraInventory

[root@apps etc]# cat oraInst.loc
inventory_loc=/u01/db/oraInventory

Installation:

Goto the zip files location through root user and unzip the following zip file only

[root@ebiz1 Stage]# unzip -o p17445880_R12_GENERIC.zip
[root@ebiz1 rapidwiz]# pwd
/u01/Stage/startCD/Disk1/rapidwiz

[root@ebiz1 bin]# pwd
/u01/Stage/startCD/Disk1/rapidwiz/bin

[root@ebiz1 bin]# sh buildStage.sh

Build Stage Menu
——————————————————
1. Create new stage area
2. Copy new patches to current stage area.
3. Display existing files in stage TechPatches.
4. Exit menu

Enter your choice [4]: 1

Rapid Install Platform Menu
——————————————————
1. Oracle Solaris SPARC (64-bit)
2. Linux x86-64
3. IBM AIX on Power Systems (64-bit)
4. HP-UX Itanium
5. Exit Menu

Enter your choice [5]: 2

Please enter the directory containing the zipped installation media:
/u01/Stage

Done Copying additional patches

Verifying stage area…

Directory /u01/Stage/TechInstallMedia is valid
Directory /u01/Stage/TechPatches/DB is valid
Directory /u01/Stage/TechPatches/MiddleTier is valid
Directory /u01/Stage/EBSInstallMedia/AppDB is valid
Directory /u01/Stage/EBSInstallMedia/Apps is valid
Directory /u01/Stage/EBSInstallMedia/AS10.1.2 is valid
Directory /u01/Stage/TechInstallMedia/database is valid
Directory /u01/Stage/TechInstallMedia/ohs11116 is valid
Directory /u01/Stage/TechInstallMedia/wls1036_generic is valid

Stage area verified.

Stage area verified.

Press enter to continue…

Build Stage Menu
——————————————————
1. Create new stage area
2. Copy new patches to current stage area.
3. Display existing files in stage TechPatches.
4. Exit menu

Enter your choice [4]: 4
Now, we start the Installation through root user as following:

[root@apps rapidwiz]# pwd

/u01/Stage/startCD/Disk1/rapidwiz

[root@apps rapidwiz]# ./rapidwiz

ebiz_apps1

 

Click Next:

ebiz_apps2Click Next:

ebiz_apps3

Click Next:

ebiz_apps4

Select yes and click Next:

ebiz_apps5

Click Next:

ebiz_apps6

Select create new configuration and click next:

ebiz_apps7

Choose your file system port poll and click next:

ebiz_apps8

Enter the Database Node Configuration and click next:

ebiz_apps9

Click next:

ebiz_apps10

Click Next:

ebiz_apps11

Click Next:

ebiz_apps12

Click Next:

ebiz_apps13

Enter the Apps node configurations and click next:

ebiz_apps14

Click Next:

ebiz_apps15Click Next:

ebiz_apps16

Click Next:

ebiz_apps17

Click Next:

ebiz_apps18

Click Next:

ebiz_apps19

Select yes

ebiz_apps20

 

ebiz_apps28

 

ebiz_apps29

ebiz_apps30

Click Next:

ebiz_apps31Click finish:

ebiz_apps32

Now, we successfully Installed Oracle Apps-12.2.0

SQL> select RELEASE_NAME from fnd_product_groups;
RELEASE_NAME
————————————————–
12.2.0

Next we need to upgrade 12.2.0 to 12.2.3 following steps:

http://www.appsdbatraining.com/2013/12/25/oracle-apps-12-2-3-released/

Step-1:

Shutdown all the Database and Application Services.

[applmgr@ebiz1 appl]$ pwd
/u01/apps/PROD/fs1/inst/apps/PROD_ebiz1/admin/scripts/

[applmgr@ebiz1 scripts]$ sh adstpall.sh apps/oracle123

Shut down Database and Database Listner.

Step-2:

Backup the Opatch Directory and apply the database patch.

[oracle@ebiz1 11.2.0]$ cp -R OPatch OPatch_bkp
[oracle@ebiz1 11.2.0]$ pwd
/u01/ora/PROD/11.2.0
[oracle@ebiz1 11.2.0]$ export ORACLE_HOME=/u01/ora/PROD/11.2.0/
[oracle@ebiz1 11.2.0]$ export PATH=$PATH:$ORACLE_HOME/OPatch:$ORACLE_HOME/bin
[oracle@ebiz1 11.2.0]$ export OBJECT_MODE=32_64
Copy Patch 17875948 to opatch directory
[oracle@ebiz1 OPatch]$ unzip p17875948_112030_Linux-x86-64.zip
[oracle@ebiz1 OPatch]$ cd 17875948/
[oracle@ebiz1 17875948]$ opatch apply
[oracle@ebiz1 17875948]$ !sq
SQL> startup
SQL> exit
[oracle@ebiz1 17875948]$ sqlplus /nolog
SQL> conn /as sysdba
SQL> @?/sqlpatch/17875948/postinstall.sql
(VI) Bugs Fixed by This Patch
The following are the bugs fixed by this patch:
14158012: [LRGDBCONS4XS] ORA-600 [KKZLPLLG:5] ENCOUNTERED ON WINDOWS
14215010: TRACKING BUG FOR LRG 6950246 6950260 INCLUSION IN MAIN
14465787: UNABLE TO REMOVE COMMENTS FROM A VIEW
17654622: APPSST11204: MANY ERRORS IN IMPORT DUE TO INTERNAL MAPPED EDITION SCHEMAS.

Step-3:

Shutdown all the services:
Download the patch 17495356
Copy patch file to fs1&fs2
[root@ebiz1 20140109_1052]# chown -R applmgr:dba /u01/apps/PROD/fs1/FMW_Home/utils/bsu/cache_dir
[root@ebiz1 20140109_1052]# chown -R applmgr:dba /u01/apps/PROD/fs2/FMW_Home/utils/bsu/cache_dir
[root@ebiz1 20140109_1052]# chmod -R 775 /u01/apps/PROD/fs2/FMW_Home/utils/bsu/cache_dir/p17495356_1036_Generic.zip
[root@ebiz1 20140109_1052]# chmod -R 775 /u01/apps/PROD/fs1/FMW_Home/utils/bsu/cache_dir/p17495356_1036_Generic.zip
IN fs1:
[applmgr@ebiz1 cache_dir]$ unzip p17495356_1036_Generic.zip
[applmgr@ebiz1 bsu]$ pwd
/u01/apps/PROD/fs1/FMW_Home/utils/bsu
[applmgr@ebiz1 bsu]$ ls
bsu.jar bsu.sh cache_dir patch-client.jar smartupdate.ico
[root@ebiz1 20140109_1052]# xhost +
access control disabled, clients can connect from any host
[applmgr@ebiz1 bsu]$ ./bsu.sh

smart update

 

smart update1

 

smart update2

Click Green Arrow:

smart update3

Click Ok:

smart update4

Click Ok:

smart update5

Now Patch 17495356 successfully updated of fs1.

Next we can apply the patch 17495356 on fs2 using above screens.

Step-4:

After Applying the Smartupdate patch on fs1&fs2, we need to start Database, DB Listner & Admin server
[applmgr@ebiz1 bsu]$ cd /u01/apps/PROD/fs1/EBSapps/appl/
[applmgr@ebiz1 appl]$ . ./APPSPROD_ebiz1.env
[applmgr@ebiz1 appl]$ cd /u01/apps/PROD/fs1/inst/apps/PROD_ebiz1/admin/scripts/
[applmgr@ebiz1 scripts]$ sh adadminsrvctl.sh start
Download the Patch p17204589 , and copy to fn_ne/Ebiz/patch
[root@ebiz1 20140109_1052]# cd /u01/apps/PROD/fs_ne/EBSapps/patch/
[root@ebiz1 patch]# chown -R applmgr:dba p17204589_12.2.0_R12_GENERIC.zip
[root@ebiz1 patch]# chmod -R 775 p17204589_12.2.0_R12_GENERIC.zip
[applmgr@ebiz1 scripts]$ cd /u01/apps/PROD/fs_ne/EBSapps/patch/
[applmgr@ebiz1 patch]$ unzip p17204589_12.2.0_R12_GENERIC.zip
[applmgr@ebiz1 17204589]$ pwd
/u01/apps/PROD/fs_ne/EBSapps/patch/17204589
[applmgr@ebiz1 17204589]$ adop phase=apply patches=17204589 hotpatch=yes

Step-5:

Next Copy and Unzip p17021789_R12.TXK.C_R12_GENERIC&p17023760_R12.AD.C_R12_LINUX to fs_ne/patch
[root@ebiz1 patch]# chown -R applmgr:dba p17023760_R12.AD.C_R12_LINUX.zip p17021789_R12.TXK.C_R12_GENERIC.zip
[root@ebiz1 patch]# chmod -R 775 p17023760_R12.AD.C_R12_LINUX.zip p17021789_R12.TXK.C_R12_GENERIC.zip
[applmgr@ebiz1 patch]$ pwd
/u01/apps/PROD/fs_ne/EBSapps/patch
[applmgr@ebiz1 patch]$ ls
17204589 p17021789_R12.TXK.C_R12_GENERIC.zip p17023760_R12.AD.C_R12_LINUX.zip p17204589_12.2.0_R12_GENERIC.zip
[applmgr@ebiz1 patch]$ unzip p17021789_R12.TXK.C_R12_GENERIC.zip
[applmgr@ebiz1 patch]$ unzip p17023760_R12.AD.C_R12_LINUX.zip

[oracle@ebiz1 appsutil]$ pwd
/u01/ora/PROD/11.2.0/appsutil
[oracle@ebiz1 appsutil]$ mkdir -p admin
[oracle@ebiz1 appsutil]$ chown -R oracle:dba /$ORACLE_HOME/appsutil/admin
[oracle@ebiz1 appsutil]$ chmod -R 775 /$ORACLE_HOME/appsutil/admin

[applmgr@ebiz1 admin]$ pwd
/u01/apps/PROD/fs_ne/EBSapps/patch/17023760/admin
[root@ebiz1 admin]# cp -R adgrants.sql /u01/ora/PROD/11.2.0/appsutil/admin
[root@ebiz1 admin]# chown -R oracle:dba /u01/ora/PROD/11.2.0/appsutil/admin/adgrants.sql
[root@ebiz1 admin]# chmod -R 775 /u01/ora/PROD/11.2.0/appsutil/admin/adgrants.sql

[oracle@ebiz1 admin]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jan 21 18:19:47 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPS;

[applmgr@ebiz1 17023760]$ adop phase=apply patches=17023760 hotpatch=yes
[applmgr@ebiz1 17021789 ]$ adop phase=apply patches=17023760 hotpatch=yes

Step-6:

After that Stop all the application services and start only Admin Server:
[applmgr@ebiz1 scripts]$ sh adstpal.sh apps/oracle123
[applmgr@ebiz1 scripts]$ sh adadminsrvctl.sh start
[applmgr@ebiz1 scripts]$ adop phase=prepare
And Copy & unzip the softwares to fs_ne/patch (17020683&17020685) and change the permissions to applmgr and chmod

[applmgr@ebiz1 scripts]$ adop phase=apply patches=17020683,17020685
Tablespace Issue
Add Datafile to the tablespace
[applmgr@ebiz1 scripts]$ adop restart=yes phase=apply patches=17020683,17020685

adop exiting with status = 0 (Success)

Step-7:

[applmgr@ebiz1 appl]$ echo $PATCH_BASE
/u01/apps/PROD/fs2
$ . $PATCH_BASE/EBSapps/appl/APPS$CONTEXT_NAME.env
[applmgr@ebiz1 appl]$ pwd
/u01/apps/PROD/fs2/EBSapps/appl
[applmgr@ebiz1 appl]$ . ./APPSPROD_ebiz1.env

[applmgr@ebiz1 appl]$ $ADJVAPRG oracle.apps.ad.autoconfig.InstantiateFile \

[applmgr@ebiz1 appl]$ $ADJVAPRG oracle.apps.ad.autoconfig.InstantiateFile \

[applmgr@ebiz1 appl]$ $ADJVAPRG oracle.apps.ad.autoconfig.InstantiateFile \

[applmgr@ebiz1 appl]$ perl $FND_TOP/patch/115/bin/txkSetAppsConf.pl \

[applmgr@ebiz1 appl]$ . ./APPSPROD_ebiz1.env
. $RUN_BASE/EBSapps/appl/APPS$CONTEXT_NAME.env

[applmgr@ebiz1 appl]$ adop phase=finalize
adop exiting with status = 0 (Success)

[applmgr@ebiz1 appl]$ adop phase=cutover
adop exiting with status = 0 (Success)

[applmgr@ebiz1 appl]$ adop phase=cleanup
adop exiting with status = 0 (Success)

[applmgr@ebiz1 appl]$ adop phase=fs_clone
adop exiting with status = 0 (Success)

SQL> select RELEASE_NAME from fnd_product_groups;
RELEASE_NAME
————————————————–
12.2.3

Now, Oracle Apps 12.2.3 Upgradation completed successfully

Nagulu Polagani

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

Comments

  1. It is very helpfull for me to upgrade 12.2.0 to 12.2.3.
    It is very clear to each and every step to upgrade.
    Keep it up. Thanks alot for your post. 🙂

    Good job..