SQL> col ABBREVIATION for a10
set lines 1000
col NAME for a50
col CODELEVEL for a20
SELECT ABBREVIATION,NAME,codelevel FROM apps.AD_TRACKABLE_ENTITIES WHERE abbreviation in (‘txk’,’ad’);

ABBREVIATION NAME                                             CODELEVEL
———- ————————————————– ——————–
ad Applications DBA                                           C.14
txk Oracle Applications Technology Stack                      C.14

sql> SELECT bug_number, creation_date
FROM ad_bugs
WHERE bug_number IN (25452805,
26052406,
26521736,
30433124,
31349591,
31800803,
33346385,
33119203,
30611319,
28732161,
31088182);

BUG_NUMBER CREATION_
—————————— ———
31800803 13-JUL-23
33119203 13-JUL-23
33346385 13-JUL-23
31349591 14-JUL-23
25452805 14-JUL-23
31088182 14-JUL-23
30433124 14-JUL-23
26052406 14-JUL-23
30611319 14-JUL-23

9 rows selected.

[oracle@test1 ~]$ cd /u01/oracle/PROD/19.0.0/media/interoperability
[oracle@test1 interoperability]$ ll
total 4700
-rwxrwxr-x. 1 oracle oinstall 3298300 Jul 16 00:09 p26521736_12.2.0_R12_LINUX.zip
-rwxrwxr-x. 1 oracle oinstall 1500624 Jul 16 00:09 p28732161_R12.FRM.C_R12_GENERIC.zip

[oracle@test1 interoperability]$ unzip p26521736_12.2.0_R12_LINUX.zip
[oracle@test1 interoperability]$ unzip p28732161_R12.FRM.C_R12_GENERIC.zip
[oracle@test1 interoperability]$ cp -pr 26521736/ $PATCH_TOP
[oracle@test1 interoperability]$ cp -pr 28732161/ $PATCH_TOP

Now Applying the patches through ADOP in one command after sourcing the application run environment

[oracle@test1 ~]$ . ./EBSapps.env

E-Business Suite Environment Information
—————————————-
RUN File System : /u01/oracle/PROD/fs1/EBSapps/appl
PATCH File System : /u01/oracle/PROD/fs2/EBSapps/appl
Non-Editioned File System : /u01/oracle/PROD/fs_ne

DB Host: test1.example.com Service/SID: PROD

E-Business Suite Environment Setting
————————————
– Enter [R/r] for sourcing Run File System Environment file, or
– Enter [P/p] for sourcing Patch File System Environment file, or
– Enter anything else to exit

Please choose the environment file you wish to source [R/P]:R

Sourcing the RUN File System …

[oracle@test1 ~]$ cd /u01/oracle/PROD/19.0.0/media/interoperability

[oracle@test1 ~]$ adop phase=prepare,apply,finalize,cutover,cleanup mtrestart=no patches= 26521736,28732161

Enter the APPS password:
Enter the EBS_SYSTEM password:
Enter the WLSADMIN password:

Validating credentials.

Initializing.
Run Edition context : /u01/oracle/PROD/fs1/inst/apps/PROD_test1/appl/admin/PROD_test1.xml
Patch edition context: /u01/oracle/PROD/fs2/inst/apps/PROD_test1/appl/admin/PROD_test1.xml
Patch file system free space: 95.41 GB

Validating system setup.

ADOP (C.Delta.14)
Session ID: 6
Node: test1
Phase: prepare,apply,finalize,cutover,cleanup
Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/6/20230716_124157/adop.log

Run the following commands to create the $ORACLE_HOME/dbs/<ORACLE_SID>_initparam.sql and $ORACLE_HOME/dbs/<ORACLE_SID>_datatop.txt files.

• $ cd $ORACLE_HOME/appsutil
• $ . ./txkSetCfgCDB.env dboraclehome=<full path of ORACLE_HOME>
• $ export ORACLE_SID=<ORACLE_SID>
• $ cd $ORACLE_HOME/appsutil/bin$ perl txkOnPremPrePDBCreationTasks.pl -dboraclehome=<ORACLE_HOME> -outdir=<ORACLE_HOME>/appsutil/log -appsuser=<apps user> -dbsid=<ORACLE_SID> -skipdbshutdown=yes
  perl txkOnPremPrePDBCreationTasks.pl -dboraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -appsuser=apps -dbsid=PROD -skipdbshutdown=yes

[oracle@test1 ~]$ cd $ORACLE_HOME/appsutil
[oracle@test1 appsutil]$ echo $ORACLE_HOME
/u01/oracle/PROD/12.1.0
[oracle@test1 appsutil]$ . ./txkSetCfgCDB.env dboraclehome=/u01/oracle/PROD/12.1.0

Oracle Home being passed: /u01/oracle/PROD/12.1.0
[oracle@test1 appsutil]$ echo $ORACLE_SID
PROD
[oracle@test1 appsutil]$ cd bin
[oracle@test1 bin]$ perl txkOnPremPrePDBCreationTasks.pl -dboraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -appsuser=apps -dbsid=PROD -skipdbshutdown=yes
Enter the APPS Password:

Once completed you can check the below highlighted are created in cd $ORACLE_HOME/dbs

[oracle@test1 bin]$ cd $ORACLE_HOME/dbs
[oracle@test1 dbs]$ ls -ltrh
total 38M
-rw-r–r–. 1 oracle oinstall 0 Jul 11 22:17 PROD_ifile.ora
-rw-r—–. 1 oracle oinstall 24 Jul 11 22:18 lkPROD
-rw-r—–. 1 oracle oinstall 4.0M Jul 11 22:26 arch1_32_899606885.dbf
-rwxr-xr-x. 1 oracle oinstall 433 Jul 11 22:28 RMANinit.ora
-rw-r–r–. 1 oracle oinstall 22K Jul 11 22:31 initPROD.ora
-rw-r–r–. 1 oracle oinstall 0 Jul 14 17:03 PROD_test1_ifile.ora
-rw-r–r–. 1 oracle oinstall 22K Jul 14 17:03 initPROD_noaq.ora
-rw-r—–. 1 oracle oinstall 34M Jul 15 17:24 snapcf_PROD.f
-rw-rw—-. 1 oracle oinstall 1.6K Jul 16 12:27 hc_PROD.dat
-rw-r—–. 1 oracle oinstall 6.5K Jul 16 14:24 spfilePROD.ora
-rw-r–r–. 1 oracle oinstall 3.4K Jul 16 14:46 PROD_initparam.sql
-rw-r–r–. 1 oracle oinstall 419 Jul 16 14:46 PROD_datatop.txt
-rw-r–r–. 1 oracle oinstall 40K Jul 16 14:46 PROD_PDBDesc.xml

1. Select “Set Up Software Only”
2. Click Next

1. Select “Single instance database installation”
2. Click Next

1. Select “Enterprise Edition”
2. Click Next

Click Next

1. Select “oinstall” for all Group
2. Click Next

1. Select “Automatically run configuration scripts”
2. Enter OS root User Credential
3. Click Next

1. Click Install

Installation Process Starts

Click Yes

Click Close

[oracle@test1 ~]$ . ./19c.env

[oracle@test1 ~]$ cd /u01/oracle/PROD/19.0.0/media/35042068

[oracle@test1 35042068]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Oracle Interim Patch Installer version 12.2.0.1.37

Copyright (c) 2023, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/oracle/PROD/19.0.0

