Linux, Oracle, Oracle E-Business Suite

Oracle E-Business Suite Installation

by jb

In this post we are going to install Oracle E-Business Suite 12.2 on a RHEL 8 system. We will use Oracle Database 12.1 as the database.

We will perform the installation on a single Virtual Machine. The setup of the VM is described here. The time each individual step takes can be seen in the headings.

Preparation

The required files to perform the installation can be found on edelivery.oracle.com (Search for: DLP: Oracle E-Business Suite 12.2.14). I will put them on a shared location that is accessible from the VM (/sw/ora_ebs/12214). Because Oracle E-Business Suite needs quite a lot of resources we will increase the memory of the VM to 12GB and the number of virtual CPUs to 8. Run the following on the host machine of the VM to do this:

set "VHOST="
(set /p VHOST=Enter VM name ^(e.g. lin1^): 
call vboxmanage controlvm %VHOST% shutdown         &rem Power down the VM and wait
timeout /T 10 /NOBREAK
call vboxmanage modifyvm %VHOST% --memory=12288    &rem Set the VM RAM to 12 GB
call vboxmanage modifyvm %VHOST% --cpus=8          &rem Set the number of virtual CPUs to 8
call vboxmanage startvm %VHOST%)                   &rem Power up the Virtual Machine

Setup of the staging area (25m)

First we create groups and users, install required OS packages and create directories.

# as root:
# install packages
dnf -y install libpthread.so.0 libnsl.so.1 libXext.so.6 libXtst.so.6 libXrender-0.9.10-7.el8.i686 motif-2.3.4-16.el8.i686 motif-devel-2.3.4-16.el8.i686 perl-File-CheckTree-4.42-303.el8.noarch redhat-lsb-4.1 glibc-devel.i686 libstdc++.so.6
# libpthread.so.0 libnsl.so.1 is needed to run jdk 1.6 32bit
# libXext.so.6 libXtst.so.6 is needed to run the rapidwiz installer
# create users
groupadd -g 9999 oinstall 
groupadd -g 8888 asmadmin 
groupadd -g 7777 asmdba 
groupadd -g 6666 asmoper 
useradd -g oinstall -G asmadmin,asmdba,asmoper,vboxsf grid
echo 'grid:welcome1'|chpasswd
groupadd -g 1010 dba 
groupadd -g 1020 oper
useradd -g oinstall -G dba,oper,asmdba,vboxsf oracle
echo 'oracle:welcome1'|chpasswd
# to avoid: error importing function definition for `which'
echo 'unset which' >> ~oracle/.bash_profile
echo "alias tal='tail -200f /d01/oracle/VIS/12.1.0/admin/VIS_lin1/diag/rdbms/vis/VIS/trace/alert_VIS.log'" >>~oracle/.bash_profile
cd /usr/lib; ln -s libXm.so.4.0.4 libXm.so.2 # for Oracle Forms and Reports

# create stage area
mkdir -p /d01 ; chown -R oracle:oinstall /d01
mkdir -p /oracle/oraInventory; chown -R oracle:dba /oracle
cat << EOF > /etc/oraInst.loc
inventory_loc=/oracle/oraInventory
inst_group=dba
EOF
chown oracle:oinstall /etc/oraInst.loc
mkdir -p /sw/ora_ebs/StageR122; chown oracle:oinstall /sw/ora_ebs/StageR122
# create swap space
dd if=/dev/zero of=/swapfile bs=1024 count=7340032 # create a 7 GB swapfile
mkswap /swapfile && chmod 0600 /swapfile && swapon /swapfile
echo '/swapfile       swap       swap       defaults       0 0' >> /etc/fstab
swapon
# set kernel parameters
cat << EOF > /etc/sysctl.conf
kernel.sem = 256 32000 100 142
kernel.shmall = 2097152
kernel.shmmax = 6442450944
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.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
EOF
sysctl -p

Then we start the setup of the staging area as the oracle user.

# as oracle
su - oracle
# unpack the patches
cd /sw/ora_ebs/12214patches
if [[ ! -d 36541996 ]] ; then unzip -oq p36541996_R12_GENERIC.zip ; fi
if [[ ! -d 32947483 ]] ; then unzip -oq p32947483_R12_GENERIC.zip ; fi
if [[ ! -d 36332179 ]] ; then unzip -oq p36332179_R12_GENERIC.zip ; fi
if [[ ! -d 17537119 ]] ; then mkdir 17537119; unzip -q p17537119_R12_GENERIC.zip -d 17537119; fi
# fill the stage area
cd /sw/ora_ebs/12214/; cp V358*zip V100*zip V10419*zip V29*zip V75*zip V46*zip /sw/ora_ebs/StageR122
cd /sw/ora_ebs/StageR122
unzip -q V100052-01_1of3.zip; unzip -q V100052-01_2of3.zip; unzip -q V100052-01_3of3.zip
# apply StartCD 51 patch
cd /sw/ora_ebs/12214patches/36541996
echo /sw/ora_ebs/StageR122|./patchRIStage.sh
# build the stage area
cat << EOF > ~/build_stage.exp
log_file ~/build_stage.log
set timeout -1
spawn /sw/ora_ebs/StageR122/startCD/Disk1/rapidwiz/bin/buildStage.sh
# Create new stage area
expect "Press Enter to continue"
send "\r"
expect "Enter your choice"
send "1\r"
expect "Enter your choice"
send "2\r"
expect "Specify the directory"
send "/sw/ora_ebs/StageR122\r"
expect "Press Enter to continue"
exec >@stdout 2>@stderr sync
sleep 10
send "\r"
expect "Press Enter to continue"
send "\r"
expect "Press Enter to continue"
send "\r"
expect "Press Enter to continue"
send "\r"
expect "Press Enter to continue"
send "\r"
# Copy patches to existing stage area
expect "Enter your choice"
send "2\r"
expect "Enter your choice"
send "2\r"
expect "Press Enter to continue"
send "\r"
expect "Press Enter to continue"
send "\r"
expect "Press Enter to continue"
send "\r"
# Exiting
expect "Enter your choice"
send "4\r"
expect eof
EOF
expect ~/build_stage.exp

