ANJANI APPS DBA: Oracle EBS R12.2.9 installation step by step process

Hi All,

In this post i am sharing how to install Oracle EBS R12.2.9 on OEL step by step.

In this post will share >> stage creation and EBS application configuration - Part 2/2 ,

Rapid Install - application tier installation

After successful installation of the database tier, the application tier should be installed

Start a VNC server for accessing the application tier node in GUI mode. From a VNC client,

Start rapidwiz , $./rapidwiz

Click next to proceed , select 12.2.0 Install then next

If you have already database then you need to configure application select first options here we have just before created database for EBS application as part of 1/2 . we will select second option then click next

validate the system configuration make sure all success if any error need to fix else it will not proceed further .

Component install status

Select yes then click on next

EBs installation is in progress monitor the application configuration log

validation completed successfully then click next

Click on Finish , it will close the GUI

Log files ::::::

[root@StgApp01 rapidwiz]# ./rapidwiz

Rapid Install Wizard is validating your file system......

CMDDIR=/backup/12.2.9_stage/startCD/Disk1/rapidwiz

Rapid Install Wizard will now launch the Java Interface.....

[root@StgApp01 rapidwiz]#

Configuration file written to: /ebsprod/app/PROD/fs1/inst/apps/PROD_stgapp01/conf_PROD.txt

Configuration file written to: /ebsprod/app/PROD/fs2/inst/apps/PROD_stgapp01/conf_PROD.txt

Second File System logfile - /ebsprod/app/PROD/fs2/inst/apps/PROD_stgapp01/logs/01072207.log

First File System logfile - /ebsprod/app/PROD/fs1/inst/apps/PROD_stgapp01/logs/01072207.log

Check the login page

EBS Technology Code level Checker (ETCC)

ETCC can be downloaded via Patch 17537119

New Installation Customers

New Installation customers should also run the codelevel checker utility (checkDBpatch.sh or checkDBpatch.cmd for Microsoft Windows) to identify and apply required patches for Database 12.1.0.2. After the release of the startCD, new required patches may have been discovered.

Document 1594274.1, Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes and apply all technology patches for your database and middle tier versions.

The application tier technology patches you need to apply are listed 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.

Run the ETCC on DB node : complete log

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

[oraprod@Oracle ETCC]$ ./checkDBpatch.sh

>> complete log shared in the part 1/2 ..

Check the Opatch version

=== === ====

~]$./opatch version

OPatch Version: 12.1.0.1.10

OPatch succeeded.

Opatch commands ::::::::

export PATH=$PATH:$ORACLE_HOME/OPatch

export PATH=$PATH:/ebsprod/oracle/PROD/12.1.0/OPatch

opatch prereq CheckConflictAgainstOHWithDetail -ph ./ >>> Check the conflicts

opatch apply

opatch lsinv –inactive

opatch lsinventory |grep 29176139

which opatch

opatch –version

Check MT Patch >> run ETCC on Application node.

applprod@appsndes ETCC]$ ./checkMTpatch.sh

[applprod@StgApp01 ETCC]$ ./checkMTpatch.sh

+===============================================================+

| Oracle E-Business Suite Release 12.2 |

| Applicatione Tier Technology Codelevel Checker |

+===============================================================+

Using context file from currently set applications environment:

/ebsprod/app/PROD/fs1/inst/apps/PROD_stgapp01/appl/admin/PROD_stgapp01.xml

Starting Application Tier Technology Codelevel Checker

Version: 120.0.12026000.38.

Wed Jan 8 10:05:34 IST 2026

Log file for this session: /ebsprod/app/ETCC/log/checkMTpatch_62514.log

Bugfix XML file version: 120.0.12026000.42

This file will be used for identifying missing bugfixes.

Mapping XML file version: 120.0.12026000.26

This file will be used for mapping bugfixes to patches.

Checking for prerequisite bugfixes in File Edition: run

Enter the password for the APPS user:

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 product Oracle Forms and Reports.

Oracle Home = /ebsprod/app/PROD/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.

Missing Bugfix: 17353142 -> Patch 26825525

Missing Bugfix: 20643256 -> Patch 26825525

Missing Bugfix: 16041055 -> Patch 26825525