Central Inventory : /u01/oracle/oraInventory

   from           : /u01/oracle/PROD/19.0.0/oraInst.loc

OPatch version    : 12.2.0.1.37

OUI version       : 12.2.0.7.0

Log file location : /u01/oracle/PROD/19.0.0/cfgtoollogs/opatch/opatch2023-07-16_16-20-19PM_1.log

Invoking prereq “checkconflictagainstohwithdetail”

Prereq “checkConflictAgainstOHWithDetail” passed.

OPatch succeeded.

[oracle@test1 35042068]$ opatch apply

Oracle Interim Patch Installer version 12.2.0.1.37

Copyright (c) 2023, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/oracle/PROD/19.0.0

Central Inventory : /u01/oracle/oraInventory

   from           : /u01/oracle/PROD/19.0.0/oraInst.loc

OPatch version    : 12.2.0.1.37

OUI version       : 12.2.0.7.0

Log file location : /u01/oracle/PROD/19.0.0/cfgtoollogs/opatch/opatch2023-07-16_16-21-39PM_1.log

Verifying environment and performing prerequisite checks…

[oracle@test1 media]$ cd 35050341

[oracle@test1 35050341]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Oracle Interim Patch Installer version 12.2.0.1.37

Copyright (c) 2023, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/oracle/PROD/19.0.0

Central Inventory : /u01/oracle/oraInventory

   from           : /u01/oracle/PROD/19.0.0/oraInst.loc

OPatch version    : 12.2.0.1.37

OUI version       : 12.2.0.7.0

Log file location : /u01/oracle/PROD/19.0.0/cfgtoollogs/opatch/opatch2023-07-16_17-09-58PM_1.log

Invoking prereq “checkconflictagainstohwithdetail”

Prereq “checkConflictAgainstOHWithDetail” passed.

OPatch succeeded.

[oracle@test1 35050341]$ opatch apply

Oracle Interim Patch Installer version 12.2.0.1.37

Copyright (c) 2023, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/oracle/PROD/19.0.0

Central Inventory : /u01/oracle/oraInventory

   from           : /u01/oracle/PROD/19.0.0/oraInst.loc

OPatch version    : 12.2.0.1.37

OUI version       : 12.2.0.7.0

Log file location : /u01/oracle/PROD/19.0.0/cfgtoollogs/opatch/opatch2023-07-16_17-10-45PM_1.log

Verifying environment and performing prerequisite checks…

[oracle@test1 ~]$ cd /u01/oracle/PROD/19.0.0/media/

[oracle@test1 media]$ cd 35406065

[oracle@test1 35406065]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Oracle Interim Patch Installer version 12.2.0.1.37

Copyright (c) 2023, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/oracle/PROD/19.0.0

Central Inventory : /u01/oracle/oraInventory

   from           : /u01/oracle/PROD/19.0.0/oraInst.loc

OPatch version    : 12.2.0.1.37

OUI version       : 12.2.0.7.0

Log file location : /u01/oracle/PROD/19.0.0/cfgtoollogs/opatch/opatch2023-07-16_18-44-53PM_1.log

Invoking prereq “checkconflictagainstohwithdetail”

Prereq “checkConflictAgainstOHWithDetail” passed.

OPatch succeeded.

[oracle@test1 35406065]$ opatch apply

Oracle Interim Patch Installer version 12.2.0.1.37

Copyright (c) 2023, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/oracle/PROD/19.0.0

Central Inventory : /u01/oracle/oraInventory

   from           : /u01/oracle/PROD/19.0.0/oraInst.loc

OPatch version    : 12.2.0.1.37

OUI version       : 12.2.0.7.0

Log file location : /u01/oracle/PROD/19.0.0/cfgtoollogs/opatch/opatch2023-07-16_18-45-17PM_1.log

Verifying environment and performing prerequisite checks…

OPatch continues with these patches:   35406065 

[oracle@test1 rapidwiz]$ cd /home/apps/stage/startCD/Disk1/rapidwiz

[oracle@test1 rapidwiz]$ export DISPLAY=192.168.1.147:0.0

[oracle@test1 rapidwiz]$ cd /home/apps/stage/startCD/Disk1/rapidwiz

[oracle@test1 rapidwiz]$ export DISPLAY=192.168.1.147:0.0

Note: the ip is of your local machine not Virtual Machine

[oracle@test1 rapidwiz]$ ./rapidwiz

Click Next

Click Next

Enter the Following Details Highlighted as per the environment and then Click Next

Make Sure all The Pre-Requisite Test Pass Successfully with Green Tick as Shown in the Picture.

Now Click Next

Upon completion of the installation, a post-verification procedure will be performed to ensure the successful execution of all post-installation tasks. This verification step is essential in confirming that all necessary tasks have been completed without any errors or issues.

[oracle@test1 stage]$ ls -ltrh V100052-01_*

-rwxr-xr-x. 1 oracle oinstall  98M Jan 12  2016 V100052-01_3of3.zip

-rwxr-xr-x. 1 oracle oinstall  82M Jan 12  2016 V100052-01_2of3.zip

-rwxr-xr-x. 1 oracle oinstall 726M Jan 20  2016 V100052-01_1of3.zip

Now Unzip the Files

[oracle@test1 stage]$ unzip V100052-01_1of3.zip

[oracle@test1 stage]$ unzip V100052-01_2of3.zip

[oracle@test1 stage]$ unzip V100052-01_3of3.zip

Now we will Check The StartCD Version provided with the Media from Oracle and Above Extracted Zip Files

[oracle@test1 stage]$ cd startCD/

[oracle@test1 startCD]$ cat README.txt | grep -i Version

Disk1/doc      : Contains Adobe Acrobat versions of E-Business Suite

Version       : 12.2.0.51

Now go to the Following Directory to build Stage

[oracle@test1 bin]$ cd /home/apps/stage/startCD/Disk1/rapidwiz/bin

[oracle@test1 bin]$ ls -ltr buildStage.sh

-rwxr-xr-x. 1 oracle oinstall 17325 Jan 20  2016 buildStage.sh

Run Buildstage Script

[oracle@test1 bin]$ ./buildStage.sh

Press Enter to continue

Enter 1 and Press Enter to Continue

Enter the Location of the downloaded Zip Files and press enter

Note: As I missed 12c Media to download along with E-Business Suite Media, this is why it is giving a warning, we will download the Media and add it again in the stage. This issue will not occur with you.

This will start unzipping all the other files

Press Enter to Continue…

Press Enter to Continue…

Press Enter to Continue…

Press Enter to Continue…

Stage File are now created and Media ready to Install Oracle E-Business Suite 12.2.0

Click the Below Link to go 

Login Process in Oracle E-Delivery Account

Go To E-delivery Website and Click Sign in

https://edelivery.oracle.com/

If you already possess an Oracle account, please sign in using your credentials.

In the event that you do not have an account, you can create one by selecting the “Create Account” button.

Oracle Enterprise Linux (OEL) 7.9 Download Process

Once You Login, you will see the Screen Like this as shown in the picture

1. Write Oracle Linux 7 in Search Field
2. Click Click Search
3. Click Oracle Linux 7.9.0.0
4. Click Continue

1. Select Platform
2. Click Continue

1. Accept the Agreement
2. Click Continue

Click the File Shown in the Picture to Start Download

Oracle E-Business Suite R12.2.12 Download Process

