Oracle E-Business suite 12.2.6 Installation on Oracle Linux 6.8 (64 bit)

Version 2

MD. KAZIUl ISLAM BULBUL

DATE : 2ND APRIL 2017 (v1)

update : 2nd may 2017 (v2)

DHAKA, BANGLADESH

Table of Contents

1. Reference Document

2. High Level Installation Steps

3. Patch Download

4. Stage Preparation

5. Operating System Prerequisite

6. Check System Prerequisite using Oracle Remote Diagnostic Agent

7. VNC Server Configuration

8. Base Version 12.2.0 Installation

9. Apply Required Database Patches

10. Apply Required Application Tier Patches

11. Apply Consolidated Seed Table Upgrade Patch

12. Apply the Latest AD and TXK Delta Release Update Packs

13. Apply Oracle E-Business Suite 12.2.6 Release Update Pack

14. Post-Update Steps

15. Startup /Shutdown Steps

1. Reference Document

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

b) Oracle E-Business Suite Release 12.2.6 Readme (Doc ID 2114016.1)

c) Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)

d) Oracle E-Business Suite 12.2 Patching Technology Components Guide (Doc ID 1355068.1)

e) Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)

f) Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1)

g) How to Change Temporary Directories in Apps? (Doc ID 469377.1)

2. High Level Installation Steps

a) Configure Operating System prerequisite for R12.2.6 and 12c Database

b) Install R12.2.0 with 12c Database using startcd 51.

c) Run ETCC in both database tier and Application tier to get the list of required patches and apply.

d) Upgrade to AD.C.8 and TXK.C.8

e) Apply the R12.2.6 upgrade patch

f) FS_CLONE for filesystem cloning

g) Apply the Help patch.

3. Patch Download

Download required installer https://edelivery.oracle.com and patch from https://support.oracle.com site.

a) Download Rapid Install Startcd 12.2.0.51 (Patch 22066363)

b) Download EBS Installation Packages, Oracle E-Business Suite (12.2.0)

a. V100053-01_2of2.zip Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 1

b. V100053-01_1of2.zip Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 1

c. V100054-01.zip Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 2

d. V100055-01.zip Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 3

e. V100056-01.zip Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 4

f. V100057-01.zip Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 5

g. V100058-01.zip Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 6

h. V100059-01_1of2.zip Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 1

i. V100059-01_2of2.zip Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 1

j. V100060-01_3of3.zip Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 2

k. V100060-01_2of3.zip Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 2

l. V100060-01_1of3.zip Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 2

m. V100061-01.zip Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Technology one-off Patches

n. V35802-01.zip Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install AS10.1.2

o. V35803-01_1of3.zip Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 1

p. V35803-01_2of3.zip Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 1

q. V35803-01_3of3.zip Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 1

r. V35804-01_1of2.zip Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 2

s. V35804-01_2of2.zip Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 2

t. V46095-01_1of2.zip Oracle Database 12c Release 1 (12.1.0.2.0)

u. V46095-01_2of2.zip Oracle Database 12c Release 1 (12.1.0.2.0)

v. V100102-01.zip Oracle Database 12c Release 1 (12.1.0.2.0) EXAMPLES for Linux x86-64

w. V29856-01.zip Oracle WebLogic Server 11gR1 (10.3.6) Generic and Coherence

x. V75792-01.zip Oracle Fusion Middleware Web Tier Utilities 11g Patch Set 7 (11.1.1.9.0) for Linux x86-64

c) Download Oracle E-Business Suite Release 12.2.6 Update Pack for Linux x86-64

a. V776670-01_10of10.zip Oracle E-Business Suite Release 12.2.6 Update Pack for Linux x86-64

b. V776670-01_1of10.zip Oracle E-Business Suite Release 12.2.6 Update Pack for Linux x86-64

c. V776670-01_2of10.zip Oracle E-Business Suite Release 12.2.6 Update Pack for Linux x86-64

d. V776670-01_3of10.zip Oracle E-Business Suite Release 12.2.6 Update Pack for Linux x86-64

e. V776670-01_4of10.zip Oracle E-Business Suite Release 12.2.6 Update Pack for Linux x86-64

f. V776670-01_5of10.zip Oracle E-Business Suite Release 12.2.6 Update Pack for Linux x86-64

g. V776670-01_6of10.zip Oracle E-Business Suite Release 12.2.6 Update Pack for Linux x86-64

h. V776670-01_7of10.zip Oracle E-Business Suite Release 12.2.6 Update Pack for Linux x86-64

i. V776670-01_8of10.zip Oracle E-Business Suite Release 12.2.6 Update Pack for Linux x86-64

j. V776670-01_9of10.zip Oracle E-Business Suite Release 12.2.6 Update Pack for Linux x86-64

4. Stage Preparation

[root@erpdev ~]# mkdir –p /u01/Stage122

[root@erpdev ~]# unzip p22066363_R12_GENERIC.zip

[root@erpdev ~]# cd /u01/Stage122/startCD/Disk1/rapidwiz/bin

[root@erpdev ~]# ./buildStage.sh

Oracle E-Business Suite Rapid Install
Version 12.2.0

Press Enter to continue...
Build Stage Menu
------------------------------------------------------
1. Create new stage area
2. Copy patches to existing stage area
3. List files in TechPatches directory
4. Exit menu

Enter your choice [4]: 1

Rapid Install Platform Menu

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

Enter your choice [5]: 2

……………………..

Specify the directory containing the zipped installation media:

/u01/EBS_Installer/12.2.6

…………………………..

Unzip command is: /u01/ Stage122/startCD/Disk1/rapidwiz/unzip/Linux_x64/unzip -o

Unzipping V35802-01.zip

Unzipping V35803-01_1of3.zip

Unzipping V35803-01_2of3.zip

Unzipping V35803-01_3of3.zip

Unzipping V35804-01_1of2.zip

Unzipping V35804-01_2of2.zip

Unzipping V46095-01_1of2.zip

Unzipping V46095-01_2of2.zip

Unzipping V100059-01_1of2.zip

Unzipping V100059-01_2of2.zip

Unzipping V100060-01_1of3.zip

Unzipping V100060-01_2of3.zip