# install patches
cat << EOF > ~/patch.exp
log_file ~/build_patch.log
set timeout -1
spawn /sw/ora_ebs/StageR122/startCD/Disk1/rapidwiz/bin/buildStage.sh
expect "Press Enter to continue"
send "\r"
expect "Enter your choice"
send "2\r"
expect "Enter your choice"
send "2\r"
expect "Press Enter to continue"
send "\r"
expect "Press Enter to continue"
send "\r"
expect "Press Enter to continue"
send "\r"
# Exiting
expect "Enter your choice"
send "4\r"
expect eof
EOF
cd /sw/ora_ebs/12214patches/32947483
echo /sw/ora_ebs/StageR122|./patchRIStage.sh
expect ~/patch.exp
cd /sw/ora_ebs/12214patches/36332179
echo /sw/ora_ebs/StageR122|./patchRIStage.sh
expect ~/patch.exp
cd

Standard Installation (Rapid Install) (2h15m)

We will start the installation of the Oracle E-Business Suite now as the oracle user in a X terminal with these commands:

cd /sw/ora_ebs/StageR122/startCD/Disk1/rapidwiz/
./rapidwiz

Enter welcome1 as the passwords

The main installation will start now and take about 2 hours. If all went well we see a screen like that:

Press Finish to end the Standard Installation.

Updating the Technology Stack

Applying the Latest Application Tier Technology Patches to the Run File System (45m)

We will us the EBS Tech Patch Automation Tool – Application Tier (ETPAT-AT) to install the patches. As of now these patches need to be downloaded (in .zip format) to /sw/ora_ebs/12214patches/:

  • p6880880_101000_LINUX.zip
  • p6880880_111000_Linux-x86-64.zip
  • p36616672_R12_LINUX_1of2.zip and p36616672_R12_LINUX_2of2.zip
  • p17537119_R12_GENERIC.zip
  • p33845432_R12_GENERIC.zip
  • p35710802_R12_GENERIC.zip

Now we start the installation of etpat-at:

# stop the application services
. /d01/oracle/VIS/fs1/EBSapps/appl/VIS_lin1.env
(echo apps; echo apps; echo welcome1)|/d01/oracle/VIS/fs1/inst/apps/VIS_lin1/admin/scripts/adstpall.sh

# patch the database and the Middle Tier
mkdir /d01/oracle/VIS/fs_ne/EBSapps/patch/etpat-at
cd /d01/oracle/VIS/fs_ne/EBSapps/patch/etpat-at
# copy patches to stage area
cp /sw/ora_ebs/12214patches/p6880880* .
cp /sw/ora_ebs/12214patches/p36616672_R12_LINUX_* .
cp /sw/ora_ebs/12214patches/p17537119_R12_GENERIC.zip .
cp /sw/ora_ebs/12214patches/p33845432_R12_GENERIC.zip .
cp /sw/ora_ebs/12214patches/p35710802_R12_GENERIC.zip .
# start etpat-at
unzip -q /sw/ora_ebs/12214patches/p32208510_R12_GENERIC.zip
. /d01/oracle/VIS/fs1/EBSapps/appl/APPSVIS_lin1.env
perl ./etpat_at.pl <<EOF
/d01/oracle/VIS/fs1/inst/apps/VIS_lin1/appl/admin/VIS_lin1.xml
apps
apps
/d01/oracle/VIS/fs_ne/EBSapps/patch/etpat-at
Yes
/d01/oracle/VIS/fs_ne/EBSapps/patch/etpat-at
1
Yes
Yes
EOF

Applying Required Database Patches (15m)

We will now stop the database and apply all required patches on top of the Oracle 12.1.0.2 database.

# shutdown database
. /d01/oracle/VIS/12.1.0/VIS_lin1.env; echo 'shutdown immediate'|sqlplus -S / as sysdba
# apply Patch 34057742: DATABASE PATCH SET UPDATE 12.1.0.2.220719
cd; unzip -oq /sw/ora_ebs/12214patches/p34057742_121020_Linux-x86-64.zip
# update opatch
mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch.old
unzip -oq /sw/ora_ebs/12214patches/p6880880_122010_Linux-x86-64.zip -d $ORACLE_HOME
. /d01/oracle/VIS/fs1/EBSapps/appl/VIS_lin1.env
# remove conflicting patches
$ORACLE_HOME/OPatch/opatch nrollback -silent -id 18485835,18689530,20181016,20204035,20476776
# apply PSU
$ORACLE_HOME/OPatch/opatch apply -silent ~/34057742
# because of error: ORA-22308: operation not allowed on evolved type (Doc ID 2327572.1) during datapatch
sqlplus -S / as sysdba <<EOF
startup
drop type sys.oracle_loader;
drop type sys.oracle_datapump;
@?/rdbms/admin/dpload.sql
EOF
# run datapatch
cd $ORACLE_HOME/OPatch; ./datapatch
# rollback and apply individual patches
. /d01/oracle/VIS/12.1.0/VIS_lin1.env; echo 'shutdown immediate'|sqlplus -S / as sysdba
mkdir ~/dbfixes; for i in `ls /sw/ora_ebs/12214patches/dbfixes/`; do unzip -oq /sw/ora_ebs/12214patches/dbfixes/$i -d ~/dbfixes/; done
cd ~/dbfixes; $ORACLE_HOME/OPatch/opatch napply -id 15894842,19665139,20123899,20181016,21293453,21321429,21322448,21864513,21904072,21967332,25305405,25599890,27531926,30614876,33327372,33620146,34067556,34086863,34275933 -silent
# run datapatch
lsnrctl start; echo 'startup'|sqlplus -S / as sysdba
cd $ORACLE_HOME/OPatch; ./datapatch
echo '@?/rdbms/admin/utlrp'|sqlplus -S / as sysdba