As we need to Download the Oracle E-Business Suite Media, we will Search and select the Version as shown in the Picture Below.

After the Selection, as you can see 1 item added in Cart, Click Continue

Choose The Product list to be downloaded with the Platform Required Version and Click Continue as shown in the Picture Below

Click the check Box and Click Continue

Now All the Files of the Products selected previously will show on this Page.

You have 2 Options To Download All the Files.

Option 1. Downloading through Download Manager

Click Download Link

(It will download an EXE file like “Oracle_SSN_DLM_{DateStamp}”, once downloaded you will open the Download Manager and Start The Downloading process of all the files as shown in Pictures Below )

Click Next

Option 2. WGET Options Link

It will download a Script ‘sh’  file which can be copied on the installation System and executed. While after the execution It will ask for Oracle SSO Username and Password which you can provide same as provided while logging into the Oracle E-Delivery.

Note:

1. This method needs to have Internet Enabled on the OS where you are installing the Software.
2. You can edit the parameter given below where you want to download the files

# Output directory and file

OUTPUT_DIR=/home/apps

The Picture Below Shows The Execution of wget.sh script for downloading the media.

Provide Oracle SSO Username and Password same as provided while logging into the Oracle E-Delivery

You Can Also Check The Log file for the Downloading Process as shown in the picture below.

All the Media Files Will be downloaded Directory on the Linux Server.

Once E-Business Suite Media Download Completes, you Can go for Staging the Media

The link is Given Below

Overview:
The EBS Tech Patch Automation Tool – Application Tier (ETPAT-AT) automates the patching process for technology one-offs in various components of the Oracle E-Business Suite Release (EBS) Release 12.2.0 application tier. The following components are included:

– FMW WebTier 11.1.1.9
– Oracle WebLogic Server 10.3.6 Smart Update Patch
– Oracle WebLogic Server 10.3.6.0
– FMW oracle_common 11.1.1.9
– Forms and Reports 10.1.2.3

Specifically, ETPAT-AT:
– Can be executed on a new installation or an upgrade of the EBS Release 12.2.0 application tier (run file system).
– Is compatible with all platforms supported by Oracle E-Business Suite.
– Runs ETCC-MT before and after each patching session.
– Generates comprehensive reports on the patched components in the session and updates the inventory of the application tier technology stack.
– Works for both on-premises and Compute environments.
– Does not make any modifications to the EBS database.
– Cannot be utilized on EBS systems already on Release 12.2.3 or later versions.

[oracle@test1 ~]$ cd /home/apps/stage/stage12212/patches/ETPAT-AT

[oracle@test1 ETPAT-AT]$ unzip p32208510_R12_GENERIC.zip

Archive:  p32208510_R12_GENERIC.zip

  inflating: etpat_at.pl            

  inflating: post_install_steps.xml 

  inflating: README.txt             

[oracle@test1 ETPAT-AT]$ source /u01/oracle/PROD/fs1/EBSapps/appl/APPSPROD_test1.env

[oracle@test1 ETPAT-AT]$ perl etpat_at.pl

Enter 12.2.0 Run edition file system context file:

/u01/oracle/PROD/fs1/inst/apps/PROD_test1/appl/admin/PROD_test1.xml

**********************************************************

Validating the context file…

Context file exists: /u01/oracle/PROD/fs1/inst/apps/PROD_test1/appl/admin/PROD_test1.xml

***********************************************************

Start Time: Thu Jul 13 02:30:49 PKT 2023

***********************************************************

File System level is 12.2.0

***********************************************************

Sourcing the 12.2 RUN File System

Sourcing Apps Environment file /u01/oracle/PROD/fs1/EBSapps/appl/APPSPROD_test1.env

***********************************************************

***********************************************************

Generating ocm.rsp file for silent installation

Provide your email address to be informed of security issues, install and

initiate Oracle Configuration Manager. Easier for you if you use your My

Oracle Support Email address/User Name.

Visit http://www.oracle.com/support/policies.html for details.

Email address/User Name:

You have not provided an email address for notification of security issues.

Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  The OCM configuration response file (/home/apps/stage/stage12212/patches/ETPAT-AT/ocm.rsp) was successfully created.

***********************************************************

Platform: LINUX_X86-64

***********************************************************

Enter APPS schema name [APPS]: 

apps

Enter password for apps schema: 

Validating apps user login details…

Password validation is completed

******************************************************************

EBS Release level is 12.2.0

*****************************************************************

Validating pre-requisite files availability under Technology Stack Patching tool stage area…

Post install steps file post_install_steps.xml exists under Technology Stack Patching tool stage area

****************************************************************

Enter directory where you downloaded ETCC Patch 17537119:

/home/apps/stage/stage12212/patches/EBS     

*******************************************

Validating the Latest ETCC patch availability…

ETCC Patch /home/apps/stage/stage12212/patches/EBS/p17537119_R12_GENERIC.zip exists

Archive:  /home/apps/stage/stage12212/patches/EBS/p17537119_R12_GENERIC.zip

  inflating: /home/apps/stage/stage12212/patches/EBS/checkDBpatch.cmd 

  inflating: /home/apps/stage/stage12212/patches/EBS/checkDBpatch.sh 

  inflating: /home/apps/stage/stage12212/patches/EBS/checkMTpatch.cmd 

  inflating: /home/apps/stage/stage12212/patches/EBS/checkMTpatch.sh 

  inflating: /home/apps/stage/stage12212/patches/EBS/db/cloud/txk_R1220_EXABM_mappings.xml 

  inflating: /home/apps/stage/stage12212/patches/EBS/db/cloud/txk_R1220_DBCS_base_bugs.xml 

  inflating: /home/apps/stage/stage12212/patches/EBS/db/cloud/txk_R1220_DBCS_RAC_base_bugs.xml 

  inflating: /home/apps/stage/stage12212/patches/EBS/db/cloud/txk_R1220_VMDB_RAC_base_bugs.xml 

  inflating: /home/apps/stage/stage12212/patches/EBS/db/cloud/txk_R1220_EXACS_mappings.xml 

  inflating: /home/apps/stage/stage12212/patches/EBS/db/cloud/txk_R1220_EXACS_base_bugs.xml 

  inflating: /home/apps/stage/stage12212/patches/EBS/db/cloud/txk_R1220_DBCS_RAC_mappings.xml 

  inflating: /home/apps/stage/stage12212/patches/EBS/db/cloud/txk_R1220_DBSI_base_bugs.xml 

  inflating: /home/apps/stage/stage12212/patches/EBS/db/cloud/txk_R1220_VMDB_RAC_mappings.xml 

  inflating: /home/apps/stage/stage12212/patches/EBS/db/cloud/txk_R1220_DBSI_mappings.xml 

  inflating: /home/apps/stage/stage12212/patches/EBS/db/cloud/txk_R1220_DBCS_mappings.xml 

  inflating: /home/apps/stage/stage12212/patches/EBS/db/cloud/txk_R1220_EXABM_base_bugs.xml 

  inflating: /home/apps/stage/stage12212/patches/EBS/db/onprem/txk_R1220_DB_mappings.xml 

  inflating: /home/apps/stage/stage12212/patches/EBS/db/onprem/txk_R1220_DB_base_bugs.xml 

  inflating: /home/apps/stage/stage12212/patches/EBS/db/onprem/txk_R1220_GRID_base_bugs.xml 

  inflating: /home/apps/stage/stage12212/patches/EBS/mw/txk_R1220_MT_base_bugs.xml 

  inflating: /home/apps/stage/stage12212/patches/EBS/mw/txk_R1220_MT_mappings.xml 

  inflating: /home/apps/stage/stage12212/patches/EBS/README.txt 

  inflating: /home/apps/stage/stage12212/patches/EBS/db/cloud/txk_R1220_EXACC_base_bugs.xml 

  inflating: /home/apps/stage/stage12212/patches/EBS/db/cloud/txk_R1220_EXACC_mappings.xml 