Missing Bugfix: 16910762 -> Patch 26825525

Missing Bugfix: 20270659 -> Patch 26825525

Missing Bugfix: 17372642 -> Patch 26825525

Missing Bugfix: 17566694 -> Patch 26825525

Missing Bugfix: 20240480 -> Patch 26825525

Missing Bugfix: 19304738 -> Patch 26825525

Missing Bugfix: 20391574 -> Patch 26825525

Missing Bugfix: 22351071 -> Patch 26825525

Missing Bugfix: 21024122 -> Patch 26825525

Missing Bugfix: 19588847 -> Patch 26825525

Missing Bugfix: 19639173 -> Patch 26825525

Missing Bugfix: 20545718 -> Patch 26825525

Missing Bugfix: 22524329 -> Patch 26825525

Missing Bugfix: 23123655 -> Patch 26825525

Missing Bugfix: 23728755 -> Patch 26825525

Missing Bugfix: 24315226 -> Patch 26825525

Missing Bugfix: 24480018 -> Patch 26825525

Missing Bugfix: 24808044 -> Patch 26825525

Missing Bugfix: 24620875 -> Patch 26825525

Missing Bugfix: 25355211 -> Patch 26825525

Missing Bugfix: 23538157 -> Patch 26825525

Missing Bugfix: 23538170 -> Patch 26825525

Missing Bugfix: 13557392 -> Patch 26825525

Missing Bugfix: 25506193 -> Patch 26825525

Missing Bugfix: 25342269 -> Patch 25342269

Missing Bugfix: 26048089 -> Patch 26825525

Missing Bugfix: 25990479 -> Patch 26825525

Missing Bugfix: 1770039 -> Patch 26825525

Missing Bugfix: 27491934 -> Patch 27491934

The above list shows missing bugfixes for Oracle Forms and Reports.

Checking required bugfixes for RSF within Forms 10.1.0.5.0.

All required bugfixes are present for RSF within Forms.

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

Oracle Fusion Middleware (FMW) - Web Tier

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

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

Oracle Home = /ebsprod/app/PROD/fs1/FMW_Home/webtier.

Product Version = 11.1.1.9.0

Checking required bugfixes for FMW - Web Tier 11.1.1.9.0.

Missing Bugfix: 21300463 -> Patch 22288381

Missing Bugfix: 21892015 -> Patch 22288381

Missing Bugfix: 23266217 -> Patch 27369643

Missing Bugfix: 22750215 -> Patch 27369643

Missing Bugfix: 23055182 -> Patch 27369643

Missing Bugfix: 26318200 -> Patch 27369643

Missing Bugfix: 24567879 -> Patch 27301611

Missing Bugfix: 20900385 -> Patch 27301611

Missing Bugfix: 26837992 -> Patch 27301611

Missing Bugfix: 21305938 -> Patch 27301611

Missing Bugfix: 20913582 -> Patch 27301611

Missing Bugfix: 22218211 -> Patch 27301611

Missing Bugfix: 23107407 -> Patch 27301611

Missing Bugfix: 19571821 -> Patch 27301611

Missing Bugfix: 26929226 -> Patch 27301611

Missing Bugfix: 25191174 -> Patch 27301611

Missing Bugfix: 26101975 -> Patch 27301611

Missing Bugfix: 21520649 -> Patch 27301611

The above list shows missing bugfixes for FMW - Web Tier.

Checking required bugfixes for RSF within FMW Web tier 11.1.0.7.0.

Missing Bugfix: 20004021 -> Patch 22290164

Missing Bugfix: 20004087 -> Patch 22290164

Missing Bugfix: 16872333 -> Patch 22290164

Missing Bugfix: 19699191 -> Patch 22290164

Missing Bugfix: 20558005 -> Patch 22290164

Missing Bugfix: 20331945 -> Patch 22290164

The above list shows missing bugfixes for RSF within FMW Web tier.

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

Oracle Fusion Middleware (FMW) - oracle_common

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

Now examining product Oracle Fusion Middleware (FMW) - oracle_common.

Oracle Home = /ebsprod/app/PROD/fs1/FMW_Home/oracle_common.

Product Version = 11.1.1.9.0

