5.1 Download the R12.2.0 software zip and keep on the server.(How to Download EBS 12.2.0)
5.2 Add Service ebs_patch in EBS Database
[oracle@ebstest tech_st]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jul 18 21:34:52 2025
Version 19.27.0.0.0
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.27.0.0.0
SQL> show parameter service NAME TYPE VALUE------------------------------------ ----------- ------------------------------service_names string FBSSQL> show parameter spfile; NAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string /u01/app/FBS/db/tec h_st/19c/dbs/spfileFBS. oraSQL> alter system set service_names='FBS,ebs_patch' scope=both; System altered. SQL> show parameter service NAME TYPE VALUE------------------------------------ ----------- ------------------------------service_names string FBS,ebs_patch5.3 Download Patch 17537119 on the server and run as below. No need to apply the patches as recommended for now.
[oracle@fbsebs bin]$ cd /u01/patches/etcc/
[oracle@ebstest tech_st]$ cd /u01/patches/etcc/
[oracle@ebstest etcc]$ ./checkDBpatch.sh contextfile=$CONTEXT_FILE
+===============================================================+
| Copyright (c) 2005, 2025 Oracle and/or its affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release 12.2 |
| Database EBS Technology Codelevel Checker |
+===============================================================+
Database environment not set, going to check for GridHome.
Oracle Grid Infrastructure not identified.
Database environment not set and no Grid home found, so context file must be specified.
Enter full path to database context file: /u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebstest.xml
Validating context file: /u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebstest.xml
Using context file from user input:
/u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebstest.xml
Starting Database EBS Technology Codelevel Checker, Version 120.137
Fri Jul 18 21:53:28 EAT 2025
Log file for this session:
/u01/patches/etcc/log/checkDBpatch_20572.log
Identifying database release.
Database release set to 19.27.0.0.
Multitenant identified.
- Container database (CDB) identified via s_cdb_name is fbscdb
- Pluggable database (PDB) identified via s_pdb_name is FBS
Connecting to database.
Database connection successful.
Database FBS is in READ WRITE mode.
Identifying APPS and APPLSYS schema names.
- APPS schema: APPS
- APPLSYS schema: APPLSYS
Checking for existence DB-ETCC results table.
Creating DB-ETCC results table.
Created the table to store DB-ETCC results.
Bugfix file ./db/onprem/txk_R1220_DB_base_bugs.xml: 120.0.12020000.93
This file will be used for identifying missing bugfixes.
Mapping file ./db/onprem/txk_R1220_DB_mappings.xml: 120.0.12020000.70
This file will be used for mapping bugfixes to patches.
[WARNING] DB-ETCC: Bugfix XML file (./db/onprem/txk_R1220_DB_base_bugs.xml) is
more than 30 days old.
+---------------------------------------------------------------------------------------+
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: 44
Checking Bugfix XML file for tag 19.27.0.0_RU.
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 19.27.0.0.250415DBRU.
All the required one-off bugfixes are present in database ORACLE_HOME.
+---------------------------------------------------------------------------------------+
Finished checking fixes for database FBS: Fri Jul 18 21:53:50 EAT 2025
Log file for this session:
/u01/patches/etcc/log/checkDBpatch_20572.log
This file should be reviewed for errors after the ETCC run.
5.4 Setup new layout for R12.2 file system. Login as root and go to the directory where the EBS12.2.0 zip files are kept and run rapidwiz
[root@ebstest stage1220]# pwd/mnt/stage1220[root@ebstest stage1220]# lsV100052-01_1of3.zip V100060-01_1of3.zip V29856-01.zip V35804-01_1of2.zipV100052-01_2of3.zip V100060-01_2of3.zip V35802-01.zip V35804-01_2of2.zipV100052-01_3of3.zip V100060-01_3of3.zip V35803-01_1of3.zip V46095-01_1of2.zipV100059-01_1of2.zip V100061-01.zip V35803-01_2of3.zip V46095-01_2of2.zipV100059-01_2of2.zip V100102-01.zip V35803-01_3of3.zip V75792-01.zip5.5 Build staging area.
5.5.1 Make we have all the zip downloaded and placed at /mnt/stage1220.
[root@fbsvis stage1220]# lsV100052-01_2of3.zip V100057-01.zip V100061-01.zip V35804-01_1of2.zipV100052-01_3of3.zip V100058-01.zip V100102-01.zip V35804-01_2of2.zipp32947483_R12_GENERIC.zip V100053-01_1of2.zip V100059-01_1of2.zip V29856-01.zip V46095-01_1of2.zip V100053-01_2of2.zip V100059-01_2of2.zip V35802-01.zip V46095-01_2of2.zip V100054-01.zip V100060-01_1of3.zip V35803-01_1of3.zip V75792-01.zipV100055-01.zip V100060-01_2of3.zip V35803-01_2of3.zip V100052-01_1of3.zip V100056-01.zip V100060-01_3of3.zip V35803-01_3of3.zip5.5.2 Now we will unzip the startCD zip files.
[root@fbsvis stage1220]# ls V100052*V100052-01_1of3.zip V100052-01_2of3.zip V100052-01_3of3.zip[root@fbsvis stage1220]# unzip 'V100052*.zip'
After unzipping the above 3 zip files we will see a folder created with startCD name.
[root@funoracleapps stage]# ls -ld startCDdrwxr-xr-x. 5 root root 4096 Mar 27 08:14 startCDLet's check the version of start CD.
[root@fbsvis stage1220]# cd startCD/Disk1/rapidwiz/[root@fbsvis rapidwiz]# lsbin driver File jlib oui RapidWiz.cmd RapidWizVersion TechInstallers unzipClientWiz.cmd etc images jre rapidwiz RapidWiz.ini RapidWizVersion.cmd template Xpatches[root@fbsvis rapidwiz]# cd /u01/mnt/stage12201220/startCD/Disk1/rapidwiz/[root@fbsvis rapidwiz]# ./RapidWizVersion Oracle E-Business Suite Rapid Install Wizard Version 12.2.0.51 (c) Copyright 2000-2011 Oracle Corporation. All rights reserved.Note: During installation rapidwiz might error with the unzip version if it higher than 5.5x.
The startCD provide us with correct version of the unzip. We will use same.
mv /usr/bin/unzip /usr/bin/unzip_origln -s /mnt/stage1220/startCD/Disk1/rapidwiz/unzip/Linux_x64/unzip /usr/bin/unzipCheck version
unzip -version We will build stage now which will automatically take care of all unzipping all other zip file and checking its integrity.
Go to below directory and run buildstage.sh
[root@fbsvis rapidwiz]# cd bin/[root@fbsvis bin]# pwd/u01/mnt/stage12201220/startCD/Disk1/rapidwiz/bin[root@fbsvis bin]# ./buildStage.sh Copyright (c) 2002, 2013 Oracle Corporation Redwood Shores, California, USA Oracle E-Business Suite Rapid Install Version 12.2.0 Press Enter to continue...Press Enter
Select Option 1
Select option 2 as we are using Linux.
It was ask for the directory containing all the zip files.
Running command:
/mnt/stage1220/startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java -classpath /mnt/stage1220/startCD/Disk1/rapidwiz/bin/../jlib/emocmutl.jar:/mnt/stage1220/startCD/Disk1/rapidwiz/bin/../jlib/ewt-3_4_22.jar:/mnt/stage1220/startCD/Disk1/rapidwiz/bin/../jlib/share-1_1_18.jar:/mnt/stage1220/startCD/Disk1/rapidwiz/bin/../jlib/jnls.jar:/mnt/stage1220/startCD/Disk1/rapidwiz/bin/../jlib/ACC.JAR:/mnt/stage1220/startCD/Disk1/rapidwiz/bin/../jlib/netcfg.jar:/mnt/stage1220/startCD/Disk1/rapidwiz/bin/../jlib/ojdbc14.jar:/mnt/stage1220/startCD/Disk1/rapidwiz/bin/../jlib/OraInstaller.jar:/mnt/stage1220/startCD/Disk1/rapidwiz/bin/../jlib/java oracle.apps.ad.rapidwiz.util.StageBuilder /mnt/stage1220/startCD/Disk1/rapidwiz/bin Linux_x64 Linux_x64WARNING: Insufficient free space in directory /mnt/stage1220 to unzip all EBS installation media.Specify the directory containing the zipped installation media: I have kept all the file as /mnt/stage1220 location. I will pass the same path and hit enter. I will get some warning related to zip files which are missing. I don't wanted to install vision database so I skipped those zip to be downloaded and will proceed without it.
/mnt/stage1220----------Finished unzipping shiphome.------------Directory /mnt/stage1220/TechPatches After this it will run few more unzip command once successful it will come out and we can go and see the stage directory.
[root@fbsvis stage1220]# ls32947483 V100053-01_1of2.zip V100060-01_1of3.zip V35803-01_3of3.zipEBSInstallMedia V100053-01_2of2.zip V100060-01_2of3.zip V35804-01_1of2.zipp32947483_R12_GENERIC.zip V100054-01.zip V100060-01_3of3.zip V35804-01_2of2.zipstartCD V100055-01.zip V100061-01.zip V46095-01_1of2.zipTechInstallMedia V100056-01.zip V100102-01.zip V46095-01_2of2.zipTechPatches V100057-01.zip V29856-01.zip V75792-01.zipV100052-01_1of3.zip V100058-01.zip V35802-01.zipV100052-01_2of3.zip V100059-01_1of2.zip V35803-01_1of3.zipV100052-01_3of3.zip V100059-01_2of2.zip V35803-01_2of3.zip5.6 Patching the Stage Area
After running the buildStage script, you should patch the stage area with the latest consolidated fixes since the release of the current StartCD. For StartCD 12.2.0.51, the consolidated fixes are delivered in Patch 32947483.
Download Patch 32947483.
Unzip this patch using the following command:
unzip p 32947483_R12_GENERIC.zip.Change to the 32947483 directory.
Patch the stage area using the following commands:
UNIX:
sh patchRIStage.sh
When prompted for the location of the Rapid Install stage, enter the path to the stage area you created for StartCD 12.2.0.51.
Tip: Run the script as the same user(root) that you used to run the buildStage script when creating the stage area.
[root@ebstest 32947483]# ./patchRIStage.shPatch directory is /mnt/stage1220/32947483 Enter the location of the Rapid Install Stage area:/mnt/stage1220Copied /mnt/stage1220/32947483/Disk1/rapidwiz/template/adcfgdeploy.sh to /mnt/stage1220/startCD/Disk1/rapidwiz/template/adcfgdeploy.sh. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/template/adcfgdeploy.cmd to /mnt/stage1220/startCD/Disk1/rapidwiz/template/adcfgdeploy.cmd. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/template/adrundeploy.cmd to /mnt/stage1220/startCD/Disk1/rapidwiz/template/adrundeploy.cmd. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/template/adrundb.sh to /mnt/stage1220/startCD/Disk1/rapidwiz/template/adrundb.sh. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/template/adrundb.cmd to /mnt/stage1220/startCD/Disk1/rapidwiz/template/adrundb.cmd. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/template/adrunat.sh to /mnt/stage1220/startCD/Disk1/rapidwiz/template/adrunat.sh. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/template/adrunat.cmd to /mnt/stage1220/startCD/Disk1/rapidwiz/template/adrunat.cmd. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/template/adrunfmw.cmd to /mnt/stage1220/startCD/Disk1/rapidwiz/template/adrunfmw.cmd. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/template/adsetpass.sh to /mnt/stage1220/startCD/Disk1/rapidwiz/template/adsetpass.sh. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/template/adsetpass.cmd to /mnt/stage1220/startCD/Disk1/rapidwiz/template/adsetpass.cmd. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/etc/afcpctx.sh to /mnt/stage1220/startCD/Disk1/rapidwiz/etc/afcpctx.sh. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/etc/afcpctx.cmd to /mnt/stage1220/startCD/Disk1/rapidwiz/etc/afcpctx.cmd. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/bin/riwTDBup.sh to /mnt/stage1220/startCD/Disk1/rapidwiz/bin/riwTDBup.sh. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/bin/riwTDBup.cmd to /mnt/stage1220/startCD/Disk1/rapidwiz/bin/riwTDBup.cmd. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/etc/adstartallmanaged.cmd to /mnt/stage1220/startCD/Disk1/rapidwiz/etc/adstartallmanaged.cmd. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/etc/oamksvc.obj to /mnt/stage1220/startCD/Disk1/rapidwiz/etc/oamksvc.obj. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/etc/OAMKSVC.exe to /mnt/stage1220/startCD/Disk1/rapidwiz/etc/OAMKSVC.exe. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/etc/adwindowsservicesuser.cmd to /mnt/stage1220/startCD/Disk1/rapidwiz/etc/adwindowsservicesuser.cmd. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/etc/adsvNodeManager.cmd to /mnt/stage1220/startCD/Disk1/rapidwiz/etc/adsvNodeManager.cmd. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/etc/igccmprf.cmd to /mnt/stage1220/startCD/Disk1/rapidwiz/etc/igccmprf.cmd. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/jlib/java/oracle/apps/ad/rapidwiz/data/AppsInstall.class to /mnt/stage1220/startCD/Disk1/rapidwiz/jlib/java/oracle/apps/ad/rapidwiz/data/AppsInstall.class. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/jlib/java/oracle/apps/ad/clone/util/OracleHomeCloner.class to /mnt/stage1220/startCD/Disk1/rapidwiz/jlib/java/oracle/apps/ad/clone/util/OracleHomeCloner.class. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/jlib/java/oracle/apps/ad/clone/util/OracleHomeCloner$AbsorbPrintStream.class to /mnt/stage1220/startCD/Disk1/rapidwiz/jlib/java/oracle/apps/ad/clone/util/OracleHomeCloner$AbsorbPrintStream.class. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/jlib/java/oracle/apps/ad/rapidwiz/util/CheckerClass.class to /mnt/stage1220/startCD/Disk1/rapidwiz/jlib/java/oracle/apps/ad/rapidwiz/util/CheckerClass.class. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/jlib/java/oracle/apps/ad/util/TimedProcess.class to /mnt/stage1220/startCD/Disk1/rapidwiz/jlib/java/oracle/apps/ad/util/TimedProcess.class. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/jlib/java/oracle/apps/ad/util/TimedProcess$TimedProcessProcess.class to /mnt/stage1220/startCD/Disk1/rapidwiz/jlib/java/oracle/apps/ad/util/TimedProcess$TimedProcessProcess.class. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/jlib/java/oracle/apps/ad/util/TimedProcess$AsyncStreamReader.class to /mnt/stage1220/startCD/Disk1/rapidwiz/jlib/java/oracle/apps/ad/util/TimedProcess$AsyncStreamReader.class. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/jlib/java/oracle/apps/ad/util/TimedProcess$TimedProcessTimer.class to /mnt/stage1220/startCD/Disk1/rapidwiz/jlib/java/oracle/apps/ad/util/TimedProcess$TimedProcessTimer.class. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/etc/txkManageDBConnectionPool.pl to /mnt/stage1220/startCD/Disk1/rapidwiz/etc/txkManageDBConnectionPool.pl. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/TechInstallers/ASInstallHome/fnd/patch/115/etc/txkUpdateBSU.sh to /mnt/stage1220/startCD/Disk1/rapidwiz/TechInstallers/ASInstallHome/fnd/patch/115/etc/txkUpdateBSU.sh. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/TechInstallers/ASInstallHome/fnd/patch/115/etc/txkUpdateBSU.cmd to /mnt/stage1220/startCD/Disk1/rapidwiz/TechInstallers/ASInstallHome/fnd/patch/115/etc/txkUpdateBSU.cmd. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/etc/Java.pm to /mnt/stage1220/startCD/Disk1/rapidwiz/etc/Java.pm. Copied /mnt/stage1220/32947483/Disk1/rapidwiz/etc/TechstackDB.pm to /mnt/stage1220/startCD/Disk1/rapidwiz/etc/TechstackDB.pm. Completed patching of the Rapid Install Stage area /mnt/stage1220Give 777 permission to stage location.
[root@ebstest rapidwiz]# cd /mnt/stage1220[root@ebstest stage1220]# ls -ltrtotal 8drwxr-xr-x. 3 root root 4096 Dec 10 21:01 software [root@ebstest stage1220]# chmod -R 777 software[root@ebstest stage1220]# ls -ltrrtotal 8drwxrwxrwx. 3 root root 4096 Dec 10 21:01 software
5.7 Apply patches to staging area
5.8 Modification of StartCD for Linux 8
Note: This workaround has been given from EBS users, not from EBS Development.
[root@fbsebs bin]# cd /u01/stage1220/TechInstallMedia/ohs11119/Disk3/stage/Components/oracle.buildtools.rsf/11.1.0.7.0/1/DataFiles/
[root@fbsebs DataFiles]# jar xvf filegroup4.jar
inflated: lib/stubs/libXaw-2.3.4-stub.so
inflated: lib/stubs/libpthread.so.0
inflated: lib/stubs/libXaw.so.7
inflated: lib/stubs/librt.so.1
inflated: lib/stubs/libXm.so.3
inflated: lib/stubs/libXext-2.3.4-stub.so
inflated: lib/stubs/libXp.so
inflated: lib/stubs/libaio.so.1
inflated: lib/stubs/libX11.so
inflated: lib/stubs/libXtst.so
inflated: lib/stubs/libXm.so
inflated: lib/stubs/libXi.so.6
inflated: lib/stubs/libXt.so
inflated: lib/stubs/libXaw3d-2.3.4-stub.so
inflated: lib/stubs/libutil.so.1
inflated: lib/stubs/libXmu.so.6
inflated: lib/stubs/libm-2.3.4-stub.so
inflated: lib/stubs/libutil.so
inflated: lib/stubs/libX11-2.3.4-stub.so
inflated: lib/stubs/libstdc++.so
inflated: lib/stubs/libcrypt-2.3.4-stub.so
inflated: lib/stubs/libc-2.3.4-stub.so
inflated: lib/stubs/libXaw3d.so
inflated: lib/stubs/ld-linux-2.3.4-stub.so
inflated: lib/stubs/libresolv.so
inflated: lib/stubs/libaio.so
inflated: lib/stubs/libXaw3d.so.7
inflated: lib/stubs/libutil-2.3.4-stub.so
inflated: lib/stubs/libICE.so.6
inflated: lib/stubs/libstdc++_shared.so
inflated: lib/stubs/libXi-2.3.4-stub.so
inflated: lib/stubs/libXpm-2.3.4-stub.so
inflated: lib/stubs/libm.so.6
inflated: lib/stubs/libICE-2.3.4-stub.so
inflated: lib/stubs/libcrypt.so
inflated: lib/stubs/libXm-2.3.4-stub.so
inflated: lib/stubs/libstdc++.so.6
inflated: lib/stubs/librt.so
inflated: lib/stubs/libc.so
inflated: lib/stubs/libc.so.tmp
inflated: lib/stubs/libdl.so
inflated: lib/stubs/librt-2.3.4-stub.so
inflated: lib/stubs/libpthread.so
inflated: lib/stubs/libX11.so.6
inflated: lib/stubs/libXmu-2.3.4-stub.so
inflated: lib/stubs/libXext.so.6
inflated: lib/stubs/libpthread.tmp
inflated: lib/stubs/libXpm.so
inflated: lib/stubs/libnsl-2.3.4-stub.so
inflated: lib/stubs/libnsl.so.1
inflated: lib/stubs/libcrypt.so.1
inflated: lib/stubs/libXtst-2.3.4-stub.so
inflated: lib/stubs/libnsl.so
inflated: lib/stubs/libdl.so.2
inflated: lib/stubs/libBrokenLocale-2.3.4-stub.so
inflated: lib/stubs/libpthread-2.3.4-stub.so
inflated: lib/stubs/libXp-2.3.4-stub.so
inflated: lib/stubs/libXt.so.6
inflated: lib/stubs/libXext.so
inflated: lib/stubs/libXt-2.3.4-stub.so
inflated: lib/stubs/libc.so.6
inflated: lib/stubs/libdl-2.3.4-stub.so
inflated: lib/stubs/libBrokenLocale.so
inflated: lib/stubs/ld-linux-x86-64.so.2
inflated: lib/stubs/libSM.so.6
inflated: lib/stubs/libaio-2.3.4-stub.so
inflated: lib/stubs/libXi.so
inflated: lib/stubs/libXaw.so
inflated: lib/stubs/libresolv.so.2
inflated: lib/stubs/libXp.so.6
inflated: lib/stubs/libXpm.so.4
inflated: lib/stubs/libm.so
inflated: lib/stubs/libSM-2.3.4-stub.so
inflated: lib/stubs/libstdc++_shared-2.3.4-stub.so
inflated: lib/stubs/libICE.so
inflated: lib/stubs/libXtst.so.6
inflated: lib/stubs/libBrokenLocale.so.1
inflated: lib/stubs/libresolv-2.3.4-stub.so
inflated: lib/stubs/libXmu.so
inflated: lib/stubs/libSM.so[root@fbsebs DataFiles]# cd lib/stubs
[root@fbsebs stubs]# mv libc.so.6 libc.so.6.safe
[root@fbsebs stubs]# cp -p /lib64/libc.so.6 .
[root@fbsebs stubs]# cd -
/u01/stage1220/TechInstallMedia/ohs11119/Disk3/stage/Components/oracle.buildtools.rsf/11.1.0.7.0/1/DataFiles
[root@fbsebs DataFiles]# mv filegroup4.jar filegroup4.jar.safe
[root@fbsebs DataFiles]# jar cvf filegroup4.jar lib
added manifest
adding: lib/(in = 0) (out= 0)(stored 0%)
adding: lib/stubs/(in = 0) (out= 0)(stored 0%)
adding: lib/stubs/libXaw-2.3.4-stub.so(in = 48856) (out= 10100)(deflated 79%)
adding: lib/stubs/libpthread.so.0(in = 38112) (out= 8757)(deflated 77%)
adding: lib/stubs/libXaw.so.7(in = 48856) (out= 10100)(deflated 79%)
adding: lib/stubs/librt.so.1(in = 10605) (out= 2970)(deflated 71%)
adding: lib/stubs/libXm.so.3(in = 415469) (out= 97445)(deflated 76%)
adding: lib/stubs/libXext-2.3.4-stub.so(in = 17229) (out= 4663)(deflated 72%)
adding: lib/stubs/libXp.so(in = 8924) (out= 2559)(deflated 71%)
adding: lib/stubs/libaio.so.1(in = 6540) (out= 1945)(deflated 70%)
adding: lib/stubs/libX11.so(in = 137006) (out= 36433)(deflated 73%)
adding: lib/stubs/libXtst.so(in = 7715) (out= 2218)(deflated 71%)
adding: lib/stubs/libXm.so(in = 415469) (out= 97445)(deflated 76%)
adding: lib/stubs/libXi.so.6(in = 9549) (out= 2682)(deflated 71%)
adding: lib/stubs/libXt.so(in = 58178) (out= 16657)(deflated 71%)
adding: lib/stubs/libXaw3d-2.3.4-stub.so(in = 41950) (out= 6895)(deflated 83%)
adding: lib/stubs/libutil.so.1(in = 5515) (out= 1683)(deflated 69%)
adding: lib/stubs/libXmu.so.6(in = 19497) (out= 5203)(deflated 73%)
adding: lib/stubs/libm-2.3.4-stub.so(in = 46537) (out= 11932)(deflated 74%)
adding: lib/stubs/libutil.so(in = 5515) (out= 1683)(deflated 69%)
adding: lib/stubs/libX11-2.3.4-stub.so(in = 137006) (out= 36433)(deflated 73%)
adding: lib/stubs/libstdc++.so(in = 45) (out= 33)(deflated 26%)
adding: lib/stubs/libcrypt-2.3.4-stub.so(in = 5639) (out= 1686)(deflated 70%)
adding: lib/stubs/libc-2.3.4-stub.so(in = 294016) (out= 83714)(deflated 71%)
adding: lib/stubs/libXaw3d.so(in = 41950) (out= 6895)(deflated 83%)
adding: lib/stubs/ld-linux-2.3.4-stub.so(in = 12113) (out= 2551)(deflated 78%)
adding: lib/stubs/libresolv.so(in = 17331) (out= 4328)(deflated 75%)
adding: lib/stubs/libaio.so(in = 6540) (out= 1945)(deflated 70%)
adding: lib/stubs/libXaw3d.so.7(in = 41950) (out= 6895)(deflated 83%)
adding: lib/stubs/libutil-2.3.4-stub.so(in = 5515) (out= 1683)(deflated 69%)
adding: lib/stubs/libICE.so.6(in = 22121) (out= 4824)(deflated 78%)
adding: lib/stubs/libstdc++_shared.so(in = 775802) (out= 157307)(deflated 79%)
adding: lib/stubs/libXi-2.3.4-stub.so(in = 9549) (out= 2682)(deflated 71%)
adding: lib/stubs/libXpm-2.3.4-stub.so(in = 11572) (out= 3048)(deflated 73%)
adding: lib/stubs/libm.so.6(in = 46537) (out= 11932)(deflated 74%)
adding: lib/stubs/libICE-2.3.4-stub.so(in = 22121) (out= 4824)(deflated 78%)
adding: lib/stubs/libcrypt.so(in = 5639) (out= 1686)(deflated 70%)
adding: lib/stubs/libXm-2.3.4-stub.so(in = 415469) (out= 97445)(deflated 76%)
adding: lib/stubs/libstdc++.so.6(in = 775802) (out= 157307)(deflated 79%)
adding: lib/stubs/librt.so(in = 10605) (out= 2970)(deflated 71%)
adding: lib/stubs/libc.so(in = 48) (out= 46)(deflated 4%)
adding: lib/stubs/libc.so.tmp(in = 48) (out= 46)(deflated 4%)
adding: lib/stubs/libdl.so(in = 6395) (out= 1962)(deflated 69%)
adding: lib/stubs/librt-2.3.4-stub.so(in = 10605) (out= 2970)(deflated 71%)
adding: lib/stubs/libpthread.so(in = 215) (out= 162)(deflated 24%)
adding: lib/stubs/libX11.so.6(in = 137006) (out= 36433)(deflated 73%)
adding: lib/stubs/libXmu-2.3.4-stub.so(in = 19497) (out= 5203)(deflated 73%)
adding: lib/stubs/libXext.so.6(in = 17229) (out= 4663)(deflated 72%)
adding: lib/stubs/libpthread.tmp(in = 215) (out= 162)(deflated 24%)
adding: lib/stubs/libXpm.so(in = 11572) (out= 3048)(deflated 73%)
adding: lib/stubs/libnsl-2.3.4-stub.so(in = 23997) (out= 6183)(deflated 74%)
adding: lib/stubs/libnsl.so.1(in = 23997) (out= 6183)(deflated 74%)
adding: lib/stubs/libcrypt.so.1(in = 5639) (out= 1686)(deflated 70%)
adding: lib/stubs/libXtst-2.3.4-stub.so(in = 7715) (out= 2218)(deflated 71%)
adding: lib/stubs/libnsl.so(in = 23997) (out= 6183)(deflated 74%)
adding: lib/stubs/libdl.so.2(in = 6395) (out= 1962)(deflated 69%)
adding: lib/stubs/libBrokenLocale-2.3.4-stub.so(in = 4911) (out= 1519)(deflated 69%)
adding: lib/stubs/libpthread-2.3.4-stub.so(in = 38112) (out= 8757)(deflated 77%)
adding: lib/stubs/libXp-2.3.4-stub.so(in = 8924) (out= 2559)(deflated 71%)
adding: lib/stubs/libXt.so.6(in = 58178) (out= 16657)(deflated 71%)
adding: lib/stubs/libXext.so(in = 17229) (out= 4663)(deflated 72%)
adding: lib/stubs/libXt-2.3.4-stub.so(in = 58178) (out= 16657)(deflated 71%)
adding: lib/stubs/libdl-2.3.4-stub.so(in = 6395) (out= 1962)(deflated 69%)
adding: lib/stubs/libBrokenLocale.so(in = 4911) (out= 1519)(deflated 69%)
adding: lib/stubs/ld-linux-x86-64.so.2(in = 12113) (out= 2551)(deflated 78%)
adding: lib/stubs/libSM.so.6(in = 9932) (out= 2779)(deflated 72%)
adding: lib/stubs/libaio-2.3.4-stub.so(in = 6540) (out= 1945)(deflated 70%)
adding: lib/stubs/libXi.so(in = 9549) (out= 2682)(deflated 71%)
adding: lib/stubs/libXaw.so(in = 48856) (out= 10100)(deflated 79%)
adding: lib/stubs/libresolv.so.2(in = 17331) (out= 4328)(deflated 75%)
adding: lib/stubs/libXp.so.6(in = 8924) (out= 2559)(deflated 71%)
adding: lib/stubs/libXpm.so.4(in = 11572) (out= 3048)(deflated 73%)
adding: lib/stubs/libm.so(in = 46537) (out= 11932)(deflated 74%)
adding: lib/stubs/libSM-2.3.4-stub.so(in = 9932) (out= 2779)(deflated 72%)
adding: lib/stubs/libstdc++_shared-2.3.4-stub.so(in = 775802) (out= 157307)(deflated 79%)
adding: lib/stubs/libICE.so(in = 22121) (out= 4824)(deflated 78%)
adding: lib/stubs/libXtst.so.6(in = 7715) (out= 2218)(deflated 71%)
adding: lib/stubs/libBrokenLocale.so.1(in = 4911) (out= 1519)(deflated 69%)
adding: lib/stubs/libresolv-2.3.4-stub.so(in = 17331) (out= 4328)(deflated 75%)
adding: lib/stubs/libXmu.so(in = 19497) (out= 5203)(deflated 73%)
adding: lib/stubs/libSM.so(in = 9932) (out= 2779)(deflated 72%)
adding: lib/stubs/libc.so.6.safe(in = 294016) (out= 83714)(deflated 71%)
adding: lib/stubs/libc.so.6(in = 2164784) (out= 891006)(deflated 58%)Known Issues:
Error: oracle.apps.fnd.txk.config.ProcessStateException: OUI process failed : Exit=1 See log for details. CMD= /b01/1225/TechInstallMedia/ohs11117/Disk1/runInstaller -waitForCompletion -ignoreSysPrereqs -force -silent -responseFile /u01/app/VIS/fs2/inst/apps/VIS_af82/temp/cfgHome/response/APPS_OHS_HOME/txkOHS_11117.rsp at oracle.apps.fnd.txk.config.OUIPatchActionNode.processState(OUIPatchActionNode.java:159)at oracle.apps.fnd.txk.config.PatchActionNode.processState(PatchActionNode.java:187)at oracle.apps.fnd.txk.config.PatchNode.processState(PatchNode.java:338)at oracle.apps.fnd.txk.config.PatchesNode.processState(PatchesNode.java:79)at oracle.apps.fnd.txk.config.InstallNode.processState(InstallNode.java:68)at oracle.apps.fnd.txk.config.TXKTopology.traverse(TXKTopology.java:594)at oracle.apps.fnd.txk.config.InstallService.doInvoke(InstallService.java:224)at oracle.apps.fnd.txk.config.InstallService.invoke(InstallService.java:237)at oracle.apps.fnd.txk.config.InstallService.main(InstallService.java:291) Cannot install Web Tier Utilities RW-50010: Error: – script has returned an error: 1RW-50004: Error code received when running external process. Check log file for details.Running APPL_TOP Install Driver for VIS instance5.9 Start installation using Rapidwiz from root user.
[root@fbsebs DataFiles]# cd /u01/stage1220/startCD/Disk1/rapidwiz/
[root@fbsebs rapidwiz]# ls
bin driver File jlib oui RapidWiz.cmd RapidWizVersion TechInstallers unzip
ClientWiz.cmd etc images jre rapidwiz RapidWiz.ini RapidWizVersion.cmd template Xpatches
[root@fbsebs rapidwiz]# ./rapidwiz
Rapid Install Wizard is validating your file system......
CMDDIR=/u01/stage1220/startCD/Disk1/rapidwiz
Rapid Install Wizard will now launch the Java Interface.....
Click Next
Select the upgrade Option
Uncheck the security updates click next then click yes.
Select Create a new Upgrade File System
Select Port Pool for file system 1 same as the one used for R12.1
Select details for current R12.1.3 database details and check option as use existing Oracle Home
Make sure all passwords for correct.
a) Selected Languages: American_English-US
b) Default Territory: AMERICA
c) Database Character Set: AL32UTF8
d) APPL_TOP Character Set: AL32UTF8
e) IANA Character Set: UTF-8
Provide a path where the file system layout for R12.2 will be installed. I am using a different folder for the same. "/mnt/stage1220"
Give a password that need to be set for the weblogic and the correct password for applmgr OS user.
As soon as you click next it will do a pre-check to validate.
Please ignore the Technology CodeCheck, These patches we will apply later and proceed as per the below screenshots.
It took 4 hrs for me to complete. Click finish once completed.
Verify the new EBS12.2 file system layout has been created.
[applmgr@fbsebs FBS]$ pwd
/u01/app/FBS
[applmgr@fbsebs FBS]$ ls -ltr
total 0
drwxr-xr-x. 4 oracle oinstall 36 Dec 6 12:46 db
drwxr-xr-x. 5 applmgr oinstall 49 Dec 13 09:04 fs1
drwxr-xr-x. 5 applmgr oinstall 49 Dec 13 09:04 fs2
drwxr-xr-x. 4 applmgr oinstall 33 Dec 13 09:57 fs_ne
5.10 Enable the maintenance mode by setting the environment file from the new EBS12.2 file system. Please use fs1 only as it will be the run file system.
[applmgr@fbsebs FBS]$ . /u01/app/FBS/fs1/EBSapps/appl/APPSFBS_fbsebs.env
[applmgr@fbsebs FBS]$ 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.
Successfully created out directory
Your default directory is '/u01/app/FBS/fs1/EBSapps/appl'.
Is this the correct APPL_TOP [Yes] ?
AD Administration Main Menu
--------------------------------------------------
1. Generate Applications Files menu
2. Maintain Applications Files menu
3. Compile/Reload Applications Database Entities menu
4. Maintain Applications Database Entities menu
5. Change Maintenance Mode
6. Exit AD Administration
Select option 5 and then select option 1. Once maintenance mode is set, please exit.
Enter your choice [6] : 5
Change Maintenance Mode
----------------------------------------
Maintenance Mode is currently: [Disabled].
Maintenance mode should normally be enabled when patching
Oracle E-Business Suite and disabled when users are logged on
to the system. See the Oracle E-Business Suite Maintenance
Utilities manual for more information about maintenance mode.
Please select an option:
1. Enable Maintenance Mode
2. Disable Maintenance Mode
3. Return to Main Menu
Enter your choice [3] : 1
sqlplus -s &un_apps/***** @/u01/app/FBS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql ENABLE
Successfully enabled Maintenance Mode.
5.11 Apply AD 12.2 Upgrade Driver
Download below patches and need to be applied
10117518
33526872
5.11.1 Copy adgrants from 33526872 to DB oracle home.
[oracle@fbsebs etcc]$ cd /u01/app/FBS/db/tech_st/12.1.0/appsutil/admin/
[oracle@fbsebs admin]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Fri Dec 13 10:20:19 2024
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql apps
5.11.2 Merge both patches and apply. Remember the source environment is set from fs1.
Create AD_source and AD_target directory and copy both patches to AD_source. Make sure the owner of directories is applmgr.
[applmgr@fbsebs patch]$ admrgpch -s /u01/app/FBS/fs_ne/EBSapps/patch/AD_source -d /u01/app/FBS/fs_ne/EBSapps/patch/AD_target -merge_name ad_cup13_patch -admode
Executing the merge of the patch drivers
-- Processing patch: /u01/app/FBS/fs_ne/EBSapps/patch/AD_source/10117518
-- Processing file: /u01/app/FBS/fs_ne/EBSapps/patch/AD_source/10117518/u10117518.drv
-- Done processing file: /u01/app/FBS/fs_ne/EBSapps/patch/AD_source/10117518/u10117518.drv
-- Done processing patch: /u01/app/FBS/fs_ne/EBSapps/patch/AD_source/10117518
-- Processing patch: /u01/app/FBS/fs_ne/EBSapps/patch/AD_source/33526872
-- Processing file: /u01/app/FBS/fs_ne/EBSapps/patch/AD_source/33526872/u33526872.drv
-- Done processing file: /u01/app/FBS/fs_ne/EBSapps/patch/AD_source/33526872/u33526872.drv
-- Done processing patch: /u01/app/FBS/fs_ne/EBSapps/patch/AD_source/33526872
Copying files...
5% complete. Copied 47 files of 925...
10% complete. Copied 93 files of 925...
15% complete. Copied 139 files of 925...
20% complete. Copied 185 files of 925...
25% complete. Copied 232 files of 925...
30% complete. Copied 278 files of 925...
35% complete. Copied 324 files of 925...
40% complete. Copied 370 files of 925...
45% complete. Copied 417 files of 925...
50% complete. Copied 463 files of 925...
55% complete. Copied 509 files of 925...
60% complete. Copied 555 files of 925...
65% complete. Copied 602 files of 925...
70% complete. Copied 648 files of 925...
75% complete. Copied 694 files of 925...
80% complete. Copied 740 files of 925...
85% complete. Copied 787 files of 925...
90% complete. Copied 833 files of 925...
95% complete. Copied 879 files of 925...
100% complete. Copied 925 files of 925...
Character-set converting files...
2 unified drivers merged.
Patch merge completed successfully
Please check the log file at ./admrgpch.log.
Source fs1 file system environment file.
cd /u01/app/FBS/fs_ne/EBSapps/patch/AD_target
Run
adpatch
when prompted for drive file, give the merge driver file name
u_ad_cup13_patch.drv
It will take around 30 minutes to complete.
5.12 Fix Timestamp Mismatch
Download patch 17268684 and unzip.
Copy file 17268684/admin/ADZDDTFIX.sql from patch to DB ORACLE HOME
[oracle@ebstest EBS1213_1220_upgrade_patches]$ cp 17268684/admin/ADZDDTFIX.sql $ORACLE_HOME/appsutil/admin
Connect as system user only and execute the script.
[oracle@fbsebs admin]$ ls
adctxprv.sql adgrants.sql adstats.sql ADZDDTFIX.sql wfaqupfix.sql
[oracle@fbsebs admin]$ sqlplus system/manager
SQL*Plus: Release 12.1.0.2.0 Production on Fri Dec 13 11:16:33 2024
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Fri Dec 13 2024 11:13:49 +03:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> @ADZDDTFIX.sql
begin
dbms_utility.invalidate(20857,NULL,0);
dbms_utility.invalidate(20829,NULL,0);
dbms_utility.invalidate(20837,NULL,0);
dbms_utility.invalidate(20838,NULL,0);
dbms_utility.invalidate(233652,NULL,0);
dbms_utility.invalidate(20849,NULL,0);
dbms_utility.invalidate(20791,NULL,0);
dbms_utility.invalidate(233653,NULL,0);
end;
/
exec sys.utl_recomp.recomp_parallel;
exit;
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@fbsebs admin]$ cat adzddtfix.out
begin
dbms_utility.invalidate(20857,NULL,0);
dbms_utility.invalidate(20829,NULL,0);
dbms_utility.invalidate(20837,NULL,0);
dbms_utility.invalidate(20838,NULL,0);
dbms_utility.invalidate(233652,NULL,0);
dbms_utility.invalidate(20849,NULL,0);
dbms_utility.invalidate(20791,NULL,0);
dbms_utility.invalidate(233653,NULL,0);
end;
/
exec sys.utl_recomp.recomp_parallel;
exit;
[oracle@fbsebs admin]$ sqlplus system/manager
SQL*Plus: Release 12.1.0.2.0 Production on Fri Dec 13 11:17:05 2024
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Fri Dec 13 2024 11:16:33 +03:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> @adzddtfix.out
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Re-execute script ADZDDTFIX.sql to check for any pending TimeStamp Mismatch issues.It should show no output.
5.13 Apply Consolidated Upgrade Patch and Run the 12.2.0 Upgrade
Connect as sysdba at db node and set
sec_case_sensitive_logon to False if set to True.
alter system set sec_case_sensitive_logon=false;
I have already kept it false so nothing to do.
SQL> show parameter case
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean FALSE
Download 34754463
Go to the Application node and run below from the patch location. Source fs1 environment file.
[applmgr@fbsebs 34754463]$ pwd
/u01/app/FBS/fs_ne/EBSapps/patch/34754463
[applmgr@fbsebs 34754463]$ ls
ad ar b34754463.ldt cn csr edr frm gme ibe j34754463_ad.zip jg msd ozf po qa wsh zx
ahl as ben cs cz ego fte gmf iby j34754463_ecx.zip jl msr pa pon qp xdo
ak asf bic csd ddr eni fun gmi icx j34754463_fnd.zip jtf okc patch_metadata.xml pos README.html xdp
alr asg bis csi dom f34754463.ldt fv gml ieu j34754463_jtf.zip jtm okl pay pqp README.txt xla
ams aso bne csl dpp fa ghg hri iex j34754463_xdo.zip marker1.txt oks per psa rrs xle
amv au bom csm eam fnd gl hxc imc ja mrp okx pji psp u34754463.drv xnb
ap az ce csp ecx fpa gmd ibc inv je msc ont pn pv wms xtr
[applmgr@fbsebs 34754463]$ adpatch preinstall=y
Now merge the patch.
Note: American English Patch driver u10124646.drv comes with 12.2 filesystem layout installation as done earlier
[applmgr@fbsebs 34754463]$ cd $AU_TOP/patch/115/driver
[applmgr@fbsebs driver]$ ls
augenmsg.drvx ausstats.drvx u10124646.drv u10201000.drv
[applmgr@fbsebs driver]$ admrgpch -d . -preinstall -master u10124646.drv
Executing the merge of the patch drivers
-- Processing file: /u01/app/FBS/fs1/EBSapps/appl/admin/FBS/preinstall/u34754463.drv
-- Done processing file: /u01/app/FBS/fs1/EBSapps/appl/admin/FBS/preinstall/u34754463.drv
-- Processing file: u10124646.drv
-- Done processing file: u10124646.drv
2 unified drivers merged.
Patch merge completed successfully
Please check the log file at ./admrgpch.log.
[applmgr@fbsebs driver]$ pwd
/u01/app/FBS/fs1/EBSapps/appl/au/12.0.0/patch/115/driver
[applmgr@fbsebs driver]$ ls
admrgpch.log augenmsg.drvx ausstats.drvx u10124646.drv u10201000.drv u_merged.drv
[applmgr@fbsebs driver]$ adpatch options=nocopyportion,nogenerateportion
when prompted for drive file, give the merge driver file name
u_merged.drv
It will take around 3 hrs to complete.
Please keep monitoring the database alert log and patch log on other putty/terminal sessions.
------------------------------------------------------------------------------------------------------------------
Known Error: ( if you did not autoextend tablespases then do this the step below)
Updating FND_PRODUCT_GROUPS.release_name, if necessary...
Done saving Patch History information.
AutoPatch error:
adptaskStoreTimInfoToHist: Error while inserting into AD_PROGRAM_RUN_TASK_JOBS.
AutoPatch error:
ORA-01653: unable to extend table APPLSYS.AD_PROGRAM_RUN_TASK_JOBS by 16 in tablespace APPS_TS_TX_DATA
AutoPatch error:
adpmrp: Error calling adptaskStoreTimInfoToHist(2).
Add space to tablespace/or autoextend the datafile.Rerun adpatch again.
Solution:
SQL> select file_name,bytes/1024/1024,autoextensible from dba_data_files where tablespace_name='APPS_TS_TX_DATA';
FILE_NAME BYTES/1024/1024 AUT
---------------------------------------------------------------------- --------------- ---
/u01/app/VIS/db/apps_st/data/a_txn_data04.dbf 1744 NO
/u01/app/VIS/db/apps_st/data/a_txn_data01.dbf 1267.5 NO
/u01/app/VIS/db/apps_st/data/a_txn_data02.dbf 1657.625 NO
/u01/app/VIS/db/apps_st/data/a_txn_data03.dbf 1323 NO
SQL> alter database datafile '/u01/app/VIS/db/apps_st/data/a_txn_data01.dbf' autoextend on;
Database altered.
SQL> SQL> select file_name,bytes/1024/1024,autoextensible from dba_data_files where tablespace_name='APPS_TS_TX_DATA'
2 ;
FILE_NAME BYTES/1024/1024 AUT
---------------------------------------------------------------------- --------------- ---
/u01/app/VIS/db/apps_st/data/a_txn_data04.dbf 1744 NO
/u01/app/VIS/db/apps_st/data/a_txn_data01.dbf 1267.5 YES
/u01/app/VIS/db/apps_st/data/a_txn_data02.dbf 1657.625 NO
/u01/app/VIS/db/apps_st/data/a_txn_data03.dbf 1323 NO
Re-run adpatch now.
-----------------------------------------------------------------------------------------------------------------------------
Verify patch 34754463 has been applied.
SQL> select bug_number from ad_bugs where bug_number='34754463';
BUG_NUMBER
------------------------------
34754463
5.14 Disable Maintenance Mode
Run adadmin after sourcing fs1 environment file.
Change Maintenance Mode
----------------------------------------
Maintenance Mode is currently: [Enabled].
Maintenance mode should normally be enabled when patching
Oracle E-Business Suite and disabled when users are logged on
to the system. See the Oracle E-Business Suite Maintenance
Utilities manual for more information about maintenance mode.
Please select an option:
1. Enable Maintenance Mode
2. Disable Maintenance Mode
3. Return to Main Menu
Enter your choice [3] : 2
sqlplus -s &un_apps/***** @/u01/app/FBS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql DISABLE
Successfully disabled Maintenance Mode.
5.15 Run AutoConfig on the Apps Tier
On Application node and Source the applications run file system environment file
Verify if below autoconfig table exists
[applmgr@ebstest driver]$ sqlplus apps/apps
SQL*Plus: Release 10.1.0.5.0 - Production on Sat Dec 12 08:01:25 2020
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select object_name, object_type, owner, status from dba_objects where upper(object_name)='ADX_PRE_AUTOCONFIG' and object_type='TABLE' and upper(owner)='APPS';
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-----------------------
OWNER
--------------------------------------------------------------------------------
STATUS
-------
ADX_PRE_AUTOCONFIG
TABLE
APPS
VALID
Execute the following commands to drop table ADX_PRE_AUTOCONFIG from APPS
schema:
sqlplus apps/apps
SQL> @$AD_TOP/patch/115/sql/txkDropAdxPreAutoConfig.sql
Table ADX_PRE_AUTOCONFIG dropped
Synonym ADX_PRE_AUTOCONFIG does not exist
PL/SQL procedure successfully completed.
Commit complete.
Execute auto-config now
Make sure it completes successfully.
[applmgr@ebstest driver]$ $ADMIN_SCRIPTS_HOME/adautocfg.sh
5.16 Configuring the Oracle E-Business Suite Release 12.2 Application Tier by rapid install
Go to the stage area which was also used in step 4 earlier.
connect with root user and launch rapidwiz
[root@ebstest rapidwiz]# pwd
/mnt/stage1220/startCD/Disk1/rapidwiz
./rapidwiz
Click next on the Welcome Screen
Select Upgrade Option
Don't provide any email address and continue.
On Select Upgarde Action screen, select Configure Upgarde Release 12.2.0 Instance
and Browse the path ($INST_TOP>/appl/admin/<CONTEXT_NAME>.xml) and click Next.
e.g. /u01/app/FBS/fs1/inst/apps/FBS_fbsebs/appl/admin/FBS_fbsebs.xml
Enter the WebLogic password which was given earlier in Step 4. and click Next. It will do pre-checks.
Click next on the Validate system configuration screen. But before that ensure that all the checks should be passed
Verify the Database and Middle tier Information
Confirm rapidwiz to start configuring the EBS 12.2.0
It took 1 hrs for me to complete.
Click Next and Finish.
5.17 Enable the Online patching
Run the Online Patching Enablement - Readiness Reports
Source run file system and create below directory.
mkdir $LOG_HOME/appl/op
cd $LOG_HOME/appl/op
Run the following Readiness reports:
5.17.1 ADZDPSUM.sql
Provides a summary of the schemas that will be editioned and also schemas with objects that depend on E-Business Suite code that is recommended to be editioned. You can register these schemas with the application by running the commands that will be listed in the last section of this report. Oracle recommends that you run this report again after the custom schemas are registered with the application. You should run ADZDPSUM.sql repeatedly to handle dependent schemas until no further EBR violations are reported.
sqlplus system/manager
@$AD_TOP/sql/ADZDPSUM.sql
Once completed rename the outfile which is created.
mv adzdpsum.txt adzdpsum_pre_dbprep.txt
5.17.2 ADZDPMAN.sql
Lists objects with different categories of violations to EBR rules that must be fixed prior to running the enablement process to avoid errors during this process. Oracle recommends that you run this report after all custom schemas are registered with the application according to instructions in the above report ADZDPSUM.sql.
sqlplus system/manager
@$AD_TOP/sql/ADZDPMAN.sql
Once completed rename the outfile which is created.
mv adzdpman.txt adzdpman_pre_dbprep.txt
5.17.3 ADZDPAUT.sql
This report lists all the objects with violations of the EBR rules that will be fixed automatically from the enablement process. This report is provided for information purposes and no action should be taken from this report.
Note: Please make sure you have sufficient space in TEMP tablespace as it can fail with "unable to extend temp tablespace error".
sqlplus system/manager
SQL> @$AD_TOP/sql/ADZDPAUT.sql
Once completed rename the outfile which is created.
mv adzdpaut.txt adzdpaut_pre_dbprep.txt
----------------------------------------------------------------------------------------------------
Important
The Online Patching Readiness Report contains sections with different violation types.
Review all sections listed from the ADZDPMAN.sql report. Follow instructions in each section to fix violations.
Note: Many violations in the Readiness report can be automatically fixed by registering your custom schemas. Review the last section of the Summary Readiness Report (ADZDPSUM.sql) for sample commands on how to register your custom schemas as well as any schema installed as part of an Oracle technology such as APEX, XDB, and OWBSYS. You must register any custom or third-party schema that does not support Oracle E-Business Suite Online Patching.
The following schemas should NOT be registered:
SYS
SYSTEM
CTXSYS
Any dependency between these schemas and Editioned Objects is a coding standards violation and must be fixed manually.
Oracle recommends that you perform the chosen fix by customizing template file $AD_TOP/sql/ADZDPCUST.sql. The reports provide more details on this step.
Repeat the Run the Online Patching Enablement - Readiness Report step above until all violations have been addressed.
-------------------------------------------------------------------------------------------------------------------------
Verify database tablespace free space (if you did not autoextend tablespases then do this)
On application node and Source the application run environment file.
perl $AD_TOP/bin/adzdreport.pl apps
a) Enter apps password (apps) when prompt to enter.
b) Select option 3 - 'Other Generic Reports'
Select the next option 3 - 'Free Space in Important Tablespaces
=========================================================================
= Important Tablespace Status
=========================================================================
TABLESPACE_NAME TOTAL_SPACE(GB) USED_SPACE(GB) FREE_SPACE(GB) PCT_USED
------------------------------ --------------- -------------- -------------- --------
APPS_TS_SEED 2.97 2.81 .16 94.74
APPS_TS_TX_DATA 6.16 5.86 .30 95.13
APPS_TS_TX_IDX 8.26 7.57 .69 91.63
SYSTEM 12.38 11.79 .60 95.18
Above report is captured in file : /u01/app/FBS/fs1/EBSapps/appl/admin/VIS/out/adzdshowts.out.
===============================================================================
Ensure the following:
SYSTEM Tablespace: has a minimum of 25 GB of free space
APPS_TS_SEED Tablespace: has a minimum of 5 GB of free space
APPS_TS_SEED is used to host all tables that have been registered as seed tables and that require seed data storage infrastructure.
Add the required space in the tablespaces and rerun the report to validate.
=========================================================================
= Important Tablespace Status
=========================================================================
TABLESPACE_NAME TOTAL_SPACE(GB) USED_SPACE(GB) FREE_SPACE(GB) PCT_USED
------------------------------ --------------- -------------- -------------- --------
APPS_TS_SEED 8.82 2.81 6.01 31.86
APPS_TS_TX_DATA 10.46 5.86 4.60 56.06
APPS_TS_TX_IDX 13.18 7.57 5.60 57.47
SYSTEM 38.43 11.79 26.64 30.67
Above report is captured in file : /u01/app/FBS/fs1/EBSapps/appl/admin/VIS/out/adzdshowts.out.
===============================================================================
Note: Verify that all middle-tier E-Business Suite services are shut down prior to applying the Online Patching Enablement patch.
Run the Online Patching Enablement - Status Report
This report provides an overall status of the enabling online patching process. You can run it before, during, and after the enablement, the patch is applied. At this stage, you will receive report results before you enable online patching.
Set the current directory to $LOG_HOME/appl/op:
$ cd $LOG_HOME/appl/op
Run the report using the following command. Ensure that you verify any invalid objects at this stage. Take special note to ensure that all online patching objects (objects that match the pattern 'AD_ZD%') are valid:
$ sqlplus <apps username> @$AD_TOP/sql/ADZDEXRPT.sql
Note: Enter the apps password when prompted.
Save the output as pre_dbprep for future references, such as:
$ mv adzdexrpt.txt adzdexrpt_pre_dbprep.txt
Apply the Online Patching Enablement patch
Download patch 13543062
On the application node and source the environment file.
Copy the 13543062 patch to the default patch directory.
cd /u01/app/VIS/fs_ne/EBSapps/patch
cp /mnt/stage1220/p13543062_R12.AD.C_R12_GENERIC.zip .
.
unzip p13543062_R12.AD.C_R12_GENERIC.zip
Run Autopatch in hotpatch mode to apply the patch
Note: We are not placing in maintenance mode as we are applying it in hotpatch mode,after this patch is applied, maintenance mode will be removed from good, so should not enable maintenance mode.
This patch is reapplied here for online Patching enablement, that is why it is applied in forceapply mode.
cd /u01/app/VIS/fs_ne/EBSapps/patch/13543062
adpatch options=hotpatch,forceapply
Important: While applying the Online Enablement patch, you may receive the following error: 'Attention: Adpatch should no longer be used to apply patches. Please use ADOP tool for applying patches.' If you receive this error, then you must use adop in hotpatch mode to apply the enablement patch.
Known Error:
There are now 46 jobs remaining (current phase=A3):
0 running, 1 ready to run and 45 waiting.
Assigned: file ADZDPREP.sql on worker 1 for product ad username APPLSYS.
FAILED: file ADZDPREP.sql on worker 1 for product ad username APPLSYS.
Deferred: file ADZDPREP.sql on worker 1 for product ad username APPLSYS. (Deferment number 1 for this job)
Assigned: file ADZDPREP.sql on worker 1 for product ad username APPLSYS.
FAILED: file ADZDPREP.sql on worker 1 for product ad username APPLSYS.
Deferred: file ADZDPREP.sql on worker 1 for product ad username APPLSYS. (Deferment number 2 for this job)
Assigned: file ADZDPREP.sql on worker 1 for product ad username APPLSYS.
FAILED: file ADZDPREP.sql on worker 1 for product ad username APPLSYS.
ATTENTION: All workers either have failed or are waiting:
FAILED: file ADZDPREP.sql on worker 1.
Error from worker001.log
begin
*
ERROR at line 1:
ORA-44303: service name exists
ORA-06512: at "SYS.DBMS_SERVICE_ERR", line 21
ORA-06512: at "SYS.DBMS_SERVICE", line 316
ORA-06512: at "APPS.AD_ZD_PREP", line 392
ORA-01403: no data found
ORA-06512: at "APPS.AD_ZD_PREP", line 386
ORA-06512: at line 4
Solution:
If ebs_patch exists then Please perform below action plan.:
[oracle@ebstest ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jul 20 01:05:25 2025
Version 19.27.0.0.0
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.27.0.0.0
SQL> select SERVICE_ID,NAME from dba_services;
SERVICE_ID NAME
---------- ----------------------------------------------------------------
1 SYS$BACKGROUND
2 SYS$USERS
3 fbscdb
4 ebs_patch
5 fbscdbXDB
6 fbscdb.finsys.co.ke
6 rows selected.
SQL> select c.name from cdb_services c, service$ s where s.deletion_date is null and s.name = c.name;
NAME
----------------------------------------------------------------
SYS$BACKGROUND
fbscdb
SYS$USERS
ebs_patch
fbscdbXDB
fbscdb.finsys.co.ke
6 rows selected.
SQL> begin
DBMS_SERVICE.STOP_SERVICE(service_name =>'ebs_patch');
DBMS_SERVICE.DELETE_SERVICE(service_name =>'ebs_patch');
end; 2 3 4 5 6 7 8 9
10 /
PL/SQL procedure successfully completed.
SQL> select SERVICE_ID,NAME from dba_services;
SERVICE_ID NAME
---------- ----------------------------------------------------------------
1 SYS$BACKGROUND
2 SYS$USERS
3 fbscdb
5 fbscdbXDB
6 fbscdb.finsys.co.ke
SQL>
5.21 Continue with the upgrade and confirm online patching is successfully enabled.
Use adctrl to restart the failed worker.
Enter the worker number(s)/range(s) or 'all' for all workers,
or press [Return] to go back to the menu : 1
Status changed to 'Fixed, restart' for worker 1.
Review the messages above, then press [Return] to continue.
AD Controller Menu
---------------------------------------------------
1. Show worker status
2. Tell worker to restart a failed job
3. Tell worker to quit
4. Tell manager that a worker failed its job
5. Tell manager that a worker acknowledges quit
6. Restart a worker on the current machine
7. Exit
Enter your choice [1] : 4
Enter the worker number(s)/range(s) or 'all' for all workers,
or press [Return] to go back to the menu : 1
AD Controller error:
Worker 1 does not have status 'Running' or 'Restarted' or 'Fixed, restart'.
Review the messages above, then press [Return] to continue.
AD Controller Menu
---------------------------------------------------
1. Show worker status
2. Tell worker to restart a failed job
3. Tell worker to quit
4. Tell manager that a worker failed its job
5. Tell manager that a worker acknowledges quit
6. Restart a worker on the current machine
7. Exit
Enter your choice [1] : 2
Enter the worker number(s)/range(s) or 'all' for all workers,
or press [Return] to go back to the menu : 1
Status changed to 'Fixed, restart' for worker 1.
Review the messages above, then press [Return] to continue.
AD Controller Menu
---------------------------------------------------
1. Show worker status
2. Tell worker to restart a failed job
3. Tell worker to quit
4. Tell manager that a worker failed its job
5. Tell manager that a worker acknowledges quit
6. Restart a worker on the current machine
7. Exit
Enter your choice [1] :
Monitor the Online Patching Enablement patch application.
The enablement patch application may take several hours to finish. You can monitor its progress at any time by running the DDL Status Report (ADZDSHOWDDLS.sql) as follows:
$ sqlplus <apps Username> @$AD_TOP/sql/ADZDSHOWDDLS.sql
This report lists a count of the DDL statements that are required to EBR enable your environment. The report is organized by outcome of execution: 'Successfully Executed', 'Not Executed', and 'Failed Execution'. At the end of the patch application the report should have a zero count in the sections: 'Not Executed' and 'Failed Execution'. If the report contains 'Not Executed' and 'Failed Execution' items, then report these failures to Oracle Support. You will be asked to provide the output from the report, the patch log and all worker logs, and the online patching enablement status report output. If there is any worker failure during the Online Enablement patch, you should not ignore or skip the failed error. The issue should be addressed before restarting the worker. Ignoring or skipping the error can cause database corruption.
Example:
[applmgr@ebstest ~]$ sqlplus apps @$AD_TOP/sql/ADZDSHOWDDLS.sql
SQL*Plus: Release 10.1.0.5.0 - Production on Sat Dec 12 14:26:43 2020
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
DOC>
DOC> Count of Current DDL Jobs per Phase and Status
DOC>
DOC> Phases:
DOC> 1. DROP_UNUSED_OBJECT : Remove obsolete objects from XLA schema.
DOC> 2. COPY_TYPE : Create EBS Types in APPS_NE schema, stop Advanced Queues.
DOC> 3. COMPILE_TYPE : Recompile APPS_NE schema.
DOC> 4. COPY_EVOLVED_TYPE : Create evolved types in APPS_NE schema.
DOC> 5. FIX_COLUMN : Fix TYPE reference to APPS_NE.<type> at table and AQ level.
DOC> 6. FIX_TYPE : Additional check, Fix TYPE reference and then drop TYPE
DOC> from source schema.
DOC> 7. FIX_PUBLIC_SYNONYM : Fix public synonyms.
DOC> 8. RECREATE_AQ_OBJECT : Re-create internal AQ objects after TYPE Ref fix.
DOC> 9. DROP_OBJECT : Drop objects like CTXSYS.<package>, CTXSYS.<synonym> and others if any.
DOC> 10. ENABLE_EDITIONING : Enable registered schemas for Online Patching.
DOC> 11. UPGRADE_TABLE : Create Editioning View cover layer over EBS data model.
DOC> 12. UPGRADE_SEED : Upgrade seed data tables to support edition based storage.
DOC> 13. COLLECT_STATS : Gather Statistics on Seed Data Tables after upgrade.
DOC> 14. UPGRADE_MVIEW : Convert Materialized Views with expand query.
DOC> 15. CUTOVER : Perform maintenance operations on columns and indexes after adop APPLY phase
DOC> and before actually changing Patch-Edition as Default-Edition.
DOC> 16. ACTUALIZE_ALL : Actualize all editioned objects into the current edition.
DOC> 17. CLEANUP : Cleanup task after adop CUTOVER.
DOC>
DOC>
DOC> Results spooled to: ADZDSHOWDDLS.out
DOC>#
Phase Count Status
-------------------- ------- ------------------------------
COPY_TYPE 41 S - Successfully Executed
COMPILE_TYPE 1 S - Successfully Executed
COPY_EVOLVED_TYPE 1 S - Successfully Executed
FIX_COLUMN 2 S - Successfully Executed
FIX_TYPE 22 S - Successfully Executed
FIX_PUBLIC_SYNONYM 4486 S - Successfully Executed
RECREATE_AQ_OBJECT 11 S - Successfully Executed
DROP_OBJECT 10 S - Successfully Executed
ENABLE_EDITIONING 163 S - Successfully Executed
UPGRADE_TABLE 11508 N - Not Executed
4 R - Running
6331 S - Successfully Executed
UPGRADE_SEED 2605 N - Not Executed
COLLECT_STATS 2605 N - Not Executed
UPGRADE_MVIEW 120 N - Not Executed
15 rows selected.
DOC>
DOC> Currently running phase is:
DOC>
DOC>#
Running Phase
--------------------
UPGRADE_TABLE
1 row selected.
Total time taken is 7 hrs .
5.22 Compile Invalid Objects (if any)
Connect to sqlplus as 'apps' and run the following:
$ exec sys.utl_recomp.recomp_parallel
5.23 Re-run the Online Patching Enablement Status Report after the Online Patching Enablement patch has been applied
Set the current directory to $LOG_HOME/appl/op:
$ cd $LOG_HOME/appl/op
Run the Status Report immediately after the enablement patch completes:
$ sqlplus <Apps Username> @$AD_TOP/sql/ADZDEXRPT.sql
Note: You must provide the APPS schema password when prompted.
The purpose of running this report at this stage is to identify and fix any errors that occurred during the enablement process.
Important: You must fix errors listed by this report. Failure to comply may result in unexpected failures during future patching cycles.
5.24 Re-run the Online Patching Enablement Readiness Report after the Online Patching Enablement patch has been applied
Set the current directory to $LOG_HOME/appl/op:
$ cd $LOG_HOME/appl/op
Run the Readiness Report after the enablement patch completes:
$ sqlplus system @$AD_TOP/sql/ADZDPSUM.sql
Note: You must provide the SYSTEM schema password when prompted.
$ mv adzdpsum.txt adzdpsum_post_dbprep.txt
$ sqlplus system @$AD_TOP/sql/ADZDPMAN.sql
$ mv adzdpman.txt adzdpman_post_dbprep.txt
$ sqlplus system @$AD_TOP/sql/ADZDPAUT.sql
$ mv adzdpaut.txt adzdpaut_post_dbprep.txt
The purpose of running this report at this stage is to ensure that all EBR violations that could have appeared before enabling the online patching feature are fixed.
5.25 Run the Online Patching Database Compliance Checker report to check for coding standards violations
There are two levels of compliance that can be targeted:
Minimal Compliance (Minimal) - These checks represent the minimum requirement for correct operation of Oracle E-Business Suite Release 12.2.
Warning: Do not attempt to operate the system if there are P1 minimal compliance violations. Custom code should pass the minimal compliance checks before being used in a Release 12.2 system.
Full Compliance (Full) - These checks indicate whether an object can be patched using Online Patching. Objects which do not meet full compliance may have limitations in how they can be patched, or may need to be patched using downtime patching. Full compliance also requires that all minimal compliance checks are passed. Custom code that will only be patched using downtime patching does not need to meet the full compliance level.
Set the current directory to $LOG_HOME/appl/op:
$ cd $LOG_HOME/appl/op
Run the Online Patching Database Compliance Checker report to check for online patching database objects standards violations:
sqlplus <Apps Username> @$AD_TOP/sql/ADZDDBCC.sql
This utility reports all violations to the Online Patching Development Standards. All Oracle E-Business Suite violations are fixed by the 12.2 upgrade. You must fix any object listed in this report that is part of your custom code. If you do not fix the violation, then you cannot leverage the online patching infrastructure to patch the objects listed in this report.
Note:
The 'recyclebin' parameter must be turned off to allow the cleanup phase of the online patching cycle to be performed without having to connect as SYS. This feature may still be used at other times.
For example:
ALTER SYSTEM SET recyclebin = OFF SCOPE = spfile;
If the _SYSTEM_TRIG_ENABLED parameter is set to false, then system triggers are not processed. The post Online Patching Enablement parameter must be set to true.
_SYSTEM_TRIG_ENABLED=true
alter system set "_system_trig_enabled"= TRUE SCOPE = both;
This completes our upgrade of EBS to R12.2.0. How to upgrade to the latest code level will be shared in another post.
Reference Note:
R12.2: How To Create the Stage In Preparation For Installation (Doc ID 1596433.1)
Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1)
Oracle E-Business Suite Release 12.2: Suite-Wide Rollup and AD/TXK Delta Information (Doc ID 1583092.1)
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
Using the Online Patching Readiness Report in Oracle E-Business Suite Release 12.2 (Doc ID 1531121.1)
https://docs.oracle.com/cd/E26401_01/doc.122/e73540/T660854T660862.htm#8360043
12.2 E-Business Suite DBA Upgrade Script ADZDEXRPT.sql Fails On Invalid Object 'AD_ZD_PREP' Or Patch 13543062 Fails With Error: ORA-06508: PL/SQL: could not find APPS.AD_ZD_PREPAD_ZD_PREP Due To Missing Package 'xdb_migrateschema' (Doc ID 2066607.1
No comments:
Post a Comment