Latest ETCC patch available in ETCC stage area

Continuing using txk_R1220_MT_mappings.xml 120.0.12020000.43 2022/07/22

*******************************************

Enter patch stage area: 

/home/apps/stage/stage12212/patches/ETPAT-AT   

*******************************************

Validating patch stage area…

Patch stage area exists: /home/apps/stage/stage12212/patches/ETPAT-AT

Archive:  /home/apps/stage/stage12212/patches/EBS/p17537119_R12_GENERIC.zip

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/checkDBpatch.cmd 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/checkDBpatch.sh 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/checkMTpatch.cmd 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/checkMTpatch.sh 

   creating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/

   creating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/cloud/

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/cloud/txk_R1220_EXABM_mappings.xml 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/cloud/txk_R1220_DBCS_base_bugs.xml 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/cloud/txk_R1220_DBCS_RAC_base_bugs.xml 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/cloud/txk_R1220_VMDB_RAC_base_bugs.xml 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/cloud/txk_R1220_EXACS_mappings.xml 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/cloud/txk_R1220_EXACS_base_bugs.xml 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/cloud/txk_R1220_DBCS_RAC_mappings.xml 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/cloud/txk_R1220_DBSI_base_bugs.xml 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/cloud/txk_R1220_VMDB_RAC_mappings.xml 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/cloud/txk_R1220_DBSI_mappings.xml 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/cloud/txk_R1220_DBCS_mappings.xml 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/cloud/txk_R1220_EXABM_base_bugs.xml 

   creating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/onprem/

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/onprem/txk_R1220_DB_mappings.xml 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/onprem/txk_R1220_DB_base_bugs.xml 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/onprem/txk_R1220_GRID_base_bugs.xml 

   creating: /home/apps/stage/stage12212/patches/ETPAT-AT/mw/

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/mw/txk_R1220_MT_base_bugs.xml 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/mw/txk_R1220_MT_mappings.xml 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/README.txt 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/cloud/txk_R1220_EXACC_base_bugs.xml 

  inflating: /home/apps/stage/stage12212/patches/ETPAT-AT/db/cloud/txk_R1220_EXACC_mappings.xml 

*******************************************

****************************************************************

Generating WLS inventory report…

WLS inventory report file: /home/apps/stage/stage12212/patches/ETPAT-AT/PROD_etpat_at/log/wlsInventory.txt

************************************************************

Your current WLS PSU version: 10.3.6.0.7

************************************************************

WLS PSU version: 10.3.6.0.7 is not at supported WLS PSU levels. Requires WLS PSU uptake.

Note: It is strongly recommended to uptake latest WLS PSU.

Select the WLS PSU you want to upgrade to: 

6. JUL22 [10.3.6.0.220719] – Recommended
7. APR22 [10.3.6.0.220419]
8. JAN22 [10.3.6.0.220118]
9. OCT21 [10.3.6.0.211019]
10. JUL21 [10.3.6.0.210720]
11. APR21 [10.3.6.0.210420]

Enter your choice (1 or 2 or 3 or 4 or 5 or 6): 

1       (Enter The Value 1)

You have selected option: 1

You have opted to apply WLS PSU version: 10.3.6.0.220719

Enter ‘Yes’ to Continue (Yes/No): 

Yes

[OPatch patch 6880880. Ensure that p6880880_101000_LINUX.zip, p6880880_111000_Linux-x86-64.zip are downloaded under the patch stage area]

[Fusion Middleware consolidated patch 34105303. Ensure that p34105303_R12_LINUX.zip is downloaded under patch stage area]

[WLS Patch 34105280. Ensure that p34105280_R12_GENERIC.zip is downloaded under patch stage area]

[Smart update Patch 33845432. Ensure that p33845432_R12_GENERIC.zip is downloaded under patch stage area]

Download above patches under patch stage area and Enter ‘Yes’ to Continue (Yes/No):

Yes

After This Wait for the ET-PAT to Finish Applying all the ETCC-MT Patches.

[oracle@test1 EBS]$ source /u01/oracle/PROD/fs1/EBSapps/appl/APPSPROD_test1.env

[oracle@test1 EBS]$ cd $ADMIN_SCRIPTS_HOME

[oracle@test1 scripts]$ ./adadminsrvctl.sh start

[oracle@test1 EBS]$ cd /home/apps/stage/stage12212/patches/EBS

[oracle@test1 EBS]$ unzip p26787701_12.2.0_R12_GENERIC.zip

[oracle@test1 EBS]$ cd 26787701/

[oracle@test1 EBS]$ source /u01/oracle/PROD/fs1/EBSapps/appl/APPSPROD_test1.env

[oracle@test1 EBS]$ cp -pr 26787701/ /u01/oracle/PROD/fs_ne/EBSapps/patch

[oracle@test1 EBS]$ adop phase=apply patches=26787701 hotpatch=yes

Enter the APPS password:

Enter the SYSTEM password:

Enter the WLSADMIN password:

      [STATEMENT] [END   2023/07/13 13:38:35] Generating Report to spool all logs from ad_zd_logs

  [STATEMENT] [END   2023/07/13 13:38:36] Generating Post Apply Reports

[STATEMENT] [END   2023/07/13 13:38:39] adzdoptl.pl run

[STATEMENT] adop phase=apply – Completed Successfully

[STATEMENT] Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/3/adop_20230713_132715.log

adop exiting with status = 0 (Success)

[oracle@test1 EBS]$ cd /home/apps/stage/stage12212/patches/EBS

[oracle@test1 EBS]$ unzip p33600809_R12.AD.C_R12_LINUX.zip

[oracle@test1 EBS]$ cp -pr 33600809/ /u01/oracle/PROD/fs_ne/EBSapps/patch

[oracle@test1 ~]$ cd /home/apps/stage/stage12212/patches/EBS/33600809/admin

[oracle@test1 admin]$ cp adgrants.sql /u01/oracle/PROD/12.1.0/appsutil/admin

 $ sqlplus /nolog

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

SQL> ALTER USER EBS_SYSTEM ACCOUNT UNLOCK;

User altered.

[oracle@test1 ~]$ cd /home/apps/stage/stage12212/patches/EBS/33600809

[oracle@test1 33600809]$ adop phase=apply patches=33600809 hotpatch=yes workers=4

[oracle@test1 critical]$ ls -ltrh

total 224K

-rwxrwxr-x. 1 oracle oinstall 61K Jul 13 15:07 p34681299_R12.AD.C_R12_LINUX.zip

-rwxrwxr-x. 1 oracle oinstall 57K Jul 13 15:07 p35280947_R12.AD.C_R12_GENERIC.zip

-rwxrwxr-x. 1 oracle oinstall 99K Jul 13 15:07 p34669333_R12.AD.C_R12_LINUX.zip

[oracle@test1 critical]$ unzip p34669333_R12.AD.C_R12_LINUX.zip

[oracle@test1 critical]$ unzip p35280947_R12.AD.C_R12_GENERIC.zip

