Oracle EBS R12 (12.2.9) Installation on Oracle
Linux 6.8 (64 bit)
Oracle E-Business suite 12.2.9 Installation on Oracle Linux 6.8 (64 bit)
By
Anil Bandi
DATE : 14/11/2019
HYDERABAD, tELANGANA
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.9 Readme (Doc ID 2495027.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.9 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.11 and TXK.C.11
e) Apply the R12.2.9 upgrade patch 28840850
f) FS_CLONE for filesystem cloning
g) Apply the Help patch.
Downloading Software and Unzipping Start Here Files
After creating the stage area directory, you must download
into that directory the components of the latest Oracle E-Business Suite
Release 12.2 software distribution (also known as a media pack) that are used
by Rapid Install. The Oracle E-Business Suite Release 12.2 software
distribution includes Oracle E-Business Suite, Oracle Database, and Oracle
Fusion Middleware. It is obtainable in zip format from the Oracle Software
Delivery Cloud.
Suggested
Reading: Before you download the files, read the Release Notes for the
specific release you are installing.
To download the required components of the Oracle E-Business
Suite Release 12.2 software distribution:
1.
Sign in to the Oracle Software Delivery Cloud with your My
Oracle Support Credentials.
2.
Select Download Package as the search category,
enter Oracle E-Business Suite as the search term, and
choose Search.
3.
In the search results, select the latest Oracle E-Business
Suite package for Release 12.2, such as Oracle E-Business Suite 12.2.9.0.0
4.
Click the Selected Software cart.
5.
Select only the following releases:
o Oracle
E-Business Suite 12.2.0 Current
o Oracle
WebLogic Server 10.3.6.0.0
o Oracle
Web Tier 11.1.1.9.0
o Oracle
Database 12.1.0.2.0
Ensure that all other releases in
the list are deselected.
6.
Select the platform for each of the selected releases, and choose Continue.
7.
Read and accept the license agreement, and
choose Continue.
8.
By default, all available files are selected. Select only the
required files and choose Download to start the download into your
stage directory. You must download the following specific components of the
Oracle E-Business Suite Release 12.2 software distribution:
o Oracle
E-Business Suite Release 12.2.0 Rapid Install Start Here (all parts)
o Oracle
E-Business Suite Release 12.2.0 for <Platform> Rapid Install
(all disks and parts)
o Oracle
E-Business Suite Release 12.2.0 for <Platform> Rapid Install
Technology one-off Patches
o Oracle
WebLogic Server 10.3.6 (11gR1) Generic with Coherence 3.7.1
o Oracle
Web Tier 11.1.1.9.0 Utilities (11g Patch Set 7) - Oracle Fusion Middleware
for <Platform>
o Oracle
Database 12.1.0.2.0 for <Platform>
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) Oracle E-Business
Suite Release 12.2.0 for Linux x86-64 Rapid Install
1) Oracle Database
12.1.0.2.0 for Linux x86-64
i.
V46095-01_1of2.zip
Oracle Database 12c Release 1 (12.1.0.2.0)
ii.
V46095-01_2of2.zip
Oracle Database 12c Release 1 (12.1.0.2.0)
2)
Oracle E-Business Suite 12.2.9 for Linux
x86-64
i.
V982743-01_1of2.zip
ii.
V982743-01_2of2.zip
iii.
V982746-01_1of10.zip
iv.
V982746-01_2of10.zip
v.
V982746-01_3of10.zip
vi.
V982746-01_4of10.zip
vii.
V982746-01_5of10.zip
viii.
V982746-01_6of10.zip
ix.
V982746-01_7of10.zip
x.
V982746-01_8of10.zip
xi.
V982746-01_9of10.zip
xii.
V982746-01_10of10.zip
xiii.
V983437-01.zip
xiv.
V983438-01.zip
3)
Oracle E-Business Suite 12.2.0 Current for
Linux x86-64
i.
V35803-01_1of3.zip
ii.
V35803-01_2of3.zip
iii.
V35803-01_3of3.zip
iv.
V35804-01_1of2.zip
v.
V35804-01_2of2.zip
vi.
V35802-01.zip
vii.
V100060-01_1of3.zip
viii.
V100060-01_2of3.zip
ix.
V100060-01_3of3.zip
x.
V100061-01.zip
xi.
V100054-01.zip
xii.
V100055-01.zip
xiii.
V100052-01_1of3.zip
xiv.
V100052-01_2of3.zip
xv.
V100052-01_3of3.zip
xvi.
V100053-01_1of2.zip
xvii.
V100053-01_2of2.zip
xviii.
V100058-01.zip
xix.
V100059-01_1of2.zip
xx.
V100059-01_2of2.zip
xxi.
V100056-01.zip
xxii.
V100057-01.zip
xxiii.
V100102-01.zip
4)
Oracle Web Tier 11.1.1.9.0 for Linux x86-64
i.
V75792-01.zip
5)
Oracle WebLogic Server 10.3.6.0.0 for Linux
x86-64
ii.
V29856-01.zip
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
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 ~]# service ip6tables stop
[root@erpdev ~]# chkconfig --level 0123456 ip6tables off
[root@erpdev ~]# chkconfig --level 0123456 iptables 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
[root@erpdev ~]# vi /etc/sysctl.conf
# kernel.semmsl 256
# kernel.semmns 32000
# kernel.semopm 100
# kernel.semmni 142
# 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
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 ~]# 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
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
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 ~]# 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
[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 ~]$
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 ~]$ 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
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:
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.9 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.9 Release Update Pack Patch 28840850 on the run edition application environment, using downtime mode.
[dbltest@erpdev DBLTEST]$ adop phase=apply apply_mode=downtime patches=28840850 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 28840850 using adop hotpatch mode on the run file system.
[dbltest@erpdev DBLTEST]$ . /u01/DBLTEST/EBSapps.env run
[dbltest@erpdev DBLTEST]$ adop phase=apply patches=28840850 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