Now we check the Database and the Middle Tier and verify that all patches are applied.

. /d01/oracle/VIS/fs1/EBSapps/appl/APPSVIS_lin1.env
echo apps|/d01/oracle/VIS/fs_ne/EBSapps/patch/etpat-at/checkMTpatch.sh
. /d01/oracle/VIS/12.1.0/VIS_lin1.env
/d01/oracle/VIS/fs_ne/EBSapps/patch/etpat-at/checkDBpatch.sh
Sample Output: 
[oracle@lin1 ~]$ . /d01/oracle/VIS/fs1/EBSapps/appl/APPSVIS_lin1.env
[oracle@lin1 ~]$ echo apps|/d01/oracle/VIS/fs_ne/EBSapps/patch/etpat-at/checkMTpatch.sh
 +===============================================================+
 |    Copyright (c) 2005, 2025 Oracle and/or its affiliates.     |
 |                     All rights reserved.                      |
 |             Oracle E-Business Suite Release 12.2              |
 |        Application Tier EBS Technology Codelevel Checker      |
 +===============================================================+

Using context file from currently set applications environment:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin1/appl/admin/VIS_lin1.xml

Starting Application Tier EBS Technology Codelevel Checker, Version 120.0.12020000.70.
Fri Feb 28 11:06:07 CET 2025
Log file for this session: /home/oracle/log/checkMTpatch_13280.log

Bugfix XML file version: 120.0.12020000.64
This file will be used for identifying missing bugfixes.

Mapping XML file version: 120.0.12020000.52
This file will be used for mapping bugfixes to patches.


[WARNING] ETCC: Bugfix XML file (/d01/oracle/VIS/fs_ne/EBSapps/patch/etpat-at/mw/txk_R1220_MT_base_bugs.xml) is more than
 30 days old.

Checking for prerequisite bugfixes in File Edition: run
stty: 'standard input': Inappropriate ioctl for device

Enter the password for the APPS user: stty: 'standard input': Inappropriate ioctl for device

Connecting to database.
Database connection successful.
The installed AD.C codelevel does not support storing the results in the database.
===============================================================================
Oracle Forms and Reports
===============================================================================
Now examining Oracle Forms and Reports.

Oracle Home: /d01/oracle/VIS/fs1/EBSapps/10.1.2.
Product version: 10.1.2.3.0.
Checking required bugfixes for Oracle Forms and Reports 10.1.2.3.0.
All required bugfixes are present for Oracle Forms and Reports.

Identified DST version: 18

Checking required bugfixes for RSF 10.1.0.5.0 in Oracle Forms.
All required bugfixes are present for RSF 10.1.0.5.0 in Oracle Forms.

===============================================================================
Oracle Fusion Middleware (FMW) - Web Tier
===============================================================================
Now examining Oracle Fusion Middleware (FMW) - Web Tier.

Oracle Home: /d01/oracle/VIS/fs1/FMW_Home/webtier.
Product version: 11.1.1.9.0.
Checking required bugfixes for FMW - Web Tier 11.1.1.9.0.
All required bugfixes are present for FMW - Web Tier.

Identified DST version: 18

Checking required bugfixes for RSF 11.1.0.7.0 in FMW Web tier.
All required bugfixes are present for RSF 11.1.0.7.0 in FMW Web tier.

===============================================================================
Oracle Fusion Middleware (FMW) - Oracle Common
===============================================================================
Now examining Oracle Fusion Middleware (FMW) - Oracle Common.

Oracle Home: /d01/oracle/VIS/fs1/FMW_Home/oracle_common.
Product version: 11.1.1.9.0.
Checking required bugfixes for FMW - Oracle Common 11.1.1.9.0.
All required bugfixes are present for FMW - Oracle Common.

===============================================================================
Oracle WebLogic Server (WLS)
===============================================================================
Now examining WLS.

Oracle Home: /d01/oracle/VIS/fs1/FMW_Home/wlserver_10.3.
Product version: 10.3.6.0.231017.
Note: For WLS, patches rather than bugfixes are verified.
Checking required patches for WLS 10.3.6.0.231017.
All required patches are present for WLS.

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

All required one-offs are confirmed as present.
Finished checking prerequisite patches for file edition: run.
Fri Feb 28 11:06:26 CET 2025

Log file for this session: /home/oracle/log/checkMTpatch_13280.log

===============================================================================
[oracle@lin1 ~]$ . /d01/oracle/VIS/12.1.0/VIS_lin1.env
[oracle@lin1 ~]$ /d01/oracle/VIS/fs_ne/EBSapps/patch/etpat-at/checkDBpatch.sh

 +===============================================================+
 |    Copyright (c) 2005, 2025 Oracle and/or its affiliates.     |
 |                     All rights reserved.                      |
 |             Oracle E-Business Suite Release 12.2              |
 |          Database EBS Technology Codelevel Checker            |
 +===============================================================+

Validating context file: /d01/oracle/VIS/12.1.0/appsutil/VIS_lin1.xml

Using context file from currently set database environment:
/d01/oracle/VIS/12.1.0/appsutil/VIS_lin1.xml