[oracle@test1 critical]$ cp -pr 35280947/ /u01/oracle/PROD/fs_ne/EBSapps/patch

[oracle@test1 critical]$ cp -pr 34669333/ /u01/oracle/PROD/fs_ne/EBSapps/patch

[oracle@test1 critical]$ adop phase=apply patches=34669333,35280947 hotpatch=yes merge=yes

[oracle@test1 EBS]$ cd /home/apps/stage/stage12212/patches/EBS

[oracle@test1 EBS]$ unzip p33602997_R12.TXK.C_R12_GENERIC.zip

[oracle@test1 EBS]$ cp -pr 33602997/ /u01/oracle/PROD/fs_ne/EBSapps/patch

[oracle@test1 EBS]$ adop phase=apply patches=33602997 hotpatch=yes merge=yes

[oracle@test1 ~]$ cd /home/apps/stage

[oracle@test1 stage]$ mv V1031181-01_* /u01/oracle/12212/

[oracle@test1 12212]$ cd /u01/oracle/12212

[oracle@test1 12212]$ ls -ltrh

total 5.2G

-rwxr-xr-x. 1 oracle oinstall 464M Oct 17  2022 V1031181-01_6of12.zip

-rwxr-xr-x. 1 oracle oinstall 488M Oct 17  2022 V1031181-01_9of12.zip

-rwxr-xr-x. 1 oracle oinstall 610M Oct 17  2022 V1031181-01_10of12.zip

-rwxr-xr-x. 1 oracle oinstall 115M Oct 17  2022 V1031181-01_11of12.zip

-rwxr-xr-x. 1 oracle oinstall 494M Oct 17  2022 V1031181-01_8of12.zip

-rwxr-xr-x. 1 oracle oinstall 503M Oct 17  2022 V1031181-01_5of12.zip

-rwxr-xr-x. 1 oracle oinstall 6.3M Oct 17  2022 V1031181-01_12of12.zip

-rwxr-xr-x. 1 oracle oinstall 487M Oct 17  2022 V1031181-01_1of12.zip

-rwxr-xr-x. 1 oracle oinstall 501M Oct 17  2022 V1031181-01_2of12.zip

-rwxr-xr-x. 1 oracle oinstall 533M Oct 17  2022 V1031181-01_7of12.zip

-rwxr-xr-x. 1 oracle oinstall 577M Oct 17  2022 V1031181-01_4of12.zip

-rwxr-xr-x. 1 oracle oinstall 486M Oct 17  2022 V1031181-01_3of12.zip

[oracle@test1 12212]$ unzip -o ‘*.zip’

[oracle@test1 12212]$ du -sh 33527700/

13G        33527700/

SQL> col tablespace_name format a20;

SQL> col file_name format a40;

SQL> select FILE_NAME,TABLESPACE_NAME,BYTES/1024/1024 SizeMB  from dba_data_files where tablespace_name=’APPS_TS_TX_DATA’;

FILE_NAME                                                      TABLESPACE_NAME         SIZEMB

—————————————- ——————– ———-

/u01/oracle/PROD/data/a_txn_data03.dbf            APPS_TS_TX_DATA              1465

/u01/oracle/PROD/data/a_txn_data02.dbf            APPS_TS_TX_DATA          1657.625

/u01/oracle/PROD/data/a_txn_data01.dbf            APPS_TS_TX_DATA              1800

/u01/oracle/PROD/data/a_txn_data04.dbf            APPS_TS_TX_DATA              1744

SQL> Alter tablespace “APPS_TS_TX_DATA” add DATAFILE ‘/u01/oracle/PROD/data/a_txn_data05.dbf’ SIZE 100M REUSE AUTOEXTEND ON MAXSIZE 25600M;

Tablespace altered.

SQL> select FILE_NAME, TABLESPACE_NAME, BYTES/1024/1024 SizeMB, Status from dba_temp_files order by tablespace_name;

FILE_NAME                                                      TABLESPACE_NAME         SIZEMB STATUS

—————————————- ——————– ———- ——-

/u01/oracle/PROD/data/temp01.dbf        TEMP1                                   1100 ONLINE

/u01/oracle/PROD/data/temp0001.dbf   TEMP1                                   1000 ONLINE

/u01/oracle/PROD/data/temp02.dbf        TEMP2                                   1024 ONLINE

SQL> ALTER TABLESPACE TEMP2 ADD TEMPFILE ‘/u01/oracle/PROD/data/temp0002.dbf’ size 10240M reuse;

Tablespace altered.

SQL> show parameter service_name;

NAME                                                      TYPE VALUE

———————————— ———– ——————————

service_names                                      string               PROD, ebs_patch

SQL> alter system set service_names=’PROD’,’ebs_patch’ scope=both;

System altered.

[oracle@test1 ~]$ cd /u01/oracle/12212

[oracle@test1 12212]$ mv 33527700/ /u01/oracle/PROD/fs_ne/EBSapps/patch

[oracle@test1 12212]$ adop phase=apply apply_mode=downtime patches=33527700 wait_on_failed_job=yes workers=4 flags=autoskip

Enter the APPS password:

Enter the EBS_SYSTEM password:

Enter the WLSADMIN password:

Validating credentials.

Initializing.

    Run Edition context  : /u01/oracle/PROD/fs1/inst/apps/PROD_test1/appl/admin/PROD_test1.xml

    Patch edition context: /u01/oracle/PROD/fs2/inst/apps/PROD_test1/appl/admin/PROD_test1.xml

    Patch file system free space: 83.64 GB

Validating system setup.

[oracle@test1 ~]$ adopmon

Running script. Press Ctrl-C to quit.

Enter the APPS password:

Validating credentials…

Printing the log statements starting from sequence #506405

Timestamp           Node name           Message Type Message Text

—————————————————————————————————————————

2023/07/13 21:31:03 test1               EVENT        Application tier services are down.

2023/07/13 21:31:03 test1               EVENT        Continuing with the existing session [Session ID: 3].

2023/07/13 21:31:03 test1               EVENT        ADOP (C.Delta.14)

2023/07/13 21:31:03 test1               EVENT        Session ID: 3

2023/07/13 21:31:03 test1               EVENT        Node: test1

2023/07/13 21:31:04 test1               EVENT        Phase: apply

2023/07/13 21:31:04 test1               EVENT        Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/3/20230713_213030/adop.log

2023/07/13 21:31:06 test1               EVENT        Applying patch 33527700.

2023/07/13 21:31:10 test1               EVENT        Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/3/20230713_213030/apply/test1/33527700/log/u33527700.log

Since I have an SSD in my laptop and this is a production database rather than a vision database, the patching process took approximately 6 hours to finish. However, if you have limited resources, it may take around 14 to 15 hours. Therefore, I advise you to sit back and relax. You can periodically monitor the patch status after some time to stay updated.

[oracle@test1 ~]$ cd /u01/oracle/PROD/fs_ne/EBSapps/log/adop/3/20230713_213030/apply/test1/33527700/log

[oracle@test1 log]$ ls -ltrh autoskip.log

-rw-r–r–. 1 oracle oinstall 104 Jul 13 21:31 autoskip.log

[oracle@test1 log]$ cat autoskip.log

************* Start of AutoPatch session *************

AutoPatch started at: Thu Jul 13 2023 21:31:16

[oracle@test1 PROD]$ adop phase=cleanup cleanup_mode=full workers=4