Unzipping V100060-01_3of3.zip

Unzipping V100053-01_1of2.zip

Unzipping V100053-01_2of2.zip

Unzipping V100054-01.zip

Unzipping V100055-01.zip

Unzipping V100056-01.zip

Unzipping V100057-01.zip

Unzipping V100058-01.zip

Unzipping V100061-01.zip

Unzipping V100102-01.zip

Unzipping V75792-01.zip

Unzipping V29856-01.zip

……………………………

Finished unzipping shiphome.

Unzipping Oracle Software Delivery Cloud one-off patches...

Press Enter to continue...

……………………………

Finished unzipping Oracle Software Delivery Cloud one-off patches.

Press Enter to continue...

……………………………

Finished copying additional patches.

Verifying stage area...

Directory /u01/Stage122/TechInstallMedia is valid.

Directory /u01/Stage122/TechPatches/DB is valid.

Directory /u01/Stage122/TechPatches/MiddleTier is valid.

Directory /u01/Stage122/EBSInstallMedia/AppDB is valid.

Directory /u01/Stage122/EBSInstallMedia/Apps is valid.

Directory /u01/Stage122/EBSInstallMedia/AS10.1.2 is valid.

Directory /u01/Stage122/TechInstallMedia/database is valid.

Directory /u01/Stage122/TechInstallMedia/ohs11119 is valid.

Directory /u01/Stage122/TechInstallMedia/wls1036_generic is valid.

Stage area verified.

Press Enter to continue...

5. Operating System Prerequisite

a) Installing rpms for EBS 12.2 and RDBMS 12C

[root@erpdev ~]# cd /etc/yum.repos.d

[root@erpdev ~]# wget http://public-yum.oracle.com/public-yum-ol6.repo

[root@erpdev ~]# vi public-yum-ol6.repo

[ol6_latest]

gpgcheck=1

enabled=1

[ol6_addons]

gpgcheck=1

enabled=1

#[ol6_UEK_latest]

#gpgcheck=1

#enabled=1

[root@erpdev ~]# yum update

[root@erpdev ~]# yum install –y oracle-ebs-server-R12-preinstall

[root@erpdev ~]# yum install –y oracle-rdbms-server-12cR1-preinstall

b) Check all rpms using below command

[root@erpdev ~]# rpm -qa --qf "%{n}-%{v}-%{r}.%{arch}\n" | grep openmotif21

openmotif21-2.1.30-11.EL6.i686

Run ldconfig –v command to relink all symbolic libraries

[root@erpdev ~]# ldconfig –v

c) Create soft link for library as below for 10.1.2 Server

[root@erpdev ~]# ls -lrt /usr/lib/libXtst.so.6

lrwxrwxrwx. 1 root root 16 Feb 20 20:53 /usr/lib/libXtst.so.6 -> libXtst.so.6.1.0

[root@erpdev ~]# unlink /usr/lib/libXtst.so.6

[root@erpdev ~]# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

[root@erpdev ~]# ls -lrt /usr/lib/libXtst.so.6

lrwxrwxrwx 1 root root 29 Feb 25 16:12 /usr/lib/libXtst.so.6 -> /usr/X11R6/lib/libXtst.so.6.1

[root@erpdev ~]# ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

d) Check Threading model in Linux should be NPTL

[root@erpdev ~]# getconf GNU_LIBPTHREAD_VERSION

NPTL 2.12

e) Disable selinux and shutdown iptables,ip6tables services also on run levels

[root@erpdev ~]# vi /etc/selinux/config

change SELINUX=enforcing to SELINUX=disabled

[root@erpdev ~]# service iptables stop
[root@erpdev ~]# service ip6tables stop

[root@erpdev ~]# chkconfig --level 0123456 ip6tables off
[root@erpdev ~]# chkconfig --level 0123456 iptables off

f) Check kernel settings for the parameters are correctly set

Note: If the current value for any parameter is higher than the value listed in the following table, then do not change the value of that parameter.

[root@erpdev ~]# vi /etc/sysctl.conf

# kernel.semmsl 256
# kernel.semmns 32000
# kernel.semopm 100
# kernel.semmni 142

kernel.sem = 250 32000 100 142
kernel.shmall = 20971524
kernel.shmmax Half the size of the physical memory (in bytes), and at least 42949672952
kernel.shmmni = 4096
kernel.msgmax = 8192
kernel.msgmnb = 65535
kernel.msgmni = 2878
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
net.ipv4.tcp_tw_recycle = 05
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

Note : Parameter kernel.sem = 250 32000 100 128 is changed to kernel.sem = 250 32000 100 142

g) Check Domain Name System (DNS) Resolver Parameters , it should be below

[root@erpdev ~]# vi /etc/resolv.conf

nameserver 192.168.100.252

nameserver 8.8.8.8

options attempts:5

options timeout:15

h) Verifying Host Names

[root@erpdev ~]# vi /etc/hosts

127.0.0.1 localhost.localdomain localhost

::1 localhost.localdomain localhost

192.168.1.113 erpdev.dblgroup.com erpdev

i) Verify that the /etc/sysconfig/network file is formatted as follows

[root@erpdev ~]# vi /etc/sysconfig/network

NETWORKING=yes

HOSTNAME=erpdev.dblgroup.com

# oracle-rdbms-server-12cR1-preinstall : Add NOZEROCONF=yes

NOZEROCONF=yes

If the /etc/sysconfig/networking/profiles/default/network file exists, remove it.

[root@erpdev ~]# rm -rf /etc/sysconfig/networking/profiles/default/network

j) Modify ulimit settings in limits.conf

[root@erpdev ~]# vi /etc/security/limits.conf

* hard nofile 65536

* soft nofile 4096

* hard nproc 16384

* soft nproc 2047

* hard stack 16384

* soft stack 10240

k) Swap space on the system be 16 GB or more

[root@erpdev ~]# grep SwapTotal /proc/meminfo

SwapTotal: 4194300 kB

l) Create OS group, User

[root@erpdev ~]# groupadd dba

[root@erpdev ~]# useradd –g dba erpdev

