Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
Step By Step Guide to Apply Oracle E-Business Suite R12.2 ADTXK Update 16
Oracle Applications DBA (AD) and Oracle E-Business Suite Technology Stack (TXK) Release Update Packs are periodic updates provided by Oracle to enhance and maintain the technology stack components of Oracle E-Business Suite (EBS). These packs include fixes, optimizations, and new features to ensure stability, performance, and compatibility with the latest Oracle technologies.
Key Components:
- AD (Applications DBA):
- Contains utilities, scripts, and tools for managing and maintaining Oracle EBS applications.
- Covers tasks like patching, cloning, and upgrading EBS environments.
- TXK (Technology Stack):
- Provides updates to the underlying technology stack of Oracle EBS, such as Oracle WebLogic Server, Oracle Fusion Middleware, and configuration files.
- Ensures compatibility with the latest EBS versions and database releases.
Purpose of Release Update Packs:
- Bug Fixes: Resolve known issues in AD and TXK components.
- Feature Enhancements: Introduce improvements and new functionality to streamline administration tasks.
- Compatibility Updates: Ensure integration with newer database versions (e.g., Oracle Database 19c) and middleware components.
- Security Updates: Address vulnerabilities and enhance security configurations.
Benefits of AD and TXK Update Packs:
- Improved system stability and performance.
- Support for newer hardware and software configurations.
- Enhanced automation for routine tasks like patching and cloning.
- Simplified compliance with Oracleโs recommended best practices.
Where to Download:
- AD and TXK Release Update Packs can be downloaded from My Oracle Support (MOS).
- Refer to the following documents for guidance:ย
-
- Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
- Oracle E-Business Suite Release 12.2: Consolidated List of Oracle Database Patches and Bug Fixes (Doc ID 1594274.1)
When to Apply:
- During routine maintenance to keep your environment up-to-date.
- Before upgrading your Oracle EBS or migrating to a new database version.
- To resolve specific issues or enhance system performance.
These updates are essential for maintaining a robust and secure Oracle EBS environment, ensuring seamless operations and compatibility with Oracleโs evolving technology stack.
Pre-Requisites of AD-TXK
(ETCC) EBS Technology Codelevel Checker
Use the Below given file to Download the latest ETCC Patch and Identifying and applying the required Database and Middleware Technology Patches
Link ๐Apply ETCC(OCT-2024) Patches
Check Database Parameter and adtxk code level
| [oracle@ebs12214 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 โ Production on Tue Nov 26 23:39:25 2024 Copyright (c) 1982, 2024, Oracle.ย All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 โ Production Version 19.25.0.0.0 SQL> show parameter _disable_actualization_for_grant NAMEย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย TYPEย VALUE SQL> select abbreviation, name, codelevel from ad_trackable_entities where abbreviation in( โadโ,โtxkโ,โatg_pfโ)ย order by abbreviation; ABBREVIATION ย NAMEย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย CODELEVEL |
Apply AD-TXK Patches
Prepare for Applying AD-TXK Patch
Source Apps Env and Run Prepare Phase
| [oracle@ebs12214 ~]$ . ./EBSapps.env run
E-Business Suite Environment Information DB Host: ebs12214.com Service/SID: PROD Sourcing the RUN File System โฆ [oracle@ebs12214 ~]$ adop phase=prepare Enter the APPS password: Validating credentials. Warning: WebLogic Admin Server is not running. Trying to start Admin Server. You are running adadminsrvctl.sh version 120.10.12020000.11 ================ Note: It will take timeย If fs_clone is not done in Previous Patching Cycle =================== The prepare phase completed successfully. adop exiting with status = 0 (Success) |
Unzip AD Patches 36119925 and 36303698
| [oracle@ebs12214 ~]$ cd /u01/Patches/AD_TXK [oracle@ebs12214 AD_TXK]$ unzip -qo p36119925_R12.AD.C_R12_LINUX.zip [oracle@ebs12214 AD_TXK]$ unzip -qo p36303698_R12.AD.C_R12_GENERIC.zip [oracle@ebs12214 AD_TXK]$ cd 36119925/ [oracle@ebs12214 admin]$ ls -ltrh adgrants.sql Copy adgrants.sql to Oracle DataBase Home appsutil/admin folder [oracle@ebs12214 ~]$ cd /u01/oracle/PROD/19.0.0/appsutil ==== (Database home Directory) [oracle@ebs12214 ~]$ cd /u01/Patches/AD_TXK/36119925/admin Copy unzipped patch 36119925, 36303698 to $PATCH_TOP [oracle@ebs12214 ~]$ cd /u01/Patches/AD_TXK |
Running ADgrants.sql
| Source Database Environment File and Then Run ADgrants.sql
[oracle@ebs12214 ~]$ . ./env_prodCDB.env SQL*Plus: Release 19.0.0.0.0 โ Production on Wed Nov 27 00:54:54 2024 Copyright (c) 1982, 2024, Oracle. All rights reserved. Connected to: Current user is SYS โโโโโโโโโโโโโโโโโ Completed granting and checking privileges Generating list of ERRORS and WARNINGS to print out CURRENT_USER Creating PL/SQL profiler objects. โโโโโโโโโโโโโโโโโ In 12.2c and beyond, the Oracle-supplied profload.sql script is a verification script, not an installation script. โโโโโโโโโโโโโโโโโโ โโโโโโโโโโโโโโโโโ โโโโโโโโโโโโโโโโโโ Installing Hierarchical Profiler. Begin creating the APPS_NE.ADGRANTS_VER_PKG package End creating the APPS_NE.ADGRANTS_VER_PKG package Executing PURGE DBA_RECYCLEBIN. The following ERRORS and WARNINGS have been encountered during this adgrants session: Grants given by this script have been written to the ad_zd_logs table. Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 โ Production |
Apply AD Patch 36119925 and 36303698
| [oracle@ebs12214 ~]$ . ./EBSapps.env run
E-Business Suite Environment Information DB Host: ebs12214.com Service/SID: PROD Sourcing the RUN File System โฆ [oracle@ebs12214 ~]$ adop phase=apply patches=36119925,36303698 merge=yes Enter the APPS password: Validating credentials. Initializing. Validating system setup. Checking for existing adop sessions. =========================================================================== Starting patch merge. Executing the merge of the patch drivers โ Processing patch: /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20241127_1732651731/src/36119925 Copying filesโฆ 5% complete. Copied 47 files of 937โฆ Character-set converting filesโฆ 2 unified drivers merged. Patch merge completed successfully Generating post apply reports. Generating log report. The apply phase completed successfully. adop exiting with status = 0 (Success) |
Unzip and Apply TXK Patch 36117775
| [oracle@ebs12214 ~]$ cd /u01/Patches/AD_TXK/ [oracle@ebs12214 AD_TXK]$ unzip -qo p36117775_R12.TXK.C_R12_GENERIC_1of3.zip [oracle@ebs12214 AD_TXK]$ unzip -qo p36117775_R12.TXK.C_R12_GENERIC_2of3.zip [oracle@ebs12214 AD_TXK]$ unzip -qo p36117775_R12.TXK.C_R12_GENERIC_3of3.zip [oracle@ebs12214 AD_TXK]$ cp -pR 36117775/ $PATCH_TOP Source Application Run Environment [oracle@ebs12214 AD_TXK]$ source /u01/oracle/PROD/EBSapps.env run E-Business Suite Environment Information DB Host: ebs12214.com Service/SID: PROD Sourcing the RUN File System โฆ Apply TXK Patch [oracle@ebs12214 AD_TXK]$ adop phase=apply patches=36117775 Enter the APPS password: Validating credentials. Initializing. Validating system setup. Checking for existing adop sessions. =========================================================================== Applying patch 36117775. Generating post apply reports. Generating log report. The apply phase completed successfully. adop exiting with status = 0 (Success) |
Complete Online Patching Cycle
| Source Apps ENV in new Terminal
[oracle@ebs12214 ~]$ . ./EBSapps.env run E-Business Suite Environment Information DB Host: ebs12214.com Service/SID: PROD Sourcing the RUN File System โฆ Run Finalize Phae [oracle@ebs12214 ~]$ adop phase=finalize Enter the APPS password: Validating credentials. Initializing. Validating system setup. Checking for existing adop sessions. =========================================================================== Verifying data dictionary. Running finalize phase database actions. Generating log report. The finalize phase completed successfully. adop exiting with status = 0 (Success) Run CutOver Phase [oracle@ebs12214 ~]$ adop phase=cutover Enter the APPS password: Validating credentials. Initializing. Validating system setup. Checking for existing adop sessions. =========================================================================== Validating configuration on node: [ebs12214]. Checking if finalize required. Submitting request for Internal Concurrent Manager shutdown. You are running adcmctl.sh version 120.19.12020000.7 Shutting down concurrent managers for PROD โฆ adcmctl.sh: exiting with status 0 Cancelling ADZDPATCH concurrent request Waiting for Internal Concurrent Manager to go down. The AdminServer is already shutdown Stopping patch edition Node Manager. You are running adnodemgrctl.sh version 120.11.12020000.12 The Node Manager is already shutdown adnodemgrctl.sh: check the logfile /u01/oracle/PROD/fs2/inst/apps/PROD_ebs12214/logs/appl/admin/log/adnodemgrctl.txt for more information โฆ Stopping the application tier services on current node. Stopping run edition Admin Server. Stopping run edition Node Manager. You are running adnodemgrctl.sh version 120.11.12020000.12 NodeManager log is located at /u01/oracle/PROD/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1 Running stored cutover DDLs. Loading JAR files into database. Performing database cutover. Statement handler reference is invalid. Session killed. Flipping snapshots in run and patch editions. Performing file system cutover. Checking if file system cutover completed. Broadcast message from oracle@ebs12214.com (somewhere) (Wed Nov 27 02:59:49 202 PROD environment has changed. Starting run edition Admin Server. Starting application tier services. Waiting for middle tier services to start on all available nodes. Generating post-cutover reports. Generating log report. Broadcast message from oracle@ebs12214.com (somewhere) (Wed Nov 27 03:10:01 202 PROD environment has changed. The cutover phase completed successfully. adop exiting with status = 0 (Success) |
Post AD-TXK Patch Configuration
Update Database Tier to Latest Autoconfig Code
Create theย appsutil.zip
Update all database tier nodes with the latest AutoConfig code, by performing the following steps on the application and database tiers
| Source Application Run Environment
[oracle@ebs12214 ~]$ source /u01/oracle/PROD/EBSapps.env run E-Business Suite Environment Information DB Host: ebs12214.com Service/SID: PROD Sourcing the RUN File System โฆ Run the admkappsutil.pl utility to create the appsutil.zip file in <INST_TOP>/admin/out. [oracle@ebs12214 ~]$ perl $AD_TOP/bin/admkappsutil.pl MakeAppsUtil completed successfully. |
Copy the appsutil.zip file to <RDBMS ORACLE_HOME> and Unzip
| Open New Terminal Source Database Environment
[oracle@ebs12214 ~]$ . ./env_PROD.env Take Backup of Current appsutil Directory [oracle@ebs12214 19.0.0]$ cp -pr appsutil appsutil_backup Copy appsutil.zip from Application Tier to Oracle Database Home (In our case, we have Application and Database on Same Machine) [oracle@ebs12214 19.0.0]$ cp /u01/oracle/PROD/fs2/inst/apps/PROD_ebs12214/admin/out/appsutil.zip /u01/oracle/PROD/19.0.0 Unzip appsutil.zip [oracle@ebs12214 19.0.0]$ unzip -o appsutil.zip Archive:ย appsutil.zip |
Autoconfig on DataBase and APPS Tier
|
Open New Terminal for Running Autoconfig on Database and Source DB Environment
[oracle@ebs12214 ~]$ source /u01/oracle/PROD/19.0.0/PROD_ebs12214.env
[oracle@ebs12214 ~]$ cd $ORACLE_HOME
[oracle@ebs12214 19.0.0]$ cd appsutil/scripts/PROD_ebs12214/
Run Autoconfig On DB
[oracle@ebs12214 PROD_ebs12214]$ ./adautocfg.shย
Enter the APPS user password:
The log file for this session is located at:
/u01/oracle/PROD/19.0.0/appsutil/log/PROD_ebs12214/11270323/adconfig.log
AutoConfig is configuring the Database environmentโฆ
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/oracle/PROD/19.0.0
Value of s_dbcset is US7ASCII
Character set is present in the allowed list. No need to add orai18n.jar to the CLASSPATH.
Value of s_dbcset is US7ASCII
Character set is present in the allowed list. No need to add orai18n.jar to the CLASSPATH.
Classpathย ย ย ย ย ย ย ย ย ย : :/u01/oracle/PROD/19.0.0/jdbc/lib/ojdbc8.jar:
/u01/oracle/PROD/19.0.0/appsutil/java/xmlparserv2.jar:
/u01/oracle/PROD/19.0.0/appsutil/java:/u01/oracle/PROD/19.0.0/jlib/netcfg.jar:
/u01/oracle/PROD/19.0.0/jlib/ldapjclnt19.jar
Using Context fileย ย ย ย ย : /u01/oracle/PROD/19.0.0/appsutil/PROD_ebs12214.xml
Context Value Management will now update the Context file
Updating Context fileโฆCOMPLETED
Attempting upload of Context file and templates to databaseโฆCOMPLETED
Updating rdbms version in Context file to db19
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME โฆ
AutoConfig completed successfully.
[oracle@ebs12214 PROD_ebs12214]$
Open New Terminal for Running Autoconfig on Application Tier
Source Application Environment file
[oracle@ebs12214 ~]$ source /u01/oracle/PROD/EBSapps.env run
ย E-Business Suite Environment Information
ย โโโโโโโโโโโโโ-
ย RUN File Systemย ย ย ย ย ย : /u01/oracle/PROD/fs2/EBSapps/appl
ย PATCH File Systemย ย ย ย ย : /u01/oracle/PROD/fs1/EBSapps/appl
ย Non-Editioned File System : /u01/oracle/PROD/fs_ne
ย DB Host: ebs12214.comย Service/SID: PROD
ย Sourcing the RUN File System โฆ
Run Autoconfig on AppsTier
[oracle@ebs12214 ~]$ cd $ADMIN_SCRIPTS_HOME
[oracle@ebs12214 scripts]$ ./adautocfg.shย
Enter the APPS user password:
The log file for this session is located at:
/u01/oracle/PROD/fs2/inst/apps/PROD_ebs12214/admin/log/11270325/adconfig.log
wlsDomainName: EBS_domain
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/fs2/inst/apps/PROD_ebs12214
Classpathย ย ย ย ย ย ย ย ย ย : /u01/oracle/PROD/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/oracle/PROD/fs2/EBSapps/comn/java/classes
Using Context fileย ย ย ย ย : /u01/oracle/PROD/fs2/inst/apps/PROD_ebs12214/appl/admin/PROD_ebs12214.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@ebs12214 scripts]$
|
Synchronize the File Systems
-
This action copies the new run edition code and configuration to the other file system.
-
After you apply AD-TXK Delta 16, you should run fs_clone to synchronize the run and patch file systems with the configuration changes that the new codelevel introduces.
-
If you do not runย fs_clone, it will run automatically in the next prepare phase, which will consequently take more time.
|
Open New Terminal for Running fs_clone
Source Application Environment file
[oracle@ebs12214 ~]$ source /u01/oracle/PROD/EBSapps.env run
ย E-Business Suite Environment Information
ย โโโโโโโโโโโโโ-
ย RUN File Systemย ย ย ย ย ย : /u01/oracle/PROD/fs2/EBSapps/appl
ย PATCH File Systemย ย ย ย ย : /u01/oracle/PROD/fs1/EBSapps/appl
ย Non-Editioned File System : /u01/oracle/PROD/fs_ne
ย DB Host: ebs12214.comย Service/SID: PROD
ย Sourcing the RUN File System โฆ
[oracle@ebs12214 ~]$ cd $ADMIN_SCRIPTS_HOME
[oracle@ebs12214 scripts]$ adop phase=fs_clone
Enter the APPS password:
Enter the EBS_SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Validating credentials.
Warning: WebLogic Admin Server is not running.
Trying to start Admin Server.
You are running adadminsrvctl.sh version 120.10.12020000.11
Starting WLS Admin Serverโฆ
Refer /u01/oracle/PROD/fs2/inst/apps/PROD_ebs12214/logs/appl/admin/log/adadminsrvctl.txt for details
AdminServer logs are located at
/u01/oracle/PROD/fs2/FMW_Home/user_projects/domains/EBS_domain/servers/AdminServer/logs
adadminsrvctl.sh: exiting with status 0
adadminsrvctl.sh: check the logfile
/u01/oracle/PROD/fs2/inst/apps/PROD_ebs12214/logs/appl/admin/log/adadminsrvctl.txt for more information โฆย ย
Initializing.
ย ย Run Edition contextย : /u01/oracle/PROD/fs2/inst/apps/PROD_ebs12214/appl/admin/PROD_ebs12214.xml
ย ย Patch edition context: /u01/oracle/PROD/fs1/inst/apps/PROD_ebs12214/appl/admin/PROD_ebs12214.xml
ย ย Patch file system free space: 137.18 GB
Validating system setup.
ย ย Node registry is valid.
Checking for existing adop sessions.
ย ย No pending session exists.
ย ย Starting new adop session.
===========================================================================
ADOP (C.Delta.16)
Session ID: 8
Node: ebs12214
Phase: fs_clone
Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/8/20241127_033418/adop.log
===========================================================================
Validating configuration on node: [ebs12214].
ย ย Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/8/20241127_033418/fs_clone/validate/ebs12214
[WARNING]: There could be issues while validating the ports used for E-Business Suite instance against ports
used in /etc/services. Refer the log file for more details.
Checking for pending cleanup actions.
ย ย Running cleanup as it was not run in previous patching cycle.
Processing cleanup actions in parallel.
ย ย Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/8/20241127_033418/fs_clone/ebs12214/log/cleanup.log
Generating report of queued DDL actions.
ย ย Output: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/8/20241127_033418/fs_clone/ebs12214/adzdallddls.out
Running cleanup in STANDARD mode.
ย ย Log: @ADZDSHOWLOG.sql โ2024/11/27 03:39:50โ
ย ย [ERROR]ย ย ย [CLEANUP 1:1 ddl_id=26909] ORA-01432: public synonym to be dropped does not exist SQL:
drop public synonym WF_ALL_JOBS force
Blocking managed server ports.
ย ย Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/8/20241127_033418/fs_clone/ebs12214/txkCloneAcquirePort.log
Performing CLONE steps.
ย ย Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/8/20241127_033418/fs_clone/ebs12214
Beginning application tier FSCloneStage โ Wed Nov 27 03:41:07 2024
/u01/oracle/PROD/fs2/EBSapps/comn/util/jdk32/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false
-Doracle.jdbc.DateZeroTime=true -Doracle.jdbc.DateZeroTimeExtra=true -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath
/u01/oracle/PROD/fs2/FMW_Home/webtier/lib/xmlparserv2.jar:/u01/oracle/PROD/fs2/FMW_Home/oracle_common/modules/
oracle.jdbc_11.1.1/ojdbc6dms.jar:/u01/oracle/PROD/fs2/FMW_Home/oracle_common/modules/oracle.odl_11.1.1/ojdl.jar:
/u01/oracle/PROD/fs2/FMW_Home/oracle_common/modules/oracle.dms_11.1.1/dms.jar::/u01/oracle/PROD/fs2/EBSapps/comn/java/classes:
/u01/oracle/PROD/fs2/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/u01/oracle/PROD/fs2/FMW_Home/webtier/oui/jlib/ewt3.jar:/
u01/oracle/PROD/fs2/FMW_Home/webtier/oui/jlib/share.jar:/u01/oracle/PROD/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:
/u01/oracle/PROD/fs2/FMW_Home/webtier/jlib/ojmisc.jar:/u01/oracle/PROD/fs2/FMW_Home/
wlserver_10.3/server/lib/weblogic.jar:/u01/oracle/PROD/fs2/FMW_Home/oracle_common/jlib/obfuscatepassword.jarย
oracle.apps.ad.clone.FSCloneStageAppsTier -e /u01/oracle/PROD/fs2/inst/apps/PROD_ebs12214/appl/admin/PROD_ebs12214.xml -targ
/u01/oracle/PROD/fs1/inst/apps/PROD_ebs12214/appl/admin/PROD_ebs12214.xml -stage /u01/oracle/PROD/fs2/EBSapps/comn/adopclone_ebs12214
-tmp /tmp -component appsTier -nopromptmsgย
Log file located at /u01/oracle/PROD/fs2/inst/apps/PROD_ebs12214/admin/log/clone/FSCloneStageAppsTier_11270341.log
Completed FSCloneStageโฆ
Wed Nov 27 03:57:34 2024
Beginning application tier FSCloneApply โ Wed Nov 27 04:02:13 2024
/u01/oracle/PROD/fs2/EBSapps/comn/adopclone_ebs12214/FMW/t2pjdk/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false
-Doracle.jdbc.DateZeroTime=true -Doracle.jdbc.DateZeroTimeExtra=true -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath
/u01/oracle/PROD/fs2/EBSapps/comn/adopclone_ebs12214/jlib/xmlparserv2.jar:/u01/oracle/PROD/fs2/FMW_Home/oracle_common/modules/
oracle.jdbc_11.1.1/ojdbc6dms.jar:/u01/oracle/PROD/fs2/FMW_Home/oracle_common/modules/oracle.odl_11.1.1/ojdl.jar:
/u01/oracle/PROD/fs2/FMW_Home/oracle_common/modules/oracle.dms_11.1.1/dms.jar::
u01/oracle/PROD/fs2/EBSapps/comn/adopclone_ebs12214/jlib/java:
/u01/oracle/PROD/fs2/EBSapps/comn/adopclone_ebs12214/jlib/oui/OraInstaller.jar:/u01/oracle/PROD/fs2/EBSapps/comn
/adopclone_ebs12214/jlib/oui/ewt3.jar:/u01/oracle/PROD/fs2/EBSapps/comn/adopclone_ebs12214/jlib/oui/share.jar:
/u01/oracle/PROD/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/oracle/PROD/fs2/EBSapps/comn/adopclone_ebs12214/jlib/ojmisc.jar:/u01/oracle/PROD/fs2/FMW_Home/
wlserver_10.3/server/lib/weblogic.jar:/u01/oracle/PROD/fs2/EBSapps/comn/adopclone_ebs12214/jlib/obfuscatepassword.jarย
oracle.apps.ad.clone.FSCloneApplyAppsTier -e /u01/oracle/PROD/fs2/inst/apps/PROD_ebs12214/appl/admin/PROD_ebs12214.xml -targ
/u01/oracle/PROD/fs1/inst/apps/PROD_ebs12214/appl/admin/PROD_ebs12214.xml -stage /u01/oracle/PROD/fs2/EBSapps/comn/adopclone_ebs12214 -tmp /u01/oracle/PROD/fs2/inst/apps/PROD_ebs12214/appltmp -nodbac -component appsTier -nopromptmsgย
Log file located at /u01/oracle/PROD/fs2/inst/apps/PROD_ebs12214/admin/log/clone/FSCloneApplyAppsTier_11270402.log
Log file located at /u01/oracle/PROD/fs2/inst/apps/PROD_ebs12214/admin/log/clone/FSCloneApplyAppsTier_11270402.log
Target System Fusion Middleware Home set to /u01/oracle/PROD/fs1/FMW_Home
Target System Web Oracle Home set to /u01/oracle/PROD/fs1/FMW_Home/webtier
Target System Appl TOP set to /u01/oracle/PROD/fs1/EBSapps/appl
Target System COMMON TOP set to /u01/oracle/PROD/fs1/EBSapps/comn
Target System Instance Top set to /u01/oracle/PROD/fs1/inst/apps/PROD_ebs12214
Report file located at /u01/oracle/PROD/fs1/inst/apps/PROD_ebs12214/temp/portpool.lst
The new APPL_TOP context file has been created :
ย /u01/oracle/PROD/fs1/inst/apps/PROD_ebs12214/appl/admin/PROD_ebs12214.xml
contextfile=/u01/oracle/PROD/fs1/inst/apps/PROD_ebs12214/appl/admin/PROD_ebs12214.xml
Completed FSCloneApplyโฆ
Wed Nov 27 04:55:42 2024
Resetting FARM nameโฆ
runDomainName: EBS_domain
patchDomainName: EBS_domain
targets_xml_loc: /u01/oracle/PROD/fs1/FMW_Home/user_projects/domains/EBS_domain/sysman/state/targets.xml
Patch domain is not updated, no need to reset FARM name.
Releasing managed server ports.
ย ย Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/8/20241127_033418/fs_clone/ebs12214/txkCloneAcquirePort.log
Synchronizing snapshots.
Stopping services on patch file system.
ย ย Stopping admin server.
You are running adadminsrvctl.sh version 120.10.12020000.11
Stopping WLS Admin Serverโฆ
Refer /u01/oracle/PROD/fs1/inst/apps/PROD_ebs12214/logs/appl/admin/log/adadminsrvctl.txt for details
AdminServer logs are located at /u01/oracle/PROD/fs1/FMW_Home/user_projects/domains/EBS_domain/servers/AdminServer/logs
adadminsrvctl.sh: exiting with status 0
adadminsrvctl.sh: check the logfile /u01/oracle/PROD/fs1/inst/apps/PROD_ebs12214/logs/appl/admin/log/adadminsrvctl.txt for more information โฆย ย
ย ย Stopping node manager.
You are running adnodemgrctl.sh version 120.11.12020000.12
The Node Manager is already shutdown
NodeManager log is located at /u01/oracle/PROD/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1
adnodemgrctl.sh: exiting with status 2
adnodemgrctl.sh: check the logfile /u01/oracle/PROD/fs1/inst/apps/PROD_ebs12214/logs/appl/admin/log/adnodemgrctl.txt for more information โฆย ย
Generating log report.
ย ย Output: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/8/20241127_033418/fs_clone/ebs12214/adzdshowlog.out
The fs_clone phase completed successfully.
adop exiting with status = 0 (Success)
[oracle@ebs12214 scripts]$
|
Online Patching DB Compliance Checker
Run the Online Patching Database Compliance Checker report to check for online patching database objects standards violations:
| [oracle@ebs12214 scripts]$ sqlplus apps/apps
SQL*Plus: Release 10.1.0.5.0 โ Production on Wed Nov 27 05:02:14 2024 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: SQL> @$AD_TOP/sql/ADZDDBCC.sql |
This utility reports any violations of the Online Patching Development Standards. All Oracle E-Business Suite violations are fixed by the Release 12.2 upgrade.ย You must fix any object listed in this report that is part of your custom code.
Verify AD TXK Version Applied
SQL> select abbreviation, name, codelevel from ad_trackable_entities where abbreviation in( โadโ,โtxkโ,โatg_pfโ)ย order by abbreviation;
ABBREVIATIONย ย ย ย ย NAMEย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย CODELEVEL
โโโโ- ย ย โโโโโโโโโโโโโโ โโโ-
adย ย ย ย ย ย ย ย ย ย ย Applications DBAย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย C.16
atg_pfย ย ย ย ย Oracle Applications Technology Familyย ย ย ย C.11
txk ย ย ย ย ย ย ย ย ย ย Oracle Applications Technology Stackย ย ย ย C.16
Hope you found this document informative and gained valuable insights.
One comment
Pingback: Step By Step Upgrading Oracle EBS to R12.2.14 - Oracle Solutions