[oracle@test1 PROD]$ adop phase=fs_clone

[oracle@test1 ~]$ cd /home/apps/stage/stage12212/patches/ONLINEpatch

[oracle@test1 ONLINEpatch]$ ls -ltrh p33527707_R12_GENERIC.zip

-rwxr-xr-x. 1 oracle oinstall 81M Jul 14 01:52 p33527707_R12_GENERIC.zip

oracle@test1 ONLINEpatch]$ unzip p33527707_R12_GENERIC.zip

[oracle@test1 ~]$ cd /u01/oracle/PROD/

[oracle@test1 PROD]$ . ./EBSapps.env run

  E-Business Suite Environment Information

  —————————————-

  RUN File System           : /u01/oracle/PROD/fs1/EBSapps/appl

  PATCH File System         : /u01/oracle/PROD/fs2/EBSapps/appl

  Non-Editioned File System : /u01/oracle/PROD/fs_ne

  DB Host: test1.example.com  Service/SID: PROD

  Sourcing the RUN File System …

[oracle@test1 PROD]$ cd /home/apps/stage/stage12212/patches/ONLINEpatch

[oracle@test1 ONLINEpatch]$ cp -pR 33527707/ $PATCH_TOP

[oracle@test1 ONLINEpatch adop phase=apply patches=33527707 hotpatch=yes

Enter the APPS password:

Enter the EBS_SYSTEM password:

Enter the WLSADMIN password:

Validating credentials.

Initializing.

    Run Edition context  : /u01/oracle/PROD/fs1/inst/apps/PROD_test1/appl/admin/PROD_test1.xml

    Patch edition context: /u01/oracle/PROD/fs2/inst/apps/PROD_test1/appl/admin/PROD_test1.xml

    Patch file system free space: 83.64 GB

Validating system setup.

[oracle@test1 PROD]$ . ./EBSapps.env Run

  E-Business Suite Environment Information

  —————————————-

  RUN File System           : /u01/oracle/PROD/fs1/EBSapps/appl

  PATCH File System         : /u01/oracle/PROD/fs2/EBSapps/appl

  Non-Editioned File System : /u01/oracle/PROD/fs_ne

  DB Host: test1.example.com  Service/SID: PROD

  Sourcing the RUN File System …

[oracle@test1 PROD]$ perl $AD_TOP/bin/admkappsutil.pl

Starting the generation of appsutil.zip

Log file located at /u01/oracle/PROD/fs1/inst/apps/PROD_test1/admin/log/MakeAppsUtil_07141658.log

output located at /u01/oracle/PROD/fs1/inst/apps/PROD_test1/admin/out/appsutil.zip

MakeAppsUtil completed successfully.

[oracle@test1 PROD]$ cp /u01/oracle/PROD/fs1/inst/apps/PROD_test1/admin/out/appsutil.zip /u01/oracle/PROD/12.1.0

[oracle@test1 ~]$ cd /u01/oracle/PROD/12.1.0

[oracle@test1 12.1.0]$ cp -pR appsutil appsutil_bkp

[oracle@test1 12.1.0]$ unzip -o appsutil.zip

[oracle@test1 ~]$ cd /u01/oracle/PROD/12.1.0/appsutil/scripts/PROD_test1

[oracle@test1 PROD_test1]$ ./adautocfg.sh

Enter the APPS user password:

The log file for this session is located at:

/u01/oracle/PROD/12.1.0/appsutil/log/PROD_test1/07141703/adconfig.log

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@test1 ~]$ source /u01/oracle/PROD/EBSapps.env run

  E-Business Suite Environment Information

  —————————————-

  RUN File System           : /u01/oracle/PROD/fs1/EBSapps/appl

  PATCH File System         : /u01/oracle/PROD/fs2/EBSapps/appl

  Non-Editioned File System : /u01/oracle/PROD/fs_ne

  DB Host: test1.example.com  Service/SID: PROD

  Sourcing the RUN File System …

[oracle@test1 ~]$ cd $ADMIN_SCRIPTS_HOME

[oracle@test1 scripts]$ ./adautocfg.sh

Enter the APPS user password:

The log file for this session is located at: /u01/oracle/PROD/fs1/inst/apps/PROD_test1/admin/log/07141710/adconfig.log

wlsDomainName: EBS_domain_PROD

WLS Domain Name is VALID.

AutoConfig is configuring the Applications environment…

AutoConfig will consider the custom templates if present.

               Using CONFIG_HOME location     : /u01/oracle/PROD/fs1/inst/apps/PROD_test1

               Classpath                   : /u01/oracle/PROD/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/oracle/PROD/fs1/EBSapps/comn/java/classes

               Using Context file          : /u01/oracle/PROD/fs1/inst/apps/PROD_test1/appl/admin/PROD_test1.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@test1 ~]$ echo $CONTEXT_FILE

/u01/oracle/PROD/fs1/inst/apps/PROD_test1/appl/admin/PROD_test1.xml

[oracle@test1 ~]$ grep s_forms_launch_method $CONTEXT_FILE

         <config_option type=”techstack” oa_var=”s_forms_launch_method”>browser</config_option>

[oracle@test1 ~]$ vi /u01/oracle/PROD/fs1/inst/apps/PROD_test1/appl/admin/PROD_test1.xml

[oracle@test1 ~]$ sh $ADMIN_SCRIPTS_HOME/adautocfg.sh

Enter the APPS user password:

The log file for this session is located at: /u01/oracle/PROD/fs1/inst/apps/PROD_test1/admin/log/07141755/adconfig.log

wlsDomainName: EBS_domain_PROD

WLS Domain Name is VALID.

AutoConfig is configuring the Applications environment…

AutoConfig will consider the custom templates if present.

               Using CONFIG_HOME location     : /u01/oracle/PROD/fs1/inst/apps/PROD_test1

               Classpath                   : /u01/oracle/PROD/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/oracle/PROD/fs1/EBSapps/comn/java/classes

               Using Context file          : /u01/oracle/PROD/fs1/inst/apps/PROD_test1/appl/admin/PROD_test1.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@test1 ~]$ adadmin

                     Copyright (c) 2002, 2012 Oracle Corporation

                        Redwood Shores, California, USA

                   Oracle E-Business Suite AD Administration

                                 Version 12.2.0

NOTE: You may not use this utility for custom development

      unless you have written permission from Oracle Corporation.

Your default directory is ‘/u01/oracle/PROD/fs1/EBSapps/appl’.

Is this the correct APPL_TOP [Yes] ?

AD Administration records your AD Administration session in a text file

you specify.  Enter your AD Administration log file name or press [Return]

to accept the default file name shown in brackets.

Filename [adadmin.log] :

************* Start of AD Administration session *************

AD Administration version: 12.2.0

AD Administration started at: Fri Jul 14 2023 18:07:31

APPL_TOP is set to /u01/oracle/PROD/fs1/EBSapps/appl

You can be notified by email if a failure occurs.

Do you wish to activate this feature [No] ?

Please enter the batchsize [1000] :

Please enter the name of the Oracle E-Business Suite System that this

APPL_TOP belongs to.

The Applications System name must be unique across all Oracle

Applications Systems at your site, must be from 1 to 30 characters

long, may only contain alphanumeric and underscore characters,

and must start with a letter.

Sample Applications System names are: “prod”, “test”, “demo” and

“Development_2”.

Applications System Name [PROD] : PROD *