[root@erpdev ~]# passwd erpdev

m) Create directories and change permissions

[root@erpdev ~]# mkdir –p /u01/ERPDEV
[root@erpdev ~]# mkdir –p /u01/ERPDEV/temp

[root@erpdev ~]# chmod –R 775 /u01/ERPDEV

[root@erpdev ~]# chown –R erpdev:dba /u01/ERPDEV

n) Create Inventory

[root@erpdev ~]# mkdir –p /u01/ERPDEV/oraInventory

[root@erpdev ~]# chown -R erpdev.dba /u01/ERPDEV/oraInventory/

[root@erpdev ~]# vi /etc/oraInst.loc

inventory_loc=/u01/ERPDEV/oraInventory
inst_group=dba

6. Check System Prerequisite using Oracle Remote Diagnostic Agent

Download and Unzip Patch p21769913_81517314_Linux-x86-64.zip

[root@erpdev ~]# cd rda

[root@erpdev ~]# ./rda.sh -T hcve

Run rda for the below Rule Sets and make sure there is no failed result,

a) Oracle Database 12c R1 (12.1.0) Preinstallation (Linux)

b) Oracle E-Business Suite Release 12 (12.2.0) Preinstall (Linux x86_64)

7. VNC Server Configuration

[root@erpdev ~]# yum install tigervnc-server*

[root@erpdev ~]# vi /etc/sysconfig/vncservers

VNCSERVERARGS[2]=”-geometry 1280×1024

[root@erpdev ~]# chkconfig vncserver on
[root@erpdev ~]# vncpasswd

[root@erpdev ~]# service vncserver start

[root@erpdev ~]# vi /etc/ssh/sshd_config

X11Forwarding yes

X11DisplayOffset 10

[root@erpdev ~]# vi /etc/ssh/ssh_config

ForwardX11 yes

[root@erpdev ~]# /etc/init.d/sshd restart

[root@erpdev ~]# su - root

[root@erpdev ~]# vncserver –kill :2

[root@erpdev ~]# vncserver :2

8. Base Version 12.2.0 Installation

Check Rapid Wizard Version and start Installation

[root@erpdev ~]# export DISPLAY=:2

[root@erpdev ~]# xhost +

[root@erpdev ~]# ./rapidwiz -version

Version 12.2.0.51

[root@erpdev ~]# unset ENV
[root@erpdev ~]# export TEMP=/u01/ERPDEV/temp

[root@erpdev ~]# cd /u01/Stage122/startCD/Disk1/rapidwiz/

[root@erpdev rapidwiz]# ./rapidwiz

9. Apply Required Database Patches

a) Document Reference for this Section

a. Doc ID 1594274.1

b. Doc ID 2114016.1

Download Patch p17537119_R12_GENERIC.zip

The EBS Technology Codelevel Checker (ETCC) utility provides two scripts you can run to help ensure you have the necessary database and application tier bugfixes installed on your Oracle E-Business Suite Release 12.2 system.

b) For Database Tier

a. Download and apply latest PSU Patch p24732082_121020_Linux-x86-64.zip.

[ebscrp@erptest 12.1.0]$ . *.env

[ebscrp@erptest 24732082]$ export PATH=$PATH:/u01/DBLTEST/12.1.0/OPatch/

[dbltest@erpdev ~]$ unzip p24732082_121020_Linux-x86-64.zip

[dbltest@erpdev ~]$ cd 24732082

                          [dbltest@erpdev  24732082]$  opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :

……………………………….

18485835, 20476776, 24732082

………………………………...

[dbltest@erpdev 24732082]$ opatch rollback –id 18485835

[dbltest@erpdev 24732082]$ opatch rollback –id 20476776

             [dbltest@erpdev 24732082]$  ]$  opatch prereq  CheckConflictAgainstOHWithDetail -ph ./

                          ………………………………….

                          Prereq "checkConflictAgainstOHWithDetail" passed.

                          ………………………………….

Ensure that you shut down all the services running from the Oracle home.

[dbltest@erpdev ~]$ opatch apply

[dbltest@erpdev ~]$ sqlplus /nolog

SQL> Connect / as sysdba

SQL> startup

SQL> quit

[dbltest@erpdev ~]$ cd /u01/DBLTEST/12.1.0/OPatch/

[dbltest@erpdev OPatch]$ ./datapatch -verbose

b. Run etcc on DB Tier

[dbltest@erpdev ~]$ mkdir –p $ORACLE_HOME/appsutil/etcc

[dbltest@erpdev ~]$ unzip p17537119_R12_GENERIC.zip

Copy below 4 files to new etcc directory,

i. checkDBpatch.sh

ii. checkDBpatch.cmd

iii. txk_R1220_DB_base_bugs.xml

iv. txk_R1220_DB_mappings.xml

[dbltest@erpdev ~]$ cd $ORACLE_HOME/appsutil/etcc
[dbltest@erpdev etcc]$ sh checkDBpatch.sh

PATCH RECOMMENDATION SUMMARY AFTER LATEST PSU PATCH 24732082 APPLIED

============================================================

Oracle Database Release 12.1.0.2 (PATCHSET UPDATE 12.1.0.2.170117)

-------------------------------------------------------------------------------

Patch 24568754 [12.1.0.2.161018 version]

- Filename: p24568754_12102161018_Linux-x86-64.zip

Patch 24566317 [12.1.0.2.160719 version]

- Filename: p24566317_12102160719_Linux-x86-64.zip

Patch 25128602 [12.1.0.2.170117 version]

- Filename: p25128602_12102170117_Linux-x86-64.zip

Patch 20766180 [12.1.0.2.4 version]

- Filename: p20766180_121024_Generic.zip

Patch 21321429 [12.1.0.2.170117 version]

- Filename: p21321429_12102170117_Generic.zip

Patch 21967332 [12.1.0.2.160419 version]

- Filename: p21967332_12102160419_Linux-x86-64.zip

Patch 22338374 [12.1.0.2.160119 version]

- Filename: p22338374_12102160119_Linux-x86-64.zip

Patch 24326444 [12.1.0.2.161018 version]

