Sunday, April 2, 2017

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

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


Version 2
By

MD. KAZIUl ISLAM BULBUL    
   DATE : 2ND APRIL 2017 (v1)
update : 2nd may 2017 (v2)
DHAKA, BANGLADESH






Table of Contents


1.      Reference Document. 2
2.      High Level Installation Steps. 2
3.      Patch Download. 2
4.      Stage Preparation. 4
5.      Operating System Prerequisite. 6
6.      Check System Prerequisite using Oracle Remote Diagnostic Agent. 10
7.      VNC Server Configuration. 10
8.      Base Version 12.2.0 Installation. 11
9.      Apply Required Database Patches. 21
10.    Apply Required Application Tier Patches. 28
11.    Apply Consolidated Seed Table Upgrade Patch. 33
12.    Apply the Latest AD and TXK Delta Release Update Packs. 34
13.    Apply Oracle E-Business Suite 12.2.6 Release Update Pack. 37
14.    Post-Update Steps. 38
15.    Startup /Shutdown Steps. 39





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 ~]#  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 ~]$  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:

  1. Wow... it was a nice & very helpful documentation :)

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

    ReplyDelete
    Replies
    1. Can you share autopatch logfile?

      Delete
    2. 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 too,
      help!help!help!

      Delete
  3. 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 !

    ReplyDelete
  4. Cool and that i have a swell provide: What Does A Full House Renovation Cost house renovation contractors

    ReplyDelete