Hi in this blog we go through upgrading EBS R12.2 from Version 12.2.9 to 12.2.10
Follow the below MOS ID
Oracle E-Business Suite Release 12.2.10 Readme (Doc ID 2666934.1)
Certification Check:
OS Check before Prepare:
root@ebsprodapp3:~# cat /etc/release
Oracle Solaris 11.4 SPARC
Copyright (c) 1983, 2020, Oracle and/or its affiliates. All rights reserved.
Assembled 26 March 2020
root@ebsprodapp3:~#root@ebsprodapp3:~# uname -a
Note: This zip does not include Release Updates,
Bundle Patches or Patch Set Updates.
SunOS ebsprodapp3 5.11 11.4.20.4.0 sun4v sparc sun4v
root@ebsprodapp3:~#
root@ebsprodapp3:~# prtconf
System Configuration: Oracle Corporation sun4v
Memory size: 391680 Megabytes
System Peripherals (Software Nodes):
prtconf: devinfo facility not available
root@ebsprodapp3:~#
root@ebsprodapp3:~# pkg info entire
Name: entire
Summary: entire incorporation including Support Repository Update
(Oracle Solaris 11.4.20.4.0).
Description: This package constrains system package versions to the same
build. WARNING: Proper system update and correct package
selection depend on the presence of this incorporation.
Removing this package will result in an unsupported system.
For more information see:
https://support.oracle.com/rs?type=doc&id=2433412.1
Category: Meta Packages/Incorporations
State: Installed
Publisher: solaris
Version: 11.4 (Oracle Solaris 11.4.20.4.0)
Branch: 11.4.20.0.1.4.0
Packaging Date: Thu Mar 26 17:29:32 2020
Last Install Time: Wed Oct 14 20:51:30 2020
Size: 2.52 kB
FMRI: pkg://solaris/entire@11.4-11.4.20.0.1.4.0:20200326T172932Z
root@ebsprodapp3:~#
Section 1: Prepare:
apploci@ebsprodapp3:~$ export
ORACLE_HOME=$FMW_HOME/webtier
apploci@ebsprodapp3:~$ $ORACLE_HOME/OPatch/opatch
lsinventory | grep WebTier
Oracle WebTier and Utilities CD 11.1.1.9.0
apploci@ebsprodapp3:~$
apploci@ebsprodapp3:~$ echo
$APPS_VERSION
12.2.9
apploci@ebsprodapp3:~$
SQL> SELECT
RELEASE_NAME FROM FND_PRODUCT_GROUPS;
RELEASE_NAME
--------------------------------------------------
12.2.9
SQL>
as
per 30399999 Readme minimum AD/TXK required is 12 :
SQL>
col ABBREVIATION for a16;
col CODELEVEL for a9;
select
ABBREVIATION,CODELEVEL from ad_trackable_entities where abbreviation
in('ad','txk','atg_pf','fnd','fwk','au','gl','per','xdo','cc_pf');ABBREVIATION CODELEVEL
---------------- ---------
fwk C.8
atg_pf C.8
fnd C.8
ad
C.12
au 2.9
cc_pf C.9
xdo C.8
per C.13
txk
C.12
gl C.9
10 rows selected.
SQL>
################################################################################################################
################################################################################################################
Section 2: Obsolete Products in Release 12.2.10:
No
Activity in Section 2
Section 3: Upgrade Database to 11.2.0.4 or higher:
No Activity in Section 3 as database is already on 12.1.0.2
################################################################################################################
################################################################################################################
Section 4: Apply Required Database Patches and Update Database Initialization Parameters:
4.1 Apply Required Database Patches
Before you apply the AD and TXK Delta 12 release update packs (RUPs), you must run the latest version (available via Patch 17537119) of the EBS Technology Codelevel Checker (ETCC). Use the command checkDBpatch.sh (on UNIX) or checkDBpatch.cmd (on Windows).
Run
latest ETCC checkMTpatch.sh on Database Node:
oraoci@ahcsc1zdbclient010102:~/ETCC$ checkDBpatch.sh
Identified RDBMS DST version 18.
Checking Bugfix XML file for 12.1.0.2_BP
Obtained list of bugfixes to be applied and the list to be rolled back.
Now checking Database ORACLE_HOME.
The opatch utility is version 12.2.0.1.24.
DB-ETCC is compatible with this opatch version.
Found patch records in the inventory.
Checking Mapping XML file for 12.1.0.2.210119ProactiveBP
Patch mapping data is not available for 12.1.0.2.210119ProactiveBP
Refer to Doc ID 1594274.1 for the recommended Bundle Patch versions.
Some required one-off bugfixes are missing from the Database ORACLE_HOME.
The missing bugfixes are:
17777718
26436717
32355765
33114885
** Refer to MOS Doc ID "1392527.1:Database Patches Required by Oracle E-Business Suite on Oracle Engineered Systems: Exadata Database Machines and SuperClusters" to find the recommended combination of patches.
**
Apply the missing bugfixes and then rerun the script.
+-----------------------------------------------------------------------------+
A
consolidated zip file with the required patches for Database release
12.1.0.2.210119
ProactiveBP is available on My Oracle Support via:
Patch 33186784
- EBS RELEASE 12.2 CONSOLIDATED DATABASE
FIXES FOR OCT 2021
+-----------------------------------------------------------------------------+
Stored Technology Codelevel Checker results in the database PROD successfully.
Finished checking fixes for Oracle Database: Wed Nov 17 09:07:06 +03 2021
Log file for this session: /export/home/oraoci/ETCC/log/checkDBpatch_178.log
===============================================================================
oraoci@ahcsc1zdbclient010102:~/ETCC$
Run
latest ETCC checkMTpatch.sh on APPS Node:
apploci@ebsprodapp3:/u01/AD_TXK_13$ checkMTpatch.sh
+===============================================================+
| Copyright (c) 2005, 2020 Oracle and/or its affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release 12.2 |
| Application Tier Technology Codelevel Checker |
+===============================================================+
Using context file from currently set applications environment:
/u01/PRODAPPS/fs1/inst/apps/PROD_ebsprodapp3/appl/admin/PROD_ebsprodapp3.xml
Starting Application Tier Technology Codelevel Checker
Version: 120.0.12020000.51.
Wed Nov 17 09:41:16 +03 2021
Log file for this session: /u01/AD_TXK_13/log/checkMTpatch_1004.log
Bugfix XML file version: 120.0.12020000.53
This file will be used for identifying missing bugfixes.
Mapping XML file version: 120.0.12020000.39
This file will be used for mapping bugfixes to patches.
Checking for prerequisite bugfixes in File Edition: run
Enter the password for the APPS user:
Connecting to database.
Database connection successful.
The installed AD.C.12 codelevel supports storing the results in the database.
Checking for ETCC results table.
Table to store results already exists in database.
===============================================================================
Oracle Forms and Reports
===============================================================================
Now examining product Oracle Forms and Reports.
Oracle Home = /u01/PRODAPPS/fs1/EBSapps/10.1.2.
Product version = 10.1.2.3.0.
Checking required bugfixes for Oracle Forms and Reports 10.1.2.3.0.
All required bugfixes are present for Oracle Forms and Reports.
These results have been stored in the database.
Checking required bugfixes for RSF within Forms 10.1.0.5.0.
All required bugfixes are present for RSF within Forms.
These results have been stored in the database.
===============================================================================
Oracle Fusion Middleware (FMW) - Web Tier
===============================================================================
Now examining product Oracle Fusion Middleware (FMW) - Web Tier.
Oracle Home = /u01/PRODAPPS/fs1/FMW_Home/webtier.
Product Version = 11.1.1.9.0
Checking required bugfixes for FMW - Web Tier 11.1.1.9.0.
Missing Bugfix: 31909295 -> Patch 32287205
Missing Bugfix: 31748000 -> Patch 32287205
Missing Bugfix: 31696577 -> Patch 32287205
Missing Bugfix: 27072923 -> Patch 32287205
Missing Bugfix: 31169366 -> Patch 32287205
Missing Bugfix: 17428816 -> Patch 32287205
Missing Bugfix: 31658943 -> Patch 32287205
Missing Bugfix: 32294066 -> Patch 33311587
Missing Bugfix: 32593782 -> Patch 33311587
Missing Bugfix: 31586302 -> Patch 33311587
Missing Bugfix: 29857440 -> Patch 33311587
Missing Bugfix: 32928416 -> Patch 32928416
Missing Bugfix: 32949290 -> Patch 33144848
The above list shows missing bugfixes for FMW - Web Tier.
These results have been stored in the database.
Checking required bugfixes for RSF within FMW Web tier 11.1.0.7.0.
All required bugfixes are present for RSF within FMW Web tier.
These results have been stored in the database.
===============================================================================
Oracle Fusion Middleware (FMW) - oracle_common
===============================================================================
Now examining product Oracle Fusion Middleware (FMW) - oracle_common.
Oracle Home = /u01/PRODAPPS/fs1/FMW_Home/oracle_common.
Product Version = 11.1.1.9.0
Checking required bugfixes for FMW - oracle common 11.1.1.9.0.
Missing Bugfix: 26933408 -> Patch 26933408
The above list shows missing bugfixes for FMW - oracle common.
These results have been stored in the database.
===============================================================================
Oracle WebLogic Server (WLS)
===============================================================================
Now examining product Oracle WebLogic Server (WLS).
Oracle Home = /u01/PRODAPPS/fs1/FMW_Home/wlserver_10.3.
Product Version = 10.3.6.0.210119
Note that for Oracle WebLogic Server, patches rather than bugfixes are verified.
Checking required patches for Oracle WebLogic Server (WLS) 10.3.6.0.210119.
Missing Patch ID: 31241365
The above list shows missing patches for Oracle WebLogic Server.
If you have applied other Oracle WebLogic Server patches, they may have included the bugfixes needed.
Contact Oracle Support if you require assistance in determining whether this is the case.
These results have been stored in the database.
===============================================================================
Generating Patch Recommendation Summary.
===============================================================================
PATCH RECOMMENDATION SUMMARY
===============================================================================
One or more products have bugfixes missing.
The default patch recommendations to install these missing bugfixes are:
-------------------------------------------------------------------------------
Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0
-------------------------------------------------------------------------------
Patch 32287205 [IMPORTANT: Follow Note 2555355.1 before applying.]
- Filename: p32287205_111190_SOLARIS64.zip
Patch 33311587
- Filename: p33311587_111190_SOLARIS64.zip
Patch 32928416
- Filename: p32928416_111190_SOLARIS64.zip
Patch 33144848
- Filename: p33144848_111190_SOLARIS64.zip
-------------------------------------------------------------------------------
Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0
-------------------------------------------------------------------------------
Patch 26933408
- Filename: p26933408_111190_Generic.zip
-------------------------------------------------------------------------------
Oracle WebLogic Server (WLS) 10.3.6.0.210119
-------------------------------------------------------------------------------
Patch 31241365 [SU Patch [KKLY]]
- Filename: p31241365_1036_SOLARIS64.zip
Apply the required patches and rerun this script.
+-----------------------------------------------------------------------------+
A
consolidated zip file with the required application tier patches is
available on My Oracle Support via: Patch
33186821
- EBS
RELEASE 12.2 CONSOLIDATED FMW FIXES FOR OCT 2021
+-----------------------------------------------------------------------------+
See Doc ID 1594274.1 for any special instructions regarding these patches.
Footnotes in Doc ID 1594274.1 also apply to corresponding overlay patches.
Finished checking prerequisite patches for File Edition: run.
Wed Nov 17 09:42:15 +03 2021
Log file for this session: /u01/AD_TXK_13/log/checkMTpatch_1004.log
===============================================================================
apploci@ebsprodapp3:/u01/AD_TXK_13$
##################################################
##################################################
4.2 Set Database Parameter (Conditional)
1. Optimizer Adaptive Optimization
SQL> show
parameter optimizer_adaptive_features
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
optimizer_adaptive_features boolean FALSE
SQL>
SQL> show
parameter _disable_actualization_for_grant
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_disable_actualization_for_grant boolean TRUE
SQL>
################################################################################################################
################################################################################################################
Section 5: Apply Consolidated Seed Table Upgrade Patch (Required):
Step No. 1:
apploci@ebsprodapp3:$ adstpall.sh
apps/apps123
Step No. 2:
apploci@ebsprodapp3:$ adadminsrvctl.sh
start
You are running adadminsrvctl.sh version 120.10.12020000.11
Enter the WebLogic Admin password:
Enter the APPS Schema password:
Starting WLS Admin Server...
Refer /u01/PRODAPPS/fs2/inst/apps/PROD_ebsprodapp3/logs/appl/admin/log/adadminsrvctl.txt for details
AdminServer logs are located at /u01/PRODAPPS/fs2/FMW_Home/user_projects/domains/EBS_domain/servers/AdminServer/logs
adadminsrvctl.sh: exiting with status 0
adadminsrvctl.sh: check the logfile /u01/PRODAPPS/fs2/inst/apps/PROD_ebsprodapp3/logs/appl/admin/log/adadminsrvctl.txt for more information ...
apploci@ebsprodapp3:/u01/12.2.10/31856773$
apploci@ebsprodapp3:/u01/12.2.10/31856773$
BeforeApply enable flashback at database and make application backup:
adop
worker log file location:
apploci@ebsprodapp3:~$ find
$ADOP_LOG_HOME/28 -iname adwork*.log
We
were supposed to skip CUPS-12 patch later decided to apply it:
Apply
patch in screen session to avoid network disconnect.
Step No. 3:
patch 31856773 ORACLE E-BUSINESS SUITE CONSOLIDATED UPGRADE PATCH 12 (CUP12) FOR R12.2.0
apploci@ebsprodapp3:/u01/12.2.10/31856773$ adop
phase=apply patches=31856773 hotpatch=yes patchtop=/u01/12.2.10 (approx. 2 Hrs on testm7) (before gather sys stats on db if patching is taking too much time)
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /u01/PRODAPPS/fs2/inst/apps/PROD_ebsprodapp3/appl/admin/PROD_ebsprodapp3.xml
Patch edition context: /u01/PRODAPPS/fs1/inst/apps/PROD_ebsprodapp3/appl/admin/PROD_ebsprodapp3.xml
Step No. 4:
apploci@ebsprodapp3:~$ adstrtal.sh
apps/apps123
################################################################################################################
################################################################################################################
Section 8: Apply Oracle E-Business Suite 12.2.10 Release Update Pack:
8.2 Path B — Existing Customers (Release 12.2.3, 12.2.4, 12.2.5, 12.2.6, 12.2.7, 12.2.8 or 12.2.9) upgrading to Oracle E-Business Suite 12.2.10 Release Update Pack
- as per 12.2.10 patch 30399999 Readme minimum AD/TXK required is 12
- Oracle E-Business Suite 12.2.10 Release Update Pack Patch 30399999 or higher requires a minimum Oracle WebLogic Server PSU version of 10.3.6.0.190416 Patch 29204678.:
Enable flashback and create restore point for any disaster recovery
Always run adop session on screen to avoid network disconnection:
SQL> alter
database FLASHBACK on;
Database altered.
SQL> select
name,open_mode,LOG_MODE,FLASHBACK_ON,FORCE_LOGGING from v$database;
NAME OPEN_MODE LOG_MODE FLASHBACK_ON FORCE_LOGGING
--------- -------------------- ------------ ------------------ ---------------------------------------
PROD READ WRITE ARCHIVELOG YES YES
SQL>
SQL>
SQL>
SQL>
SQL> alter
system switch logfile;
System altered.
SQL> /
System altered.
SQL> select
* from v$restore_point;
no rows selected
SQL> select
CURRENT_SCN from v$database;
SQL>
SQL> create
restore point before_12210 guarantee flashback database;
Restore point created.
SQL> select
* from v$restore_point;
SCN DATABASE_INCARNATION# GUA STORAGE_SIZE TIME
---------- --------------------- --- ------------ ---------------------------------------------------------------------------
RESTORE_POINT_TIME PRE
--------------------------------------------------------------------------- ---
NAME CON_ID
-------------------------------------------------------------------------------------------------------------------------------- ----------
4.3188E+10 3 YES 524288000 04-DEC-21 01.57.07.000000000 PM
YES
BEFORE_12210 0
SQL>
SQL>
root@ebsprodapp3:~# screen
root@ebsprodapp3:~# screen
-ls
There is a screen on:
11940.pts-2.ebsprodapp3 (Attached)
1 Socket in /root/.screen.
root@ebsprodapp3:~# screen
-d -r 11940.pts-2.ebsprodapp3
root@ebsprodapp3:~# su
– apploci
Step No. 2:
apploci@ebsprodapp3:~$ adop
phase=prepare (approx. 30 Mins on testm7)
. . . . .
. . . . .
AutoConfig completed successfully.
Synchronizing patch filesystem with run filesystem.
Log: /u01/PRODAPPS/fs_ne/EBSapps/log/adop/29/20211204_135906/prepare/ebsprodapp3
========================================
SUMMARY OF PATCHES BEING SYNCHRONIZED...
========================================
[1] SINGLE PATCH (DRV=u31856773.drv): 31856773
SYNCHRONIZATION is in progress. This may take a little longer depending on the number and size of patches that are being synchronized.
Check log file /u01/PRODAPPS/fs_ne/EBSapps/log/adop/29/20211204_135906/prepare/ebsprodapp3/TXK_SYNC_update/txkADOPPreparePhaseSynchronize.log for details.
LOGPATH is set to /u01/PRODAPPS/fs_ne/EBSapps/log/adop/29/20211204_135906/prepare/ebsprodapp3/TXK_SYNC_update/log
Log: /u01/PRODAPPS/fs_ne/EBSapps/log/adop/29/20211204_135906/prepare/ebsprodapp3
Synchronizing snapshots.
Step No. 5:
unzip p30399999_R12_SOLARIS64_1of11.zip
unzip p30399999_R12_SOLARIS64_2of11.zip
unzip p30399999_R12_SOLARIS64_3of11.zip
unzip p30399999_R12_SOLARIS64_4of11.zip
unzip p30399999_R12_SOLARIS64_5of11.zip
unzip p30399999_R12_SOLARIS64_6of11.zip
unzip p30399999_R12_SOLARIS64_7of11.zip
unzip p30399999_R12_SOLARIS64_8of11.zip
unzip p30399999_R12_SOLARIS64_9of11.zip
unzip p30399999_R12_SOLARIS64_10of11.zip
unzip p30399999_R12_SOLARIS64_11of11.zip
pwdapploci@ebsprodapp3:~$ chown apploci:applmgr /u01/12.2.10/30399999
as
per 30399999 Readme minimum AD/TXK required is 12
Note: ebs-upgrade patch includes compiling ojsp which it self requires around 30 mins
grep MISSING_TRANSLATED_VERSION $APPL_TOP/admin/${TWO_TASK}/adalldefaults.txt
apploci@ebsprodapp3:~$ adop
phase=apply patches=30399999 patchtop=/u01/12.2.10 (approx. 6 Hrs on TEST M7)
apploci@ebsprodapp3:~$ find $ADOP_LOG_HOME/29 -iname u*.log
apploci@ebsprodapp3:~$ find $ADOP_LOG_HOME/29 -iname u*.lgi ----> approx (30+ Mins keeps on copying files)
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /u01/PRODAPPS/fs2/inst/apps/PROD_ebsprodapp3/appl/admin/PROD_ebsprodapp3.xml
Patch edition context: /u01/PRODAPPS/fs1/inst/apps/PROD_ebsprodapp3/appl/admin/PROD_ebsprodapp3.xml
Patch file system free space: 291.74 GB
Validating system setup.
Node registry is valid.
Checking for existing adop sessions.
Continuing with existing session [Session ID: 29].
===========================================================================
ADOP (C.Delta.12)
Session ID: 29
Node: ebsprodapp3
Phase: apply
Log: /u01/PRODAPPS/fs_ne/EBSapps/log/adop/29/20211204_143026/adop.log
===========================================================================
Applying patch 30399999.
Log: /u01/PRODAPPS/fs_ne/EBSapps/log/adop/29/20211204_143026/apply/ebsprodapp3/30399999/log/u30399999.log
/u01/PRODAPPS/fs_ne/EBSapps/log/adop/29/20211204_143026/apply/ebsprodapp3/30399999/log/u30399999.log
Generating post apply reports.
Generating log report.
Output: /u01/PRODAPPS/fs_ne/EBSapps/log/adop/29/20211204_143026/apply/ebsprodapp3/adzdshowlog.out
The apply phase completed successfully.
adop exiting with status = 0 (Success)
apploci@ebsprodapp3:~$
apploci@ebsprodapp3:~$ adop
phase=finalize,cutover,cleanup (approx. 2 Hrs on TEST M7)
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
apploci@ebsprodapp3:~$
apploci@ebsprodapp3:~$ . /u01/PRODAPPS/EBSapps.env
run
Verification
Steps after Upgrade:
apploci@ebsprodapp3:~$
SQL> SELECT
RELEASE_NAME FROM FND_PRODUCT_GROUPS;
RELEASE_NAME
--------------------------------------------------
12.2.10
SQL>
SQL>
col ABBREVIATION for a16;
col CODELEVEL for a9;
select ABBREVIATION,CODELEVEL from ad_trackable_entities where abbreviation in('ad','txk','atg_pf','fnd','fwk','au','gl','per','xdo','cc_pf','hr_pf');|
EBS 12.2.9
|
EBS 12.2.10
|
|
ABBREVIATION CODELEVEL
---------------- ---------
fwk C.8 atg_pf C.8 fnd C.8 ad C.12 au 2.9 cc_pf C.9 xdo C.8 per C.13 txk C.12 gl C.9 hr_pf C.13 |
ABBREVIATION CODELEVEL ---------------- --------- fwk C.9 atg_pf C.9 fnd C.9 ad C.12 au 2.10 cc_pf C.10 xdo C.9 per C.14 txk C.12 gl C.10 hr_pf C.14 |
SQL> SELECT
NUMBER_OF_FILES FROM v$recovery_area_usage where FILE_TYPE='FLASHBACK LOG';
NUMBER_OF_FILES
---------------
89
SQL>
apploci@ebsprodapp3:~$ echo
$APPS_VERSION
12.2.9
apploci@ebsprodapp3:~$
Run
autoconfig on db & apps to generate new env then source new env again:
oraoci@ahcsc1zdbclient010102:~$ cd
$ORACLE_HOME/appsutil/scripts/PROD_ahcsc1zdbclient010102/
oraoci@ahcsc1zdbclient010102:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/scripts/PROD_ahcsc1zdbclient010102$ adautocfg.sh
(on db node)
oraoci@ahcsc1zdbclient010102:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/scripts/PROD_ahcsc1zdbclient010102$
apploci@ebsprodapp3:~$ . /u01/PRODAPPS/EBSapps.env
run
apploci@ebsprodapp3:~$ adautocfg.sh
apploci@ebsprodapp3:~$
apploci@ebsprodapp3:~$ . /u01/PRODAPPS/EBSapps.env
run
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u01/PRODAPPS/fs1/EBSapps/appl
PATCH File System : /u01/PRODAPPS/fs2/EBSapps/appl
Non-Editioned File System : /u01/PRODAPPS/fs_ne
DB Host: ebsprodapp3.areefdba.com.sa Service/SID: PROD
Sourcing the RUN File System ...
apploci@ebsprodapp3:~$
apploci@ebsprodapp3:~$ echo
$APPS_VERSION
12.2.10
apploci@ebsprodapp3:~$
SQL>
Run
fsclone by sourcing new env:
apploci@ebsprodapp3:~$ . /u01/PRODAPPS/EBSapps.env
run
apploci@ebsprodapp3:~$ adop
phase=fs_clone (approx. 1 Hrs on TEST M7)
################################################################################################################
################################################################################################################
Section 9: Post-Update Steps:
Apply Oracle E-Business Suite Release 12.2.10 Online Help
apploci@ebsprodapp3:/u01/12.2.10$ unzip
p30399996_R12_GENERIC.zip
apploci@ebsprodapp3:/u01/12.2.10$ adop
phase=apply patches=30399996 hotpatch=yes patchtop=/u01/12.2.10 (approx. 15 mins on TEST M7)
3.
Complete Password Hashing Migration (conditionally required)
apploci@ebsprodapp3:~$
apploci@ebsprodapp3:~$ .
/u01/OCI/EBSapps.env run
apploci@ebsprodapp3:~$ AFPASSWD
-P BACKGROUND
Enter the ORACLE password of Application Object Library 'APPSUSER':
Connected successfully to APPS.
Enter the password for your 'SYSTEM' ORACLE schema:
Connected successfully to SYSTEM.
Log file: AFPWD_PROD_819737.log
System was successfully converted to hash mode.
apploci@ebsprodapp3:~$
6.Perform Product-Specific Steps (conditional)
Human Resources Legislative customers only: Refer to My Oracle Support Knowledge Document 1469456.1 for details on the patches supplying the latest legislative data definitions and for instructions on how to actually apply this data to your system.
These steps shows how to apply hrglobal.drv just for reference
Applying the R12.HR_PF.C.Delta.14 Release Update Pack (Doc ID 2656548.1)
DataInstall and HRGLOBAL Application: 12.2 Specifics (Doc ID 1469456.1)
Known Issues on Top of Patch 30096069 - R12.HR_PF.C.DELTA.14 (Doc ID 2656623.1)
Oracle HRMS Product Family - Release 12.1.x and Release 12.2.x Information (Doc ID 135266.1)
[apploci@ebsprodapp3 ~]$ adop
-status
Enter the APPS password:
Connected.
==============================================================
ADOP (C.Delta.12)
Session Id: 38
Command: status
Output: /u01/PRODAPPS/fs_ne/EBSapps/log/adop/38/20220123_113935/adzdshowstatus.out
===============================================================
Node Name Node Type Phase Status Started Finished Elapsed
--------------- ---------- --------------- --------------- -------------------- -------------------- ------------
ebsprodapp3 master FS_CLONE COMPLETED 2022/01/23 08:29:53 2022/01/23 11:10:05 2:16:12
File System Synchronization Type: Full
adop exiting with status = 0 (Success)
[apploci@ebsprodapp3 ~]$
[apploci@ebsprodapp3 ~]$ tnsping
PROD
TNS Ping Utility for Linux: Version 10.1.0.5.0 - Production on 23-JAN-2022 11:26:31
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
/u01/PRODAPPS/fs1/inst/apps/PROD_ebsprodapp3/ora/10.1.2/network/admin/sqlnet_ifile.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=ebsproddb1.developmentsn.ahccloudprdvcn1.oraclevcn.com)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=PROD) (INSTANCE_NAME=PRODCDB)))
OK (0 msec)
[apploci@ebsprodapp3 ~]$
[apploci@ebsprodapp3 ~]$
Run the DataInstall java utility in order to select the legislations you want to apply as follows:
java oracle.apps.per.DataInstall <un> <pw> thin <host:port:sid>
where
<un> is the username of the main apps account
<pw> is the password for this account
<host:port:sid> represents the database connection information
For example: java oracle.apps.per.DataInstall apps apps thin dbsvr1:1521:testdb
[apploci@ebsprodapp3 ~]$ java
oracle.apps.per.DataInstall apps apps_pswd thin ebsproddb1:1521:PROD (approx. Time immediate)
DataInstall for hrglobal
Patch Edition: null
NO PATCH EDITION EXISTS - WILL TRY RUN EDN
Run Edition: V_20220121_1047
+-------------------------------------------------+
| DataInstall Main Menu |
+-------------------------------------------------+
1. Select legislative
data to install/upgrade
2. Select college data to install/upgrade
3. Select JIT to install/upgrade
4. Select International HRMS Setup to install
5. Exit to confirmation menu
Enter your choice : 1
# Localisation Product(s) Leg. Data? Action
-- ------------------- ------------------------ ---------- -------------
1 Global Human Resources Installed
2 Australia Human Resources
3 Australia Payroll
4 Belgium Human Resources
5 Canada Human Resources
6 Canada Payroll
7 China Human Resources
8 China Payroll
9 Denmark Human Resources
10 Finland Human Resources
11 France Human Resources
12 Germany Human Resources
13 Hong Kong Human Resources
14 Hong Kong Payroll
15 Hungary Human Resources
16 India Human Resources
17 India Payroll
18 Ireland Human Resources
19 Ireland Payroll
20 Italy Human Resources
21 Japan Human Resources
22 Japan Payroll
23 Korea, Republic of Human Resources
24 Korea, Republic of Payroll
25 Kuwait Human Resources
26 Kuwait Payroll
27 Mexico Human Resources
28 Mexico Payroll
29 Netherlands Human Resources
30 Netherlands Payroll
31 New Zealand Human Resources
32 New Zealand Payroll
33 Norway Human Resources
34 Poland Human Resources
35 Romania Human Resources
36 Russian Federation Human Resources
37 Saudi Arabia Human Resources Installed
38 Saudi Arabia Payroll Installed
39 Singapore Human Resources
40 Singapore Payroll
41 South Africa Human Resources
42 South Africa Payroll
43 Spain Human Resources
44 Sweden Human Resources
45 United Arab Emirates Human Resources
46 United Arab Emirates Payroll
47 United Kingdom Human Resources Installed
48 United Kingdom Payroll Installed
49 United States Human Resources
50 United States Payroll
51 United States US Federal Human Resources
<Product #><Action> - Change Action
where <Action> is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 2I) : 37I
Enter your choice (for example 2I) : 38I
37 Saudi Arabia
Human Resources
Installed Install
38 Saudi Arabia
Payroll
Installed Install
<Product #><Action> - Change Action
where <Action> is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 2I) : Press
enter to go back to main menu
+-------------------------------------------------+
| DataInstall Main Menu |
+-------------------------------------------------+
1. Select legislative data to install/upgrade
2. Select college data to install/upgrade
3. Select JIT to install/upgrade
4. Select International HRMS Setup to install
5. Exit to confirmation menu
Enter your choice : 5
DataInstall - Actions confirmation
Do you really wish to exit and save your changes?
[Y] - Yes, save then exit
[N] - No, don't save but exit
[Return] - To return to the DataInstall Main Menu
Enter your choice (for
example Y) : Y
DataInstall - Actions summary
-----------------------------
The following actions will be performed:
Localisation Product(s) Leg. Data? Action
-------------------- ------------------------ ---------- -------------
Saudi Arabia
Human Resources
Installed Install
Saudi Arabia
Payroll
Installed Install
Localisation College Data? Action
-------------- ------------- -------------
United Kingdom
United States
Option Data? Action
------------------------------ ------------- -------------
JIT/Geocode
Legislation Action
------------------------------ -------------
ALL All Legislations
[apploci@ebsprodapp3 appl]$
Optional Instruction for applying hrglobal.drv in Downtime mode (approx. 20 Mins)
adstpall.sh apps/apps
adop phase=apply
apply_mode=downtime patchtop=$PER_TOP/patch/115
patches=driver:hrglobal.drv
options=nocopyportion,nogenerateportion,forceapply
Know Issues for hr_pf14 patches:
[apploci@ebsprodapp3
~]$ adop phase=apply apply_mode=downtime
patches=31700840,31418487,31962108,32009830
################################################################################################################
################################################################################################################
Section 10: Apply Additional Critical Patches:
apploci@ebsprodapp3:~$ FNDCPASS
apps/appsocim7 0 Y system/manager1 USER SYSADMIN sysoci1234
apploci@ebsprodapp3:~$ cat
L4766083.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
FNDCPASS:
+---------------------------------------------------------------------------+
Current system time is 06-DEC-2021 19:55:07
+---------------------------------------------------------------------------+
Arguments
FNDCPASS system/***** USER SYSADMIN *****
+----------------------------------------------------------------------------+
Working...
PASSWORD_INVALID
Unable to change the password for fnd_user SYSADMIN.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 06-DEC-2021 19:55:08
+---------------------------------------------------------------------------+
apploci@ebsprodapp3:~$
Copy latest adgrant from $APPL_TOP/admin to database tier
root@ebsprodapp3:/u01/PRODAPPS/fs1/EBSapps/appl/admin# scp
adgrants.sql
root@192.168.4.12:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/admin
root@ebsproddb1: # chown oraoci:oinstall adgrants.sql
/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/admin$
oraoci@ebsproddb1:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/admin$ strings -a adgrants.sql | grep Header
oraoci@ebsproddb1:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/admin$ sqlplus
/nolog
SQL*Plus: Release 12.1.0.2.0 Production on Mon Dec 6 20:21:48 2021
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql
apps (approx. 3mins on TEST M7)
Connected.
PL/SQL procedure successfully completed.
End of Creating PL/SQL Package AD_GRANTS.
Start of giving grants. This may take few minutes.
PL/SQL procedure successfully completed.
Session altered.
Removing logs from prior runs of adgrants.sql.
PL/SQL procedure successfully completed.
Start of PURGE DBA_RECYCLEBIN.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
The following ERRORS and WARNINGS have been encountered during this adgrants session:
TIME_STAMP SESSION_ID LOG_MODULE LOG_LEVEL
-------------------- ---------- ------------------------------------------ ----------
LOG_MESSAGE
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2021/12/06 20:22:58 3097 ad.plsql.ad_zd_sys.GIVE_PRIVILEGE WARNING
ORA-04042: procedure, function, package, or package body does not exist, SQL: grant EXECUTE on "DBMS_SCHEMA_COPY" to "SYSTEM" with grant option
2021/12/06 20:22:58 3097 ad.plsql.ad_zd_sys.GIVE_PRIVILEGE WARNING
ORA-04042: procedure, function, package, or package body does not exist, SQL: grant EXECUTE on "DBMS_SCHEMA_COPY" to "APPS"
2021/12/06 20:22:59 3097 ad.plsql.ad_zd_sys.GIVE_PRIVILEGE WARNING
ORA-00942: table or view does not exist, SQL: grant WRITE on "DIRECTORY FND_DIAG_DIR" to "APPS"
2021/12/06 20:22:59 3097 ad.plsql.ad_zd_sys.GIVE_PRIVILEGE WARNING
ORA-00942: table or view does not exist, SQL: grant READ on "DIRECTORY FND_DIAG_DIR" to "APPS"
Grants given by this script have been written to the ad_zd_logs table.
You can run $AD_TOP/sql/ADZDSHOWLOG.sql to produce a report showing these grants.
Commit complete.
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
oraoci@ebsproddb1:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/admin$
Ignore the warnings of adgrants.sql and proceed:
apploci@ebsprodapp3:/u01/12.2.10$ adop
phase=apply patches=31948857,32357755,32357755_AR:u32357755.drv hotpatch=yes
patchtop=/u01/12.2.10 (approx. 15 mins on TEST M7)
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /u01/PRODAPPS/fs1/inst/apps/PROD_ebsprodapp3/appl/admin/PROD_ebsprodapp3.xml
Patch edition context: /u01/PRODAPPS/fs2/inst/apps/PROD_ebsprodapp3/appl/admin/PROD_ebsprodapp3.xml
apploci@ebsprodapp3:~$ FNDCPASS
apps/appsocim7 0 Y system/manager1 USER SYSADMIN sysoci1234
Login to sysadmin run the workflow user/role validation req.
Refer steps as per sec.9
-> step 6 -> ORACLE WORKFLOW -> point bQuery
1:
SELECT
ASSIGNING_ROLE, LAST_UPDATE_DATE, USER_ORIG_SYSTEM, USER_ORIG_SYSTEM_ID,
ROLE_ORIG_SYSTEM, ROLE_ORIG_SYSTEM_ID FROM WF_USER_ROLE_ASSIGNMENTS WHERE
USER_NAME = 'SYSADMIN' AND ROLE_NAME =
'FND_RESP|FND|APPLICATION_DIAGNOSTICS|STANDARD';
Query 2:
SELECT
ORIG_SYSTEM_ID FROM WF_LOCAL_ROLES WHERE NAME =
'FND_RESP|FND|APPLICATION_DIAGNOSTICS|STANDARD';
Query 3:
SELECT
* FROM FND_USER_RESP_GROUPS WHERE RESPONSIBILITY_ID = <RESP_ID> AND
USER_ID = 0;
Concurrent
Prog:
Workflow
Directory Services User/Role Validation
################################################################################################################
################################################################################################################
Thanks for Reading
Regards,
Mohammed Areefuddin.
Suggested Topics :
Linux | DATABASE | RMAN | RAC | EBS |
| R1229 M7 Clone | ||||
| RAC DataGuard | Pluggable DB Clone | |||
| appsutil for DB | ||||
| JDK JRE upgrade | ||||
| Add EBS Node | ||||
No comments:
Post a Comment