- Filename: p24326444_12102161018_Linux-x86-64.zip

Patch 24560906 [12.1.0.2.5 version]

- Filename: p24560906_121025_Linux-x86-64.zip

Apply the required patches and rerun this script

You should check the patch READMEs for minimum opatch version requirements.

The latest opatch is available from My Oracle Support via Patch 6880880.

+-----------------------------------------------------------------------------+

A consolidated zip file with the required patches for Database release

12.1.0.2.170117 is available on My Oracle Support via:

Patch 25201332 [12.1.0.2.170117 version]

- EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR JAN 2017

Note: This zip does not include any database bundle patches or PSUs.

+-----------------------------------------------------------------------------+

See Doc ID 1147107.1 for any special instructions for these patches.

Note: Footnotes in Doc ID 1594274.1 also apply to corresponding overlay patches.

Stored Technology Codelevel Checker results in the database dbltest successfully.

Finished prerequisite patch testing : Sat Mar 11 13:38:09 BDT 2017

Log file for this session: ./checkDBpatch_47684.log

c) Apply the below patches using opatch

1	24568754
2	24566317
3	18793246
4	25128602
5	20766180
6	22098146
7	21321429
8	21864513
9	21904072
10	21967332
11	22338374
12	22731026
13	24326444
14	24560906

[dbltest@erpdev ~]$ export PATH=$PATH:$ORACLE_HOME/OPatch

To Check the patch applied or not use below command

[dbltest@erpdev ~]$ opatch lsinventory | grep 19908836

Download Patch p25201332_12102170117_Linux-x86-64.zip for all the etcc-bundle patches.

Ensure that you shut down all the services running from the Oracle home.

[dbltest@erpdev ~]$ unzip p25201332_12102170117_Linux-x86-64.zip

[dbltest@erpdev ~]$ cd etcc-bundle/LINUX_X86-64/database/12.1.0.2.170117

Minimum OPatch version required is 12.1.0.1.4

[dbltest@erpdev ~]$ cd $ORACLE_HOME/OPatch

[dbltest@erpdev ~]$ ./opatch version

OPatch Version: 12.1.0.1.10

Apply all the patches using opatch.

[dbltest@erpdev ~]$ unzip p24568754_12102161018_Linux-x86-64.zip

[dbltest@erpdev ~]$ cd 24568754

[dbltest@erpdev 24568754]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

[dbltest@erpdev 24568754]$ opatch apply

Start the services from the Oracle home

[dbltest@erpdev 24568754]$ cd $ORACLE_HOME/OPatch

[dbltest@erpdev OPatch]$ datapatch

Ensure that you shut down all the services running from the Oracle home.

[dbltest@erpdev 12.1.0.2.170117]$ unzip p24566317_12102160719_Linux-x86-64.zip

[ebscrp@erptest 24566317]$ opatch lsinventory | grep 23054246

Sub-patch 23054246; "Database Patch Set Update : 12.1.0.2.160719 (23054246)"

[dbltest@erpdev 12.1.0.2.170117]$ cd 24566317

[dbltest@erpdev 24566317]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

[dbltest@erpdev 24566317]$ opatch apply

[dbltest@erpdev 12.1.0.2.170117]$ unzip p18793246_121020_Generic.zip

[dbltest@erpdev 12.1.0.2.170117]$ cd 18793246

[dbltest@erpdev 18793246]$ opatch apply

[dbltest@erpdev 18793246]$ cd $ORACLE_HOME/OPatch

[dbltest@erpdev OPatch]$ datapatch

Ensure that you shut down all the services running from the Oracle home.

[dbltest@erpdev 12.1.0.2.170117]$ unzip p25128602_12102170117_Linux-x86-64.zip

[dbltest@erpdev 12.1.0.2.170117]$ cd 25128602

[dbltest@erpdev 25128602]$ opatch apply

[dbltest@erpdev 12.1.0.2.170117]$ unzip p20766180_121024_Generic.zip

[dbltest@erpdev 12.1.0.2.170117]$ cd 20766180

[dbltest@erpdev 20766180]$ opatch apply –local

[dbltest@erpdev 12.1.0.2.170117]$ unzip p22098146_121020_Linux-x86-64.zip

[dbltest@erpdev 12.1.0.2.170117]$ cd 22098146

[dbltest@erpdev 22098146]$ opatch apply

[dbltest@erpdev 22098146]$ cd $ORACLE_HOME/OPatch

[dbltest@erpdev OPatch]$ datapatch

Ensure that you shut down all the services running from the Oracle home.

[dbltest@erpdev 12.1.0.2.170117]$ unzip p21321429_12102170117_Generic.zip

[dbltest@erpdev 12.1.0.2.170117]$ cd 21321429

[dbltest@erpdev 21321429]$ opatch apply

[dbltest@erpdev 21321429]$ cd $ORACLE_HOME/OPatch

[dbltest@erpdev OPatch]$ datapatch

Ensure that you shut down all the services running from the Oracle home.

[dbltest@erpdev 12.1.0.2.170117]$ unzip p21864513_121020_Linux-x86-64.zip

[dbltest@erpdev 12.1.0.2.170117]$ cd 21864513

[dbltest@erpdev 21864513]$ opatch apply

[dbltest@erpdev 12.1.0.2.170117]$ unzip p21904072_121020_Linux-x86-64.zip

[dbltest@erpdev 12.1.0.2.170117]$ cd 21904072

[dbltest@erpdev 21904072]$ opatch apply

[dbltest@erpdev 12.1.0.2.170117]$ unzip p21967332_12102160419_Linux-x86-64.zip

[dbltest@erpdev 12.1.0.2.170117]$ cd 21967332

[dbltest@erpdev 21967332]$ opatch apply

[dbltest@erpdev 12.1.0.2.170117]$ unzip p22338374_12102160119_Linux-x86-64.zip

[dbltest@erpdev 12.1.0.2.170117]$ cd 22338374

[dbltest@erpdev 22338374]$ opatch apply

[dbltest@erpdev 12.1.0.2.170117]$ unzip p22731026_121020_Generic.zip