NOTE: If you do not currently have certain types of files installed

in this APPL_TOP, you may not be able to perform certain tasks.

Example 1: If you don’t have files used for installing or upgrading

the database installed in this area, you cannot install or upgrade

the database from this APPL_TOP.

Example 2: If you don’t have forms files installed in this area, you cannot

generate them or run them from this APPL_TOP.

Example 3: If you don’t have concurrent program files installed in this area,

you cannot relink concurrent programs or generate reports from this APPL_TOP.

Do you currently have files used for installing or upgrading the database

installed in this APPL_TOP [YES] ? YES *

Do you currently have Java and HTML files for HTML-based functionality

installed in this APPL_TOP [YES] ? YES *

Do you currently have Oracle E-Business Suite forms files installed

in this APPL_TOP [YES] ? YES *

Do you currently have concurrent program files installed

in this APPL_TOP [YES] ? YES *

Please enter the name Oracle E-Business Suite will use to identify this APPL_TOP.

The APPL_TOP name you select must be unique within an Oracle E-Business Suite

System, must be from 1 to 30 characters long, may only contain

alphanumeric and underscore characters, and must start with a letter.

Sample APPL_TOP Names are: “prod_all”, “demo3_forms2”, and “forms1”.

APPL_TOP Name [AT_test1] : AT_test1 *

You are about to use or modify Oracle E-Business Suite product tables

in your ORACLE database ‘PROD’

using ORACLE executables in ‘/u01/oracle/PROD/fs1/EBSapps/10.1.2’.

Is this the correct database [Yes] ?

AD Administration needs the password for your ‘EBS_SYSTEM’ ORACLE schema

in order to determine your installation configuration.

Enter the password for your ‘EBS_SYSTEM’ ORACLE schema: 

The ORACLE username specified below for Application Object Library

uniquely identifies your existing product group: APPLSYS

Enter the ORACLE password of Application Object Library [APPS] : 

AD Administration is verifying your username/password.

EBSSYS code level : [C.1]

Connecting to EBS_SYSTEM with SYSTEM password

The status of various features in this run of AD Administration is:

                                           <-Feature version in->

Feature                          Active?   APPLTOP    Data model    Flags

——————————   ——-   ——–   ———–   ———–

CHECKFILE                        Yes       1          1             Y N N Y N Y

PREREQ                           Yes       6          6             Y N N Y N Y

CONCURRENT_SESSIONS              No        2          2             Y Y N Y Y N

PATCH_TIMING                     Yes       2          2             Y N N Y N Y

PATCH_HIST_IN_DB                 Yes       6          6             Y N N Y N Y

SCHEMA_SWAP                      Yes       1          1             Y N N Y Y Y

JAVA_WORKER                      Yes       1          1             Y N N Y N Y

CODELEVEL                        Yes       1          1             Y N N Y N Y

Identifier for the current session is 35792

Reading product information from file…

Reading language and territory information from file…

Reading language information from applUS.txt …

Reading database to see what industry is currently installed.

Reading FND_LANGUAGES to see what is currently installed.

Currently, the following language is installed:

Code   Language                                Status

—-   ————————————— ———

US     American English                        Base        

Your base language will be AMERICAN.

Setting up module information.

Reading database for information about the modules.

Saving module information.

Reading database for information about the products.

Reading database for information about how products depend on each other.

Reading topfile.txt …

Saving product information.

AD code level : [C.14]

*** Maintaining the Run File System (in Hotpatch mode) ***

*** Edition Enabled User ***

            AD Administration Main Menu

   ————————————————–

5. Generate Applications Files menu
6. Maintain Applications Files menu
7. Compile/Reload Applications Database Entities menu
8. Maintain Applications Database Entities menu
9. Exit AD Administration

Enter your choice [5] :1

1. Enter 4 and press enter
2. Enter Yes

Jar Files Starts Generating

Press Enter to continue

Press Enter

Press Enter to EXIT

[oracle@test1 scripts]$ ./adstrtal.sh apps/apps

You are running adstrtal.sh version 120.24.12020000.11

Enter the WebLogic Server password:

The logfile for this session is located at /u01/oracle/PROD/fs1/inst/apps/PROD_test1/logs/appl/admin/log/adstrtal.log

Executing service control script:

/u01/oracle/PROD/fs1/inst/apps/PROD_test1/admin/scripts/jtffmctl.sh start

Timeout specified in context file: 100 second(s)

script returned:

****************************************************

You are running jtffmctl.sh version 120.3.12020000.4

Validating Fulfillment patch level via /u01/oracle/PROD/fs1/EBSapps/comn/java/classes

Fulfillment patch level validated.

Starting Fulfillment Server for PROD on port 9300 …

jtffmctl.sh: exiting with status 0

.end std out.

.end err out.

****************************************************

Executing service control script:

/u01/oracle/PROD/fs1/inst/apps/PROD_test1/admin/scripts/adopmnctl.sh start

Timeout specified in context file: 100 second(s)

script returned:

****************************************************

You are running adopmnctl.sh version 120.0.12020000.2

Starting Oracle Process Manager (OPMN) …

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /u01/oracle/PROD/fs1/inst/apps/PROD_test1/logs/appl/admin/log/adopmnctl.txt for more information … 

.end std out.

.end err out.

****************************************************

Executing service control script:

/u01/oracle/PROD/fs1/inst/apps/PROD_test1/admin/scripts/adapcctl.sh start

Timeout specified in context file: 100 second(s)

script returned:

****************************************************

You are running adapcctl.sh version 120.0.12020000.6

Starting OPMN managed Oracle HTTP Server (OHS) instance …

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /u01/oracle/PROD/fs1/inst/apps/PROD_test1/logs/appl/admin/log/adapcctl.txt for more information … 

.end std out.

.end err out.

****************************************************

Executing service control script:

/u01/oracle/PROD/fs1/inst/apps/PROD_test1/admin/scripts/adnodemgrctl.sh start -nopromptmsg

Timeout specified in context file: -1 second(s)

script returned:

****************************************************

You are running adnodemgrctl.sh version 120.11.12020000.12

Calling txkChkEBSDependecies.pl to perform dependency checks for ALL MANAGED SERVERS

Perl script txkChkEBSDependecies.pl got executed successfully

Starting the Node Manager…

Refer /u01/oracle/PROD/fs1/inst/apps/PROD_test1/logs/appl/admin/log/adnodemgrctl.txt for details

NodeManager log is located at /u01/oracle/PROD/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1

adnodemgrctl.sh: exiting with status 0

adnodemgrctl.sh: check the logfile /u01/oracle/PROD/fs1/inst/apps/PROD_test1/logs/appl/admin/log/adnodemgrctl.txt for more information … 

.end std out.

*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

*** Log File = /u01/oracle/PROD/fs1/inst/apps/PROD_test1/logs/appl/rgf/TXK/txkChkEBSDependecies_Fri_Jul_14_16_22_06_2023

/txkChkEBSDependecies_Fri_Jul_14_16_22_06_2023.log

.end err out.

****************************************************

Executing service control script:

/u01/oracle/PROD/fs1/inst/apps/PROD_test1/admin/scripts/adalnctl.sh start

Timeout specified in context file: 100 second(s)

script returned:

****************************************************

adalnctl.sh version 120.3.12020000.4

Checking for FNDFS executable.

Starting listener process APPS_PROD.

adalnctl.sh: exiting with status 0

adalnctl.sh: check the logfile /u01/oracle/PROD/fs1/inst/apps/PROD_test1/logs/appl/admin/log/adalnctl.txt for more information … 

.end std out.

.end err out.

****************************************************

Executing service control script:

/u01/oracle/PROD/fs1/inst/apps/PROD_test1/admin/scripts/adcmctl.sh start

Timeout specified in context file: 1000 second(s)

script returned:

****************************************************

You are running adcmctl.sh version 120.19.12020000.7

Starting concurrent manager for PROD …

Starting PROD_0714@PROD Internal Concurrent Manager

Default printer is noprint

adcmctl.sh: exiting with status 0

adcmctl.sh: check the logfile /u01/oracle/PROD/fs1/inst/apps/PROD_test1/logs/appl/admin/log/adcmctl.txt for more information … 

.end std out.

.end err out.

****************************************************

Executing service control script:

/u01/oracle/PROD/fs1/inst/apps/PROD_test1/admin/scripts/adadminsrvctl.sh start -nopromptmsg

Timeout specified in context file: -1 second(s)

script returned:

****************************************************

You are running adadminsrvctl.sh version 120.10.12020000.11

Starting WLS Admin Server…

Refer /u01/oracle/PROD/fs1/inst/apps/PROD_test1/logs/appl/admin/log/adadminsrvctl.txt for details

AdminServer logs are located at /u01/oracle/PROD/fs1/FMW_Home/user_projects/domains/EBS_domain_PROD/servers/AdminServer/logs

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/oracle/PROD/fs1/inst/apps/PROD_test1/logs/appl/admin/log/adadminsrvctl.txt for more information … 

.end std out.

.end err out.

****************************************************

Executing service control script:

/u01/oracle/PROD/fs1/inst/apps/PROD_test1/admin/scripts/admanagedsrvctl.sh start forms_server1 -nopromptmsg

Timeout specified in context file: -1 second(s)

script returned:

****************************************************

You are running admanagedsrvctl.sh version 120.14.12020000.12

Starting forms_server1…

Server specific logs are located at /u01/oracle/PROD/fs1/FMW_Home/user_projects/domains/EBS_domain_PROD/servers/forms_server1/logs

admanagedsrvctl.sh: exiting with status 0

admanagedsrvctl.sh: check the logfile /u01/oracle/PROD/fs1/inst/apps/PROD_test1/logs/appl/admin/log/adformsctl.txt for more information … 

.end std out.

.end err out.

****************************************************

Executing service control script:

/u01/oracle/PROD/fs1/inst/apps/PROD_test1/admin/scripts/admanagedsrvctl.sh start oafm_server1 -nopromptmsg

Timeout specified in context file: -1 second(s)

script returned:

****************************************************

You are running admanagedsrvctl.sh version 120.14.12020000.12

Starting oafm_server1…

Server specific logs are located at /u01/oracle/PROD/fs1/FMW_Home/user_projects/domains/EBS_domain_PROD/servers/oafm_server1/logs

admanagedsrvctl.sh: exiting with status 0

admanagedsrvctl.sh: check the logfile /u01/oracle/PROD/fs1/inst/apps/PROD_test1/logs/appl/admin/log/adoafmctl.txt for more information … 

.end std out.

.end err out.

****************************************************

Executing service control script:

/u01/oracle/PROD/fs1/inst/apps/PROD_test1/admin/scripts/admanagedsrvctl.sh start oacore_server1 -nopromptmsg

Timeout specified in context file: -1 second(s)

script returned:

****************************************************

You are running admanagedsrvctl.sh version 120.14.12020000.12

Starting oacore_server1…

Server specific logs are located at /u01/oracle/PROD/fs1/FMW_Home/user_projects/domains/EBS_domain_PROD/servers/oacore_server1/logs

admanagedsrvctl.sh: exiting with status 0

admanagedsrvctl.sh: check the logfile /u01/oracle/PROD/fs1/inst/apps/PROD_test1/logs/appl/admin/log/adoacorectl.txt for more information … 

.end std out.

.end err out.

***************************************************

All enabled services for this node are started.

adstrtal.sh: Exiting with status 0

adstrtal.sh: check the logfile /u01/oracle/PROD/fs1/inst/apps/PROD_test1/logs/appl/admin/log/adstrtal.log for more information … 

Although we have enabled JWS by which you can open the application in all JWS-supported browsers including Google Chrome but we will open the application in Microsoft Edge

1. Open Microsoft Edge and enter the link http://test1.example.com:8000/
2. Reload the Page in Internet Explorer Mode as shown in the Picture

Enable the Following Options on This Link

1 Open This Page in Compatibility View  (Once you will Enable the Page will be reloaded)

2 Open this Page In Internet Explorer Mode Next Time (Once you will Enable the Page will be reloaded again

Now login with the Credentials as Shown in the Picture

As We are logging in first time after the upgrade it will give you this warning, Click Unlock

Select the following option and Proceed as shown in the Picture.

It will proceed to the Login Screen Again

1. Expand System Administrator Responsibility.
2. Click Define Profile Options to Open Forms Interface.

As You can See the Following Application and Database Version

Database Version: 12.1.0.2

Application Version: 12.2.12  

Login with the APPS or SYS user on Sqllplus to check the Application Version

SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME

————————————————–

12.2.12

Only Following Parameters need to be changed

[ol6_latest]

name=Oracle Linux $releasever Latest ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=1

[ol6_addons]

name=Oracle Linux $releasever Add ons ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/addons/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=1

[ol6_UEK_latest]

name=Latest Unbreakable Enterprise Kernel for Oracle Linux $releasever ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/UEK/latest/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=1

[root@test1 ~]# id oracle

uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)

[root@test1 ~]# id applmgr

uid=54322(applmgr) gid=54321(oinstall) groups=54321(oinstall)

[root@test1 ~]# passwd oracle

Changing password for user oracle.

New password:

BAD PASSWORD: The password contains the user name in some form

Retype new password:

passwd: all authentication tokens updated successfully.

[root@test1 ~]# vi /etc/security/limits.conf

—————

 * hard nofile 65536

 * soft nofile 4096

 * hard nproc 16384

 * soft nproc 2047

 * hard stack 16384

 * soft stack 10240

[root@test1 u01]# vi /etc/oraInst.loc

[root@test1 u01]# cat /etc/oraInst.loc

inventory_loc=/u01/oracle/oraInventory

inst_group=oinstall

Change the Permission level on oraInst.loc

[root@test1 /]# chmod 777 /etc/oraInst.loc

[root@test1 /]# mkdir -p /u01/oracle/oraInventory

[root@test1 /]# chmod 755 -R /u01/oracle/oraInventory

[root@test1 /]# ls -ld /u01/oracle/oraInventory

drwxr-xr-x. 2 root root 4096 Jul 12 16:39 /u01/oracle/oraInventory

[root@test1 /]# chown  -R oracle:oinstall  /u01/oracle/oraInventory

[root@test1 /]# chmod -R 777 /u01/oracle/oraInventory

 [root@test1 /]# chmod -R 775 /u01

[root@test1 /]# unlink /usr/lib/libXtst.so.6

[root@test1 /]# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

[root@test1 /]# ls -ltr /usr/lib/libXtst.so.6

lrwxrwxrwx. 1 root root 29 Jul 12 16:36 /usr/lib/libXtst.so.6 -> /usr/X11R6/lib/libXtst.so.6.1