In this blog post, we will see an example EBS 12.2 installation , which is done on a Linux x86-64 system.
Main Document: Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)
1. Installation Linux 6.5
2. Installing rpms for EBS 12.2 and RDBMS 12C
[root@ermantest yum.repos.d]# wget http://public-yum.oracle.com/public-yum-ol6.repo
Note : use vi editor to open repo and change enable 0 to 1 for addon and latest repositery
yum install -y oracle-ebs-server-R12-preinstall
yum install –y oracle-rdbms-server-12cR1-preinstall
3. Check all rpms
rpm -qa --qf "%{n}-%{v}-%{r}.%{arch}\n" | grep openmotif21
4. Run ldconfig –v command to relink all symbolic libraries
5. Disable selinux and shutdown iptables,ip6tables services also on run levels
vi /etc/selinux/config ( change SELINUX=enforcing to SELINUX=disabled )
service iptables stop
service ip6tables stop
chkconfig --level 0123456 ip6tables off
chkconfig --level 0123456 iptables off
6. 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.
vi /etc/sysctl.conf
kernel.semmsl 256
kernel.semmns 32000
kernel.semopm 100
kernel.semmni 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
7. Check Domain Name System (DNS) Resolver Parameters , it should be below
options attempts:5
options timeout:15
8. Verifying Host Names
· Verify that the /etc/hosts file is formatted as follows:
127.0.0.1 localhost.localdomain localhost
[ip_address] [node_name].[domain_name] [node_name]
· Verify that the /etc/sysconfig/network file is formatted as follows:
HOSTNAME=[node_name].[domain_name]
or as follows:
[root@ermantest rapidwiz]# pwd
/ebssetupfiles/EBS1225/startCD/Disk1/rapidwiz
[root@ermantest rapidwiz]# ./rapidwiz
13. Now follow the screens
If we encounter some errors for database pre-install checks and/or for filesystems, fix them as documented below ;
inventory_loc=/u01/oracle/TEST/oraInventory
inst_group=dba
For filesystem check error ;
chmod –R 777 /u01 (or any appropriate file permissions)
After installation is completed we can connect to the EBS and check the version 12.2.0 and go for next step...
At this point, EBS 12.2.0 installation is complete, so we continue with the EBS 12.2.5 upgrade.
1. EBS Technology Codelevel Checker (ETCC) (Doc ID 1594274.1)
Note: This patch verifies the missing bugfixes which is not applied for db and middle tiers. You can apply the patches directly to the related component but I recommend you go for the next steps and crosscheck the output of the log with the table you will see in section 3.2
Download patch 17537119
Upload patch to DB and APP node
For DB Node :
mkdir –p $ORACLE_HOME/appsutil/etcc
copy all files in the patch to the directory “mkdir –p $ORACLE_HOME/appsutil/etcc”
cd $ORACLE_HOME/appsutil/etcc
./checkDBpatch.sh
For APP Node :
cd <patchdirectory>
./checkMTpatch.sh
2. Apply RDBMS (12.1.0.2) Patches
Note: Shutdown database before apply patches
3. After applying database patches, ensure the following additional tasks are performed:
Copy $APPL_TOP/admin/adgrants.sql to db node
sqlplus "/ as sysdba" @adgrants.sql apps
sqlplus "/ as sysdba" @$ORACLE_HOME/rdbms/admin/utlrp.sql
Note: If the Release 12.2.0 Vision or PROD instance (New Installation) was created using startCD 12.2.0.51 (Patch 22066363), you must apply Consolidated Seed Table Upgrade Patch 17204589:12.2.0 by merging with Patch 21900871:12.2.0 on the run file system using adop hotpatch mode.
sh $ADMIN_SCRIPTS_HOME/adstpall.sh “ kill -9 `ps -ef|grep applmgr | awk '{print $2}'` “
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
Note : copy patches to the patch_top directory “/app/oracle/PROD/fs_ne/EBSapps/patch “
adop phase=apply patches=17204589,21900871 merge=yes hotpatch=yes
7. Apply Oracle Reports and Forms Patches ( 10.1.2.3.0 )
Note : Any configuration file changes suggested in post-install steps can be skipped, as those changes are controlled through technology stack templates initialized by AutoConfig. Any recommendation in any Forms patch readme to redeploy Forms ear file can be skipped as it is automatically deployed by Oracle E-Business Suite service control scripts before starting services. Please regenerate jars from adadmin after applying any of the forms patch, do not opt to force the regeneration of all JAR files. If the patch is being applied in the patch file system then ensure Online Patching prepare phase (adop phase=prepare) has completed successfully first before running adadmin. If the patch is being applied in the run file system, run adadmin after applying the patch
Note: The 10.1.2.3 distribution is 32-bit, even on 64-bit platforms. Download the available patch for your platform.
Default Oracle Home path is already set to 10.1.2 directory but if you need to set or to be make sure use below command
export ORACLE_HOME=/u01/oracle/TEST/fs1/EBSapps/10.1.2
export PATH=$ORACLE_HOME/OPatch:$PATH
opatch lsinventory
[applmgr@ermantest~]$ opatch lsinventory
Oracle Home : /u01/oracle/TEST/fs1/EBSapps/10.1.2
Oracle Home Inventory : /u01/oracle/TEST/fs1/EBSapps/10.1.2/inventory
Central Inventory : /u01/oracle/TEST/oraInventory
from : /etc/oraInst.loc
OUI location : /u01/oracle/TEST/fs1/EBSapps/10.1.2/oui
OUI shared library : /u01/oracle/TEST/fs1/EBSapps/10.1.2/oui/lib/linux/liboraInstaller.so
Java location : /u01/oracle/TEST/fs1/EBSapps/10.1.2/jdk/jre/bin/java
Opatch apply
After apply patch
Run adadmin
Generate jar files ( dont use force )
Set the ORACLE_HOME environment variable to Webtier home and Opatch version should be 11.1.0.9.0 or higher
export ORACLE_HOME=/u01/oracle/TEST/fs1/FMW_Home/webtier
export PATH=$ORACLE_HOME/OPatch:$PATH
[applmgr@ermantest ContentsXML]$ opatch lsinventory
Oracle Interim Patch Installer version 11.1.0.12.9
Copyright (c) 2016, Oracle Corporation. All rights reserved.
Oracle Home : /u01/oracle/TEST/fs1/FMW_Home/webtier
Central Inventory : /u01/oracle/TEST/oraInventory
from : /u01/oracle/TEST/fs1/FMW_Home/webtier/oraInst.loc
OPatch version : 11.1.0.12.9
OUI version : 11.1.0.11.0
OPatch detects the Middleware Home as "/u01/oracle/TEST/fs1/FMW_Home"
Installed Top-level Products (1):
Oracle WebTier and Utilities CD 11.1.1.9.0
cd 22107540/
opatch apply -jre $ORACLE_HOME/jdk/jre
Set the ORACLE_HOME environment variable to oracle_common home and Opatch version should be 11.1.0.9.0 or higher
export ORACLE_HOME=/u01/oracle/TEST/fs1/FMW_Home/oracle_common
export PATH=$ORACLE_HOME/OPatch:$PATH
To be make sure for the oracle home is correctly set. Use opatch lsinventory command
cd <patchdirectory>
opatch apply
--UPGRADING EBS FROM 12.2.0 TO 12.2.5--
Oracle E-Business Suite Release 12.2.5 Readme (Doc ID 1983050.1) Section 7 and 8
Path A — Upgrade and New Installation Customers upgrading to Oracle E-Business Suite 12.2.5 Release Update Pack
15. Stop Weblogic AdminServer and Node Manager services.
Applying the patch in downtime mode requires all application tier services to be down. Therefore, Weblogic AdminServer 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.
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
Request a translation sync path using "https://updates.oracle.com/TransSync"
Upload and apply patch with adop through an online patching cycle (prepare,apply,finalize,cutover,cleanup)
The aim of this installation is to obtain an EBS 12.2.5 instance running on Oracle Linux 6 64-bit.
We will use the latest startCD, so we will have an 12C database in our newly installed EBS 12.2.5 instance. This document involves some post upgrade steps, which may be required or changed according to your needs. The underlying server system used for this installation is based on a single node server environment. However, the steps are quite similar in a multi node system.
The general overview of the process is to install Oracle Linux, install EBS 12.2.0 and upgrade it to EBS 12.2.5. This blog post is a little different than my earlier post, as it will be like a compilation, but still it will give the valuable filtered information required for EBS 12.2. installations.
Please do not take the configuration values, licensed products as well as the post upgrade steps used in this document as the orders :), because they are only there for giving you the general explanation of the installation process, as they may vary according to your environments and needs.
Let 's see, how we do it.
Main Document: Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)
1. Installation Linux 6.5
2. Installing rpms for EBS 12.2 and RDBMS 12C
[root@ermantest yum.repos.d]# wget http://public-yum.oracle.com/public-yum-ol6.repo
Note : use vi editor to open repo and change enable 0 to 1 for addon and latest repositery
yum install -y oracle-ebs-server-R12-preinstall
yum install –y oracle-rdbms-server-12cR1-preinstall
3. Check all rpms
rpm -qa --qf "%{n}-%{v}-%{r}.%{arch}\n" | grep openmotif21
4. Run ldconfig –v command to relink all symbolic libraries
5. Disable selinux and shutdown iptables,ip6tables services also on run levels
vi /etc/selinux/config ( change SELINUX=enforcing to SELINUX=disabled )
service iptables stop
service ip6tables stop
chkconfig --level 0123456 ip6tables off
chkconfig --level 0123456 iptables off
6. 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.
vi /etc/sysctl.conf
kernel.semmsl 256
kernel.semmns 32000
kernel.semopm 100
kernel.semmni 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
7. Check Domain Name System (DNS) Resolver Parameters , it should be below
options attempts:5
options timeout:15
8. Verifying Host Names
· Verify that the /etc/hosts file is formatted as follows:
127.0.0.1 localhost.localdomain localhost
[ip_address] [node_name].[domain_name] [node_name]
· Verify that the /etc/sysconfig/network file is formatted as follows:
HOSTNAME=[node_name].[domain_name]
or as follows:
HOSTNAME=[node_name]
NISDOMAIN=[domain_name]
NISDOMAIN=[domain_name]
· If the /etc/sysconfig/networking/profiles/default/network file exists, remove it.
· If you changed any files in the previous steps, restart the system
9. Modify ulimit settings in limits.conf
vi /etc/security/limits.conf
# oracle-rdbms-server-11gR2-preinstall setting for nofile soft limit is 1024
oracle soft nofile 4096
# oracle-rdbms-server-11gR2-preinstall setting for nofile hard limit is 65536
oracle hard nofile 65536
# oracle-rdbms-server-11gR2-preinstall setting for nproc soft limit is 2047
oracle soft nproc 2047
# oracle-rdbms-server-11gR2-preinstall setting for nproc hard limit is 16384
oracle hard nproc 16384
# oracle-rdbms-server-11gR2-preinstall setting for stack soft limit is 10240KB
oracle soft stack 10240
# oracle-rdbms-server-11gR2-preinstall setting for stack hard limit is 32768KB
oracle hard stack 32768
10. Download EBS Installation Packages, Oracle E-Business Suite (12.2.5)
V100052-01_1of3.zipOracle E-Business Suite Release 12.2.0 Rapid Install Start Here 725.3 MB
V100052-01_2of3.zipOracle E-Business Suite Release 12.2.0 Rapid Install Start Here 81.6 MB
V100052-01_3of3.zipOracle E-Business Suite Release 12.2.0 Rapid Install Start Here 97.3 MB
V100059-01_1of2.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 1 1007.0 MB
V100059-01_2of2.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 1 1.6 GB
V100060-01_1of3.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 2 1.6 GB
V100060-01_2of3.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 2 1.1 GB
V100060-01_3of3.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 2 1.0 GB
V100061-01.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Technology one-off Patches 839.9 MB
V100078-01.zipOracle E-Business Suite Release 12.2 Supplemental Documentation - REVIEW FIRST 21.6 MB
V100079-01.zipOracle E-Business Suite Release 12.2 Supplemental Media 603.2 MB
100102-01.zipOracle Database 12c Release 1 (12.1.0.2.0) EXAMPLES for Linux x86-64 476.1 MB
V77840-01_1of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 514.5 MB
V77840-01_2of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 527.6 MB
V77840-01_3of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 459.4 MB
V77840-01_4of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 530.4 MB
V77840-01_5of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 571.4 MB
V77840-01_6of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 554.9 MB
V77840-01_7of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 526.7 MB
V77840-01_8of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 596.3 MB
V77840-01_9of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 100.5 MB
V77972-01.zipOracle E-Business Suite Release 12.2.5 Documentation Library 730.2 MB
Oracle Database (12.1.0.2.0)
V46095-01_1of2.zipOracle Database 12c Release 1 (12.1.0.2.0) 1.6 GB
V46095-01_2of2.zipOracle Database 12c Release 1 (12.1.0.2.0) 967.5 MB
Oracle E-Business Suite (12.2.0)
V35802-01.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install AS10.1.2 711.6 MB
V35803-01_1of3.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 1 1.2 GB
V35803-01_2of3.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 1 1022.8 MB
V35803-01_3of3.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 1 1.3 GB
V35804-01_1of2.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 2 1.2 GB
V35804-01_2of2.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 2 1.6 GB
Oracle Web Tier (11.1.1.9.0)
V75792-01.zipOracle Fusion Middleware Web Tier Utilities 11g Patch Set 7 (11.1.1.9.0) for Linux x86-64 2.0 GB
· If you changed any files in the previous steps, restart the system
9. Modify ulimit settings in limits.conf
vi /etc/security/limits.conf
# oracle-rdbms-server-11gR2-preinstall setting for nofile soft limit is 1024
oracle soft nofile 4096
# oracle-rdbms-server-11gR2-preinstall setting for nofile hard limit is 65536
oracle hard nofile 65536
# oracle-rdbms-server-11gR2-preinstall setting for nproc soft limit is 2047
oracle soft nproc 2047
# oracle-rdbms-server-11gR2-preinstall setting for nproc hard limit is 16384
oracle hard nproc 16384
# oracle-rdbms-server-11gR2-preinstall setting for stack soft limit is 10240KB
oracle soft stack 10240
# oracle-rdbms-server-11gR2-preinstall setting for stack hard limit is 32768KB
oracle hard stack 32768
10. Download EBS Installation Packages, Oracle E-Business Suite (12.2.5)
V100052-01_1of3.zipOracle E-Business Suite Release 12.2.0 Rapid Install Start Here 725.3 MB
V100052-01_2of3.zipOracle E-Business Suite Release 12.2.0 Rapid Install Start Here 81.6 MB
V100052-01_3of3.zipOracle E-Business Suite Release 12.2.0 Rapid Install Start Here 97.3 MB
V100059-01_1of2.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 1 1007.0 MB
V100059-01_2of2.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 1 1.6 GB
V100060-01_1of3.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 2 1.6 GB
V100060-01_2of3.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 2 1.1 GB
V100060-01_3of3.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 2 1.0 GB
V100061-01.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Technology one-off Patches 839.9 MB
V100078-01.zipOracle E-Business Suite Release 12.2 Supplemental Documentation - REVIEW FIRST 21.6 MB
V100079-01.zipOracle E-Business Suite Release 12.2 Supplemental Media 603.2 MB
100102-01.zipOracle Database 12c Release 1 (12.1.0.2.0) EXAMPLES for Linux x86-64 476.1 MB
V77840-01_1of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 514.5 MB
V77840-01_2of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 527.6 MB
V77840-01_3of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 459.4 MB
V77840-01_4of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 530.4 MB
V77840-01_5of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 571.4 MB
V77840-01_6of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 554.9 MB
V77840-01_7of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 526.7 MB
V77840-01_8of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 596.3 MB
V77840-01_9of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 100.5 MB
V77972-01.zipOracle E-Business Suite Release 12.2.5 Documentation Library 730.2 MB
Oracle Database (12.1.0.2.0)
V46095-01_1of2.zipOracle Database 12c Release 1 (12.1.0.2.0) 1.6 GB
V46095-01_2of2.zipOracle Database 12c Release 1 (12.1.0.2.0) 967.5 MB
Oracle E-Business Suite (12.2.0)
V35802-01.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install AS10.1.2 711.6 MB
V35803-01_1of3.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 1 1.2 GB
V35803-01_2of3.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 1 1022.8 MB
V35803-01_3of3.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 1 1.3 GB
V35804-01_1of2.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 2 1.2 GB
V35804-01_2of2.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 2 1.6 GB
Oracle Web Tier (11.1.1.9.0)
V75792-01.zipOracle Fusion Middleware Web Tier Utilities 11g Patch Set 7 (11.1.1.9.0) for Linux x86-64 2.0 GB
Oracle WebLogic Server (10.3.6.0.0)
V29856-01.zipOracle WebLogic Server 11gR1 (10.3.6) Generic and Coherence 1018.5 MB
11. Create Stage
[root@ermantest EBS1225]# cd startCD/Disk1/rapidwiz/bin/
[root@ermantest bin]# ./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
Running command:
……………..
Specify the directory containing the zipped installation media:
/ebssetupfiles/EBS1225/
File list:
/ebssetupfiles/EBS1225/startCD/Disk1/rapidwiz/bin/stageData/zipFiles.dat
V29856-01.zipOracle WebLogic Server 11gR1 (10.3.6) Generic and Coherence 1018.5 MB
11. Create Stage
[root@ermantest EBS1225]# cd startCD/Disk1/rapidwiz/bin/
[root@ermantest bin]# ./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
Running command:
……………..
Specify the directory containing the zipped installation media:
/ebssetupfiles/EBS1225/
File list:
/ebssetupfiles/EBS1225/startCD/Disk1/rapidwiz/bin/stageData/zipFiles.dat
The following files are missing from /ebssetupfiles/EBS1225/.
Return to the Oracle Software Delivery Cloud and download them:
====================================================
Part number: V100053-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 1
File name: V100053-01_1of2.zip
====================================================
Part number: V100053-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 1
File name: V100053-01_2of2.zip
====================================================
Part number: V100054-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 2
File name: V100054-01.zip
====================================================
Part number: V100055-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 3
File name: V100055-01.zip
====================================================
Part number: V100056-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 4
File name: V100056-01.zip
====================================================
Part number: V100057-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 5
File name: V100057-01.zip
====================================================
Part number: V100058-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 6
File name: V100058-01.zip
====================================================
WARNING: Some of the required zip files have not yet been downloaded. Do you want to continue, and obtain them later? (Y)/N
Y
Return to the Oracle Software Delivery Cloud and download them:
====================================================
Part number: V100053-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 1
File name: V100053-01_1of2.zip
====================================================
Part number: V100053-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 1
File name: V100053-01_2of2.zip
====================================================
Part number: V100054-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 2
File name: V100054-01.zip
====================================================
Part number: V100055-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 3
File name: V100055-01.zip
====================================================
Part number: V100056-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 4
File name: V100056-01.zip
====================================================
Part number: V100057-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 5
File name: V100057-01.zip
====================================================
Part number: V100058-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 6
File name: V100058-01.zip
====================================================
WARNING: Some of the required zip files have not yet been downloaded. Do you want to continue, and obtain them later? (Y)/N
Y
Note that: During creation of stage , enter to continue couple of times
12. Start E-Business Installation / EBS 12.2.0 installation
12. Start E-Business Installation / EBS 12.2.0 installation
[root@ermantest rapidwiz]# pwd
/ebssetupfiles/EBS1225/startCD/Disk1/rapidwiz
[root@ermantest rapidwiz]# ./rapidwiz
13. Now follow the screens
Open new terminal with root user and run xhost +
Database Pre-installchecks;
Create oraInst.loc file and point it to the inventory location, which can be ORACLE_BASE directory.
ORACLE_HOME==/u01/oracle/TEST/12.1.0
ORACLE_BASE==/u01/oracle/TEST
ORACLE_HOME==/u01/oracle/TEST/12.1.0
ORACLE_BASE==/u01/oracle/TEST
So the orainventory should be in ora base directory
[oracle@ermanrtest app]$ cat /etc/oraInst.loc
inventory_loc=/u01/oracle/TEST/oraInventory
inst_group=dba
For filesystem check error ;
chmod –R 777 /u01 (or any appropriate file permissions)
--PREPARING for 12.2.0 to 12.2.5 upgrade--
APPLYING TECHNOLOGY PATCHES FOR 12.2.0 Oracle E-Business Suite Release 12.2.5 Readme (Doc ID 1983050.1) Master Note
Note: This patch verifies the missing bugfixes which is not applied for db and middle tiers. You can apply the patches directly to the related component but I recommend you go for the next steps and crosscheck the output of the log with the table you will see in section 3.2
Download patch 17537119
Upload patch to DB and APP node
For DB Node :
mkdir –p $ORACLE_HOME/appsutil/etcc
copy all files in the patch to the directory “mkdir –p $ORACLE_HOME/appsutil/etcc”
cd $ORACLE_HOME/appsutil/etcc
./checkDBpatch.sh
For APP Node :
cd <patchdirectory>
./checkMTpatch.sh
2. Apply RDBMS (12.1.0.2) Patches
Note: Shutdown database before apply patches
Not
included in any startCD
|
Linux x86-64
|
|
21841318
|
||
22098146
|
||
21286665
|
||
21967332
|
opatch rollback
-id 18893947
|
|
21387964
|
3. After applying database patches, ensure the following additional tasks are performed:
Copy $APPL_TOP/admin/adgrants.sql to db node
sqlplus "/ as sysdba" @adgrants.sql apps
sqlplus "/ as sysdba" @$ORACLE_HOME/rdbms/admin/utlrp.sql
4. Apply Consolidated Seed Table Upgrade Patch (Required)
sh $ADMIN_SCRIPTS_HOME/adstpall.sh “ kill -9 `ps -ef|grep applmgr | awk '{print $2}'` “
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
Note : copy patches to the patch_top directory “/app/oracle/PROD/fs_ne/EBSapps/patch “
5. 3.1 Path A — Upgrade and New Installation Customers. Run ETCC (1617461.1 )
Note: Applying the AD and TXK Delta 7 release update packs checks for the existence of the ETCC tables. Even if you already have all the required database patches installed, you must execute the latest version of ETCC on your database before proceeding to Section 3.
Note: Applying the AD and TXK Delta 7 release update packs checks for the existence of the ETCC tables. Even if you already have all the required database patches installed, you must execute the latest version of ETCC on your database before proceeding to Section 3.
6. Technology Inventory Utility (Optional )
The Technology Inventory Utility generates a report that lists the installed technology stack components, as well as patches that have been applied. Any patches listed in this section that are not shown in the generated report must be installed. Refer to Oracle E-Business Suite Maintenance Guide for instructions on generating the technology report.
perl $FND_TOP/patch/115/bin/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP -contextfile=$CONTEXT_FILE -appspass=apps321 -outfile=$APPLTMP/Report_Inventory.html
The Technology Inventory Utility generates a report that lists the installed technology stack components, as well as patches that have been applied. Any patches listed in this section that are not shown in the generated report must be installed. Refer to Oracle E-Business Suite Maintenance Guide for instructions on generating the technology report.
perl $FND_TOP/patch/115/bin/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP -contextfile=$CONTEXT_FILE -appspass=apps321 -outfile=$APPLTMP/Report_Inventory.html
Linux x86-64
|
|
Not included in any startCD
|
21539521
|
export ORACLE_HOME=/u01/oracle/TEST/fs1/EBSapps/10.1.2
export PATH=$ORACLE_HOME/OPatch:$PATH
opatch lsinventory
Oracle Home : /u01/oracle/TEST/fs1/EBSapps/10.1.2
Oracle Home Inventory : /u01/oracle/TEST/fs1/EBSapps/10.1.2/inventory
Central Inventory : /u01/oracle/TEST/oraInventory
from : /etc/oraInst.loc
OUI location : /u01/oracle/TEST/fs1/EBSapps/10.1.2/oui
OUI shared library : /u01/oracle/TEST/fs1/EBSapps/10.1.2/oui/lib/linux/liboraInstaller.so
Java location : /u01/oracle/TEST/fs1/EBSapps/10.1.2/jdk/jre/bin/java
Opatch apply
After apply patch
Run adadmin
Generate jar files ( dont use force )
8. Apply Oracle Home Patch (Version 10.1.0.5.0)
There is no patch to apply if you installed EBS with the latest startCD. Check “Table 3 - Patches and bug numbers for 10.1.0.5.0” in the document.
There is no patch to apply if you installed EBS with the latest startCD. Check “Table 3 - Patches and bug numbers for 10.1.0.5.0” in the document.
9. Apply patch for Oracle Fusion Middleware (FMW) webtier 11.1.1.9
Note: When obtaining patches listed in these tables, download and install the 64-bit version of the patches.
Note: When obtaining patches listed in these tables, download and install the 64-bit version of the patches.
Linux x86-64
|
|
Not included in any startCD
|
22107540
|
Set the ORACLE_HOME environment variable to Webtier home and Opatch version should be 11.1.0.9.0 or higher
export ORACLE_HOME=/u01/oracle/TEST/fs1/FMW_Home/webtier
export PATH=$ORACLE_HOME/OPatch:$PATH
[applmgr@ermantest ContentsXML]$ opatch lsinventory
Oracle Interim Patch Installer version 11.1.0.12.9
Copyright (c) 2016, Oracle Corporation. All rights reserved.
Oracle Home : /u01/oracle/TEST/fs1/FMW_Home/webtier
Central Inventory : /u01/oracle/TEST/oraInventory
from : /u01/oracle/TEST/fs1/FMW_Home/webtier/oraInst.loc
OPatch version : 11.1.0.12.9
OUI version : 11.1.0.11.0
OPatch detects the Middleware Home as "/u01/oracle/TEST/fs1/FMW_Home"
Installed Top-level Products (1):
Oracle WebTier and Utilities CD 11.1.1.9.0
cd 22107540/
opatch apply -jre $ORACLE_HOME/jdk/jre
10. Apply patch for Oracle Fusion Middleware (FMW) oracle_common 11.1.1.9
Not
included in any startCD
|
Linux x86-64
|
21366277
|
|
21628307
|
Set the ORACLE_HOME environment variable to oracle_common home and Opatch version should be 11.1.0.9.0 or higher
export ORACLE_HOME=/u01/oracle/TEST/fs1/FMW_Home/oracle_common
export PATH=$ORACLE_HOME/OPatch:$PATH
To be make sure for the oracle home is correctly set. Use opatch lsinventory command
cd <patchdirectory>
opatch apply
11. Apply patch for Oracle Weblogic Server 10.3.6.0
Footnote 1 - This is the 10.3.6.0.12 PSU. When applying a PSU all conflicting patches (including overlays and previous PSUs) would need to be removed. For a list of bug fixes included in this PSU, refer to My Oracle Support Knowledge Document 2030251.1, Oracle WebLogic Server Patch Set Update 10.3.6.0.12 Fixed Bugs List.
Footnote 2 - This overlay patch is specific to 10.3.6.0.12 PSU; apply the PSU Patch 20780171 then this overlay patch.
Footnote 3 - This patch is specific to the Windows Platform.
Footnote 4 - This Oracle WebLogic Server patch is required for Oracle Fusion Middleware 11.1.1.9.
Ensure you have applied R12.TXK.C.Delta.7 (Patch 20784380) and Patch 21846184.
Refer to My Oracle Support Knowledge Document 1617461.1, Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release.
Patch 21846184 includes TXK code that will enable Java Secure Socket Extension (JSSE) within Oracle E-Business Suite Release 12.2 when Oracle Fusion Middleware version is 11.1.1.9.
Follow the instructions in the patch readme, except for the last step (Step 6) in the post-install instructions.
Patch Installation Steps ;
· Copy content of this zip file with the exception of README file to your SmartUpdate cache directory ($FMW_HOME/utils/bsu/cache_dir by default)
· cd $FMW_HOME/utils/bsu
· you will see the oracle smart update interface and below of the screen displays the patches that needs to be apply
· Start to apply patches and follow their readme,footnotes.
· To apply patches, first you have to apply patch number 20780171 but you may have conflict warning with the previous patches which has older PSU patches like 10.3.6.0.7 because 20780171 patch number is PSU 10.3.6.0.12 patch
·we removed the below patches and then run ./checkMTpatch.sh
Y5AP,BLTG,1LRI,VKXF,2GYW,CW9T, FCX7
· According to the output we have to apply the below patches fort he PSU 10.3.6.0.12
Footnote 1 - This is the 10.3.6.0.12 PSU. When applying a PSU all conflicting patches (including overlays and previous PSUs) would need to be removed. For a list of bug fixes included in this PSU, refer to My Oracle Support Knowledge Document 2030251.1, Oracle WebLogic Server Patch Set Update 10.3.6.0.12 Fixed Bugs List.
Footnote 2 - This overlay patch is specific to 10.3.6.0.12 PSU; apply the PSU Patch 20780171 then this overlay patch.
Footnote 3 - This patch is specific to the Windows Platform.
Footnote 4 - This Oracle WebLogic Server patch is required for Oracle Fusion Middleware 11.1.1.9.
Ensure you have applied R12.TXK.C.Delta.7 (Patch 20784380) and Patch 21846184.
Refer to My Oracle Support Knowledge Document 1617461.1, Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release.
Patch 21846184 includes TXK code that will enable Java Secure Socket Extension (JSSE) within Oracle E-Business Suite Release 12.2 when Oracle Fusion Middleware version is 11.1.1.9.
Follow the instructions in the patch readme, except for the last step (Step 6) in the post-install instructions.
Patch Installation Steps ;
· Copy content of this zip file with the exception of README file to your SmartUpdate cache directory ($FMW_HOME/utils/bsu/cache_dir by default)
· cd $FMW_HOME/utils/bsu
· you will see the oracle smart update interface and below of the screen displays the patches that needs to be apply
· Start to apply patches and follow their readme,footnotes.
· To apply patches, first you have to apply patch number 20780171 but you may have conflict warning with the previous patches which has older PSU patches like 10.3.6.0.7 because 20780171 patch number is PSU 10.3.6.0.12 patch
·we removed the below patches and then run ./checkMTpatch.sh
Y5AP,BLTG,1LRI,VKXF,2GYW,CW9T, FCX7
· According to the output we have to apply the below patches fort he PSU 10.3.6.0.12
12.2.0.51
|
13964737
(see Footnote 4)
|
YVDZ
|
13964737
|
Not
included in any startCD
|
20780171
(see Footnote 1)
|
EJUW
|
20780171
|
13729611
(see Footnote 2)
|
L34G
|
13729611
|
|
17319481
(see Footnote 2)
|
N5FK
|
17319481
|
|
19687084
(see Footnote 2)
|
8FBW
|
19687084
|
|
22128205
(see Footnote 2)
|
GK5N
|
22128205,13337000,
21562338
|
12. Apply R12.TXK.C.Delta.7 patches
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
· Run ETCC according to the section “3.1.1 Prerequisite.
· Source the run edition environment file.
. /u01/oracle/TEST/fs1/EBSapps/appl/APPSTEST_ermtest.env
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start ( It is already started for upgrade patch )
· Start up only Weblogic AdminServer service on the run edition application tier file system
· Apply below patches
Unzip patches and run adgrants
Patch 20745242 (R12.AD.C.Delta.7)
Patch 22123818:R12.AD.C
Patch 20784380 (R12.TXK.C.Delta.7)
Patch 22363475:R12.TXK.C
Patch 22495069:R12.TXK.C
Note : Compare adgrants.sql versions with in the patch directory and $APPL_TOP/admin
vi 20745242/admin/adgrants.sql
vi $APPL_TOP/admin/adgrants.sql
sqlplus / as sysdba @/app/oracle/PROD/fs_ne/EBSapps/patch/20745242/admin/adgrants.sql apps
· Copy all patches to the $PATCH_TOP (/u01/oracle/TEST/fs_ne/EBSapps/patch )
adop phase=apply patches=20745242 hotpatch=yes
sqlplus / as sysdba @/app/oracle/PROD/fs_ne/EBSapps/patch/22123818/admin/adgrants.sql apps
run etcc on db and app nodes
adop phase=apply patches=22123818 hotpatch=yes
adop phase=apply patches=20784380,22363475,22495069 hotpatch=yes merge=yes
After applied the patch with merge parameter. ( applied Delta Patches ) you will see the env file in your system base directory
/u01/oracle/TEST
-rw-r--r-- 1 applmgr oinstall 6467 Mar 10 15:06 EBSapps.env
· Migrate Latest Code to Database Tier
On the Application Tier (as the APPLMGR user):
Run AutoConfig on the run file system.
. /u01/oracle/TEST/EBSapps.env run
cd ADMIN_SCRIPTS_HOME
adautocfg.sh
Create the appsutil.zip file in <INST_TOP>/admin/out.
perl $AD_TOP/bin/admkappsutil.pl
Copy appsutil.zip file to database $ORACLE_HOME
On the Database Tier (as the ORACLE user):
Source the environment variables for RDBMS ORACLE_HOME.
Uncompress appsutil.zip, under <RDBMS ORACLE_HOME>.
cd <ORACLE_HOME>
backup appsutil folder
unzip -o appsutil.zip
cp –pr appsutil_backup/jre appsutil/
perl adbldxml.pl ( there is no Context File in new appsutil directory so regenerate it )
Run AutoConfig on <RDBMS ORACLE_HOME>
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
· Run ETCC according to the section “3.1.1 Prerequisite.
· Source the run edition environment file.
. /u01/oracle/TEST/fs1/EBSapps/appl/APPSTEST_ermtest.env
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start ( It is already started for upgrade patch )
· Start up only Weblogic AdminServer service on the run edition application tier file system
· Apply below patches
Unzip patches and run adgrants
Patch 20745242 (R12.AD.C.Delta.7)
Patch 22123818:R12.AD.C
Patch 20784380 (R12.TXK.C.Delta.7)
Patch 22363475:R12.TXK.C
Patch 22495069:R12.TXK.C
Note : Compare adgrants.sql versions with in the patch directory and $APPL_TOP/admin
vi 20745242/admin/adgrants.sql
vi $APPL_TOP/admin/adgrants.sql
sqlplus / as sysdba @/app/oracle/PROD/fs_ne/EBSapps/patch/20745242/admin/adgrants.sql apps
· Copy all patches to the $PATCH_TOP (/u01/oracle/TEST/fs_ne/EBSapps/patch )
adop phase=apply patches=20745242 hotpatch=yes
sqlplus / as sysdba @/app/oracle/PROD/fs_ne/EBSapps/patch/22123818/admin/adgrants.sql apps
run etcc on db and app nodes
adop phase=apply patches=22123818 hotpatch=yes
adop phase=apply patches=20784380,22363475,22495069 hotpatch=yes merge=yes
After applied the patch with merge parameter. ( applied Delta Patches ) you will see the env file in your system base directory
/u01/oracle/TEST
-rw-r--r-- 1 applmgr oinstall 6467 Mar 10 15:06 EBSapps.env
· Migrate Latest Code to Database Tier
On the Application Tier (as the APPLMGR user):
Run AutoConfig on the run file system.
. /u01/oracle/TEST/EBSapps.env run
cd ADMIN_SCRIPTS_HOME
adautocfg.sh
Create the appsutil.zip file in <INST_TOP>/admin/out.
perl $AD_TOP/bin/admkappsutil.pl
Copy appsutil.zip file to database $ORACLE_HOME
On the Database Tier (as the ORACLE user):
Source the environment variables for RDBMS ORACLE_HOME.
Uncompress appsutil.zip, under <RDBMS ORACLE_HOME>.
cd <ORACLE_HOME>
backup appsutil folder
unzip -o appsutil.zip
cp –pr appsutil_backup/jre appsutil/
perl adbldxml.pl ( there is no Context File in new appsutil directory so regenerate it )
Run AutoConfig on <RDBMS ORACLE_HOME>
13. Restart app and DB
--UPGRADING EBS FROM 12.2.0 TO 12.2.5--
Oracle E-Business Suite Release 12.2.5 Readme (Doc ID 1983050.1) Section 7 and 8
Path A — Upgrade and New Installation Customers upgrading to Oracle E-Business Suite 12.2.5 Release Update Pack
14. Source the run edition applications environment.
It is already set in .bash_profile
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
16. Set the “optimizer_adaptive_features” database parameter to FALSE (required for Database version 12.1.0.2).
sqlplus "/as sysdba"
alter system set optimizer_adaptive_features=false scope=both;
System altered.
show parameter optimizer_adaptive_features
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
optimizer_adaptive_features boolean FALSE
17. Apply Oracle E-Business Suite 12.2.5 Release Update Pack Patch 19676458 on the run edition application environment, using downtime mode
cd $ADMIN_SCRIPTS_HOME
adstpall.sh apps/password
adop phase=apply apply_mode=downtime patches=19676458
Note : Restarting 12.2.5 patch fails with "ERRORMSG: Cannot identify any valid application tier nodes/ORA-01400: Cannot Insert NULL Into ("APPLSYS"."FND_NODES"."NODE_NAME")" (Doc ID 2112122.1)
18. Set the “optimizer_adaptive_features” database parameter to TRUE again
sqlplus "/as sysdba"
alter system set optimizer_adaptive_features=false scope=both;
System altered.
show parameter optimizer_adaptive_features
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
optimizer_adaptive_features boolean FALSE
17. Apply Oracle E-Business Suite 12.2.5 Release Update Pack Patch 19676458 on the run edition application environment, using downtime mode
cd $ADMIN_SCRIPTS_HOME
adstpall.sh apps/password
adop phase=apply apply_mode=downtime patches=19676458
Note : Restarting 12.2.5 patch fails with "ERRORMSG: Cannot identify any valid application tier nodes/ORA-01400: Cannot Insert NULL Into ("APPLSYS"."FND_NODES"."NODE_NAME")" (Doc ID 2112122.1)
sqlplus "/as sysdba"
alter system set optimizer_adaptive_features=true scope=both;
System altered.
19. Start all Application tier services on the run file system.
sh $ADMIN_SCRIPTS_HOME/adstrtal.sh
20. Perform adop cleanup action.
adop phase=cleanup
21. 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.
adop phase=fs_clone
--POST UPGRADE STEPS--
22. Apply Oracle E-Business Suite Release 12.2.5 Online Help Patch 19676460 using adop hotpatch mode on the run file system.
adop phase=apply patches=19676460 hotpatch=yes
23. To apply NLS ( Turkish ) Language patch follow the instructions in correct order
· Activate the new language using the Oracle Applications Manager (OAM) License Manager.
· Maintain snapshot information
· Run the AD Administration utility to maintain multi-lingual tables from the Maintain Applications Database Entities menu.
· Log on to your Applications' administration node as the APPLMGR user and source the APPL_TOP environment file. If you are on Release 12.2.0 or above, make sure you are connected to the RUN edition. Use the manifest generation tool to generate a manifest file by executing the following command:
perl $AD_TOP/bin/adgennls.pl
The manifest generated from the tool is located at :
$APPL_TOP/admin/$TWO_TASK/out/adgennls.txt
22. Apply Oracle E-Business Suite Release 12.2.5 Online Help Patch 19676460 using adop hotpatch mode on the run file system.
adop phase=apply patches=19676460 hotpatch=yes
· Activate the new language using the Oracle Applications Manager (OAM) License Manager.
· Maintain snapshot information
· Run the AD Administration utility to maintain multi-lingual tables from the Maintain Applications Database Entities menu.
· Log on to your Applications' administration node as the APPLMGR user and source the APPL_TOP environment file. If you are on Release 12.2.0 or above, make sure you are connected to the RUN edition. Use the manifest generation tool to generate a manifest file by executing the following command:
perl $AD_TOP/bin/adgennls.pl
The manifest generated from the tool is located at :
$APPL_TOP/admin/$TWO_TASK/out/adgennls.txt
Request a translation sync path using "https://updates.oracle.com/TransSync"
Upload and apply patch with adop through an online patching cycle (prepare,apply,finalize,cutover,cleanup)
24. Apply Localizations patches and implement localizations if necessary.
At this point, we reached the end. That is our EBS 12.2.5 is ready for use. But, before I put an end to this blog post, I want to share some useful documents with you.
Following is a list of document that may be useful according to your needs.
For NLS- >Oracle E-Business Suite NLS Release Notes, Release 12.2 (Doc ID 1314621.1)
For HR Legislative: DATAINSTALL AND HRGLOBAL APPLICATION: 12.2 SPECIFICS (Doc ID 1469456.1)
For Localization : Creating CLE Product & Applying Mandatory Patches for R12.2 EMEA Add-on Localizations (Doc ID 1628719.1) --optional
EMEA Add-on Localizations - Upgrade steps to 12.2 (Doc ID 1593750.1) --optional
For Turkish Localizations -> R12 EMEA Add-on Localizations - Turkey (Doc ID 472686.1)
At this point, we reached the end. That is our EBS 12.2.5 is ready for use. But, before I put an end to this blog post, I want to share some useful documents with you.
Following is a list of document that may be useful according to your needs.
For NLS- >Oracle E-Business Suite NLS Release Notes, Release 12.2 (Doc ID 1314621.1)
For HR Legislative: DATAINSTALL AND HRGLOBAL APPLICATION: 12.2 SPECIFICS (Doc ID 1469456.1)
For Localization : Creating CLE Product & Applying Mandatory Patches for R12.2 EMEA Add-on Localizations (Doc ID 1628719.1) --optional
EMEA Add-on Localizations - Upgrade steps to 12.2 (Doc ID 1593750.1) --optional
For Turkish Localizations -> R12 EMEA Add-on Localizations - Turkey (Doc ID 472686.1)
Awesome...Exactly what I was looking for . Thank you for great post.
ReplyDeleteAwesome Post Emran. God Bless You
ReplyDeletegood post
ReplyDeleteThanks for the awesome document. I am able to get the 12.2.5 running on OEL 6.7 following these steps.
ReplyDeletegreat post, I was executing the same steps.
ReplyDeletegracias! muy buen post
ReplyDeleteHi Erman!
ReplyDeleteI would like to apply on top of 12.2.5 Financials and SUpply Chain reccomended critical patches .. How do you search for them ? Patch Wizard ? I tried manual search in Metalink.. It just show 12.2 and not show is it applicable or not for 12.2.5. Any hints?
Thanks,Linda
Hi Linda,
ReplyDeleteCheck this note: How to Find E-Business Suite Recommended Patches (Doc ID 1400757.1)
I didnt try it yet, but I hope it will help you.
Also note that, there is no guarantee for RPC patches.
ReplyDeleteFor example: as for the Payables 12.2.X, at the moment, there are no available Recommended Patch Collection (RPC)
Also, 2 facts for you:
1)All patches available for versions 12.2 can be found on: My Oracle support > Patches & Updates > Select Product: Payable > Release: 12.2
2)latest patch news: https://community.oracle.com/community/support/oracle_e-business_suite/e-business_patching
Good Document with Clear Steps. Keep sharing........... Thanks & Regards Venkatesh RK
ReplyDeleteExcellent doc with clear steps thanks Earman
ReplyDeleteExcellent i will follow this doc
ReplyDeleteI have a question can we perform upgrade from 12.2.0 with startCD 46 to 12.2.5
Might me we need to upgrade db 12c and fmw to 1119 or else use starCD 51 if i m wrong please correct me
Hi Misba,
ReplyDeleteStartCDs are just for the installation. Initial installation.
However the startCD version is also important for the upgrades, because using a higher version of startCD for the initial installation, will make your job easier during the upgrade.
I mean afher 12.2.0 installation, you need to do the prereqs for the EBS 12.2.5 right?, so that prereqs will change according to your startCD version.
That is, if you did the installation using an old version startCD, then you will have to do more preregs. FMW 11.1.1.7 upgrade for example.
So the answer for your question is yes. you can perform upgrade from 12.2.0 (installed with startCD 46) to 12.2.5.
As for the db; 12c is not a must.
As for the FMW; currently -> Oracle E-Business Suite 12.2.5 Release Update Pack requires Fusion Middleware Technology Stack (FMW) 11.1.1.7 (11gR1 PS6) or higher.
However, I recommend you to install EBS 12.2.0 using startCD 51. As I said earlier, It will ease your job.
Also , versions below start CD 51 is not supported for the installation. So if you encounter any problem, Oracle support may say to you " use startCD 51".
Hi Erman,
ReplyDeleteI was followed to article for oracle e-business suit 12.2 so when i upgrade 12.2.0 to 12.2.5 some issue will come
2. Apply RDBMS (12.1.0.2) Patches
Note: Shutdown database before apply patches
Not included in any startCD
Linux x86-64
21841318
22098146
21286665
21967332
opatch rollback -id 18893947
21387964
already install database 12.1.2 why again apply these patches.
You apply these patches on top of 12.1.0.2, because these patches are not included in any installation package.
Deletewhen search this patch at oracle 21967332 lot of patches will come which patch i will choose.
ReplyDeleteYou will install the patch according to your environment.
Deletei.e For Linux intel 64 bit, you will insatall the patch for release 12.1.0.2.0 and platform Linux X86-64
What is the way to install 12.2.6. How do I know which files I have to down load from edelivary.
ReplyDeleteCheck this link. It is already answered in my forum.
ReplyDeletehttp://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/not-ablel-to-download-ebs-12-2-5-files-td1342.html
In edelivery, choose Oracle Financial(EBS,FIN,Oracle E-Business Suite,ebusiness) , then choose Oracle EBS 12.2.6. (also choose your OS type)
After this, you will see the files.
Don't bother if the filenames are not like the ones documented in my blog post.
This is normal, as now the latest release is EBS 12.2.6 and the files are new.
What you will do is, download EBS 12.2.0 (all the installation files) + download EBS 12.2.6 (all the installation files), download Oracle Database 12c (all the installation files), download the relevant lanuage installation file + weblogic + webiter files + Oracle E-Business Suite (12.2.5).
It seem there is bug there. Because, the files which is in EBS 12.2.5 category is needed for EBS 12.2.6 install as well.
Hi Emran,
ReplyDeleteThanks for your wonderful document.Need one clarification,WHen i am checking the edlivery for release pack update r12.2.5 i couldnt able to find the RUP's for 12.2.5.latest version 12.2.6 is available.can you confirm ?
Ameer
Oracle Software Delivery Cloud
ReplyDeleteNeed Help?Contact Software Delivery Customer Service
If more than one release is available, you may select an alternate release by clicking on the 'Select Alternate Release...' link.
Download Queue
Release
Selected Item
Applicable Terms & Restrictions
Size
Published Date
Oracle E-Business Suite 12.2.6.0.0 for Linux x86-64, 115 files
Select Alternate Release...
Oracle Financials Oracle Standard Terms and Restrictions 85.6 GB Jan 30, 2017
Oracle E-Business Suite (12.2.6), 13 files
7.3 GB
Oracle Database (12.1.0.2.0), 2 files
2.5 GB
Oracle E-Business Suite (12.2.0), 6 files
7.1 GB
Oracle E-Business Suite (12.2.5), 17 files
24.7 GB
Oracle E-Business Suite Languages (12.2.0.0.0), 36 files
22.0 GB
Oracle E-Business Suite Languages (12.2.6.0.0), 36 files
11.4 GB
Oracle E-Business Suite Mobile Application Archive (6.0), 2 files
5.4 GB
Oracle Mobile Maintenance for Oracle E-Business Suite Mobile Application Archive (1.6), 1 file
2.3 GB
Oracle Web Tier (11.1.1.9.0), 1 file
2.0 GB
Oracle WebLogic Server (10.3.6.0.0), 1 file
1018.5 MB
Hi Emran,
ReplyDeletewonderful document!!
I installed EBS 12.2.0 with startCD 47 then upgraded to EBS 12.2.3 successfully. Now i am having 11.2.0.3 DB along with 12.2.3 applications.
Please suggest me the procedure to upgrade the DB from 11.2.0.3 to 11.2.0.4 (or) 12.1.0.2 so that i can later upgrade EBS 12.2.3 to 12.2.5.
Thanks in Advance!!
Hi Mohammed,
ReplyDeleteFollow Section 1 "Upgrading an R12 Database to Oracle Database 11g Release 2 (11.2.0)" of Oracle Support document named "Interoperability Notes E-Business Suite Release 12.2 with Database 11g Release 2 (Doc ID 1623879.1)".
Hi Ermar,
ReplyDeleteThanks for the document, this doc makes the 12.2.5 installation easy.
I installed 12.2.5, I skipped step 11(Apply patch for Oracle Weblogic Server 10.3.6.0) but successfully upgraded to 12.2.5. I thought that it(step 11) is for security bug fixes, please correct me if i am wrong and suggest me that i need to complete the step 11 now.
The patch versions documented in this blog post belong to the time that this blog post is written.
ReplyDeleteYou need to read this blog post, but follow the oracle documentation while installing EBS.
This blog post is written for showing you the way.
So , the up-to-date patch versions should be gathered from Oracle support.
Bytheway, you can't ignore anything during the installation. Prereq is prereq.
Now, You should check : Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)
Section 4.4: Oracle WebLogic Server 10.3.6.0 Patch and Bug Numbers
Actually, check the document above entirely.
You should apply the patches documented in 1594274.1.
If you didn't yet, then you are lucky.
You should apply the patches even if you are upgraded 12.2.5.
In general the documentation you follow should start with EBS readme (EBS 12.2.5 readme in your case). The readme will direct you to all the necessary documents.
-->
apply the latest application tier technology patches documented in 'Section 4: Application Tier Technology Patches and Bug Numbers' of My Oracle Support Knowledge Document 1594274.1, Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes.
Note: Refer to My Oracle Support Knowledge Document 1355068.1, Oracle E-Business Suite 12.2 Patching Technology Components Guide for instructions on how to apply technology patches.' of My Oracle Support Knowledge Document 1594274.1, Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes.
Thank you.
DeleteHi Erman i successfully installed the 12.2.5 and now i want to upgrade it to 12.2.6
ReplyDeletecan you please suggest me any docs(or) links. what patch set should i download and apply.
Thanks in advance
This is very easy. Just follow the readme.
ReplyDeleteOracle E-Business Suite Release 12.2.6 Readme (Doc ID 2114016.1)
This comment has been removed by the author.
DeleteHi Erman! How long did it take for you to get that translation patch you requested ? 1-2 days ? Thx!
ReplyDeleteHi, within the same day. Most of the times, in 2 hours.
ReplyDeleteHi..
ReplyDeleteI want upgrade R12.1.3 to R12.2.0.
If any document
You can start with this note ->
ReplyDelete"Oracle® E-Business Suite Upgrade Guide Release 12.0 and 12.1 to 12.2 Part No. E48839-03"
Link: https://docs.oracle.com/cd/E51111_01/current/acrobat/122upg12.pdf
Hi Erman,
ReplyDeleteUnfortunately I deinstall the one I installed. It made it impossible for me to send you all that you asked me. I want to rerty it but can I use your installation steps?
Lexy
Lexy,
ReplyDeleteWe were trucking your issue under the forum entry : http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Can-t-login-into-EBS12-2-browser-tp4690.html
So you have already a forum entry for this.. Please, update that forum entry (don't make comments here)
As for your question; read my blog to get the idea, to understand the process.. On the other hand; follow Oracle documents for doing the installation. they may be more up-to-date.
how to set this two parameters. i am facing issue while running rda report.
ReplyDeleteit gives me kernel parameter semmni too small. kernel parameter semmns too small
how to set this
kernel.semmsl 256
cat /proc/sys/kernel/sem
250 32000 100 128
Please advise thanks
kernel.semmns 32000
SEMMSL defines the maximum number of System V IPC semaphores per identifier.
ReplyDeleteIt is the max number of semaphores per set.
kernel.sem = SEMMSL SEMMNS SEMOPM SEMMNI
Basically, the formula is "(max number of arrays)*(max semaphores per array)=(max semaphores system wide)."
Your SEMMSL is 250 and you want to increase it to 256 , right?
To set the values permanently in Linux, make sure the file "/etc/sysctl.conf" has the line.
kernel.sem = SEMMSL_value SEMMNS_value SEMOPM_value SEMMNI_value
Edit the file using vi and save it..
for example:
kernel.sem = 256 32000 100 128
and then activate the changes:
# /sbin/sysctl -p /etc/sysctl.conf
note that, those semaphore values are "minimum" recommended values.
ReplyDeleteIn order to set these values properly, you need to know your database workload. Max number of connections and Max number of concurrent connections..
Hi Erman,
ReplyDeleteI am a fresher starting to learn the oracle apps installation by myself. I read your blog. and i need a small clarity in the step 11.
how i will get the startcd folder by unzipping which sipped file. Could you please let me know.
which oracle ebusiness suite 12.2 files should i copy to database server and app server
ReplyDeleteThis one is awesome blog. Much thanks.
ReplyDeleteHere is another solution: https://www.ssogen.com/oracle-ebs-sso-integrations/
Kind regards,
-Mikemiller.
I am facing error at db installation phase when rman is trying to restore the control files (restorerman1.sql)
ReplyDeleteno autobackup found or specified handle
My stage is NFS mounted and taken care of all mount point options.
Kindly suggest further.
Hi, I am not getting Oracle E-Business Suite Release 12.2.5 Update Pack. is it obsolete or what. When I am trying to find I got Oracle E-Business Suite Release 12.2.8 Update Pack. Please help
ReplyDeleteHi I got error at 12%, unable to rename the database in error log, May i know the issue.
ReplyDelete