[dbltest@erpdev 12.1.0.2.170117]$ cd 22731026

[dbltest@erpdev 22731026]$ opatch apply

[dbltest@erpdev 22731026]$ cd $ORACLE_HOME/OPatch

[dbltest@erpdev OPatch]$ datapatch

Ensure that you shut down all the services running from the Oracle home.

[dbltest@erpdev 12.1.0.2.170117]$ unzip p24326444_12102161018_Linux-x86-64.zip

[dbltest@erpdev 12.1.0.2.170117]$ cd 24326444

[dbltest@erpdev 24326444]$ opatch apply

[dbltest@erpdev 12.1.0.2.170117]$ unzip p24560906_121025_Linux-x86-64.zip

[dbltest@erpdev 12.1.0.2.170117]$ cd 24560906

[dbltest@erpdev 24560906]$ opatch apply

d) After applying database patches, ensure the following additional tasks are performed

Compare & copy $APPL_TOP/admin/adgrants.sql from the administration server node to the database server node $ORACLE_HOME/appsutil/sql. Use SQL*Plus to connect to the database as SYSDBA and run the script using the following command:

SQL>sqlplus "/ as sysdba" @adgrants.sql <APPS schema name>

Use SQL*Plus to connect to the database as SYSDBA and run utlrp.sql script using the following command:

SQL>sqlplus "/ as sysdba" @?/rdbms/admin/utlrp.sql

e) Run etcc again to check all the required DB patch applied

[dbltest@erpdev etcc]$ sh checkDBpatch.sh

………………………….

All the required one-off bugfixes are present in database ORACLE_HOME.

………………………….

10. Apply Required Application Tier Patches

[dbltest@erpdev ~]$ mkdir –p /u01/DBLTEST/etcc

[dbltest@erpdev ~]$ unzip p17537119_R12_GENERIC.zip

Copy below 4 files to new etcc directory,

I. checkMTpatch.cmd

II. checkMTpatch.sh

III. txk_R1220_MT_base_bugs.xml

IV. txk_R1220_MT_mappings.xml

[dbltest@erpdev ~]$ cd /u01/DBLTEST/etcc

[dbltest@erpdev ~]$ ./checkMTpatch.sh

……………………………………………………

Patch recommendation summary

Oracle Forms and Reports 10.1.2.3.0

Patch 24946444 - Filename: p24946444_101232_LINUX.zip

Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0

Patch 22288381 - Filename: p22288381_111190_Generic.zip

Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0

Patch 9905685 - Filename: p9905685_111190_Generic.zip

Patch 21366277 - Filename: p21366277_111190_Generic.zip

Patch 21628307 - Filename: p21628307_111190_Generic.zip

Patch 24606362 - Filename: p24606362_111190_Generic.zip

Oracle WebLogic Server (WLS) 10.3.6.0.7

Patch 23743997 [SU Patch [K25M]: WLS PSU 10.3.0.6.161018]

- Filename: p23743997_1036_Generic.zip

A consolidated zip file with the required application tier patches is

available on My Oracle Support via:

Patch 25201333

- EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JAN 2017

+-----------------------------------------------------------------------------+

[WARNING] Patch 23743997 [SU Patch [K25M]: WLS PSU 10.3.0.6.161018] is missing.

This is the recommended minimum WLS patch set.

You should install it now, and then rerun this script to check for any

further fixes available.

================

Download & Unzip etcc_bundle patch 25201333

[dbltest@erpdev ~]$ unzip p25201333_R12_LINUX.zip

[dbltest@erpdev ~]$ cd etcc-bundle/LINUX_X86-64

[dbltest@erpdev LINUX_X86-64]$ ls

forms oracle_common webtier wls

EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR 161018 AND 160719

1. Oracle Forms and Reports

[dbltest@erpdev ~]$ export ORACLE_HOME=/u01/DBLTEST/fs1/EBSapps/10.1.2