Checking required bugfixes for FMW - oracle common 11.1.1.9.0.

Missing Bugfix: 9905685 -> Patch 9905685

Missing Bugfix: 17428617 -> Patch 17428617

Missing Bugfix: 21366277 -> Patch 21366277

Missing Bugfix: 21628307 -> Patch 21628307

Missing Bugfix: 24606362 -> Patch 24606362

Missing Bugfix: 24843064 -> Patch 24843064

Missing Bugfix: 13544814 -> Patch 13544814

Missing Bugfix: 16089637 -> Patch 16089637

Missing Bugfix: 20141119 -> Patch 20141119

Missing Bugfix: 24335626 -> Patch 27120730

Missing Bugfix: 22998551 -> Patch 27120730

Missing Bugfix: 22660018 -> Patch 27120730

Missing Bugfix: 24913281 -> Patch 27120730

Missing Bugfix: 20055551 -> Patch 27120730

Missing Bugfix: 27212806 -> Patch 27212806

Missing Bugfix: 28371189 -> Patch 28708563

The above list shows missing bugfixes for FMW - oracle common.

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

Oracle WebLogic Server (WLS)

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

Now examining product Oracle WebLogic Server (WLS).

Oracle Home = /ebsprod/app/PROD/fs1/FMW_Home/wlserver_10.3.

Product Version = 10.3.6.0.7

Note that for Oracle WebLogic Server, patches rather than bugfixes are verified.

Checking required patches for Oracle WebLogic Server (WLS) 10.3.6.0.7.

Missing Patch ID: 27395085

The above list shows missing patches for Oracle WebLogic Server.

If you have applied other Oracle WebLogic Server patches, they may have included the bugfixes needed.

Contact Oracle Support if you require assistance in determining whether this is the case.

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

Generating Patch Recommendation Summary.

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

PATCH RECOMMENDATION SUMMARY

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

One or more products have bugfixes missing.

The default patch recommendations to install these missing bugfixes are:

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

Oracle Forms and Reports 10.1.2.3.0

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

Patch 26825525

- Filename: p26825525_101232_LINUX.zip

Patch 25342269

- Filename: p25342269_101232_Generic.zip

Patch 27491934

- Filename: p27491934_101232_LINUX.zip

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

Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0

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

Patch 22288381

- Filename: p22288381_111190_Generic.zip

Patch 27369643

- Filename: p27369643_111190_Linux-x86-64.zip

Patch 27301611

- Filename: p27301611_111190_Linux-x86-64.zip

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

RSF within FMW Web tier 11.1.0.7.0

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

Patch 22290164

- Filename: p22290164_111070_Linux-x86-64.zip

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

Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0

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

Patch 9905685

- Filename: p9905685_111190_Generic.zip

Patch 17428617

- Filename: p17428617_111190_Generic.zip

Patch 21366277

- Filename: p21366277_111190_Generic.zip

Patch 21628307

- Filename: p21628307_111190_Generic.zip

Patch 24606362

- Filename: p24606362_111190_Generic.zip

Patch 24843064

- Filename: p24843064_111190_Generic.zip

Patch 13544814

- Filename: p13544814_111190_Generic.zip

Patch 16089637

- Filename: p16089637_111190_Generic.zip

Patch 20141119

- Filename: p20141119_111190_Generic.zip

Patch 27120730

- Filename: p27120730_111190_Generic.zip

Patch 27212806

- Filename: p27212806_111190_Generic.zip

Patch 28708563

- Filename: p28708563_111190_Generic.zip

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

Oracle WebLogic Server (WLS) 10.3.6.0.7

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

Patch 27395085 [SU Patch [GFWX]: WLS PSU 10.3.6.0.180417]

- Filename: p27395085_1036_Generic.zip

Apply the required patches and rerun this script.

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

A consolidated zip file with the required application tier patches is

available on My Oracle Support via:

Patch 29778100

- EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JUL 2019

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

[WARNING] Patch 27395085 [SU Patch [GFWX]: WLS PSU 10.3.6.0.180417] is missing.

This is the current recommended minimum WLS patch set.

As patch sets are not included in the consolidated zip file, you must obtain it

(or a later one, if available) from My Oracle Support and install it by

following its Readme.

After successful installation, rerun this script to check for any further

available fixes.

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

See Doc ID 1594274.1 for any special instructions regarding these patches.

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

Finished checking prerequisite patches for File Edition: run.

Wed Jan 8 10:06:06 IST 2026

Log file for this session: /ebsprod/app/ETCC/log/checkMTpatch_62514.log

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

[applprod@StgApp01 ETCC]$

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

Oracle Forms and Reports 10.1.2.3.0

[appldev@appsnodes dev]$ . ./fsautoDEV.sh

Running fsauto 1.0 :

Context Name (<SID_host>) : DEV_appsnodes

RUN Edition APPL_TOP : /ebsdev/app/dev/fs1

PATCH Edition APPL_TOP : /ebsdev/app/dev/fs2

Non-Editioned File System : /ebsdev/app/dev/fs_ne/EBSapps/appl

Instance Top Directory : /ebsdev/app/dev/fs1/inst/apps/DEV_appsnodes

APPL_TOP environment file : /ebsdev/app/dev/fs1/EBSapps/appl/APPSDEV_appsnodes.env

Admin Scripts Home : /ebsdev/app/dev/fs1/inst/apps/DEV_appsnodes/admin/scripts

Setting RUN Edition APPL_TOP environment for /ebsdev/app/dev/fs1 ...

Done.

[appldev@appsnodes dev]$ which opatch

/ebsdev/app/dev/fs1/EBSapps/10.1.2/OPatch/opatch

/stage/patches/APP_patches/LINUX_X86-64/forms/10.1.2.3.0/26825525

Environment sourcing as below

run etcc on application node and apply all missed pacthes by source each respective oracle homes.

export ORACLE_HOME=

export PATH=$PATH:$ORACLE_HOME/OPatch

ORACLE_HOME=/Apps/apps/VISR1228/fs1/EBSapps/10.1.2

ORACLE_HOME=/Apps/apps/VISR1228/fs1/FMW_Home/webtier

ORACLE_HOME=/Apps/apps/VISR1228/fs1/FMW_Home/oracle_common

ORACLE_HOME=/Apps/apps/VISR1228/fs1/FMW_Home/wlserver_10.3

Weblogic patch

./bsu.sh -prod_dir=$FMW_HOME/wlserver_10.3 -status=applied -view

export ORACLE_HOME=$FMW_HOME

cd $ORACLE_HOME/utils/bsu/

[applvis@osirel1226 bsu]$ pwd

/ebsdev/app/dev/fs1/FMW_Home/utils/bsu

./bsu.sh -remove -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/ -patchlist=CW9T verbose

./bsu.sh -remove -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/ -patchlist=BLTG verbose

./bsu.sh -remove -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/ -patchlist=FCX7 -verbose

./bsu.sh -remove -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/ -patchlist=1LRI -verbose

./bsu.sh -remove -prod_dir=/ebsdev/apps/VISR1228/fs1/FMW_Home/wlserver_10.3/ -patchlist=2GYW -verbose

./bsu.sh -remove -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/ -patchlist=FCX7 -verbose

./bsu.sh -remove -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/ -patchlist=2GYW -verbose

./bsu.sh -remove -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/ -patchlist=VKXF -verbose

./bsu.sh -remove -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/ -patchlist=FCX7 -verbose

./bsu.sh -remove -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/ -patchlist=Y5AP -verbos

./bsu.sh -remove -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/ -patchlist=Y5AP -verbose

./bsu.sh -remove -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/ -patchlist=VKXF -verbose

./bsu.sh -remove -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/ -patchlist=CIH8 –verbose

./bsu.sh -install -patch_download_dir=/ebsdev/app/dev/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=GFWX -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/

./bsu.sh -install -patch_download_dir=/ebsdev/app/dev/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=S5C9 -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/

./bsu.sh -install -patch_download_dir=/ebsdev/app/dev/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=HMR4 -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/

./bsu.sh -install -patch_download_dir=/ebsdev/app/dev/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=F5QI -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/

./bsu.sh -install -patch_download_dir=/ebsdev/app/dev/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=DI8E -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/

./bsu.sh -install -patch_download_dir=/ebsdev/app/dev/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=DN1F -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/

./bsu.sh -remove -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/ -patchlist=CIH8 -verbose

./bsu.sh -install -patch_download_dir=/ebsdev/app/dev/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=DN1F -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/

./bsu.sh -install -patch_download_dir=/ebsdev/app/dev/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=EN8U -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/

./bsu.sh -install -patch_download_dir=/ebsdev/app/dev/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=XNBA -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/

./bsu.sh -install -patch_download_dir=/ebsdev/app/dev/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=ETK1T -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/

./bsu.sh -install -patch_download_dir=/ebsdev/app/dev/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=TK1T -prod_dir=/ebsdev/app/dev/fs1/FMW_Home/wlserver_10.3/

After patches applied above all > run ./checkMTpatch.sh one more time .

All required one-offs are confirmed as present.

Apply the consolidated seed table upgrade Patch 26787701:12.2.0 on the run file system using adop hotpatch mode.

1. Stop all application tier services on the run file system.

UNIX:

sh $ADMIN_SCRIPTS_HOME/adstpall.sh

2. Start up only the Oracle Weblogic Admin Server on the run file system.

UNIX:

$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start

2.2 Apply Consolidated Seed Table Upgrade Patch 26787701:12.2.0

Apply the consolidated seed table upgrade Patch 26787701:12.2.0 on the run file system using adop hotpatch mode.

adop phase=apply patches=26787701 hotpatch=yes

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

UNIX:

$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start

2. Unzip patches and run adgrants.

a. Download and unzip the following patches:

 Patch 26834480 (R12.AD.C.Delta.11)

 Patch 28840822 (R12.TXK.C.Delta.11)

Note: You should also download and unzip any additional applicable patches from Section 4: Apply Additional Critical Patches.

b. Execute adgrants by following the instructions in the readme of Patch 26834480, which includes the latest version of adgrants.

3. On the run edition application tier file system, apply Patch 26834480 (R12.AD.C.Delta.11) in hotpatch mode.

Note: Do not merge Patch 26834480 with any other patches.

UNIX:

$ adop phase=apply patches=26834480 hotpatch=yes

Applying the Consolidated Seed Table Upgrade Patch (required)

Apply the consolidated seed table upgrade Patch 26787701:12.2.0 on the run file system using adop hotpatch mode.

adop phase=apply patches=26787701 hotpatch=yes

Applying the Latest AD and TXK Patchsets (required)

-> Source the run edition environment file

-> Start up only the Oracle Weblogic Admin Server on the run edition application tier file system

sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start

UNIX:

$ sqlplus /nolog

SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql <APPS schema name>

-> Unzip patches and run adgrants.

- Download and unzip the following patches:

Patch 26834480 (R12.AD.C.Delta.11)

Patch 28840822 (R12.TXK.C.Delta.11)

Execute adgrants by following the instructions in the readme of Patch 26834480, which includes the latest version of adgrants.

-> On the run edition application tier file system, apply Patch 26834480 (R12.AD.C.Delta.11) in hotpatch mode.

adop phase=apply patches=26834480 hotpatch=yes

-> On the run edition application tier file system, use hotpatch mode to apply Patch 28840822 (R12.TXK.C.Delta.11) (plus any additional critical patches.

adop phase=apply patches=28840822,29965377,29781255 hotpatch=yes merge=yes

-> Run the Middle Tier EBS Technology Codelevel Checker (MT-ETCC)

-> Stop Oracle WebLogic Server's Admin Server and Node Manager services on run filesystem

sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop

sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop

-> Update the database tier with the latest patches.

-> On the application tier EBSapps.env run

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

perl <AD_TOP>/bin/admkappsutil.pl

-> On the database tier (as the ORACLE user)

- Source the environment for RDBMS ORACLE_HOME.

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

- Uncompress appsutil.zip, under <RDBMS ORACLE_HOME>.

On the Database Tier

[

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

- Run AutoConfig on <RDBMS ORACLE_HOME>.

sh <RDBMS_ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>/adautocfg.sh

-> Run AutoConfig on the run file system.

sh <INST_TOP>/admin/scripts/adautocfg.sh

Section 6: Apply the Latest AD and TXK Delta Release Update Packs

SQL > Drop user mobileadmin cascade;

If you have a lower version of the file(s) listed below or you have performed customizations on any of these packages, create a back-up of your file(s) under $APPL_TOP_NE/.

Package Name File Version

FLM_KANBAN_CUSTOM_PKG flmkacps.pls

120.3.12026000.2

flmkacpb.pls

120.3.12026000.2

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

-> Source the run edition applications environment.

EBSapps.env run

-> Stop Oracle WebLogic Server's Admin Server and Node Manager services.

sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop

-> Stop the Oracle WebLogic Server Node Manager service on the run file system

sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop

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

UNIX:

$ adop phase=apply apply_mode=downtime patches=28840850

Log file

Applying patch 28840850.

Log: /ebsprod/app/PROD/fs_ne/EBSapps/log/adop/2/20260109_161011/apply/appsnode/28840850/log/u28840850.log

Running finalize actions for the patches being applied.

Log: @ADZDSHOWLOG.sql "2026/01/09 23:28:46"

Running cutover actions for the patches being applied.

Creating workers to process cutover DDL in parallel

Log: /ebsprod/app/PROD/fs_ne/EBSapps/log/adop/2/20260109_161011/apply/appsnode/log/cutover.log

Performing database cutover in Quick mode

[ERROR] [CUTOVER 8:3 ddl_id=33754] ORA-00942: table or view does not exist SQL: alter materialized view APPS."DDR_SV_SLSR_C_MV" evaluate using current edition

[ERROR] [CUTOVER 8:1 ddl_id=33808] ORA-00942: table or view does not exist SQL: alter materialized view APPS."DDR_SV_ORDR_C_MV" evaluate using current edition

[ERROR] [CUTOVER 8:1 ddl_id=33816] ORA-00942: table or view does not exist SQL: alter materialized view APPS."DDR_BS_SHIP_ITM_BU_WK_MV" evaluate using current edition

[WARNING] [CUTOVER 8:1] There are still 11 failed jobs in CUTOVER phase

[ERROR] [CUTOVER 8:2 ddl_id=33809] ORA-00942: table or view does not exist SQL: alter materialized view APPS."DDR_SV_SHIP_C_MV" evaluate using current edition

[ERROR] [CUTOVER 8:2 ddl_id=33817] ORA-00942: table or view does not exist SQL: alter materialized view APPS."DDR_SV_INV_INT_C_MV" evaluate using current edition

[WARNING] [CUTOVER 8:2] There are still 12 failed jobs in CUTOVER phase

[WARNING] [CUTOVER 8:3] There are still 11 failed jobs in CUTOVER phase

[WARNING] [CUTOVER 8:7] There are still 10 failed jobs in CUTOVER phase

[WARNING] [CUTOVER 8:6] There are still 9 failed jobs in CUTOVER phase

[WARNING] [CUTOVER 8:5] There are still 8 failed jobs in CUTOVER phase

[WARNING] [CUTOVER 8:8] There are still 7 failed jobs in CUTOVER phase

[WARNING] [CUTOVER 8:4] There are still 6 failed jobs in CUTOVER phase

Generating post apply reports.

Generating log report.

Output: /ebsprod/app/PROD/fs_ne/EBSapps/log/adop/2/20260109_161011/apply/appsnode/adzdshowlog.out

The apply phase completed successfully.

adop exiting with status = 0 (Success)

[applprod@appsnode scripts]$

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

UNIX:

$ sh $ADMIN_SCRIPTS_HOME/adstrtal.sh

• Perform adop cleanup action.

UNIX:

$ adop phase=cleanup

• 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-Update Steps

• Apply Oracle E-Business Suite Release 12.2.9 Online Help

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

$ adop phase=apply patches=28840900 hotpatch=yes

The syntax to run an empty patch cycle is:

adop phase=prepare,finalize,cutover,cleanup

This concludes EBs R12.2.9 installation successfully completed login the ebs and test the basic sanity check and release instance for testing .

Thanks,

Srini

ANJANI APPS DBA

Oracle Apps DBA

Oracle Apps DBA

Sunday, 19 April 2026

Oracle EBS R12.2.9 installation step by step process - Part 2/2

No comments:

Post a Comment

Popular Posts