Starting Database EBS Technology Codelevel Checker, Version 120.133
Fri Feb 28 11:06:27 CET 2025
Log file for this session: /home/oracle/log/checkDBpatch_14634.log

Identifying database release.
Database release set to 12.1.0.2.

Connecting to database.
Database connection successful.

Database VIS is in READ WRITE mode.

Identifying APPS and APPLSYS schema names.
 - APPS schema: APPS
 - APPLSYS schema: APPLSYS

Checking for existence DB-ETCC results table.
Table to store DB-ETCC results already exists in the database.

Checking if InMemory option is enabled.
InMemory option is not enabled in the database.

Bugfix file /d01/oracle/VIS/fs_ne/EBSapps/patch/etpat-at/db/onprem/txk_R1220_DB_base_bugs.xml: 120.0.12020000.89
This file will be used for identifying missing bugfixes.

Mapping file /d01/oracle/VIS/fs_ne/EBSapps/patch/etpat-at/db/onprem/txk_R1220_DB_mappings.xml: 120.0.12020000.67
This file will be used for mapping bugfixes to patches.

+---------------------------------------------------------------------------------------+
  Always use the latest version of ETCC available in patch 17537119,
  as new bugfixes will not be checked by older versions of the utility.

  You should apply the latest recommended RU, BP, or PSU as appropriate.
+---------------------------------------------------------------------------------------+


Identified database DST version: 18

Checking Bugfix XML file for tag 12.1.0.2_PSU.

Obtained list of bugfixes to be applied and list to be rolled back.

Validating OPatch version:
The OPatch utility is version 12.2.0.1.45.
DB-ETCC is compatible with this OPatch version.

Checking for applied patch history:
Found patch history in the inventory.

Checking mapping XML file for tag 12.1.0.2.220719.

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

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

+---------------------------------------------------------------------------------------+
[WARNING] 36834621 - DATABASE PATCH SET UPDATE 12.1.0.2.241015 is not applied.
This is the recommended database patch update. You should install it now
and then rerun this script to check for any further fixes available.

    - Filename: p36834621_121020_Linux-x86-64.zip

Alternatively, you can remain on your existing patch update and apply all
the patches listed above from the consolidated zip file, which is only shown
when patches need to be installed.
+---------------------------------------------------------------------------------------+

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

Finished checking fixes for database VIS: Fri Feb 28 11:06:47 CET 2025

Log file for this session: /home/oracle/log/checkDBpatch_14634.log
This file should be reviewed for errors after the ETCC run.

=========================================================================================
[oracle@lin1 ~]$

Updating to the Latest Oracle E-Business Suite Code

Applying the Consolidated Seed Table Upgrade Patch (25m)

The next step is to apply the Seed Table Patch. This can be done with the following commands (s.a. Oracle Doc ID 1320300.1 (2.2)):

unzip -oq /sw/ora_ebs/12214patches/p26787701_12.2.0_R12_GENERIC.zip -d /d01/oracle/VIS/fs_ne/EBSapps/patch/
. /d01/oracle/VIS/fs1/EBSapps/appl/VIS_lin1.env
(echo apps; echo apps; echo welcome1)|$ADMIN_SCRIPTS_HOME/adstpall.sh
echo welcome1|$ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
(echo apps; echo manager; echo welcome1)|adop phase=apply patches=26787701 hotpatch=yes

Applying the Latest AD and TXK Patchsets (1h23m)

See also Oracle Document 1617461.1. The Latest AD and TXK Patchset can be applied with:

unzip -q /sw/ora_ebs/12214patches/p36119925_R12.AD.C_R12_LINUX.zip -d /d01/oracle/VIS/fs_ne/EBSapps/patch/
unzip -q /sw/ora_ebs/12214patches/p36303698_R12.AD.C_R12_GENERIC.zip -d /d01/oracle/VIS/fs_ne/EBSapps/patch/
unzip -q /sw/ora_ebs/12214patches/p36989014_R12.AD.C_R12_GENERIC.zip -d /d01/oracle/VIS/fs_ne/EBSapps/patch/
unzip -q /sw/ora_ebs/12214patches/p36117775_R12.TXK.C_R12_GENERIC_1of3.zip -d /d01/oracle/VIS/fs_ne/EBSapps/patch/
unzip -q /sw/ora_ebs/12214patches/p36117775_R12.TXK.C_R12_GENERIC_2of3.zip -d /d01/oracle/VIS/fs_ne/EBSapps/patch/
unzip -q /sw/ora_ebs/12214patches/p36117775_R12.TXK.C_R12_GENERIC_3of3.zip -d /d01/oracle/VIS/fs_ne/EBSapps/patch/
unzip -q /sw/ora_ebs/12214patches/p36641685_R12.TXK.C_R12_GENERIC.zip -d /d01/oracle/VIS/fs_ne/EBSapps/patch/
unzip -q /sw/ora_ebs/12214patches/p37500697_R12.TXK.C_R12_GENERIC.zip -d /d01/oracle/VIS/fs_ne/EBSapps/patch/
. /d01/oracle/VIS/12.1.0/VIS_lin1.env
echo "alter system set \"_disable_actualization_for_grant\"=true;"|sqlplus -S / as sysdba
/d01/oracle/VIS/fs_ne/EBSapps/patch/etpat-at/checkDBpatch.sh
. /d01/oracle/VIS/fs1/EBSapps/appl/APPSVIS_lin1.env
echo apps|/d01/oracle/VIS/fs_ne/EBSapps/patch/etpat-at/checkMTpatch.sh
# perform installation (Path A)
. /d01/oracle/VIS/fs1/EBSapps/appl/APPSVIS_lin1.env
(echo welcome1; echo apps)|$ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
mkdir /d01/oracle/VIS/12.1.0/appsutil/admin
cp /d01/oracle/VIS/fs_ne/EBSapps/patch/36989014/admin/adgrants.sql /d01/oracle/VIS/12.1.0/appsutil/admin
. /d01/oracle/VIS/12.1.0/VIS_lin1.env
echo '@/d01/oracle/VIS/12.1.0/appsutil/admin/adgrants.sql apps'|sqlplus -S /nolog
sqlplus -S / as sysdba <<EOF
alter user ebs_system account unlock;
alter user ebs_system identified by manager;
EOF
. /d01/oracle/VIS/fs1/EBSapps/appl/APPSVIS_lin1.env
(echo apps; echo manager)|perl /d01/oracle/VIS/fs_ne/EBSapps/patch/36119925/ad/bin/adValidateEbssystemSchema.pl
# apply AD patches
(echo apps; echo manager; echo welcome1)|adop phase=apply patches=36119925 hotpatch=yes
(echo apps; echo manager; echo welcome1)|adop phase=apply patches=36303698,36989014 hotpatch=yes merge=yes  #  testen!!!
#(echo apps; echo manager; echo welcome1)|adop phase=apply patches=36303698 hotpatch=yes
#(echo apps; echo manager; echo welcome1)|adop phase=apply patches=36989014 hotpatch=yes
# apply TXK patches
(echo apps; echo manager; echo welcome1)|adop phase=apply patches=36117775 hotpatch=yes
(echo apps; echo manager; echo welcome1)|adop phase=apply patches=36641685,37500697 hotpatch=yes merge=yes
. /d01/oracle/VIS/EBSapps.env run
echo apps|/d01/oracle/VIS/fs_ne/EBSapps/patch/etpat-at/checkMTpatch.sh
. /d01/oracle/VIS/12.1.0/VIS_lin1.env
/d01/oracle/VIS/fs_ne/EBSapps/patch/etpat-at/checkDBpatch.sh
(echo welcome1; echo apps)|$ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
. /d01/oracle/VIS/EBSapps.env run
echo welcome1|$ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
# Section 5: Update Database Tier to Latest AutoConfig Code
. /d01/oracle/VIS/EBSapps.env run
perl $AD_TOP/bin/admkappsutil.pl
. /d01/oracle/VIS/12.1.0/VIS_lin1.env
cd $ORACLE_HOME; cp /d01/oracle/VIS/fs1/inst/apps/VIS_lin1/admin/out/appsutil.zip .; unzip -o ./appsutil.zip
echo apps|$ORACLE_HOME/appsutil/scripts/VIS_lin1/adautocfg.sh
. /d01/oracle/VIS/EBSapps.env run
echo apps|/d01/oracle/VIS/fs1/inst/apps/VIS_lin1/admin/scripts/adautocfg.sh

# Update Cipher Suite
sed -i s/SSLProtocol.*/'SSLProtocol TLSv1.2'/ /d01/oracle/VIS/fs1/FMW_Home/webtier/instances/EBS_web_VIS_OHS1/config/OHS/EBS_web_VIS/ssl.conf
sed -i s/'ssl-versions="TLSv1.0"'/'ssl-versions="TLSv1.2"'/ /d01/oracle/VIS/fs1/FMW_Home/webtier/instances/EBS_web_VIS_OHS1/config/OPMN/opmn/opmn.xml
sed -i s/'ssl-ciphers="SSL_RSA_WITH_AES_128_CBC_SHA,SSL_RSA_WITH_3DES_EDE_CBC_SHA"'/'ssl-ciphers="SSL_RSA_WITH_AES_128_CBC_SHA,SSL_RSA_WITH_AES_128_GCM_SHA256"'/ /d01/oracle/VIS/fs1/FMW_Home/webtier/instances/EBS_web_VIS_OHS1/config/OPMN/opmn/opmn.xml

Applying the Latest Oracle E-Business Suite Release Update Pack for Release 12.2 (8h)

See also Oracle Doc ID 3011520.1. The Release Update 12.2.14 can be applied with these commands:

unzip -oq /sw/ora_ebs/12214/V1042587-01_\*of13.zip -d /d01/oracle/VIS/fs_ne/EBSapps/patch
. /d01/oracle/VIS/EBSapps.env run
(echo welcome1; echo apps)|$ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
echo welcome1|$ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
# the next step takes about 6h
(echo apps; echo manager; echo welcome1)|adop phase=apply apply_mode=downtime patches=36026788 workers=4
sqlplus apps/apps @/d01/oracle/VIS/fs1/EBSapps/appl/fnd/12.0.0/sql/fndscmpa.sql
(echo apps; echo apps; echo welcome1)|$ADMIN_SCRIPTS_HOME/adstrtal.sh
(echo apps; echo manager; echo welcome1)|adop phase=cleanup
(echo apps; echo manager; echo welcome1)|adop phase=fs_clone
# Apply Oracle E-Business Suite Release 12.2.14 Online Help
unzip -oq /sw/ora_ebs/12214patches/p36026775_R12_GENERIC.zip -d /d01/oracle/VIS/fs_ne/EBSapps/patch
(echo apps; echo manager; echo welcome1)|adop phase=apply patches=36026775 hotpatch=yes workers=4

Now go to the following URL and unlock the system: http://lin1.fritz.box:8000/OA_HTML/AppsLocalLogin.jsp (login as sysadmin) then click unlock, select “Ignore the security configuration warnings.” and select proceed (see screenshots).


We proceed with the Release Upgrade by running:

expect -i <<EOF
spawn AFPASSWD -P BACKGROUND
expect "\'APPSUSER\': "
send "apps\r"
expect "[EBS_SYSTEM]:"
send "manager\r"
expect eof
EOF
unzip -oq /sw/ora_ebs/12214patches/p36470037_R12.FWK.C_R12_GENERIC.zip -d /d01/oracle/VIS/fs_ne/EBSapps/patch
# s.a. Doc ID 1927975.1
(echo apps; echo apps; echo welcome1)|/d01/oracle/VIS/fs1/inst/apps/VIS_lin1/admin/scripts/adstpall.sh
(echo apps; echo manager; echo welcome1)|adop phase=apply apply_mode=downtime patches=36470037 workers=4
# 3.5 Apply EBS System Schema Migration Completion Patch Doc ID 2755875.1
unzip -oq /sw/ora_ebs/12214patches/p32573930_R12_GENERIC.zip -d /d01/oracle/VIS/fs_ne/EBSapps/patch
. /d01/oracle/VIS/EBSapps.env run
(echo apps; echo manager; echo welcome1)|adop phase=cleanup cleanup_mode=full
sqlplus apps/apps @$AD_TOP/sql/ADSYSCC.sql
(echo apps; echo manager; echo welcome1)|adop phase=apply patches=32573930 apply_mode=hotpatch options=forceapply,nocopyportion,nogenerateportion
. /d01/oracle/VIS/12.1.0/VIS_lin1.env
cp $AD_TOP/patch/115/sql/adsysmigclnup.sql $ORACLE_HOME/appsutil/admin
sqlplus /nolog @$ORACLE_HOME/appsutil/admin/adsysmigclnup.sql apps
echo '@?/rdbms/admin/utlrp'|sqlplus -S / as sysdba
. /d01/oracle/VIS/EBSapps.env run
(echo apps; echo manager; echo welcome1)|adop -validate
(echo apps; echo apps; echo welcome1)|/d01/oracle/VIS/fs1/inst/apps/VIS_lin1/admin/scripts/adstrtal.sh

Login to the new Oracle E-Business Suite server

We are now ready to login as the sysadmin user to the new Oracle E-Business Suite server (click).

Accounts created during the installation

The following accounts have been created during the installation:

AccountPasswordType
oraclewelcome1OS user
weblogicwelcome1WebLogic Server
appsappsdatabase user
applsysapps
apps_neapps
systemmanagerdatabase user
ebs_systemmanagerdatabase user
syschange_on_installdatabase user
sysadminsysadminapplication user
abm/ahl/…abm/ahl/…

System URLs

URLusernameType
http://lin1.fritz.box:8000/OA_HTML/AppsLoginsysadminOracle E-Business Suite Login page
http://lin1.fritz.box:8000/OA_HTML/AppsLocalLogin.jspsysadminSecure Configuration Console
http://lin1.fritz.box:7001/emweblogicFusion Middleware Control
http://lin1.fritz.box:7001/consoleweblogicWebLogic Administration Console
http://lin1.fritz.box:8000/OA_HTML/weboam/oam/oamApps$target=VISOracle Applications Manager

Basic Administration tasks

# as user oracle
# stop all Application Services
. /d01/oracle/VIS/fs1/EBSapps/appl/VIS_lin1.env
(echo apps; echo apps; echo welcome1)|/d01/oracle/VIS/fs1/inst/apps/VIS_lin1/admin/scripts/adstpall.sh
# stop database
. /d01/oracle/VIS/12.1.0/VIS_lin1.env; echo 'shutdown immediate'|sqlplus -S / as sysdba
# stop the database (19c)
. /d01/oracle/VIS/19.3.0/VISCDB_lin1.env; unset TWO_TASK; echo 'shutdown immediate'|sqlplus -S / as sysdba
# start database and listener
. /d01/oracle/VIS/12.1.0/VIS_lin1.env; lsnrctl start; echo 'startup'|sqlplus -S / as sysdba
# start database and listener (19c)
. /d01/oracle/VIS/19.3.0/VISCDB_lin1.env; unset TWO_TASK; lsnrctl start; echo 'startup'|sqlplus -S / as sysdba
# start all Application Services
. /d01/oracle/VIS/fs1/EBSapps/appl/VIS_lin1.env
(echo apps; echo apps; echo welcome1)|/d01/oracle/VIS/fs1/inst/apps/VIS_lin1/admin/scripts/adstrtal.sh
# start only the Admin Server
(echo welcome1; echo apps)|/d01/oracle/VIS/fs1/inst/apps/VIS_lin1/admin/scripts/adadminsrvctl.sh start
# get Release Update Pack (RUP) version (e.g. 12.2.0 or 12.2.3)
echo 'select release_name from fnd_product_groups;'|sqlplus -S apps/apps
# get adop status
adop -status
# cleanup failed adop session
adop phase=cleanup
# run AD Controller
. /d01/oracle/VIS/fs1/EBSapps/appl/APPSVIS_lin1.env; adctrl
# source environments (since 12.2.2), arguments: run or patch
. /d01/oracle/VIS/EBSapps.env run
# monitor adop operations
echo apps|adopmon
# AutoConfig Database Tier Preview
echo apps|/d01/oracle/VIS/12.1.0/appsutil/bin/adchkcfg.sh contextfile=/d01/oracle/VIS/12.1.0/appsutil/VIS_lin1.xml
# AutoConfig Application Tier Preview
echo apps|/d01/oracle/VIS/fs1/EBSapps/appl/ad/12.0.0/bin/adchkcfg.sh contextfile=/d01/oracle/VIS/fs1/inst/apps/VIS_lin1/appl/admin/VIS_lin1.xml
# run AutoConfig on the Database Tier
. /d01/oracle/VIS/12.1.0/VIS_lin1.env
echo apps|/d01/oracle/VIS/12.1.0/appsutil/scripts/VIS_lin1/adautocfg.sh
# run AutoConfig on the Application Tier
echo apps|/d01/oracle/VIS/fs1/inst/apps/VIS_lin1/admin/scripts/adautocfg.sh
# display Middleware patches
. /d01/oracle/VIS/fs1/FMW_Home/SetWebtier.env
opatch lsinventory
Sample Output from some commands: 
# AutoConfig Database Tier Preview
[oracle@lin1 bin]$ echo apps|/d01/oracle/VIS/12.1.0/appsutil/bin/adchkcfg.sh contextfile=/d01/oracle/VIS/12.1.0/appsutil/VIS_lin1.xml
stty: 'standard input': Inappropriate ioctl for device
Enter the APPS password:
stty: 'standard input': Inappropriate ioctl for device

The log file for this session is located at: /d01/oracle/VIS/12.1.0/appsutil/log/VIS_lin1/03030859/adconfig.log

AutoConfig is running in test mode and building diffs...

AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /d01/oracle/VIS/12.1.0

Value of s_dbcset is AL32UTF8

Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.

Library orai18n.jar exists.

Value of s_dbcset is AL32UTF8

Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.

Library orai18n.jar exists.
        Classpath                   : :/d01/oracle/VIS/12.1.0/jdbc/lib/ojdbc7.jar:/d01/oracle/VIS/12.1.0/appsutil/java/xmlparserv2.jar:/d01/oracle/VIS/12.1.0/appsutil/java:/d01/oracle/VIS/12.1.0/jlib/netcfg.jar:/d01/oracle/VIS/12.1.0/jlib/ldapjclnt12.jar:/d01/oracle/VIS/12.1.0/jlib/orai18n.jar

        Using Context file          : /d01/oracle/VIS/12.1.0/appsutil/out/VIS_lin1/03030859/VIS_lin1.xml

Context Value Management will now update the test Context file

        Updating test Context file...COMPLETED

        [ Test mode ]
        No uploading of Context File and its templates to database.

Updating rdbms version in Context file to db121
Updating rdbms type in Context file to 64 bits
Testing templates from ORACLE_HOME ...

Differences text report is located at: /d01/oracle/VIS/12.1.0/appsutil/out/VIS_lin1/03030859/cfgcheck.txt

        Generating Profile Option differences report...COMPLETED
Differences text report for the Database is located at: /d01/oracle/VIS/12.1.0/appsutil/out/VIS_lin1/03030859/ProfileReport.txt
        Generating File System differences report......COMPLETED
Differences html report is located at: /d01/oracle/VIS/12.1.0/appsutil/out/VIS_lin1/03030859/cfgcheck.html

Differences Zip report is located at: /d01/oracle/VIS/12.1.0/appsutil/out/VIS_lin1/03030859/ADXcfgcheck.zip

AutoConfig completed successfully.
[oracle@lin1 bin]$ cat /d01/oracle/VIS/12.1.0/appsutil/out/VIS_lin1/03030859/cfgcheck.txt

The AutoConfig Diff tool (adchkcfg.sh/.cmd) did not find any  differences between your current AutoConfig configuration files  and the new AutoConfig configuration files.
[oracle@lin1 bin]$

# AutoConfig Application Tier Preview
[oracle@lin1 bin]$ echo apps|/d01/oracle/VIS/fs1/EBSapps/appl/ad/12.0.0/bin/adchkcfg.sh contextfile=/d01/oracle/VIS/fs1/inst/apps/VIS_lin1/appl/admin/VIS_lin1.xml
stty: 'standard input': Inappropriate ioctl for device
Enter the APPS password:
stty: 'standard input': Inappropriate ioctl for device

The log file for this session is located at: /d01/oracle/VIS/fs1/inst/apps/VIS_lin1/admin/log/03030854/adconfig.log


wlsDomainName: EBS_domain_VIS
WLS Domain Name is VALID.
AutoConfig is running in test mode and building diffs...

AutoConfig will consider the custom templates if present.
        Using CONFIG_HOME location     : /d01/oracle/VIS/fs1/inst/apps/VIS_lin1
        Classpath                   : /d01/oracle/VIS/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/d01/oracle/VIS/fs1/EBSapps/comn/java/classes

        Using Context file          : /d01/oracle/VIS/fs1/inst/apps/VIS_lin1/admin/out/03030854/VIS_lin1.xml

Context Value Management will now update the test Context file

        Updating test Context file...COMPLETED

        [ Test mode ]
        No uploading of Context File and its templates to database.

Testing templates from all of the product tops...
        Testing AD_TOP........COMPLETED
        Testing FND_TOP.......COMPLETED
        Testing ICX_TOP.......COMPLETED
        Testing MSC_TOP.......COMPLETED
        Testing IEO_TOP.......COMPLETED
        Testing BIS_TOP.......COMPLETED
        Testing CZ_TOP........COMPLETED
        Testing SHT_TOP.......COMPLETED
        Testing AMS_TOP.......COMPLETED
        Testing CCT_TOP.......COMPLETED
        Testing WSH_TOP.......COMPLETED
        Testing CLN_TOP.......COMPLETED
        Testing OKE_TOP.......COMPLETED
        Testing OKL_TOP.......COMPLETED
        Testing OKS_TOP.......COMPLETED
        Testing CSF_TOP.......COMPLETED
        Testing IBY_TOP.......COMPLETED
        Testing JTF_TOP.......COMPLETED
        Testing MWA_TOP.......COMPLETED
        Testing CN_TOP........COMPLETED
        Testing CSI_TOP.......COMPLETED
        Testing WIP_TOP.......COMPLETED
        Testing CSE_TOP.......COMPLETED
        Testing EAM_TOP.......COMPLETED
        Testing GMF_TOP.......COMPLETED
        Testing PON_TOP.......COMPLETED
        Testing FTE_TOP.......COMPLETED
        Testing ONT_TOP.......COMPLETED
        Testing AR_TOP........COMPLETED
        Testing AHL_TOP.......COMPLETED
        Testing IES_TOP.......COMPLETED
        Testing OZF_TOP.......COMPLETED
        Testing CSD_TOP.......COMPLETED
        Testing IGC_TOP.......COMPLETED

Differences text report is located at: /d01/oracle/VIS/fs1/inst/apps/VIS_lin1/admin/out/03030854/cfgcheck.txt

        Generating Profile Option differences report...COMPLETED
Differences text report for the Database is located at: /d01/oracle/VIS/fs1/inst/apps/VIS_lin1/admin/out/03030854/ProfileReport.txt
        Generating File System differences report......COMPLETED
Differences html report is located at: /d01/oracle/VIS/fs1/inst/apps/VIS_lin1/admin/out/03030854/cfgcheck.html

Differences Zip report is located at: /d01/oracle/VIS/fs1/inst/apps/VIS_lin1/admin/out/03030854/ADXcfgcheck.zip

AutoConfig completed successfully.
[oracle@lin1 bin]$ more /d01/oracle/VIS/fs1/inst/apps/VIS_lin1/admin/out/03030854/cfgcheck.txt

The AutoConfig Diff tool (adchkcfg.sh/.cmd) did not find any  differences between your current AutoConfig configuration files  and the new AutoConfig configuration files.
[oracle@lin1 bin]$

# run AutoConfig on the Database Tier
[oracle@lin1 ~]$ . /d01/oracle/VIS/12.1.0/VIS_lin1.env
[oracle@lin1 ~]$ echo apps|/d01/oracle/VIS/12.1.0/appsutil/scripts/VIS_lin1/adautocfg.sh
stty: 'standard input': Inappropriate ioctl for device
Enter the APPS user password:stty: 'standard input': Inappropriate ioctl for device

The log file for this session is located at: /d01/oracle/VIS/12.1.0/appsutil/log/VIS_lin1/03030828/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /d01/oracle/VIS/12.1.0

Value of s_dbcset is AL32UTF8

Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.

Library orai18n.jar exists.

Value of s_dbcset is AL32UTF8

Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.

Library orai18n.jar exists.
        Classpath                   : :/d01/oracle/VIS/12.1.0/jdbc/lib/ojdbc7.jar:/d01/oracle/VIS/12.1.0/appsutil/java/xmlparserv2.jar:/d01/oracle/VIS/12.1.0/appsutil/java:/d01/oracle/VIS/12.1.0/jlib/netcfg.jar:/d01/oracle/VIS/12.1.0/jlib/ldapjclnt12.jar:/d01/oracle/VIS/12.1.0/jlib/orai18n.jar

        Using Context file          : /d01/oracle/VIS/12.1.0/appsutil/VIS_lin1.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db121
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.
[oracle@lin1 ~]$

# run AutoConfig on the Application Tier
[oracle@lin1 ~]$ echo apps|/d01/oracle/VIS/fs1/inst/apps/VIS_lin1/admin/scripts/adautocfg.sh
stty: 'standard input': Inappropriate ioctl for device
Enter the APPS user password:
stty: 'standard input': Inappropriate ioctl for device

The log file for this session is located at: /d01/oracle/VIS/fs1/inst/apps/VIS_lin1/admin/log/03030834/adconfig.log


wlsDomainName: EBS_domain_VIS
WLS Domain Name is VALID.
AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using CONFIG_HOME location     : /d01/oracle/VIS/fs1/inst/apps/VIS_lin1
        Classpath                   : /d01/oracle/VIS/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/d01/oracle/VIS/fs1/EBSapps/comn/java/classes

        Using Context file          : /d01/oracle/VIS/fs1/inst/apps/VIS_lin1/appl/admin/VIS_lin1.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
        Configuring AD_TOP........COMPLETED
        Configuring FND_TOP.......COMPLETED
        Configuring ICX_TOP.......COMPLETED
        Configuring MSC_TOP.......COMPLETED
        Configuring IEO_TOP.......COMPLETED
        Configuring BIS_TOP.......COMPLETED
        Configuring CZ_TOP........COMPLETED
        Configuring SHT_TOP.......COMPLETED
        Configuring AMS_TOP.......COMPLETED
        Configuring CCT_TOP.......COMPLETED
        Configuring WSH_TOP.......COMPLETED
        Configuring CLN_TOP.......COMPLETED
        Configuring OKE_TOP.......COMPLETED
        Configuring OKL_TOP.......COMPLETED
        Configuring OKS_TOP.......COMPLETED
        Configuring CSF_TOP.......COMPLETED
        Configuring IBY_TOP.......COMPLETED
        Configuring JTF_TOP.......COMPLETED
        Configuring MWA_TOP.......COMPLETED
        Configuring CN_TOP........COMPLETED
        Configuring CSI_TOP.......COMPLETED
        Configuring WIP_TOP.......COMPLETED
        Configuring CSE_TOP.......COMPLETED
        Configuring EAM_TOP.......COMPLETED
        Configuring GMF_TOP.......COMPLETED
        Configuring PON_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
[oracle@lin1 ~]$

Are EBS patches applied?

Can be checked with the Oracle Applications Manager => Applied Patches

Further information

Staging area cleanup

These files can be deleted to save space. They will be recreated by a new installation.

# as root
cd; chmod -R 777 /sw/ora_ebs/StageR122/* # this avoids a 'Protocol error' during the cleanup of the vboxsf filesystem
rm -rf /sw/ora_ebs/StageR122

Database Upgrade to Oracle 19c

The Upgrade of the database from 12.1 to 19c is described in this post.