[dbltest@erpdev ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH

[dbltest@erpdev ~]$ opatch lsinventory|grep 8551790

[dbltest@erpdev ~]$ opatch lsinventory|grep 24946444

[dbltest@erpdev ~]$ unzip p24946444_101232_LINUX.zip

[dbltest@erpdev ~]$ cd 24946444

[dbltest@erpdev 24946444]$ opatch apply

2. Oracle Fusion Middleware (FMW) - Web Tier

[dbltest@erpdev ~]$ export ORACLE_HOME=/u01/DBLTEST/fs1/FMW_Home/webtier

[dbltest@erpdev ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH

[dbltest@erpdev ~]$ opatch lsinventory|grep 22288381

[dbltest@erpdev ~]$ unzip p22288381_111190_Generic.zip

[dbltest@erpdev ~]$ cd 22288381

[dbltest@erpdev 22288381]$ opatch apply

3. Oracle Fusion Middleware (FMW) - oracle_common

[dbltest@erpdev ~]$ export ORACLE_HOME = /u01/DBLTEST/fs1/FMW_Home/oracle_common

[dbltest@erpdev ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH

[dbltest@erpdev ~]$ opatch lsinventory|grep 9905685

[dbltest@erpdev ~]$ unzip p9905685_111190_Generic.zip

[dbltest@erpdev ~]$ cd 9905685

[dbltest@erpdev 9905685]$ cd oui

[dbltest@erpdev oui]$ opatch apply

[dbltest@erpdev ~]$ unzip p21366277_111190_Generic.zip

[dbltest@erpdev ~]$ cd 21366277

[dbltest@erpdev 21366277]$ opatch apply

[dbltest@erpdev ~]$ unzip p21628307_111190_Generic.zip

[dbltest@erpdev ~]$ cd 21628307

[dbltest@erpdev 21628307]$ opatch apply

[dbltest@erpdev ~]$ unzip p24606362_111190_Generic.zip

[dbltest@erpdev ~]$ cd 24606362

[dbltest@erpdev 24606362]$ opatch apply

4. Oracle WebLogic Server (WLS)

[dbltest@erpdev ~]$ export ORACLE_HOME = /u01/DBLTEST/fs1/FMW_Home/wlserver_10.3

[dbltest@erpdev ~]$ cp p23743997_1036_Generic.zip /u01/DBLTEST/fs1/FMW_Home/utils/bsu/cache_dir

[dbltest@erpdev ~]$ unzip p23743997_1036_Generic.zip

[dbltest@erpdev ~]$ ls -ltr *.jar

[dbltest@erpdev ~]$ cd /u01/DBLTEST/fs1/FMW_Home/utils/bsu

[dbltest@erpdev ~]$ echo $DISPLAY

[dbltest@erpdev ~]$ echo $DISPLAY=:2:0

[dbltest@erpdev bsu]$ ./bsu.sh -install -patch_download_dir=/u01/DBLTEST/fs1/FMW_me/utils/bsu/cache_dir -patchlist=K25M -prod_dir=/u01/DBLTEST/fs1/FMW_Home/wlserver_10.3

Checking for conflicts...

Conflict(s) detected - resolve conflict condition and execute patch installation again

Conflict condition details follow:

Patch K25M is mutually exclusive and cannot coexist with patch(es): CW9T,VKXF,FCX7,Y5AP,1LRI,2GYW,BLTG

==========================

Patch 23743997 will end with above conflicts message. So we need to be first remove the list of conflicting patch then retry Patch 23743997.

Patch Need to be removed: CW9T, VKXF, 1LRI, 2GYW, BLTG, FCX7, Y5AP

[dbltest@erpdev bsu]$ ./bsu.sh -remove -patchlist=CW9T -prod_dir=/u01/DBLTEST/fs1/FMW_Home/wlserver_10.3

[dbltest@erpdev bsu]$ ./bsu.sh -remove -patchlist=VKXF -prod_dir=/u01/DBLTEST/fs1/FMW_Home/wlserver_10.3

[dbltest@erpdev bsu]$ ./bsu.sh -remove -patchlist=1LRI -prod_dir=/u01/DBLTEST/fs1/FMW_Home/wlserver_10.3

[dbltest@erpdev bsu]$ ./bsu.sh -remove -patchlist=2GYW -prod_dir=/u01/DBLTEST/fs1/FMW_Home/wlserver_10.3

[dbltest@erpdev bsu]$ ./bsu.sh -remove -patchlist=BLTG -prod_dir=/u01/DBLTEST/fs1/FMW_Home/wlserver_10.3

[dbltest@erpdev bsu]$ ./bsu.sh -remove -patchlist=FCX7 -prod_dir=/u01/DBLTEST/fs1/FMW_Home/wlserver_10.3

[dbltest@erpdev bsu]$ ./bsu.sh -remove -patchlist=Y5AP -prod_dir=/u01/DBLTEST/fs1/FMW_Home/wlserver_10.3

Now again apply patch 23743997

[dbltest@erpdev bsu]$ ./bsu.sh -install -patch_download_dir=/u01/DBLTEST/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=K25M -prod_dir=/u01/DBLTEST/fs1/FMW_Home/wlserver_10.3

5. Run ETCC again to get the patch list

[dbltest@erpdev ~]$ cd /u01/DBLTEST/etcc

[dbltest@erpdev ~]$ ./checkMTpatch.sh

6. Download, Move & Unzip below patch to the cache_dir directory

a) 24608998 [QMJP]

b) 13729611 [Z9PC]

c) 17319481 [9KCT]

d) 19259028 [KRDE]

e) 19687084 [NJVF]

f) 22323006 [DI8E]

7. To install the patches, use below commands

./bsu.sh -install -patch_download_dir=/u01/DBLTEST/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=QMJP -prod_dir=/u01/DBLTEST/fs1/FMW_Home/wlserver_10.3

./bsu.sh -install -patch_download_dir=/u01/DBLTEST/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=Z9PC -prod_dir=/u01/DBLTEST/fs1/FMW_Home/wlserver_10.3

./bsu.sh -install -patch_download_dir=/u01/DBLTEST/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=9KCT -prod_dir=/u01/DBLTEST/fs1/FMW_Home/wlserver_10.3

./bsu.sh -install -patch_download_dir=/u01/DBLTEST/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=KRDE -prod_dir=/u01/DBLTEST/fs1/FMW_Home/wlserver_10.3

./bsu.sh -install -patch_download_dir=/u01/DBLTEST/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=NJVF -prod_dir=/u01/DBLTEST/fs1/FMW_Home/wlserver_10.3

./bsu.sh -install -patch_download_dir=/u01/DBLTEST/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=DI8E -prod_dir=/u01/DBLTEST/fs1/FMW_Home/wlserver_10.3

8. To check the MT patch list again run the following

[dbltest@erpdev ~]$ cd /u01/DBLTEST/etcc

[dbltest@erpdev ~]$ ./checkMTpatch.sh

Now you should get the message as "All required patches are present"

9. Set Database Parameter

Oracle Database 12c Release 1 uses cost based optimization. If you are using Oracle Database 12.1.0.2, the following optimizer parameter should always be set to 'false'. This setting should be completed before proceeding with the next steps and should not be changed thereafter.

SQL>create spfile from pfile;

SQL>shutdown immediate;

SQL>startup;

SQL> alter system set optimizer_adaptive_features=false scope=spfile;

You can verify the parameter was set correctly by running the following command, which should return the value FALSE:

SQL>show
parameter optimizer_adaptive_features

10. Download the Consolidated seed patches and AD C, TXK and Post patches,

a)       Consolidated seed patches:
  p17204589_12.2.0_R12_GENERIC.zip
  p21900871_12.2.0_R12_GENERIC.zip

b) AD C.8 patches:

p21841299_R12.AD.C_R12_LINUX.zip

p24578455_R12.AD.C_R12_GENERIC.zip

p24494551_R12.AD.C_R12_GENERIC.zip

p25025325_R12.AD.C_R12_GENERIC.zip

c) AD C. delta 8 patches:

p21830810_R12.TXK.C_R12_GENERIC.zip

d) TXK.C.8 patches:

p18525466_R12.TXK.C_R12_GENERIC.zip

p23569114_R12.TXK.C_R12_GENERIC.zip

p23705992_R12.TXK.C_R12_GENERIC.zip

11. All Downloaded files are moved to /u01/DBLTEST/fs_ne/EBSapps/patch

12. Unzip the above patch files.

11. Apply Consolidated Seed Table Upgrade Patch

[dbltest@erpdev ~]$ sh $ADMIN_SCRIPTS_HOME/adstpall.sh

[dbltest@erpdev ~]$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start

[dbltest@erpdev ~]$ adop phase=apply patches=17204589,21900871 merge=yes hotpatch=yes

[dbltest@erpdev ~]$ sh $ADMIN_SCRIPTS_HOME/adstrtall.sh

12. Apply the Latest AD and TXK Delta Release Update Packs

1. Start up only the Oracle Weblogic Admin Server on the run edition application tier file system.

[dbltest@erpdev ~]$ sh $ADMIN_SCRIPTS_HOME/adstpall.sh

[dbltest@erpdev ~]$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start

2. 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.

Patch AD.C

**** Patch 21841299 ****

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

2. Compare the version of adgrants.sql(UNIX) in $APPL_TOP/admin to that in patch directory.

3. Copy the higher version of adgrants.sql (UNIX) to

$ORACLE_HOME/appsutil/admin.

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

5. Use SQL*Plus to run the script:

[dbltest@erpdev ~]$ $ sqlplus /nolog

[dbltest@erpdev ~]$ SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPS

[dbltest@erpdev ~]$ adop phase=apply patches=21841299 hotpatch=yes

3. Instructions for running AD Grants *** check adgrants in patch 24494551.

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.

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

2. Compare the version of adgrants.sql(UNIX) in $APPL_TOP/admin to that in patch directory.

3. Copy the higher version of adgrants.sql (UNIX) to

$ORACLE_HOME/appsutil/admin.

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

5. Use SQL*Plus to run the script:

[dbltest@erpdev ~]$ $ sqlplus /nolog

[dbltest@erpdev ~]$ SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPS

[dbltest@erpdev ~]$ adop phase=apply patches=24578455,24494551,25025325 merge=yes hotpatch=yes workers=8

[dbltest@erpdev ~]$ adop phase=apply patches=21830810 hotpatch=yes workers=8

4. Patch TXK C

[dbltest@erpdev ~]$ adop phase=apply patches=18525466,23569114,23705992 hotpatch=yes merge=yes workers=8

After applying this patch, update all Database Tier Nodes with the code level provided by this patch, by performing the following steps :

5. After applying the above Patch 23705992 perform below steps

a. On the Application Tier

[dbltest@erpdev DBLTEST]$ . /u01/DBLTEST/EBSapps.env run

[dbltest@erpdev ~]$ cd $ADMIN_SCRIPTS_HOME

[dbltest@erpdev scripts]$ ./adautocfg.sh

[dbltest@erpdev appl]$ cd /u01/DBLTEST/fs1/EBSapps/appl

[dbltest@erpdev appl]$ . *.env

[dbltest@erpdev appl]$ perl<AD_TOP>/bin/admkappsutil.pl

This will create appsutil.zip in <INST_TOP>/admin/out

b. On the Database Tier

[dbltest@erpdev ~]$ cd /u01/DBLTEST/12.1.0

[dbltest@erpdev ~]$ . *.env

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

[dbltest@erpdev ~]$ unzip -o appsutil.zip

c. Re-run adpreclone.pl on the database tier and on the primary node of the Application tier

Note:

Since new updates included in this patch have been applied to the system, adpreclone must be executed again in order to apply them into the clone directory structures used during cloning.

[dbltest@erpdev ~]$ perl adpreclone.pl dbTier

[dbltest@erpdev ~]$ perl adpreclone.pl appsTier

d. Migrate Latest Code to Database Tier

Update all database tier nodes with the latest code, by performing the following steps:

[dbltest@erpdev appl]$ cd /u01/DBLTEST/fs1/EBSapps/appl

[dbltest@erpdev appl]$ . *.env

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

[dbltest@erpdev appl]$ perl<AD_TOP>/bin/admkappsutil.pl

[dbltest@erpdev ~]$ cd /u01/DBLTEST/12.1.0

[dbltest@erpdev ~]$ . *.env

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

[dbltest@erpdev ~]$ unzip -o appsutil.zip

[dbltest@erpdev ~]$ cd $ORACLE_HOME/appsutil/scripts/dbltest_erpdev

[dbltest@erpdev ~]$ adautocfg.sh

[dbltest@erpdev DBLTEST]$ . EBSapps.env run

[dbltest@erpdev DBLTEST]$ cd $ADMIN_SCRIPTS_HOME

[dbltest@erpdev ~]$ adautocfg.sh

13. Apply Oracle E-Business Suite 12.2.6 Release Update Pack

1. Source the run edition applications environment.

[dbltest@erpdev DBLTEST]$ .<INSTALL_BASE>/EBSapps.env run

2. Stop the Oracle Weblogic Admin Server and Node Manager services.

Applying the patch in downtime mode requires all application tier services to be down. Therefore, WeblogicAdminServer and Node Manager that were started previously when applying the latest Release Update Packs for AD and TXK for Release 12.2 need to be shut down.

a) Stop the Oracle Weblogic Admin Server on the run file system.

[dbltest@erpdev DBLTEST]$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop

b) Stop the Node Manager service on the run file system.

[dbltest@erpdev DBLTEST]$ sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop

3. Apply Oracle E-Business Suite 12.2.6 Release Update Pack Patch 21900901 on the run edition application environment, using downtime mode.

[dbltest@erpdev DBLTEST]$ adop phase=apply apply_mode=downtime patches=21900901 workers=8

4.Start all application tier services on the run file system.

[dbltest@erpdev DBLTEST]$ sh $ADMIN_SCRIPTS_HOME/adstrtal.sh

5. Perform adop cleanup action.

[dbltest@erpdev DBLTEST]$ adop phase=cleanup

6. 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 ensure that both file systems are in sync before applying patches using the regular adop cycle on the other file system.

[dbltest@erpdev DBLTEST]$ adop phase=fs_clone

14. Post-Update Steps

1. Apply Oracle E-Business Suite Release 12.2.6 Online Help Patch 21900918 using adop hotpatch mode on the run file system.

[dbltest@erpdev DBLTEST]$ . /u01/DBLTEST/EBSapps.env run

[dbltest@erpdev DBLTEST]$ adop phase=apply patches=21900918 hotpatch=yes

2. Perform 2 Cycle of Prepare and Cutover phase as follows,

[dbltest@erpdev DBLTEST]$ . /u01/DBLTEST/EBSapps.env run

[dbltest@erpdev DBLTEST]$ adop phase=prepare, cutover

[dbltest@erpdev DBLTEST]$ . /u01/DBLTEST/EBSapps.env run

[dbltest@erpdev DBLTEST]$ adop phase=prepare, cutover

3. Inventory migration to Central Inventory

[dbltest@erpdev DBLTEST]$ . /u01/DBLTEST/EBSapps.env run

[dbltest@erpdev ~]$ cd $ADMIN_SCRIPTS_HOME

[dbltest@erpdev ~]$ adstpall.sh apps/apps

[dbltest@erpdev DBLTEST]$ echo $CONTEXT_FILE

/u01/DBLTEST/fs1/inst/apps/dbltest_erpdev/appl/admin/dbltest_erpdev.xml

Edit the context file and set the value of the context variable s_ebs_central_inventory to 'true'.

[dbltest@erpdev scripts]$ ./adautocfg.sh

[dbltest@erpdev scripts]$ echo $FND_TOP

/u01/DBLTEST/fs1/EBSapps/appl/fnd/12.0.0

[dbltest@erpdev scripts]$ perl <FND_TOP>/patch/115/bin/txkMigrateInventory.pl -contextfile=<CONTEXT_FILE>

Ensure that all application tier Oracle Homes have been migrated to the EBS Installation Central Inventory.

4. Update Database Util File Directory Location and Database Parameter: -

[dbltest@erpdev ~]$ mkdir –p /u01/DBLTEST/temp

[dbltest@erpdev ~]$ sql> create pfile from spfile ;

update pfile util_file_dir parameter with new location

util_file_dir=/u01/DBLTEST/temp

processes 1000

sessions 1536

sga_target 5G

pga_aggregate_target 3G

open cursors 1000

[dbltest@erpdev ~]$ sql> startup pfile=’$ORACLE_HOME/dbs/initdbltest.ora’ ;

[dbltest@erpdev ~]$ sql> shutdown immediate;

[dbltest@erpdev ~]$ sql> startup;

[dbltest@erpdev ~]$ cd $ORACLE_HOME/appsutil/scripts/dbltest_erpdev

[dbltest@erpdev ~]$ adautocfg.sh

15. Startup /Shutdown Steps

Startup DB and APPS TIER

[dbltest@erpdev ~]$ cd /u01/DBLTEST/12.1.0

[dbltest@erpdev ~]$ . *.env

[dbltest@erpdev ~]$ cd /u01/DBLTEST/12.1.0/appsutil/scripts/dbltest_erpdev

[dbltest@erpdev ~]$ addbctl.sh start

[dbltest@erpdev ~]$ addlnctl.sh start dbltest

[dbltest@erpdev ~]$ cd /u01/DBLTEST

[dbltest@erpdev ~]$ . .EBSapps.env run

[dbltest@erpdev ~]$ cd $ADMIN_SCRIPTS_HOME

[dbltest@erpdev ~]$ adstrtal.sh apps/apps777

Enter the WebLogic Server password: weblogic098

Shutdown APPS and DB TIER

[dbltest@erpdev ~]$ cd /u01/DBLTEST

[dbltest@erpdev ~]$ . .EBSapps.env run

[dbltest@erpdev ~]$ cd $ADMIN_SCRIPTS_HOME

[dbltest@erpdev ~]$ adstpall.sh apps/apps777

Enter the WebLogic Server password: weblogic098

[dbltest@erpdev ~]$ cd /u01/DBLTEST/12.1.0

[dbltest@erpdev ~]$ . *.env

[dbltest@erpdev ~]$ cd /u01/DBLTEST/12.1.0/appsutil/scripts/dbltest_erpdev

[dbltest@erpdev ~]$ addbctl.sh stop immediate

[dbltest@erpdev ~]$ addlnctl.sh stop dbltest

12 comments:

UnknownApril 13, 2017 at 12:35 PM
Wow... it was a nice & very helpful documentation :)
AnonymousNovember 21, 2017 at 2:54 PM
Gracias!!!
Oracle TubeMay 19, 2018 at 10:34 AM
Tremendous!!!
UnknownJuly 20, 2018 at 12:43 PM
I am facing problem while apply this patch at last stage.
adop phase=apply patches=21900918 hotpatch=yes

Error Message is
AutoPatch error:

Error running SQL and EXEC commands in parallel

Freeing includes hash table
Freeing fixes hash table
Freeing basedons hash table
Freeing entities hash table

Please guide me
UnknownAugust 16, 2018 at 5:56 PM
Nice and simple anyone can understand the steps easily.
Thanks for the steps !
you are doing a good job by sharing your knowledge. keep it up !
AnonymousSeptember 12, 2024 at 6:50 PM
Cool and that i have a swell provide: What Does A Full House Renovation Cost house renovation contractors

Tips and Tricks for Administrators

Sunday, April 2, 2017

Oracle EBS R12 (12.2.6) Installation on Oracle Linux 6.8 (64 bit)

1. Reference Document

2. High Level Installation Steps

3. Patch Download

4. Stage Preparation

5. Operating System Prerequisite

6. Check System Prerequisite using Oracle Remote Diagnostic Agent

7. VNC Server Configuration

8. Base Version 12.2.0 Installation

9. Apply Required Database Patches

10. Apply Required Application Tier Patches

11. Apply Consolidated Seed Table Upgrade Patch

12. Apply the Latest AD and TXK Delta Release Update Packs

a. On the Application Tier

13. Apply Oracle E-Business Suite 12.2.6 Release Update Pack

14. Post-Update Steps

15. Startup /Shutdown Steps

12 comments: