Hello Everyone,
The purpose of this document is to detail the steps required to upgrade Oracle E-Business Suite Release 12.1.3 to R12.2.10 on Solaris SPARC 64-Bit.
This activity has been performed on Single node EBS instance running on Solaris SPARC 64-bit.
Please note that database have been upgraded to 19c before the EBS upgrade. Please make sure you are upgrading the database to certified release for 12.2. Please read step by step Database upgrade from 12c to 19c
1.
EBS
R12.2 Prerequisites
OS Requirements
Below are required OS
versions for oracle database 19c :
$ uname -r
5.11
$ cat /etc/release
Oracle Solaris 11.4 SPARC
Required Packages
|
Operating System
|
Required Packages
|
|
Solaris 11 (5.11)
|
oracle-ebs-server-R12-preinstall
compatibility/packages/SUNWxwplt2
compatibility/ucb
/library/motif
/svr4
/system/picl
network/rsync
|
# pkg install
oracle-ebs-server-R12-preinstall
$ pkg info <package name>
Software
Requirements
ar
ld
make
OpenSSL
SunSSH
(see below section under "Other Requirements" regarding how to set up
Secure Shell (SSH)
X
Display Server
OTHER
REQUIREMENTS
ulimit Settings
The ulimit settings determine process memory
related resource limits. Verify that the listed shell limits are set to the
values shown for the owner of the application server and database server file
systems.
|
ulimit parameter
|
Min value
|
|
coredump
|
unlimited
|
|
File
|
unlimited
|
|
Data
|
unlimited
|
|
maxuprc
|
29995
|
|
Nofiles
|
65536
|
|
Stack
|
65536
|
|
Time
|
unlimited
|
|
vmemory
|
unlimited
|
root@TEST21:/tmp/anal# ulimit -a
core file size (blocks,
-c) unlimited
data seg size (kbytes,
-d) unlimited
file size (blocks,
-f) unlimited
open files
(-n) 327679
pipe size (512 bytes, -p) 10
stack size (kbytes,
-s) 8192
cpu time (seconds,
-t) unlimited
max user processes
(-u) 29995
virtual memory (kbytes,
-v) unlimited
|
Resource Control
|
Minimum Value
|
|
project.max-sem-ids
|
100
|
|
process.max-sem-nsems
|
256
|
|
project.max-shm-memory
|
42949672951,2
|
|
project.max-shm-ids
|
100
|
|
|
|
Verifying UDP and TCP
Kernel Parameters
root@TEST21:/tmp/anal# /usr/sbin/ndd /dev/tcp tcp_smallest_anon_port
tcp_largest_anon_port
32768
65535
root@TEST21:/tmp/anal# /usr/sbin/ndd /dev/tcp udp_smallest_anon_port
udp_largest_anon_port
32768
65535
Host Names Settings
Verify that the /etc/hosts file is formatted as
follows:
127.0.0.1 localhost.localdomain
localhost
<ip_address>
<node_name>.<domain_name> <node_name>
root@TEST21:/tmp/anal# cat /etc/hosts
192.168.xxx.xx TEST21.ebs.com TEST21
loghost
Ensure Shared Memory and
Semaphores modules are loaded
Prior to installing, upgrading or cloning an EBS environment on Solaris,
you should ensure that the IPC Shared Memory (shmsys) and Semaphores (semsys)
modules are loaded - this can be checked by running the following command:
$ /usr/sbin/sysdef -- <Loaded>
Status in TEST21 :
Below not returned :
IPC Semaphores module is not loaded
IPC Shared Memory module is not loaded
Backup Source
Application and Datase :
Backup 12.1.3 source Database and application before upgrade :
-- Take full rman bacup
$ nohup rman cmdfile=rman_full_bkp_19c.rcv
log=rman_full_bkp_19c_before_122.log &
-- Shutdown the services (DB and listener) running out of oracle home
$cd /u02/oracle/TEST
oratest@TEST21:/u02/oracle/TEST$ tar cEvf - db/ |gzip -c > /u03/oracle/TEST_19c_db_OH_CDB_cold_bkp/19c_oh_bkp_cdb.tar.gz
--Shutdown the application and backup the apps codeset :
$cd /u02/oracle/TEST
$ tar –zcvf /u03/oracle/TEST_apps_bkp/TEST_12_1_apps_bkp_b4_upg.tar.gz apps
inst
Guranteed Restore
point :
Make sure Flashback is enabled in the Database :
SQL> select flashback_on from v$database;
Below restore point created after 19c upgrade before starting 12.2 Tasks
SQL> CREATE RESTORE POINT
b4_r122_upgrade_1 GUARANTEE FLASHBACK DATABASE;
Restore point created.
SQL> SELECT NAME, SCN, TIME,
DATABASE_INCARNATION#,
GUARANTEE_FLASHBACK_DATABASE, STORAGE_SIZE FROM V$RESTORE_POINT WHERE GUARANTEE_FLASHBACK_DATABASE='YES';
Preparing the
Database for the Upgrade
Run EURC-DT when planning upgrades,
performing test upgrades, or performing production upgrades.
EBS 12.2 Upgrade Readiness Checker -
Database Tier (EURC-DT)
Obtaining EURC-DT
Create or specify a patching stage area directory for staging patches.
oratest@TEST21 $ mkdir –p /u03/oracle/patches/12_2_upg_patches/eurc-dt
- Download Patch 32288423 and unzip this patch under
patching stage area.
$ cd /u03/oracle/patches/12_2_upg_patches/eurc-dt
$ unzip -o p32288423_R12_GENERIC.zip
oratest@TEST21:…tches/12_2_upg_patches/eurc-dt$ unzip -o
p32288423_R12_GENERIC.zip
Archive:
p32288423_R12_GENERIC.zip
inflating: README.txt
inflating: eurc_dt.pl
inflating: eurc_dt.xml
- Download the latest ETCC Patch 17537119 to the
patching stage area
oratest@TEST21 $ cd /u03/oracle/patches/12_2_upg_patches
oratest@TEST21:…racle/patches/12_2_upg_patches$ cp
p17537119_R12_GENERIC.zip eurc-dt/
Preparing To
Run EURC-DT
Source the EBS PDB environment file
$cd /u02/oracle/TEST/db/19.0.0/dbhome_1
$ . ./TEST_TEST21.env
$ cd /u03/oracle/patches/12_2_upg_patches/eurc-dt
Starting EURC-DT
Note: The EURC-DT tool can be run in two
different modes, check (the default)
and fix.
Specifying mode=check makes no
changes:
perl eurc_dt.pl mode=check
Specifying mode=fix recompiles
invalid objects and rebuilds unusable indexes.
perl eurc_dt.pl mode=fix
The example shown below will be for check.
Run the following command to start EURC-DT:
$ cd /u03/oracle/patches/12_2_upg_patches/eurc-dt
oratest@TEST21:…tches/12_2_upg_patches/eurc-dt$ perl eurc_dt.pl
Logs will be created under /u03/oracle/patches/12_2_upg_patches/eurc-dt/TEST_eurc-dt/
Enter SYSTEM password:
Validating SYSTEM credentials...
Enter APPS schema password:
Validating APPS schema credentials...
****** Generating
the Report ...... It will take couple of mins .... ******
Report generated by EBS 12.2 Upgrade Readiness Checker - Database Tier
(EURC-DT) running in "check" mode
=======================================
Status of the system prior to upgrade
=======================================
Host Name is: TEST21
CDB SID: CDBTEST
PDB SID: TEST
Database Version:
19.10.0.0.0
EBS Version: 12.1.3
Platform: Solaris
RAC Database: FALSE
==============
BEFORE UPGRADE
==============
Required Details:
=================
2. Check Name : Online Patching Readiness Report
Refer: Chapter 3: Planning and Performing Pre-Upgrade Tasks =>
Preparing Customization's => Run the Online Patching Readiness Reports of
12.0 and 12.1 to 12.2 Upgrade Guide
12.1 customers should
ensure that the online patching readiness report patch 31026891:R12.AD.B is
applied on the instance.
The patch is already
applied on the instance. No Action Needed.
Note: Refer to Using the
Online Patching Readiness Report in Oracle E-Business Suite Release 12.2 (Doc
ID 1531121.1)
for details on execution of
the scripts.
Re-execute the script to
confirm all the custom code violations are fixed before proceeding further with
the upgrade.
3. Check Name : Check for Invalid objects
Refer: Chapter 4: Performing the upgrade => Performing the Upgrade to
Release 12.2.0
There should be no INVALID
objects in APPS schema or user schema before EBS upgrades.
There are 33 APPS invalids
present in the instance before the upgrade.Refer APPS_Pre_Invalids.log.
4. Check Name : Check for Unusable Indexes
Refer: Chapter 4: Performing the upgrade => Performing the Upgrade to
Release 12.2.0
There should not be any
UNUSABLE indexes prior to upgrade.
There are 6 UNUSABLE
indexes on the instance before the upgrade.Refer
UnusableIndexList_Pre_Compilation.log.
5. Check Name : Failed Domain Indexes
Refer: Chapter 4: Performing the upgrade => Performing the Upgrade to
Release 12.2.0
There are no Failed Domain
indexes present in the instance.
6. Check Name : Logical corruptions and time stamp mismatch in the
Database
Refer: Chapter 4: Performing the upgrade => Performing the Upgrade to
Release 12.2.0
The instance has the below
logical corruptions and time stamp mismatch in the database.
Please take appropriate
action prior to upgrade.
Data Dictionary Corruptions
(dependency) : 0
Data Dictionary Corruptions
(procedure info) : 0
Data Dictionary Corruptions
(procedure plsql) : 0
Data Dictionary Corruptions (Source) : 0
7. Check Name : Materialized View Refresh
Refer: Chapter 4: Performing the upgrade => Performing the Upgrade to
Release 12.2.0
You should run
ADZDMVREFRESHNEEDED.sql prior to the upgrade to get information on MVs which
require refresh and need to make
sure all the MV's are
refreshed so that there is no data in mlog\$ tables.
Execute
$AD_TOP/patch/115/sql/ADZDMVREFRESHNEEDED.sql
It is available in the
Consolidated Online Patching Enablement Readiness Report Patch Patch
31026891:R12.AD.B for 12.1.
8. Check Name : Migrate or Upgrade your Database to Oracle Database 19c
or Oracle Database 12c Release 1 (12.1.0.2)
Refer: Chapter 4: Performing the upgrade => Upgrade Your Database and
Apply Mandatory E-Business Suite Release 12.2 Database Patches
Database version on the
instance is 19.10.0.0.0.
The instance is already at
the certified oracle DB version for 12.2.X upgrade.
Follow the instructions in
Database Preparation Guidelines for an Oracle E-Business Suite Release 12.2
Upgrade (Doc ID:1349240.1) as well as any additional steps.
9. Check Name : Review Sizes of Old and New Tablespaces
Refer: Chapter 4: Performing the upgrade => Upgrade Your Database and
Apply Mandatory E-Business Suite Release 12.2 Database Patches
Ensure that all critical
tablespaces contain sufficient space (below the threshold).
Complete Tablespace status
can be found at : CompleteTablespace.log
Temp Tablespace status can
be found at : Temp_Tablespace.log
Resize the tablespace as
necessary. For guidelines, see Oracle E-Business Suite Release 12.2:Upgrade
Sizing and Best Practices (Doc ID: 1597531.1).
10. Check Name : Validate GUEST Account
Refer: Chapter 4: Performing the upgrade => Preparing the System for Upgrade
Ensure that the GUEST
account is valid and active and that the fnd_user USER_ID for the GUEST account
is set to a value of '6'.
The value of GUEST account
is "Y" in the instance.No further action.
Execute the below query to
gather more information and take action to validate.
SQL> select
fnd_message.get from dual;
12. Check Name : Check for Patch 13420532:R12.XLA.B application
Refer: Chapter 4: Performing the upgrade => Preparing the System for Upgrade => Subledger Accounting
Apply patch
13420532:R12.XLA.B when upgrading from Release 12.0.x to clean up temporary
advance queues that were created
by prior Create Accounting
program processes.
Instance doesnt have
13420532:R12.XLA.B applied, ensure its applied.
13. Check Name : Gather SYS schema statistics
Refer: Chapter 4: Performing the upgrade => Database and System
Administration Tasks => Gather SYS schema statistics => Fixed Object and
Dictionary Statistics
Execute the below command
as SYSDBA user to gather the stale stats. This increases the performance of
the upgrade.
dbms_stats.gather_schema_stats( 'SYS',options=>'GATHER
STALE',estimate_percent =>$ DBMS_STATS.AUTO_SAMPLE_SIZE,
method_opt => 'FOR ALL
COLUMNS SIZE AUTO',cascade => TRUE);
14. Check Name : Fixed Object and Dictionary Statistics
Refer: Chapter 4: Performing the upgrade => Database and System
Administration Tasks => Gather SYS schema statistics => Fixed Object and
Dictionary Statistics
These should have been
previously gathered, correct and up-to-date on the pre-upgrade environment.
Execute the below as SYSDBA user again to gain the performance benifit during upgrade.
exec
dbms_stats.gather_fixed_objects_stats;
exec
dbms_stats.gather_dictionary_stats;
15. Check Name : Gather Schema statistics
Refer: Chapter 4: Performing the upgrade => Database and System
Administration Tasks
Schema statistics are
gathered by the FND_STATS process, which you can execute by running the Gather
Schema Statistics concurrent program.
From your Release 12
APPL_TOP, perform the following steps:
1. Log in to Oracle
E-Business Suite as the System Administrator.
2. Navigate to the Submit
Request window (Requests > Run).
3. Submit the Gather Schema
Statistics program.
Alternatively, run the
following procedure manually as apps user:
FND_STATS.GATHER_SCHEMA_STATISTICS('ALL', 10, :parallel_degree,
'NOBACKUP', NULL, 'LASTRUN', 'GATHER AUTO', 10, 'N');
Where: parallel_degree is
set to the value of the database initialization (init.ora) parameter
parallel_max_servers for your instance.
The parameters for
FND_STATS.GATHER_SCHEMA_STATISTICS are as follows:
FND_STATS.GATHER_SCHEMA_STATISTICS ({schema name}, {estimate percent},
{degree of parallelism}, {backup flag},{restart request ID,
if applicable}, {history
mode},{gather options}, {modificationsthreshold}, {invalidate dependent
cursors});
16. Check Name : Update init.ora with upgrade parameters -> Common
Database Initialization Parameters For All Releases
Refer: Chapter 4: Performing the upgrade => Performing the Upgrade to
Release 12.2.0 => See Database Initialization Parameters for Oracle
Applications Release 12.2 (Doc ID: 396009.1)
Initialization parameters
required at each stage of an upgrade may vary depending on when you upgrade
your database.
Set the appropriate
parameters now. The important common DB parameters are:
processes
sessions
_SYSTEM_TRIG_ENABLED=TRUE
Note:If your processes and
sessions values in the init.ora file is the default values provided by the
E-Business installation of 300 and 600,
then you should consider
doubling these during the upgrade process to avoid connection issues.
Note: The instance should have
_system_trig_enabled set to TRUE. If its sets to FALSE it will prevent from
system triggers from being executed.
The value of
_system_trig_enabled is set to "TRUE" on the instance.No further
action.
DB parameters can be
further fine tuned as per the guidelines, see Oracle E-Business Suite Release
12.2:Upgrade Sizing and
Best Practices (Doc ID:
1597531.1).
17. Check Name : Update init.ora with upgrade parameters ->
Release-Specific Database Initialization Parameters for Oracle 19c
Refer: Chapter 4: Performing the upgrade => Performing the Upgrade to
Release 12.2.0 => See Database Initialization Parameters for Oracle
Applications Release 12.2 (Doc ID: 396009.1)
Initialization parameters
required at each stage of an upgrade may vary depending on when you upgrade
your database.
Set the appropriate
parameters now. The important 19c DB specific parameters are:
optimizer_adaptive_plans =
TRUE
optimizer_adaptive_statistics = FALSE
_disable_actualization_for_grant = TRUE
Some of the important
Initialization parameters are not set or not valid. Please set the appropriate
parameters now.
Current parameters are:
optimizer_adaptive_plans = TRUE
optimizer_adaptive_statistics = FALSE
_disable_actualization_for_grant =
Follow the instructions in
Database Initialization Parameters for Oracle E-Business Suite Release 12.2
(Doc ID: 396009.1)
and reset the init.ora
parameters as required.
18. Check Name : Additional Database Initialization Parameters For Oracle
E-Business Suite Release 12.2
Refer: Chapter 4: Performing the upgrade => Performing the Upgrade to
Release 12.2.0 => See Database Initialization Parameters for Oracle
Applications Release 12.2 (Doc ID: 396009.1)
Initialization parameters
required at each stage of an upgrade may vary depending on when you upgrade
your database.
Set the appropriate
parameters now.
The important 12.2 specific
parameters are:
recyclebin = off
service_names=%s_dbSid%,ebs_patch
Some of the Additional Database
Initialization parameters are not set or not valid. Please set the appropriate
parameters now.
Current set parameters are:
recyclebin = on
service_names = CDBTEST,
Note: For Oracle Database 19c with a single tenant
(1 CDB:1 PDB) configuration : -
service_names: The
value for this parameter is auto-populated when CDB is created. This parameter
should not be modified manually.
Follow the instructions in
Database Initialization Parameters for Oracle E-Business Suite Release 12.2
(Doc ID: 396009.1)
and reset the init.ora
parameters as required.
19. Check Name : Set FAILED_LOGIN_ATTEMPTS to UNLIMITED
Refer: Chapter 4: Performing the upgrade => Performing the Upgrade to
Release 12.2.0
The database provides
parameters to enforce password management policies.
However, some of the
database password policy parameters may lock out the E-Business Suite schema.
The LIMIT value for the
resource FAILED_LOGIN_ATTEMPTS with profile as DEFAULT on the instance is
:"UNLIMITED". No further action.
Recommended Details:
====================
1. Check Name : Migrate Existing Objects to New Tablespace Model
Refer: Chapter 4: Performing the upgrade => Prepare Release 12.2
Tablespaces => Migrate Existing Objects to New Tablespace Model
Your instance is already
OATM enabled. If you previously upgraded your environment from Release 11i to
Release 12,then the
upgrade process created
tablespaces for all new products, configured the database for the new
tablespace model, and created new objects.
However, it did not automatically migrate
your existing objects. If you have not already done so,
Oracle strongly recommends
that you use the Tablespace Migration Utility to perform this migration now.
Note that this utility is
not supported for use after you enable Online Patching,so you cannot perform
the migration after your
environment is upgraded to
Release 12.2.If you choose not to migrate to OATM now,then you must continue to
manage your tablespaces separately.
2. Check Name : Disable Database Audit Trail
Refer: Chapter 4: Performing the upgrade => Performing the Upgrade to
Release 12.2.0
Before perform the upgrade,
ensure to Disable database audit trail, or else it would impatch the upgrade
job execution.
Conditional Details:
=====================
2. Check Name : Set the parameter sec_case_sensitive_logon
Refer: Chapter 4: Performing the upgrade => Upgrade Your Database and
Apply Mandatory E-Business Suite Release 12.2 Database Patches
For Release 12.1+ based
environments (both 11204,12c and 19c), customers have a choice to set it as
either TRUE or FALSE.
The value of
sec_case_sensitive_logon in the instance is "FALSE". No Action
Needed.
For Database 19c, the value
for SQLNET.ALLOWED_LOGON_VERSION_SERVER should be 10 irrespective of the value
of the sec_case_sensitive_logon parameter.
The value of
SQLNET.ALLOWED_LOGON_VERSION_SERVER in the instance is "10". No
Action Needed.
3. Check Name : Apply required database patches for Oracle E-Business
Release 12.2
Refer: Chapter 4: Performing the upgrade => Upgrade Your Database and
Apply Mandatory E-Business Suite Release 12.2 Database Patches
Ensure that the required
database patches for Oracle E-Business Release 12.2 have been applied.
Follow the instructions in
the Oracle E-Business Suite Release 12.2: Consolidated List of Patches and
Technology
Bug Fixes (Doc ID:
1594274.1) to do the following.
1) Check for missing
database patches by executing the Oracle E-Business Suite Technology Codelevel
Checker (ETCC) script..
Running command: sh
/u03/oracle/patches/12_2_upg_patches/eurc-dt/TEST_eurc-dt//etcc/checkDBpatch.sh >
/u03/oracle/patches/12_2_upg_patches/eurc-dt/TEST_eurc-dt//etcc/checkDBpatch_etcc.log
Executing ETCC script...
Successfully completed.........
Patch Recommendation
Summary: /u03/oracle/patches/12_2_upg_patches/eurc-dt/TEST_eurc-dt//etcc/checkDBpatch_etcc.log
2) Apply the latest
database patches identified in the report as missing.
3) Confirm successful
application or required database patches by re-executing the Oracle E-Business
Suite Technology
Codelevel Checker (ETCC)
script.
5. Check Name : Install JRE on the database tier
Refer: Chapter 4: Performing the upgrade => Database and System
Administration Tasks
If you are planning to run
Rapid Install in Upgrade Mode by using the Use Existing ORACLE HOME option,
then you must install JRE
in the Database ORACLE_HOME/appsutil.
Download the latest JRE 7
Update. For optimum stability, performance, scalability, and OS vendor
support,use the latest available update of
JRE for the Oracle
E-Business Suite database tier.
The JRE download location
is: http://www.oracle.com/technetwork/java/javase/downloads/index.html
Refer to Using the Latest
JDK 7.0 Update with Oracle E-Business Suite Release 12.2 (Doc ID 1530033.1)
The jre version on the
Database Tier is: 1.8.0_271
For Oracle Database 19c,
install JRE 8 on the database tier using the following instructions:
cp -r <RDBMS
ORACLE_HOME>/jdk/jre <RDBMS ORACLE_HOME>/appsutil
cp <RDBMS
ORACLE_HOME>/jlib/orai18n.jar <RDBMS ORACLE_HOME>/appsutil/jre/lib/ext
6. Check Name : Synchronize value of APPLPTMP with Database Directories
for PL/SQL File I/Obased Concurrent Requests
Refer: Chapter 4: Performing the upgrade => Database and System
Administration Tasks
Ensure to have the APPLPTMP
value in APPL_TOP is in synch with utl_file_dir value in the database.
The current value of
utl_file_dir in the database tier is "/u02/oracle/TEST/db/19.0.0/temp/TEST"
and value of APPLPTMP on the 12.1.3 Apps tier is "/u02/oracle/TEST/db/19.0.0/temp/TEST".
Ensure that the values are
in synch with respect to 12.2 APPL_TOP once RI is laid down.
Refer to My Oracle Support
Knowledge Document 2525754.1, Using UTL_FILE_DIR or Database Directories for
PL/SQL File I/O
in Oracle E-Business Suite
Releases 12.1 and 12.2 for more information.
7. Check Name : Disable AOL Audit Trail
Refer: Chapter 4: Performing the upgrade => Performing the Upgrade to
Release 12.2.0
If you use the Oracle
Applications Object Library Audit Trail feature, then you must disable it
before the upgrade.
The DB contains the values
as "E (Enabled)" or "R (Enable Requested)". AOL Audit Trail
is ENABLED on the instance.
Please Refer
DISABLEAOLAudit_complete.log for more details and take the below action.
From the System
Administrator responsibility under the R12.0 or 12.1 APPL_TOP, navigate to
Security > Audit Trail > Groups.
In the Audit Groups window,
set the Group State field to Disable - Prepare for Archive for each audit group
defined.
Run the Audit Trail Update
Tables report from the Submit Requests window (Requests >Run).
Note: See Audit Trail in
Oracle E-Business Suite Security Guide.
8. Check Name : Disable custom triggers, constraints, indexes, business
events, and VPD
Refer: Chapter 4: Performing the upgrade => Performing the Upgrade to
Release 12.2.0
Disable custom triggers or
constraints on Oracle E-Business Suite tables. Re-enable these triggers after
the upgrade.
If you have custom indexes
on Applications tables, then determine whether they can affect performance
during the upgrade, and drop them if necessary.
If you are not sure, then
it is best to drop the indexes and add them after the upgrade, if the new
release has not created a similar index.
IMPORTANT NOTE: For more information, please refer to Oracle E-Business
Suite Upgrade Guide Release 12.0 and 12.1 to 12.2 from Oracle E-Business Suite Documentation
Web Library Release 12.2.
Please refer to the TEST_EURC-DT_Report.html report for the
checks/validations performed and refer to the TEST_eurc-dt.log for complete
details hosted in the /u03/oracle/patches/12_2_upg_patches/eurc-dt/TEST_eurc-dt/
directory.
Apply EURC-DT Recommendations
EURC-DT
#4. Check Name : Check for Unusable Indexes
SQL> select OWNER,INDEX_NAME from dba_indexes where status='UNUSABLE';
- Rebuild all the Unusuable Indexes online
SQL> select OWNER,INDEX_NAME from dba_indexes where status='UNUSABLE';
no rows selected
EURC-DT #7. Check Name : Materialized View Refresh
sqlplus apps/TEST
SQL> @$AD_TOP/patch/115/sql/ADZDMVREFRESHNEEDED.sql
No rows Returend
Conditional : Set parameter SEC_CASE_SENSITIVE_LOGON
SQL>select NAME,VALUE
from v$parameter where name in ('sec_case_sensitive_logon');
NAME VALUE
------------------------------
---------------
sec_case_sensitive_logon FALSE
SQL> alter system set
sec_case_sensitive_logon=TRUE scope=both;
System altered.
SQL> show parameter
sec_case_sensitive_logon;
NAME TYPE VALUE
------------------------------------
----------- ------------------------------
sec_case_sensitive_logon boolean TRUE
Additionally the value of
the SQLNET.ALLOWED_LOGON_VERSION_SERVER parameter must be set to 8.
It is already set in sqlnet_ifile.ora
:
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
cd /u02/oracle/TEST/db/19.0.0/dbhome_1/network/admin
vi sqlnet.ora
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
Add Patch service_name in DB init
Parameters
SQL> alter system set
service_names=’CDBTEST’,'TEST',’ebs_patch' scope=both sid='*';
SQL> alter system
register;
- Resize CDB and PDB Tablespace sizes to adaquate level
EBS Technology Codelevel Checker (ETCC)
As oratest user, Source pdb
env file
oratest@TEST21:…/oracle/TEST/db/19.0.0/dbhome_1$ . TEST_TEST21.env
oratest@TEST21:…/oracle/TEST/db/19.0.0/dbhome_1$ cd
/u03/oracle/patches/12_2_upg_patches/DB/ETCC/
oratest@TEST21:…tches/12_2_upg_patches/DB/ETCC$ sh checkDBpatch.sh
+===============================================================+
|
Copyright (c) 2005, 2020 Oracle and/or its affiliates. |
| All rights reserved. |
|
Oracle E-Business Suite Release 12.2 |
|
Database EBS Technology Codelevel Checker |
+===============================================================+
Validating context file:
/u02/oracle/TEST/db/19.0.0/dbhome_1/appsutil/TEST_TEST21.xml
Using context file from currently
set database environment:
/u02/oracle/TEST/db/19.0.0/dbhome_1/appsutil/TEST_TEST21.xml
Starting Database EBS Technology
Codelevel Checker, Version 120.83
Monday, April 5, 2021 at 12:28:59 PM BST
Log file for this session :
/u03/oracle/patches/12_2_upg_patches/eurc-dt/log/checkDBpatch_22287.log
Identifying database release.
Database release set to 19.10.0.0.
Multitenant identified.
- Container database (CDB) identified via
s_cdb_name is CDBTEST
- Pluggable database (PDB) identified via
s_pdb_name is TEST
Connecting to database.
Database connection successful.
Database TEST is in READ WRITE
mode.
Identifying APPS and APPLSYS
schema names.
- APPS schema : APPS
- APPLSYS schema : APPLSYS
Checking for DB-ETCC results
table.
Table to store DB-ETCC results
already exists in the database.
Bugfix file
/u03/oracle/patches/12_2_upg_patches/eurc-dt/TEST_eurc-dt//etcc/db/onprem/txk_R1220_DB_base_bugs.xml
: 120.0.12020000.58
This file will be used for
identifying missing bugfixes.
Mapping file
/u03/oracle/patches/12_2_upg_patches/eurc-dt/TEST_eurc-dt//etcc/db/onprem/txk_R1220_DB_mappings.xml
: 120.0.12020000.33
This file will be used for mapping
bugfixes to patches.
Identified RDBMS DST version 32.
Checking Bugfix XML file for
19.10.0.0_RU
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
19.10.0.0.210119DBRU
All the required one-off bugfixes are present in Database ORACLE_HOME.
Stored Technology Codelevel
Checker results in the database TEST successfully.
Finished checking fixes for Oracle
Database: Monday, April 5, 2021 at
12:29:56 PM BST
Log file for this session:
/u03/oracle/patches/12_2_upg_patches/eurc-dt/log/checkDBpatch_22287.log
Interoperability Patches to
be applied for 12.2
- Below DB patches are need to be applied on 19c oracle home.
All the patches below have been applied already as part 19c DB Upgrade.
32218454 – Applied on TEST
32067171 – Applied
29867728 – applied
31405300 - applied
31424070 - applied
Apply Database Patches
Check ETCC report and Apply
if any patches reported in ETCC.
Run post-install steps
for Database Patches
oratest@TEST21:~$ . ./CDBTEST_TEST21.env
oratest@TEST21:~$ export ORACLE_PDB_SID=TEST
- run dbmsxdbschmig.sql, prvtxdbschmig.sql,
utlrp.sql scripts:
sqlplus / as sysdba
SQL> alter session set current_schema=SYS;
SQL> @?/rdbms/admin/dbmsxdbschmig.sql
SQL> @?/rdbms/admin/prvtxdbschmig.plb
SQL> @?/rdbms/admin/utlrp.sql
- run adgrants.sql:
sqlplus / as sysdba
SQL> @?/appsutil/sql/adgrants.sql APPS
Run adgrants
Copy $APPL_TOP/admin/adgrants.sql from the administration server node to
the database server node.
$ sqlplus / as sysdba
SQL> alter session set container=TEST;
SQL> @adgrants.sql APPS
SQL> @?/rdbms/admin/utlrp.sql
3.
Preparing the Oracle E-Business Suite Release 12.2 File System
Setting
Up the Stage
Area
$ cd /u01
$ mkdir Stage122
Running
the buildStage Script
The buildStage script is run as follows on
UNIX and Windows.
$ cd /u01/StageR122/startCD/Disk1/rapidwiz/bin
$ buildStage.sh
Build
Stage Area
Create new stage area
Copy new patches to current stage area.
Display existing files in stage TechPatches.
Exit menu
Enter your choice [4]: 1
These options are used as follows.
Main
Menu - Option 1. Create new stage area
Rapid Install Platform Menu
Oracle Solaris SPARC (64-bit)
Linux x86-64
IBM AIX on Power Systems (64-bit)
HP-UX Itanium
Exit Menu
Enter your choice [5]: 1
Please enter the directory containing the zipped installation media: /u01/oracle/TEST/stage
Patching
the Stage Area
Apply the below patches to the Stage Area
22066363 (12.2.0.51)
25525148
31033613
31853621
Patch 25893970
Patch 27983110
As appltest user,
$ cd /u01/oracle/TEST/stage
$ unzip p25525148_R12_GENERIC.zip
$ cd 25525148
Patch the stage area :
$ 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.
$ unzip p31033613_R12_GENERIC.zip
$ cd 31033613
$ sh patchRIStage.sh
$ unzip p31853621_R12_GENERIC.zip
$ cd 31853621
$ sh patchRIStage.sh
$ cd 25893970
$ sh patchRIStage.sh
$ cd 27983110
$ sh patchRIStage.sh
Creating
the Upgrade
File System
appltest@TEST21
$ cd /u01/oracle/TEST/stage/startCD/Disk1/rapidwiz/
appltest@TEST21
$ ./rapidwiz
- Check “Use Existing Oracle Home”
- Update current database port to establish the
connection to DB.
- Choose the Database characterset same like the source
database.
Important:
The following pre-installation checks are expected
to fail if the database is down during creation of the upgrade file system:
Technology
Codelevel
Database Version
Database Name Validation
DatabaseService Name
You should therefore verify the results of
all these tests manually.
Conditional Action:
This note applies
only if you are upgrading from Oracle E-Business Suite
Release 12.1.3 with a multitenant architecture. For a multitenant architecture,
you can ignore the failure related to 'DB service_names check'.
When there are no further issues to resolve,
click Next to continue.
SQL> select RELEASE_NAME,ARU_RELEASE_NAME from fnd_product_groups;
RELEASE_NAME
--------------------------------------------------
ARU_RELEASE_NAME
--------------------------------------------------
12.1.3
R12
Backup apps and DB
SQL> CREATE RESTORE POINT PDB_AFt_r122_installation FOR PLUGGABLE
DATABASE TEST GUARANTEE FLASHBACK DATABASE;
$ cd /u01/oracle/TEST
$ tar -zcvf TEST_r122_fresh_inst.tar.gz fs1 fs2 fs_ne
4.
Preparing the System for Upgrade
Run ETCC for Middle Tier
No need since we are patching with Automation tool.
EBS Tech
Patch Automation Tool - Application Tier (ETPAT-AT):
$ cd patch stage area
$ unzip -o p32208510_R12_GENERIC.zip
Archive:
p32208510_R12_GENERIC.zip
inflating:
post_install_steps.xml
inflating:
README.txt
inflating:
etpat_at.pl
Preparing to RUN ETPAT-AT
Download the patches below
and move to patch stage area
Note : Don’t unzip the
patches.
p17537119_R12_GENERIC.zip
p6880880_101000_SOLARIS64.zip
p6880880_111000_SOLARIS64.zip
p32152068_R12_SOLARIS64.zip
p32052267_1036_Generic.zip
p31136426_1036_Generic.zip
Respond to the following prompts:
$ Enter 12.2.0 Run edition file system context
file:
$ Enter APPS schema name [APPS]:
$ Enter password for APPS schema:
$ Enter directory where you downloaded ETCC Patch 17537119:
Running ETPAT-AT
Source the run edition
applications environment with the appropriate command for your environment.
UNIX:
$ . /u01/oracle/TEST/fs1/EBSapps/appl/APPSTEST_TEST21.env
Run the
following command to start ETPAT-AT:
$ cd
/u01/oracle/patch_stage_area
appltest@TEST21:/u01/oracle/patch_stage_area$
perl etpat_at.pl
Enter 12.2.0 Run edition file system context file: /u01/oracle/TEST/fs1/inst/apps/TEST_TEST21/appl/admin/TEST_TEST21.xml
Enter APPS schema name [APPS]: APPS
Enter password for APPS schema: <APPS_Pwd>
Enter directory where you downloaded ETCC Patch 17537119: /u01/oracle/patch_stage_area
[OPatch patch 6880880.
Ensure that p6880880_101000_SOLARIS64.zip, p6880880_111000_SOLARIS64.zip are
downloaded under the patch stage area]
[Fusion Middleware
consolidated patch 32152068. Ensure that p32152068_R12_SOLARIS64.zip is
downloaded under patch stage area]
[Latest WLS Patch 32052267.
Ensure that p32052267_1036_Generic.zip is downloaded under patch stage area]
[Smart update Patch 31136426.
Ensure that p31136426_1036_Generic.zip is downloaded under patch stage area]
Download above patches under patch stage area and Enter 'Yes' to
Continue (Yes/No):
All
missing one-offs got applied and ETCC report is clean
Summary report text file location:
/u01/oracle/patch_stage_area/TEST_etpat_at/log/ETPAT-AT_Report_TEST.txt
Summary report html file location:
/u01/oracle/patch_stage_area/TEST_etpat_at/log/ETPAT-AT_Report_TEST.html
End Time: Thursday, April 8, 2021 at
9:29:12 AM BST
Script
etpat_at.pl ran successfully.
Check the log file /u01/oracle/patch_stage_area/TEST_etpat_at/log/etpat_at_TEST.log
for more information.
appltest@TEST21:/u01/oracle/patch_stage_area$
RUN ETCC on MiddleTier
- Run ETCC again and make sure ETCC does not recommend any patches to
apply to Middle Tier.
appltest@TEST21:…1/oracle/patch_stage_area/ETCC$ ./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/oracle/TEST/fs1/inst/apps/TEST_TEST21/appl/admin/TEST_TEST21.xml
Starting Application Tier Technology Codelevel Checker
Version: 120.0.12020000.43.
Thursday, April 8, 2021 at 9:43:36 AM BST
Log file for this session: /u01/oracle/patch_stage_area/ETCC/log/checkMTpatch_14803.log
Bugfix XML file version: 120.0.12020000.49
This file will be used for identifying missing bugfixes.
Mapping XML file version: 120.0.12020000.35
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.B.8 codelevel does not support storing the results in
the database.
===============================================================================
Oracle Forms and Reports
===============================================================================
Now examining product Oracle Forms and Reports.
Oracle Home = /u01/oracle/TEST/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.
Checking required bugfixes for RSF within Forms 10.1.0.5.0.
All required
bugfixes are present for RSF within Forms.
===============================================================================
Oracle Fusion Middleware (FMW) - Web Tier
===============================================================================
Now examining product Oracle Fusion Middleware (FMW) - Web Tier.
Oracle Home = /u01/oracle/TEST/fs1/FMW_Home/webtier.
Product Version = 11.1.1.9.0
Checking required bugfixes for FMW - Web Tier 11.1.1.9.0.
All required
bugfixes are present for FMW - Web Tier.
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.
===============================================================================
Oracle Fusion Middleware (FMW) - oracle_common
===============================================================================
Now examining product Oracle Fusion Middleware (FMW) - oracle_common.
Oracle Home = /u01/oracle/TEST/fs1/FMW_Home/oracle_common.
Product Version = 11.1.1.9.0
Checking required bugfixes for FMW - oracle common 11.1.1.9.0.
All required
bugfixes are present for FMW - oracle common.
===============================================================================
Oracle WebLogic Server (WLS)
===============================================================================
Now examining product Oracle WebLogic Server (WLS).
Oracle Home = /u01/oracle/TEST/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.
All required patches are present for Oracle WebLogic Server (WLS).
===============================================================================
All required
one-offs are confirmed as present.
Finished checking prerequisite patches for File Edition: run.
Thursday, April 8, 2021 at 9:44:13 AM BST
Log file for this session:
/u01/oracle/patch_stage_area/ETCC/log/checkMTpatch_14803.log
===============================================================================
appltest@TEST21:…1/oracle/patch_stage_area/ETCC$
Validate Guest User
SQL> select fnd_web_sec.validate_login('GUEST','ORACLE') Valid from
dual;
VALID Y
If 'N' is returned, then query the error
message for more info:
SQL> select fnd_message.get
from dual;
GET
-------------------------------------------------------------------------------
SQL> select fnd_web_sec.validate_login('GUEST','ORACLE') Valid from
dual;
VALID
--------------------------------------------------------------------------------
Y
Enable Maintenance Mode
Run adadmin and select option ‘5
and 1’ to Enable maintenance mode.
5. Change Maintenance Mode
1. Enable Maintenance Mode
Financials
and Procurement Tasks
Patches to be applied in 12.1.3 :
Patch 13027498 (Patch is present
already in TEST)
Patch 13420532
Apply Subledger
Accounting Patch
Patch 13420532: 12.2 pre-install: XLA: CLEAN UP ADVANCE QUEUES
from prior runs of Create Accounting BEFORE ENABLING EBR in 12.2
Prerequisites : NONE
Apply the patch :
$ cd
/u03/oracle/patches/12_2_upg_patches/apps_1213_patches/13420532
$ time adpatch
Post Patching Steps
:
b) Fixed File Names
and versions (Verify File version after patch)
$xla/patch/115/sql/xlaqclen.sql 120.0.12010000.4
appltest@TEST21:…A/apps/apps_st/appl/xla/12.0.0$
adident Header $XLA_TOP/patch/115/sql/xlaqclen.sql
$Header xlaqclen.sql
120.0.12010000.4 2011/11/23 05:28:04
vdamerla noship $
Disable Maintenance node
Execute the below to disable Maintenance mode
:
$ sqlplus apps/
@$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE
Database
and System Administration Tasks
Modify
Initialization Parameters
As oratest user, Source CDB env file :
$ cd /u02/oracle/TEST/db/19.0.0/dbhome_1
$ . ./CDBTEST_TEST21.env
show parameter recyclebin
show parameter service_name
show parameter result_cache_max_size
show parameter LOCAL_LISTENER
show parameter result_cache_max_size
show parameter _pga_max_size
show parameter job_queue_processes
show parameter parallel_max_servers
show parameter sga_max_size
show parameter sga_target
show parameter pga_aggregate_target
show parameter _pga_max_size
show parameter db_file_multiblock_read_count
show parameter _SYSTEM_TRIG_ENABLED
show parameter recyclebin
show parameter optimizer_adaptive_plans
show parameter optimizer_adaptive_statistics
show parameter
_disable_actualization_for_grant
show parameter nls_numeric_characters
show parameter nls_sort
show parameter nls_date_format
show parameter db_files
show parameter session_cached_cursors
show parameter db_block_checking
show parameter db_block_checksum
show parameter log_checkpoints_to_alert
SQL> alter system set recyclebin=off
scope=spfile;
SQL> alter system set service_name=’CDBTEST’,
‘TEST’, ‘ebs_patch’ scope=both;
SQL> alter system register;
SQL> alter system set
result_cache_max_size=600M scope= spfile;
SQL> alter system set LOCAL_LISTENER=’TEST21:1524’
scope=both;
SQL> alter system set result_cache_max_size = 600M scope= spfile;
SQL> alter system set
_pga_max_size=104857600 scope= spfile;
SQL> alter system set job_queue_processes=16
scope= spfile;
SQL> alter system set parallel_max_servers=64 scope= spfile;
SQL> alter system set sga_max_size=12G
scope=spfile;
SQL> alter system set sga_target=12G
scope=spfile ;
SQL> alter system set pga_aggregate_target=6G
scope=spfile;
SQL> alter system set _pga_max_size=104857600
scope=spfile;
SQL> alter system reset db_file_multiblock_read_count;
SQL> alter system set _SYSTEM_TRIG_ENABLED = TRUE scope=spfile;
SQL> alter system set recyclebin = off scope=spfile;
SQL> alter system set optimizer_adaptive_plans = TRUE scope=spfile;
SQL> alter system set optimizer_adaptive_statistics = FALSE scope=spfile;
SQL> alter system set _disable_actualization_for_grant = TRUE scope=spfile;
SQL> alter system set nls_numeric_characters =
'.,' scope=spfile;
SQL> alter system set nls_sort = binary scope=spfile;
SQL> alter system set nls_date_format= DD-MON-RR
scope=spfile;
SQL> alter
system set db_files=1500 scope=spfile;
SQL> alter system set session_cached_cursors=500
scope=spfile;
SQL> alter system set db_block_checking=FALSE
scope=both;
SQL> alter system set db_block_checksum=TRUE scope=both;
SQL> alter system set log_checkpoints_to_alert=TRUE scope=both;
$sqlplus / as sysdba
SQL> shutdown immediate;
SQL>create spfile from pfile=’$ORACLE_HOME/dbs/initCDBTEST.ora’
SQL>startup
Gather
SYS, Fixed Object and Dictionary Statistics
oratest@TEST21:…cle/TEST/db/19.0.0/dbhome_1/dbs$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 8 16:38:54 2021
Copyright (c) 1982, 2014, Oracle.
All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
SQL> show con_name;
CON_NAME
------------------------------
TEST
SQL> begin
dbms_stats.gather_schema_stats( 'SYS',
options=>'GATHER STALE', estimate_percent =>
DBMS_STATS.AUTO_SAMPLE_SIZE,
method_opt => 'FOR ALL COLUMNS SIZE AUTO',
cascade => TRUE);
end;
/
PL/SQL procedure successfully completed.
Fixed Object and Dictionary Statistics
SQL> exec dbms_stats.gather_fixed_objects_stats;
PL/SQL procedure successfully completed.
SQL> exec dbms_stats.gather_dictionary_stats;
PL/SQ procedure successfully completed.
Gather
schema statistics (required)
appltest@TEST21:~$ . APPSTEST_TEST21.env
appltest@TEST21:~$ echo $ORACLE_HOME
/u02/oracle/TEST/apps/tech_st/10.1.2
appltest@TEST21:~$ sqlplus apps/TEST
SQL*Plus: Release 10.1.0.5.0 - Production on Thu Apr 8 18:06:20 2021
Copyright (c) 1982, 2005, Oracle.
All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
SQL> exec FND_STATS.GATHER_SCHEMA_STATISTICS('ALL', 10, 16,
'NOBACKUP', NULL, 'LASTRUN', 'GATHER AUTO', 10, 'N');
PL/SQL procedure successfully completed.
appltest@TEST21:…apps/TEST_TEST21/admin/scripts$ sqlplus apps/TEST
SQL*Plus: Release 10.1.0.5.0 - Production on Thu May 6 17:33:27 2021
Copyright (c) 1982, 2005, Oracle.
All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
SQL> select value from v$parameter where name='utl_file_dir';
VALUE
--------------------------------------------------------------------------------
/u02/oracle/TEST/db/19.0.0/temp/TEST
Note : Make sure the APPLPTMP is set to the value returned in the above
query.
appltest@TEST21:…01/oracle/TEST/fs1/EBSapps/appl$ cd /u01/oracle/TEST/fs1/EBSapps/appl
appltest@TEST21:…01/oracle/TEST/fs1/EBSapps/appl$ . APPSTEST_TEST21.env
appltest@TEST21:…01/oracle/TEST/fs1/EBSapps/appl
echo $APPLPTMP
/u02/oracle/TEST/db/19.0.0/temp/TEST
Install
JRE on the database tier (conditional)
oratest@TEST21:…/oracle/TEST/db/19.0.0/dbhome_1$ cd
$ORACLE_HOME/appsutil
oratest@TEST21:…BA/db/19.0.0/dbhome_1/appsutil$ cp -r
$ORACLE_HOME/jdk/jre .
oratest@TEST21:…BA/db/19.0.0/dbhome_1/appsutil$ cp $ORACLE_HOME/jlib/orai18n.jar
$ORACLE_HOME/appsutil/jre/lib/ext
oratest@TEST21:…BA/db/19.0.0/dbhome_1/appsutil$
Perform
a system backup
Backup apps and DB
before applying 12.2 upgrade driver :
Create Guranteed
Restore point in PDB Level:
SQL> CREATE RESTORE POINT PDB_bef_r122_upgrade_driver FOR PLUGGABLE
DATABASE TEST GUARANTEE FLASHBACK DATABASE;
Additionally take DB
incremental backup through RMAN :
$cd /u03/oracle/scripts
$ nohup rman cmdfile=rman_incr_bkp_19c.rcv log=rman_incr_bkp_19c.log
&
Backup Apps Codesets
:
$cd /u01/oracle/TEST
$ tar -zcvf TEST_r122_b4_upg_driver.tar.gz fs1 fs2 fs_ne
5.
Performing the
Upgrade to Release 12.2.0
Run EBS upgrade Checker
oratest@TEST21:…me_1/network/admin/TEST_TEST21$ cd /u03/oracle/patches/12_2_upg_patches/DB/eurc-dt
oratest@TEST21:…tches/12_2_upg_patches/eurc-dt$ . /u02/oracle/TEST/db/19.0.0/dbhome_1/TEST_TEST21.env
oratest@TEST21:…tches/12_2_upg_patches/eurc-dt$ perl eurc_dt.pl
Logs will be created under /u03/oracle/patches/12_2_upg_patches/eurc-dt/TEST_eurc-dt/
Apply the suggested
recommendations in EURC-DT :
Execute the below command as 'SYSDBA'
user to gather the stale stats. This increases the performance of the upgrade.
$ sqlplus / as sysdba
SQL> begin
dbms_stats.gather_schema_stats('SYS',options=>'GATHER
STALE',estimate_percent => $DBMS_STATS.AUTO_SAMPLE_SIZE,method_opt =>
'FOR ALL COLUMNS SIZE AUTO',
cascade => TRUE);$ end;
/
Disable
AOL Audit Trail
Disable Audit_trail parameter :
SQL> ALTER SYSTEM SET audit_trail=NONE
SCOPE=BOTH;
If you use the Oracle
Applications Object Library Audit Trail feature, then you must disable it
before the upgrade.
- From the System
Administrator responsibility under the R12.0 or 12.1 APPL_TOP, navigate to
Security > Audit Trail > Groups.
- In the Audit Groups
window, set the Group State field to
‘Disable - Prepare for Archive’ for
each audit group defined
- Run the Audit Trail
Update Tables report from the Submit Requests window (Requests > Run).
Navigation: System Administrator -> Security
-> AuditTrail -> Groups
Set the value Group state field set to: Disable prepare for Archive for each
defined group.
- Run the Audit Trail
Update Tables report from the Submit Requests window (Requests > Run).
Shut
down application tier listeners and concurrent managers
$ cd $ADMIN_SCRIPTS_HOME
$ ./adstpall.sh apps/<pwd>
Setup
DB Profiles
Set FAILED_LOGIN_ATTEMPTS to UNLIMITED for Oracle E-Business Suite schema
$ cd /u03/oracle/scripts
SQL> alter session set container=TEST;
Session altered.
SQL> set lines 300
set pages 300
col PROFILE for a40
col RESOURCE_NAME for a40
col RESOURCE_TYPE for a30
col LIMIT for a30
col COMMON for a10
SQL> spool
before_upgrade_profile_details.log
SQL> select * from dba_profiles;
SQL> alter profile AD_PATCH_MONITOR_PROFILE limit
FAILED_LOGIN_ATTEMPTS UNLIMITED;
Profile altered.
SQL> select profile from dba_profiles where
resource_name='FAILED_LOGIN_ATTEMPTS';
Disable custom triggers, constraints, indexes, business
events, and VPD
Invalid Objects :
$sqlplus / as sysdba
SQL> alter session set container=TEST;
SQL> set pages 100
set lines 100
col owner format a30
col object_name format a30
col object_type format a30
SQL> spool /u03/oracle/scripts/invlalids_totalcount_b4upgrade.log
select owner,count(*) from dba_objects where status='INVALID' group by
owner;
select object_name,object_type,owner from dba_objects where
status='INVALID';
SQL> spool off;
SQL> exit;
$sqlplus / as sysdba
SQL> alter session set container=TEST;
SQL> set lines 200
set pages 100
col OWNER for a20
col OBJECT_NAME for a40
col OBJECT_TYPE for a40
col STATUS for a20
SQL> spool /u03/oracle/scripts/Total_objects_Invalids_b4upgrade.log
SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE,STATUS from dba_objects
where status='INVALID';
SQL> spool off;
SQL> exit;
Create Disable INDEX script
$sqlplus / as sysdba
SQL> alter session set container=TEST;
SQL> spool
/u03/oracle/scripts/customindexdetails.log
col TABLE_OWNER for a12
col TABLE_NAME for a30
col COLUMN_NAME for a20
col owner for a12
col INDEX_NAME for a40
set lines 450
set pages 2000
select TABLE_OWNER,TABLE_NAME,owner,INDEX_NAME from dba_indexes where
index_name like 'XX%' or index_name like 'TEST%';
SQL> spool off;
SQL> exit;
$sqlplus / as sysdba
SQL> alter session set container=TEST;
set lines 450
set pages 2000
SQL> spool /u03/oracle/scripts/customindex_disable.sql
select 'ALTER INDEX '||OWNER||'.'||INDEX_NAME||' UNUSABLE;' from dba_indexes
where index_name like 'XX%' or index_name like 'TEST_%';
SQL> spool off;
Create Disable Constrain script
$sqlplus / as sysdba
SQL> alter session set container=TEST;
SQL> spool /u03/oracle/scripts/customconstraindetails.log
col owner for a12
col CONSTRAINT_NAME for a30
col TABLE_NAME for a30
set lines 450
set pages 2000
select owner,CONSTRAINT_NAME,CONSTRAINT_TYPE,TABLE_NAME,STATUS from dba_constraints
where CONSTRAINT_NAME like 'XX%' or CONSTRAINT_NAME like 'TEST_%';
SQL> spool off;
SQL> exit;
$sqlplus / as sysdba
SQL> alter session set container=TEST;
SQL> spool /u03/oracle/scripts/custom_constraint_disable.sql
set lines 300
set pages 300
select 'ALTER TABLE '||OWNER||'.'||TABLE_NAME||' DISABLE CONSTRAINT
'||CONSTRAINT_NAME||';' from dba_constraints where CONSTRAINT_NAME like 'XX%'
or CONSTRAINT_NAME like 'TEST_%';
Create Disable Trigger script
$sqlplus / as sysdba
SQL> alter session set container=TEST;
SQL> spool /u03/oracle/scripts/customTriggerdetails.log
col owner for a12
col TRIGGER_NAME for a30
col TABLE_NAME for a30
set lines 450
set pages 2000
select OWNER,TRIGGER_NAME,TRIGGER_TYPE,TABLE_NAME,STATUS from dba_triggers
where trigger_name like 'XX%' or trigger_name like 'TEST_%';
SQL> spool off;
SQL> spool /u03/oracle/scripts/customTrigger_disable.sql
SQL> select 'ALTER TRIGGER '||OWNER||'.'||TRIGGER_NAME||' DISABLE;'
from dba_triggers where trigger_name like 'XX%' or trigger_name like 'TEST_%';
Execute the disable scripts:
Modify the Disable scripts with below details:
$ sqlplus / as sysdba
SQL> alter session set container=TEST;
SQL> spool disable_index.log
SQL> @customindex_disable.sql
SQL> spool disable_Trigger.log
SQL> @customTrigger_disable.sql
SQL> spool disable_constraint.log
SQL> @custom_constraint_disable.sql
SQL> spool off;
SQL> exit;
Compile
invalid objects
SQL> exec sys.utl_recomp.recomp_parallel
PL/SQL procedure successfully completed.
Rebuild
unusable indices
alter index index_owner.index_name rebuild
Search for failed domain indices and fix them:
You can identify failed domain indices and
fix them with the following command:
select index_name,index_type,owner,table_name,table_owner,
domidx_opstatus from TEST_indexes where domidx_opstatus in
('UNUSABLE','FAILED','LOADING');
Refresh
materialized view
Execute
the below Query to find Materialized Views to be refreshed :
oratest@TEST21:~$ sqlplus / as
sysdba
SQL>
alter session set nls_date_Format = 'hh24:mi:ss dd.mm.yyyy';
SQL>
select mview_name, last_refresh_date, last_refresh_end_time from all_mviews
where
last_refresh_date IS NULL;
Execute
the below Query to Refresh MVIEW :
SQL>
DECLARE
v_number_of_failures
NUMBER(12) := 0;
BEGIN
DBMS_MVIEW.REFRESH_ALL_MVIEWS(v_number_of_failures,'C','',
TRUE, FALSE);
END;
/
Back
up the database
Create Guranteed Restore point :
Below restore point created before
applying 12.2.0 upgrade driver
CREATE RESTORE POINT
PDB_bef_r122_upgrade_driver FOR PLUGGABLE DATABASE TEST GUARANTEE FLASHBACK
DATABASE;
Run the below and take RMAN Backup :
$ nohup rman cmdfile=rman_incr_bkp_19c.rcv log=rman_incr_bkp_19c.log
&
Enable
Maintenance Mode
appltest@TEST21:…atches/12_1_3_patches/31026891$ sqlplus apps/TEST
@$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE
SQL*Plus: Release 10.1.0.5.0 - Production on Fri Apr 16 16:29:57 2021
Copyright (c) 1982, 2005, Oracle.
All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
PL/SQL procedure successfully completed.
Commit complete.
apply
preinstall Patches for 12.2.0 Upgrade
Merge the Patches below and apply in 12.2 Run FS:
Patch 10117518 (Patch R12.AD.C: Oracle Application TEST
12.2 PATCH)
Patch 30370733
(ORACLE APPLICATIONS TEST CONSOLIDATED UPGRADE PATCH 11 (CUP11) FOR R12.2.0 )
$ export PATCH_TOP=/u03/oracle/patches/12_2_upg_patches
$ mkdir -p $PATCH_TOP/12_2_upg/10117518_CUP11
appltest@TEST21:…ches/12_2_upg_patches/12_2_upg$ admrgpch -s
$PATCH_TOP/12_2_upg/AD_Source -d $PATCH_TOP/12_2_upg/10117518_CUP11 -merge_name
10117518_cup11 –admode
Executing the merge of the patch drivers
-- Processing patch:
/u03/oracle/patches/12_2_upg_patches/12_2_upg/AD_Source/30370733
-- Processing file:
/u03/oracle/patches/12_2_upg_patches/12_2_upg/AD_Source/30370733/u30370733.drv
-- Done processing file:
/u03/oracle/patches/12_2_upg_patches/12_2_upg/AD_Source/30370733/u30370733.drv
-- Done processing patch:
/u03/oracle/patches/12_2_upg_patches/12_2_upg/AD_Source/30370733
-- Processing patch:
/u03/oracle/patches/12_2_upg_patches/12_2_upg/AD_Source/10117518
-- Processing file:
/u03/oracle/patches/12_2_upg_patches/12_2_upg/AD_Source/10117518/u10117518.drv
-- Done processing file:
/u03/oracle/patches/12_2_upg_patches/12_2_upg/AD_Source/10117518/u10117518.drv
-- Done processing patch:
/u03/oracle/patches/12_2_upg_patches/12_2_upg/AD_Source/10117518
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.
appltest@TEST21:…ches/12_2_upg_patches/12_2_upg$
Patch 10117518
(Patch R12.AD.C: Oracle Application TEST 12.2 PATCH)
- Apply the merged patch driver in its entirety following the
Pre-Install and Post-Install Tasks of R12.AD.C (patch#10117518) .
Pre- requisistes :
Run the adgrants.sql script
as a user that can connect as SYSDBA to grant privileges to selected SYS
objects and create PL/SQL profiler objects.
$ cp
/u03/oracle/patches/12_2_upg_patches/12_2_upg/AD_Source/10117518/admin/adgrants.sql
$ORACLE_HOME/appsutil/admin/adgrants_10117518.sql
oratest@TEST21:~$ . CDBTEST_TEST21.env
oratest@TEST21:~$ export ORACLE_PDB_SID=TEST
$ sqlplus /nolog
SQL> conn / as sysdba
SQL> @$ORACLE_HOME/appsutil/admin/adgrants_10117518.sql APPS
Apply Patch :
appltest@TEST21:…atches/12_2_upg/10117518_CUP11$ cd
/u03/oracle/patches/12_2_upg_patches/12_2_upg/10117518_CUP11
appltest@TEST21:…atches/12_2_upg/10117518_CUP11$ ls -ltr
total 6810
drwxr-xr-x 13 appltest TEST
13 Apr 12 17:08 ad
drwxr-xr-x 7 appltest TEST 7 Apr 12 17:08 fnd
-rw-r--r-- 1 appltest TEST
1531771 Apr 12 17:08 j10117518_ad.zip
-rw-r--r-- 1 appltest TEST
767174 Apr 12 17:08 j10117518_fnd.zip
-rw-r--r-- 1 appltest TEST
228858 Apr 12 17:08 j30370733_fnd.zip
drwxr-xr-x 2 appltest TEST 4 Apr 12 17:08 metadata_files
drwxr-xr-x 2 appltest TEST
112 Apr 12 17:08 admin
-rw-r--r-- 1 appltest TEST
11041 Apr 12 17:08 10117518_README.html
-rw-r--r-- 1 appltest TEST
8110 Apr 12 17:08 10117518_README.txt
-rw-r--r-- 1 appltest TEST
160061 Apr 12 17:08 b10117518.ldt
-rw-r--r-- 1 appltest TEST
176802 Apr 12 17:08 f10117518.ldt
-rw-r--r-- 1 appltest TEST
3038 Apr 12 17:08 30370733_README.html
-rw-r--r-- 1 appltest TEST
21 Apr 12 17:08 30370733_README.txt
-rw-r--r-- 1 appltest TEST
12543 Apr 12 17:08 b30370733.ldt
-rw-r--r-- 1 appltest TEST
11048 Apr 12 17:08 f30370733.ldt
-rw-r--r-- 1 appltest TEST
476643 Apr 12 17:08 u_10117518_cup11.drv
appltest@TEST21:…atches/12_2_upg/10117518_CUP11$ pwd
/u03/oracle/patches/12_2_upg_patches/12_2_upg/10117518_CUP11
appltest@TEST21:…atches/12_2_upg/10117518_CUP11$ time adpatch
Workers used : 14
real
9m50.51s
user
2m15.93s
sys
0m22.51s
Post Install Tasks :
1. Run adadmin -> Compile/Reload
Applications Database Entities menu ->
Compile APPS schema.
2. Type "No" when prompt for Run Invoker Rights processing in
incremental mode [No] ?
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
Enter your choice [6] : 3
Compile/Reload
Applications Database Entities
---------------------------------------------------
1.
Compile APPS schema
2. Compile menu information
3. Compile flexfields
4. Reload JAR files to database
5. Return to Main Menu
Enter your choice [5] : 1
AD utilities can support a maximum of 999 workers. Your
current database configuration supports a maximum of 31 workers.
Oracle recommends that you use between 15 and 31 workers.
Enter the number of workers [15] :
Run Invoker Rights processing in incremental mode [No] ? No
Run utlrp on both CDB and PDB
SQL> @?/rdbms/admin/utlrp.sql
Apply the Consolidated Upgrade Patch (CUP) for
Release 12.2.0 (Patch 30399970:12.2.0) in pre-installation mode
on the run edition file system.
$cd /u03/oracle/patches/12_2_upg_patches/12_2_upg/30399970
$ time adpatch preinstall=y
Is Oracle E-Business Suite installed for commercial or for-profit use
[Yes] ?
Enter a list of language codes
[US]
real 7m24.61s
user 3m30.33s
sys 1m36.44s
Patch creates preinstall directory under $APPL_TOP/admin/$TWO_TASK
$ cd /u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/preinstall
appltest@TEST21:…apps/appl/admin/TEST/preinstall$ ls -ltr
total 683
-rw-r--r-- 1 appltest TEST
342151 Apr 13 11:22 u30399970.drv
Oracle E-Business Suite
Preinstall Patches Report :
Apply the below prerequisite patches in
Preinstall Mode :
Patch 31219447:R12.PA.C
Patch 31745734:R12.FND.C
$ cd
/u03/oracle/patches/12_2_upg_patches/12_2_upg/31219447
$ time adpatch preinstall=y
real
0m19.99s
user 0m0.32s
sys
0m0.42s
$ cd
/u03/oracle/patches/12_2_upg_patches/12_2_upg/31745734
$ time adpatch preinstall=y
real
0m14.68s
user
0m0.32s
sys
0m0.39s
Additionally Apply the below prerequisite
patches in Preinstall Mode :
18007406 - ORACLE E-BUSINESS SUITE
CONSOLIDATED UPGRADE PATCH 5 (CUP5) FOR R12.2.0
This Patch has been Superseded.(Replaced
by CUP11 PAtch 30399970)
18973713 - UPGRADE SCRIPT DELETES
THE CATEGORY WITH CATEGORY_ID 10000
19391190 - CODE: WRONG UPDATE ON
HZ_ORGANIZATION_PROFILES IN APSTCA01.SQL
19601460 - QRE:GSIUPG:VIEW
FAILURE:MSD:MSDSVW06.SQL
19807467 - FIX PERFORMANCE OF LONG
RUNNING NEW SQLS IN XLAAXUAR.SQL
20226747 - SQL 3012796.SQL RUNNING
LONG ON DRIVER PATCH
20366382 - ONT00161.SQL: Using AD Parallel for better
performance and new checkfile equivalence so that the script is not executed if
already executed before
18792770 - XLEUPG01.SQL FAILING
R12.2 UPGRA
18995966 - JL.SQL:SKIPPED JOB:
JLZZMIGAWTDIST.SQL ON JL_ZZ_AP_INV_DIS_WH_ALL_TI
19503850 - CSM12.2.0: FAILURE IN CSMCSMA.ODF
DUE TO INDEX CSM_PO_LOC_ASS_ALL_ACC_U1
19730774 -
PAY_33193_UPG_CANNOT_ENABLE ERROR on PYSAGUPUDT.LDT in 12.2 Upgrade
20018655 - UPGRADE TO 12.2:
AR120TRXPSA.SQL PERF AND ORA-00001 RUNNING MULTIPLE WORKERS
20280791 - RCA:
XLA_DISTRIBUTION_LINKS TABLE NOT GETTING POPULATED FOR MANUAL PAY ADJ EVENT
20526716 - 122: DELIVER SCRIPT TO
UPGRADE SPWL SEED TABLES
18951016 - Performance Issue
encountered on multi Fund Accounting Upgrade AR120TRXPSA.SQL
19080116 - PERFORMANCE PROBLEM
WITH APXLAUPG.SQL SCRIPT DURING R12.2.2 UPGRADE
19584199 - Upgrade to 12.2 fails
on pyfkbal.sql and pyfkteng.sql
1972136 - ADZDPMAN.SQL REPORTS
ERROR WITH IBY_TRXN_SUMMARIES_ALL.INITIATOR_EXTENSION_ID#1
20179510 - TRACKING BUG TO STUB
OUT PATRXINTDEL.SQL ON 12.2.X CODE LINE
20293834 - JAI_DF_3848220.SQL IS
RUNNING FOR MORE THAN 14 HOURS
appltest@TEST21:…2_upg/Consolidated_upg_patches$
pwd
/u03/oracle/patches/12_2_upg_patches/12_2_upg/Consolidated_upg_patches
appltest@TEST21:…2_upg/Consolidated_upg_patches$
ls -ltr
total 778
-rw-r--r-- 1 appltest
TEST 7435 Apr 13 12:56
p20366382_R12.ONT.C_R12_GENERIC.zip
-rw-r--r-- 1 appltest
TEST 12601 Apr 13 12:56
p18995966_R12.JL.C_R12_GENERIC.zip
-rw-r--r-- 1 appltest
TEST 1973 Apr 13 12:56
Consolidated_patches.txt
-rw-r--r-- 1 appltest
TEST 9061 Apr 13 12:56
p20526716_R12.PAY.C_R12_GENERIC.zip
-rw-r--r-- 1 appltest
TEST 9305 Apr 13 12:56
p20293834_R12.JAI.C_R12_GENERIC.zip
-rw-r--r-- 1 appltest
TEST 14599 Apr 13 12:56
p20280791_R12.AP.C_R12_GENERIC.zip
-rw-r--r-- 1 appltest
TEST 9391 Apr 13 12:56
p20226747_R12.ITM.D_R12_GENERIC.zip
-rw-r--r-- 1 appltest
TEST 6046 Apr 13 12:56
p20179510_R12.PJC.C_R12_GENERIC.zip
-rw-r--r-- 1 appltest
TEST 17770 Apr 13 12:56
p20018655_R12.AR.C_R12_GENERIC.zip
-rw-r--r-- 1 appltest
TEST 37034 Apr 13 12:56
p19807467_R12.XLA.C_R12_GENERIC.zip
-rw-r--r-- 1 appltest
TEST 13827 Apr 13 12:56
p1972136_R12.IBY.C_R12_GENERIC.zip
-rw-r--r-- 1 appltest
TEST 9275 Apr 13 12:56
p19730774_R12.PAY.C_R12_GENERIC.zip
-rw-r--r-- 1 appltest
TEST 42577 Apr 13 12:56
p19601460_R12.MSD.C_R12_GENERIC.zip
-rw-r--r-- 1 appltest
TEST 10673 Apr 13 12:56
p19584199_R12.PAY.C_R12_GENERIC.zip
-rw-r--r-- 1 appltest
TEST 8831 Apr 13 12:56
p19503850_R12.CSM.C_R12_GENERIC.zip
-rw-r--r-- 1 appltest
TEST 22276 Apr 13 12:56
p19391190_R12.AP.C_R12_GENERIC.zip
-rw-r--r-- 1 appltest
TEST 13765 Apr 13 12:56
p19080116_R12.AP.C_R12_GENERIC.zip
-rw-r--r-- 1 appltest
TEST 6587 Apr 13 12:56
p18973713_R12.AMS.C_R12_GENERIC.zip
-rw-r--r-- 1 appltest
TEST 17429 Apr 13 12:56
p18951016_R12.AR.C_R12_GENERIC.zip
-rw-r--r-- 1 appltest
TEST 6992 Apr 13 12:56
p18792770_R12.XLE.C_R12_GENERIC.zip
appltest@TEST21:…2_upg/Consolidated_upg_patches$
unzip 'p*zip'
appltest@TEST21:…2_upg/Consolidated_upg_patches$
admrgpch -s . -d . -merge_name Consolidate_pre_ins
Executing the merge of the patch
drivers
-- Processing patch: ./18973713
-- Processing file: ./18973713/u18973713.drv
-- Done processing file:
./18973713/u18973713.drv
-- Done processing patch: ./18973713
-- Processing patch: ./19391190
-- Processing file: ./19391190/u19391190.drv
-- Done processing file:
./19391190/u19391190.drv
-- Done processing patch: ./19391190
-- Processing patch: ./19807467
-- Processing file: ./19807467/u19807467.drv
-- Done processing file:
./19807467/u19807467.drv
-- Done processing patch: ./19807467
-- Processing patch: ./19730774
-- Processing file: ./19730774/u19730774.drv
-- Done processing file:
./19730774/u19730774.drv
-- Done processing patch: ./19730774
-- Processing patch: ./19503850
-- Processing file: ./19503850/u19503850.drv
-- Done processing file: ./19503850/u19503850.drv
-- Done processing patch: ./19503850
-- Processing patch: ./19080116
-- Processing file: ./19080116/u19080116.drv
-- Done processing file:
./19080116/u19080116.drv
-- Done processing patch: ./19080116
-- Processing patch: ./18995966
-- Processing file: ./18995966/u18995966.drv
-- Done processing file:
./18995966/u18995966.drv
-- Done processing patch: ./18995966
-- Processing patch: ./20526716
-- Processing file: ./20526716/u20526716.drv
-- Done processing file: ./20526716/u20526716.drv
-- Done processing patch: ./20526716
-- Processing patch: ./20280791
-- Processing file: ./20280791/u20280791.drv
-- Done processing file:
./20280791/u20280791.drv
-- Done processing patch: ./20280791
-- Processing patch: ./19584199
-- Processing file: ./19584199/u19584199.drv
-- Done processing file:
./19584199/u19584199.drv
-- Done processing patch: ./19584199
-- Processing patch: ./20366382
-- Processing file: ./20366382/u20366382.drv
-- Done processing file:
./20366382/u20366382.drv
-- Done processing patch: ./20366382
-- Processing patch: ./1972136
-- Processing file: ./1972136/u1972136.drv
-- Done processing file: ./1972136/u1972136.drv
-- Done processing patch: ./1972136
-- Processing patch: ./20179510
-- Processing file: ./20179510/u20179510.drv
-- Done processing file:
./20179510/u20179510.drv
-- Done processing patch: ./20179510
-- Processing patch: ./20293834
-- Processing file: ./20293834/u20293834.drv
-- Done processing file: ./20293834/u20293834.drv
-- Done processing patch: ./20293834
-- Processing patch: ./19601460
-- Processing file: ./19601460/u19601460.drv
-- Done processing file:
./19601460/u19601460.drv
-- Done processing patch: ./19601460
-- Processing patch: ./18792770
-- Processing file: ./18792770/u18792770.drv
-- Done processing file:
./18792770/u18792770.drv
-- Done processing patch: ./18792770
-- Processing patch: ./20226747
-- Processing file: ./20226747/u20226747.drv
-- Done processing file:
./20226747/u20226747.drv
-- Done processing patch: ./20226747
-- Processing patch: ./20018655
-- Processing file: ./20018655/u20018655.drv
-- Done processing file:
./20018655/u20018655.drv
-- Done processing patch: ./20018655
-- Processing patch: ./18951016
-- Processing file: ./18951016/u18951016.drv
-- Done processing file:
./18951016/u18951016.drv
-- Done processing patch: ./18951016
Copying files...
Character-set converting files...
19 unified drivers merged.
Patch merge completed successfully
Please check the log file at
./admrgpch.log.
-rw-r--r-- 1 appltest
TEST 14451 Apr 13 13:04
u_Consolidate_pre_ins.dr
-rw-r--r-- 1 appltest
TEST 52567 Apr 13 13:04
admrgpch.log
$ cd /u03/oracle/patches/12_2_upg_patches/12_2_upg/Consolidated_upg_patches
$ time adpatch preinstall=y
driver=u_Consolidate_pre_ins.drv logfile=u_Consolidate_pre_ins_TEST.log
real
0m20.01s
user
0m0.33s
sys
0m0.42s
Merge Patch Drivers
- Now merge the patch
drivers from the preinstall patches with the main upgrade
driver:
- Review the contents of the
$APPL_TOP/admin/$TWO_TASK/preinstall directory and ensure that only the
patch drivers of the desired preinstall patches are present in the
directory
appltest@TEST21:…2_upg/Consolidated_upg_patches$ cd
$APPL_TOP/admin/$TWO_TASK/preinstall
appltest@TEST21:…apps/appl/admin/TEST/preinstall$ ls -ltr
total 728
-rw-r--r-- 1 appltest TEST
342151 Apr 13 11:22 u30399970.drv
-rw-r--r-- 1 appltest TEST
1323 Apr 13 12:05 u31219447.drv
-rw-r--r-- 1 appltest TEST
1292 Apr 13 12:06 u31745734.drv
-rw-r--r-- 1 appltest TEST
14451 Apr 13 13:08 u_Consolidate_pre_ins.drv
Backup Preinstall
Directory :
appltest@TEST21:…TEST/fs1/EBSapps/appl/admin/TEST$ cd /u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST
appltest@TEST21:…TEST/fs1/EBSapps/appl/admin/TEST$ cp -pr
preinstall/ preinstall_orig
Merge the patch drivers present in
the $APPL_TOP/admin/$TWO_TASK/preinstall directory with the Release 12.2
upgrade driver
Backup Upgrade Driver
before Merge :
appltest@TEST21:…ppl/au/12.0.0/patch/115/driver$ cd
$AU_TOP/patch/115
appltest@TEST21:…Sapps/appl/au/12.0.0/patch/115$ cp -pr
driver driver_b4_1220_upgrade_driver
appltest@TEST21:…Sapps/appl/au/12.0.0/patch/115$ cd $AU_TOP/patch/115/driver
appltest@TEST21:…ppl/au/12.0.0/patch/115/driver$ admrgpch -d
. -preinstall -master u10124646.drv
Executing the merge of the patch drivers
-- Processing file:
/u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/preinstall/u30399970.drv
-- Done processing
file: /u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/preinstall/u30399970.drv
-- Processing file:
/u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/preinstall/u_Consolidate_pre_ins.drv
-- Done processing
file: /u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/preinstall/u_Consolidate_pre_ins.drv
-- Processing file:
/u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/preinstall/u31745734.drv
-- Done processing
file: /u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/preinstall/u31745734.drv
-- Processing file:
/u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/preinstall/u31219447.drv
-- Done processing
file: /u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/preinstall/u31219447.drv
-- Processing file:
u10124646.drv
-- Done processing
file: u10124646.drv
5 unified drivers
merged.
Patch merge completed successfully
Please check the log file at ./admrgpch.log.
Note: By default, the merged driver is created
in the specified destination directory with the name "u_merged.drv".
Extra Fixes for 12.2.0 Upgrade
Fix #1 :
$ cd $APPL_TOP
$ vi TEST_TEST21.env
Double check the environment variables below and make sure DB TNS are
set properly.
$ echo $AD_APPS_JDBC_URL
$ echo $APPS_JDBC_URL
appltest@TEST21:…atches/12_2_upg/10117518_CUP11$ env|grep -i jdbc
AD_APPS_JDBC_URL=(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=TEST21)(PORT=1524)))(CONNECT_DATA=(SERVICE_NAME=TEST)))
APPS_JDBC_URL=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=TEST21)(PORT=1524)))(CONNECT_DATA=(SERVICE_NAME=TEST)))
Note : Make sure apps user is
able to connect to database through sqlplus
Fix #2 :
SQL> SELECT APPLICATION_ID, ALERT_ID, NAME, count(*)
FROM ALR.ALR_ALERT_OUTPUTS
GROUP BY APPLICATION_ID, ALERT_ID, NAME
HAVING count(*)>1;
APPLICATION_ID ALERT_ID NAME COUNT(*)
-------------- ----------
------------------------------ ----------
160 101022 USER_EMAIL 2
160 101022 SYSDATE 2
Perform the below if duplicates returned in the above query.
CREATE TABLE ALR.ALR_ALERT_OUTPUTS_bkp AS SELECT * FROM
ALR.ALR_ALERT_OUTPUTS ;
UPDATE ALR.ALR_ALERT_OUTPUTS SET alert_id = (select max(ALERT_id)+1 from
ALR.ALR_ALERT_OUTPUTS )
where ALERT_ID = 101022
and name = 'SYSDATE'
and APPLICATION_ID=160
and END_DATE_ACTIVE IS NULL;
UPDATE ALR.ALR_ALERT_OUTPUTS SET
alert_id = (select max(ALERT_id)+1 from ALR.ALR_ALERT_OUTPUTS )
where ALERT_ID = 101022
and name = 'USER_EMAIL'
and APPLICATION_ID=160
and END_DATE_ACTIVE IS NULL;
commit;
SQL> SELECT APPLICATION_ID,
ALERT_ID, NAME, count(*)
FROM ALR.ALR_ALERT_OUTPUTS
GROUP BY APPLICATION_ID, ALERT_ID, NAME
HAVING count(*)>1;
no rows selected
Apply 12.2.0 Upgrade Driver
appltest@TEST21:…ppl/au/12.0.0/patch/115/driver$ cd
$AU_TOP/patch/115/driver
appltest@TEST21:…ppl/au/12.0.0/patch/115/driver$ ls -ltr
total 358974
-rwxr-xr-x 1 appltest TEST
755 Nov 26 2012 ausstats.drvx
-rw-r--r-- 1 appltest TEST
83457873 Nov 28 2012
u10124646.drv
-rw-r--r-- 1 appltest TEST
14305818 Nov 28 2012
u10201000.drv
-rwxr-xr-x 1 appltest TEST
242 Apr 13 11:16 augenmsg.drvx
-rw-r--r-- 1 appltest
TEST 83856541 Apr 13 15:36
u_merged.drv
-rw-r--r-- 1 appltest TEST
5470 Apr 13 15:36 admrgpch.log
appltest@TEST21:…ppl/au/12.0.0/patch/115/driver$ time adpatch
options=nocopyportion,nogenerateportion
Do you want to run AutoPatch with these actions turned off
[Yes] ?
Workers : 15
AutoPatch is complete.
AutoPatch may have written informational messages to the
file
/u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/log/u_merged_upg_driver_TEST.lgi
Errors and warnings are listed in the log file
/u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/log/u_merged_upg_driver_TEST.log
and in other log files in the same directory.
real 9h12m40.43s
user 1h42m11.48s
sys 11m52.91s
SQL> select release_name from fnd_product_groups;
RELEASE_NAME
--------------------------------------------------
12.2.0
Disable
maintenance mode (required)
$ sqlplus apps/TEST @$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE
Back
up Oracle E-Business Suite (recommended)
Perform a full Oracle E-Business Suite backup
of the application and database.
Guranteed Restore point :
Below restore point created after
applying 12.2.0 upgrade driver
SQL> CREATE RESTORE POINT
PDB_aft_r122_upgrade_driver FOR PLUGGABLE DATABASE TEST GUARANTEE FLASHBACK
DATABASE;
$ nohup rman cmdfile=rman_full_bkp_19c.rcv log=rman_full_bkp_19c.log
&
$ tar -zcvf TEST_r122_aft_upg_driver.tar.gz fs1 fs2 fs_ne
Recreate
appsutil in DB Tier
appltest@TEST21:/u01/oracle/TEST/archivelog$
perl $AD_TOP/bin/admkappsutil.pl
Starting the generation of appsutil.zip
Log file located at /u01/oracle/TEST/fs1/inst/apps/TEST_TEST21/admin/log/MakeAppsUtil_04141441.log
output located at /u01/oracle/TEST/fs1/inst/apps/TEST_TEST21/admin/out/appsutil.zip
MakeAppsUtil completed successfully.
appltest@TEST21:/u01/oracle/TEST/archivelog$ cp /u01/oracle/TEST/fs1/inst/apps/TEST_TEST21/admin/out/appsutil.zip
/tmp
oratest@TEST21:…/oracle/TEST/db/19.0.0/dbhome_1$ cd $ORACLE_HOME
oratest@TEST21:…/oracle/TEST/db/19.0.0/dbhome_1$ cp -pr appsutil
appsutil_b4_upg_driver
oratest@TEST21:…/oracle/TEST/db/19.0.0/dbhome_1$ cp /tmp/appsutil.zip
$ORACLE_HOME
oratest@TEST21:…/oracle/TEST/db/19.0.0/dbhome_1$ unzip -o appsutil.zip
Install JRE on the database
tier
oratest@TEST21:…/oracle/TEST/db/19.0.0/dbhome_1$ cd
$ORACLE_HOME/appsutil/jre/lib/ext
oratest@TEST21:…/dbhome_1/appsutil/jre/lib/ext$ ls -ltr
total 18994
-rwxr-xr-- 1 oratest TEST
283206 Apr 8 19:17 sunpkcs11.jar
-rwxr-xr-- 1 oratest TEST
43191 Apr 8 19:17 sunec.jar
-rwxr-xr-- 1 oratest TEST
3860563 Apr 8 19:17 cldrdata.jar
-rwxr-xr-- 1 oratest TEST
44516 Apr 8 19:17 jaccess.jar
-rwxr-xr-- 1 oratest TEST
815 Apr 8 19:17 meta-index
-rwxr-xr-- 1 oratest TEST
1179462 Apr 8 19:17
localedata.jar
-rwxr-xr-- 1 oratest TEST
8286 Apr 8 19:17 dnsns.jar
-rwxr-xr-- 1 oratest TEST
69303 Apr 8 19:17 zipfs.jar
-rwxr-xr-- 1 oratest TEST
285868 Apr 8 19:17
sunjce_provider.jar
-rwxr-xr-- 1 oratest TEST
76298 Apr 8 19:17 ucrypto.jar
-rwxr-xr-- 1 oratest TEST
2024156 Apr 8 19:17 nashorn.jar
-rwxr-xr-- 1 oratest TEST
1661488 Apr 8 19:18 orai18n.jar
oratest@TEST21:…BA/db/19.0.0/dbhome_1/appsutil$ cp -r
$ORACLE_HOME/jdk/jre $ORACLE_HOME/appsutil
oratest@TEST21:…BA/db/19.0.0/dbhome_1/appsutil$ cp
$ORACLE_HOME/jlib/orai18n.jar
$ORACLE_HOME/appsutil/jre/lib/ext
Set and export the following environment variables
export ORACLE_HOME=/u02/oracle/TEST/db/19.0.0/dbhome_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib
export ORACLE_PDB_SID=TEST
export TNS_ADMIN=/u02/oracle/TEST/db/19.0.0/dbhome_1/network/admin/TEST_TEST21
export DB_LISTENER=CDBTEST
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:/usr/bin:/usr/sbin:$ORACLE_HOME/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:$PATH
export PERL5LIB=$ORACLE_HOME/perl/lib/5.28.1:$ORACLE_HOME/perl/lib/site_perl/5.28.1:$ORACLE_HOME/appsutil/perl
oratest@TEST21:~$
lsnrctl status CDBTEST
LSNRCTL for
Solaris: Version 19.0.0.0.0 - Production on 29-APR-2021 15:50:23
Copyright (c) 1991,
2020, Oracle. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TEST21.ebs.com)(PORT=1524)))
STATUS of the
LISTENER
------------------------
Alias CDBTEST
Version TNSLSNR for Solaris: Version
19.0.0.0.0 - Production
Start Date 22-APR-2021 11:45:25
Uptime 7 days 4 hr. 4 min. 57 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter
File /u02/oracle/TEST/db/19.0.0/dbhome_1/network/admin/listener.ora
Listener Log
File /u02/oracle/TEST/db/19.0.0/dbhome_1/log/diag/tnslsnr/TEST21/cdbTEST/alert/log.xml
Listening Endpoints
Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TEST21.ebs.com)(PORT=1524)))
Services Summary...
Service
"6324cb1b6ae633ace05400144ffb09a0" has 1 instance(s).
Instance "CDBTEST", status READY,
has 2 handler(s) for this service...
Service "CDBTEST"
has 1 instance(s).
Instance "CDBTEST", status READY,
has 1 handler(s) for this service...
Service "CDBTESTXDB"
has 1 instance(s).
Instance "CDBTEST", status READY,
has 1 handler(s) for this service...
Service "TEST"
has 3 instance(s).
Instance "CDBTEST", status READY,
has 1 handler(s) for this service...
Instance "CDBTEST", status READY,
has 2 handler(s) for this service...
Instance "TEST", status UNKNOWN,
has 1 handler(s) for this service...
Service "TEST_ebs_patch"
has 1 instance(s).
Instance "CDBTEST", status READY,
has 2 handler(s) for this service...
Service "ebs_TEST"
has 1 instance(s).
Instance "CDBTEST", status READY,
has 2 handler(s) for this service...
Service
"ebs_patch" has 1 instance(s).
Instance "CDBTEST", status READY,
has 1 handler(s) for this service...
The command
completed successfully
Generate database context file
oratest@TEST21:~$ cd $ORACLE_HOME/appsutil
oratest@TEST21:…BA/db/19.0.0/dbhome_1/appsutil$ cp TEST_TEST21.xml TEST_TEST21.xml_aft_upg_driver
oratest@TEST21:~$ cd $ORACLE_HOME/appsutil/bin
oratest@TEST21:…b/19.0.0/dbhome_1/appsutil/bin$ perl adbldxml.pl
Starting context file generation for db tier..
Using JVM from /u02/oracle/TEST/db/19.0.0/dbhome_1/appsutil/jre/bin/java
to execute java programs..
APPS Password:
The log file for this adbldxml session is located at:
/u02/oracle/TEST/db/19.0.0/dbhome_1/appsutil/log/adbldxml_04151651.log
s_pluggable_database
: true
s_pdb_name : TEST
Enter the value for
Display Variable: TEST21:0.0
Context File /u02/oracle/TEST/db/19.0.0/dbhome_1/appsutil/TEST_TEST21.xml
already exists.
Overwriting Context File may cause loss of existing settings, hence
backing it up as: /u02/oracle/TEST/db/19.0.0/dbhome_1/appsutil/TEST_TEST21.xml.bak
The context file has been created at:
/u02/oracle/TEST/db/19.0.0/dbhome_1/appsutil/TEST_TEST21.xml
Clean Up fnd nodes
oratest@TEST21:~$ . ./CDBTEST_TEST21.env
oratest@TEST21:~$ sqlplus apps/TEST@TEST
SQL> exec fnd_conc_clone.setup_clean ;
PL/SQL procedure successfully completed.
SQL> commit;
Synchronize values of APPLPTMP
with Database Directories for PL/SQL File I/O based Concurrent Requests (required)
SQL> select value from v$parameter where name='utl_file_dir';
value
----------------------------------------------------
/u02/oracle/TEST/db/19.0.0/temp/TEST
appltest@TEST21:…as21/ora/10.1.2/network/admin$ cd $INST_TOP/appl/admin
appltest@TEST21:…st/apps/TEST_TEST21/appl/admin$ cp TEST_TEST21.xml TEST_TEST21.xml_b4_applptmp_upd
appltest@TEST21:…st/apps/TEST_TEST21/appl/admin$ vi TEST_TEST21.xml
From
<APPLPTMP oa_var="s_applptmp"
osd="UNIX">/usr/tmp</APPLPTMP>
To
<APPLPTMP oa_var="s_applptmp"
osd="UNIX">/u02/oracle/TEST/db/19.0.0/temp/TEST</APPLPTMP>
Run AutoConfig on the database tier nodes
As oratest user,
oratest@TEST21:…1/appsutil/scripts/TEST_TEST21$ $ORACLE_HOME/appsutil/bin/adconfig.sh
contextfile=/u02/oracle/TEST/db/19.0.0/dbhome_1/appsutil/TEST_TEST21.xml
oratest@TEST21:…1/appsutil/scripts/TEST_TEST21$ ./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u02/oracle/TEST/db/19.0.0/dbhome_1/appsutil/log/TEST_TEST21/04161124/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location
: /u02/oracle/TEST/db/19.0.0/dbhome_1
ERROR: Unable to set CLASSPATH
Jars and zips are missing
at the following location
ERROR: Unable to set CLASSPATH
Jars and zips are missing
at the following location
Classpath :
Version Conflicts among development maintained and customized templates
encountered; aborting AutoConfig run.
The logfile for this session is located at: /u02/oracle/TEST/db/19.0.0/dbhome_1/appsutil/log/TEST_TEST21/04161124/adconfig.log
Skipped autoconfig error for now. Ad/Txk 12 upgrade will fix autoconfig issue.
Source the Run file system
environment file
appltest@TEST21:…01/oracle/TEST/fs1/EBSapps/appl$ cd /u01/oracle/TEST/fs1/EBSapps/appl
appltest@TEST21:…01/oracle/TEST/fs1/EBSapps/appl$ . APPSTEST_TEST21.env
appltest@TEST21:…01/oracle/TEST/fs1/EBSapps/appl$ echo $FILE_EDITION
run
Drop table ADX_PRE_AUTOCONFIG
appltest@TEST21:…01/oracle/TEST/fs1/EBSapps/appl$ sqlplus apps/TEST
SQL*Plus: Release 10.1.0.5.0 - Production on Fri Apr 16 11:28:11 2021
Copyright (c) 1982, 2005, Oracle.
All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
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';
Execute the following
commands to drop table ADX_PRE_AUTOCONFIG from APPS schema:
Note: It will be recreated
during autoconfig with APPLSYS
schema.
appltest@TEST21:…01/oracle/TEST/fs1/EBSapps/appl$ cd
$AD_TOP/patch/115/sql
appltest@TEST21:…s/appl/ad/12.0.0/patch/115/sql$ sqlplus APPS/TEST
@txkDropAdxPreAutoConfig.sql
SQL*Plus: Release 10.1.0.5.0 - Production on Fri Apr 16 11:31:49 2021
Copyright (c) 1982, 2005, Oracle.
All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Table
ADX_PRE_AUTOCONFIG dropped
Synonym
ADX_PRE_AUTOCONFIG does not exist
PL/SQL procedure successfully completed.
Commit complete.
Disconnected from Oracle Database 19c Enterprise Edition Release
19.0.0.0.0 - Production
Configuring the Oracle
E-Business Suite Release 12.2 Application Tier
You will now run Rapid Install to configure
the application tier services.
Configure an Existing Instance
Ensure that the database and listeners have been started.
oratest@TEST21:…1/appsutil/scripts/TEST_TEST21$ lsnrctl status CDBTEST
LSNRCTL for Solaris: Version 19.0.0.0.0 - Production on 16-APR-2021
11:35:40
Copyright (c) 1991, 2020, Oracle.
All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TEST21.ebs.com)(PORT=1524)(IP=FIRST)))
STATUS of the LISTENER
------------------------
Alias CDBTEST
Version TNSLSNR
for Solaris: Version 19.0.0.0.0 - Production
Start Date
01-APR-2021 15:40:56
Uptime 14 days
19 hr. 54 min. 44 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File
/u02/oracle/TEST/db/19.0.0/dbhome_1/network/admin/listener.ora
Listener Log File
/u02/oracle/TEST/db/19.0.0/dbhome_1/admin/TEST_TEST21/diag/tnslsnr/TEST21/cdbTEST/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TEST21.ebs.com)(PORT=1524)))
Services Summary...
Service "6324cb1b6ae633ace05400144ffb09a0" has 1 instance(s).
Instance "CDBTEST",
status READY, has 2 handler(s) for this service...
Service "CDBTEST" has 1 instance(s).
Instance "CDBTEST",
status READY, has 1 handler(s) for this service...
Service "CDBTESTXDB" has 1 instance(s).
Instance "CDBTEST",
status READY, has 1 handler(s) for this service...
Service "TEST" has 3 instance(s).
Instance "CDBTEST",
status READY, has 2 handler(s) for this service...
Instance "CDBTEST",
status READY, has 1 handler(s) for this service...
Instance "TEST",
status UNKNOWN, has 1 handler(s) for this service...
Service "ebs_TEST" has 1 instance(s).
Instance "CDBTEST",
status READY, has 2 handler(s) for this service...
Service "ebs_patch" has 1 instance(s).
Instance "CDBTEST",
status READY, has 1 handler(s) for this service...
The command completed successfully
oratest@TEST21:…1/appsutil/scripts/TEST_TEST21$
Start the Rapid
Install Wizard by entering the command rapidwiz.
Time taken : 2.5 hrs
appltest@TEST21 $ cd /u01/oracle/TEST/stage/startCD/Disk1/rapidwiz/
appltest@TEST21:…A/stage/startCD/Disk1/rapidwiz$ ./rapidwiz
appltest@TEST21:…s/appl/ad/12.0.0/patch/115/sql$ echo $CONTEXT_FILE
/u01/oracle/TEST/fs1/inst/apps/TEST_TEST21/appl/admin/TEST_TEST21.xml
- Supply Apps. Applsyspub, and weblogic admin password in next screen
appltest@TEST21:…01/oracle/TEST/fs1/EBSapps/appl$ echo $CONTEXT_FILE
/tmp/04161141/TEST21_VIS_apps.xml
Perform the below if $CONTEXT_FILE variable is not properly set.
appltest@TEST21:…fs1/EBSapps/appl/ad/12.0.0/bin$ sh adconfig.sh contextfile=$INST_TOP/appl/admin/TEST_TEST21.xml
7. Enabling Online Patching
Verify that the latest patches have been applied to the database and application tier
ETCC DB Tier :
oratest@TEST21:…tches/12_2_upg_patches/DB/ETCC$ pwd
/u03/oracle/patches/12_2_upg_patches/DB/ETCC
oratest@TEST21:…tches/12_2_upg_patches/DB/ETCC$ ./checkDBpatch.sh
+===============================================================+
| Copyright (c) 2005, 2020 Oracle and/or its affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release 12.2 |
| Database EBS Technology Codelevel Checker |
+===============================================================+
Oracle Grid Infrastructure not identified.
Database environment not set, so context file must be specified.
Enter full path to database context file: /u02/oracle/TEST/db/19.0.0/dbhome_1/appsutil/TEST_TEST21.xml
Validating context file: /u02/oracle/TEST/db/19.0.0/dbhome_1/appsutil/TEST_TEST21.xml
Using context file from user input:
/u02/oracle/TEST/db/19.0.0/dbhome_1/appsutil/TEST_TEST21.xml
Starting Database EBS Technology Codelevel Checker, Version 120.83
Friday, April 16, 2021 at 2:45:10 PM BST
Log file for this session : /u03/oracle/patches/12_2_upg_patches/DB/ETCC/log/checkDBpatch_11943.log
Identifying database release.
Database release set to 19.10.0.0.
Multitenant identified.
- Container database (CDB) identified via s_cdb_name is CDBTEST
- Pluggable database (PDB) identified via s_pdb_name is TEST
Connecting to database.
Database connection successful.
Database TEST is in READ WRITE mode.
Identifying APPS and APPLSYS schema names.
- APPS schema : APPS
- APPLSYS schema : APPLSYS
Checking for DB-ETCC results table.
Table to store DB-ETCC results already exists in the database.
Bugfix file ./db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.58
This file will be used for identifying missing bugfixes.
Mapping file ./db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.33
This file will be used for mapping bugfixes to patches.
Identified RDBMS DST version 32.
Checking Bugfix XML file for 19.10.0.0_RU
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 19.10.0.0.210119DBRU
All the required one-off bugfixes are present in Database ORACLE_HOME.
Stored Technology Codelevel Checker results in the database TEST successfully.
Finished checking fixes for Oracle Database: Friday, April 16, 2021 at 2:46:00 PM BST
Log file for this session: /u03/oracle/patches/12_2_upg_patches/DB/ETCC/log/checkDBpatch_11943.log
===============================================================================
ETCC APPS Tier :
appltest@TEST21:…01/oracle/TEST/fs1/EBSapps/appl$ cd /u03/oracle/patches/12_2_upg_patches/12_2_MT/ETCC_MT
appltest@TEST21:…_2_upg_patches/12_2_MT/ETCC_MT$ ./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/oracle/TEST/fs1/inst/apps/TEST_TEST21/appl/admin/TEST_TEST21.xml
Starting Application Tier Technology Codelevel Checker
Version: 120.0.12020000.43.
Friday, April 16, 2021 at 2:59:48 PM BST
Log file for this session: /u03/oracle/patches/12_2_upg_patches/12_2_MT/ETCC_MT/log/checkMTpatch_19020.log
Bugfix XML file version: 120.0.12020000.49
This file will be used for identifying missing bugfixes.
Mapping XML file version: 120.0.12020000.35
This file will be used for mapping bugfixes to patches.
Checking for prerequisite bugfixes in File Edition: run
Enter the password for the APPS user:
Connecting to database.
Database connection successful.
The installed AD.C codelevel does not support storing the results in the database.
===============================================================================
Oracle Forms and Reports
===============================================================================
Now examining product Oracle Forms and Reports.
Oracle Home = /u01/oracle/TEST/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.
Checking required bugfixes for RSF within Forms 10.1.0.5.0.
All required bugfixes are present for RSF within Forms.
===============================================================================
Oracle Fusion Middleware (FMW) - Web Tier
===============================================================================
Now examining product Oracle Fusion Middleware (FMW) - Web Tier.
Oracle Home = /u01/oracle/TEST/fs1/FMW_Home/webtier.
Product Version = 11.1.1.9.0
Checking required bugfixes for FMW - Web Tier 11.1.1.9.0.
All required bugfixes are present for FMW - Web Tier.
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.
===============================================================================
Oracle Fusion Middleware (FMW) - oracle_common
===============================================================================
Now examining product Oracle Fusion Middleware (FMW) - oracle_common.
Oracle Home = /u01/oracle/TEST/fs1/FMW_Home/oracle_common.
Product Version = 11.1.1.9.0
Checking required bugfixes for FMW - oracle common 11.1.1.9.0.
All required bugfixes are present for FMW - oracle common.
===============================================================================
Oracle WebLogic Server (WLS)
===============================================================================
Now examining product Oracle WebLogic Server (WLS).
Oracle Home = /u01/oracle/TEST/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.
All required patches are present for Oracle WebLogic Server (WLS).
===============================================================================
All required one-offs are confirmed as present.
Finished checking prerequisite patches for File Edition: run.
Friday, April 16, 2021 at 3:00:42 PM BST
Log file for this session: /u03/oracle/patches/12_2_upg_patches/12_2_MT/ETCC_MT/log/checkMTpatch_19020.log
===============================================================================
appltest@TEST21:…_2_upg_patches/12_2_MT/ETCC_MT$
Gather SYS schema statistics:
oratest@TEST21:…me_1/network/admin/TEST_TEST21$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Apr 16 15:02:07 2021
Version 19.10.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0
SQL> show con_name;
CON_NAME
------------------------------
TEST
SQL> begin
dbms_stats.gather_schema_stats( 'SYS',
options=>'GATHER STALE', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,
method_opt => 'FOR ALL COLUMNS SIZE AUTO',
cascade => TRUE);
end;
/
PL/SQL procedure successfully completed.
Enable Maintenance Mode:
appltest@TEST21:…atches/12_1_3_patches/31026891$ sqlplus apps/TEST @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE
SQL*Plus: Release 10.1.0.5.0 - Production on Fri Apr 16 16:29:57 2021
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
PL/SQL procedure successfully completed.
Commit complete.
Apply OPCC Patch on 12.2 FS
Patch 31026891: E-BUSINESS SUITE: CONSOLIDATED ONLINE PATCHING ENABLEMENT READINESS REPORT
Prerequisites : Run adgrants.sql
oratest@TEST21:~$ . CDBTEST_TEST21.env
oratest@TEST21:~$ export ORACLE_PDB_SID=TEST
oratest@TEST21:~$ sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 1 22:38:01 2021
Version 19.10.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
SQL> @/tmp/adgrants.sql APPS
Apply the Patch :
appltest@TEST21:…01/oracle/TEST/fs1/EBSapps/appl$ cd /u03/oracle/patches/12_2_upg_patches/12_2_upg/31026891
appltest@TEST21:…_upg_patches/12_2_upg/31026891$ time adpatch
real 9m55.55s
user 0m4.10s
sys 0m3.99s
DISABLE Maintenance Mode :
appltest@TEST21:…_upg_patches/12_2_upg/31026891$ sqlplus apps/TEST @$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE
SQL*Plus: Release 10.1.0.5.0 - Production on Fri Apr 16 17:52:31 2021
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
PL/SQL procedure successfully completed.
Commit complete.
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Run the Online Patching Enablement - Readiness Reports
Source Run File System environment File :
appltest@TEST21:~$ . /u01/oracle/TEST/fs1/EBSapps/appl/APPSTEST_TEST21.env
appltest@TEST21:~$ echo $FILE_EDITION
run
appltest@TEST21:…01/oracle/TEST/fs1/EBSapps/appl$ mkdir $LOG_HOME/appl/op
appltest@TEST21:…01/oracle/TEST/fs1/EBSapps/appl$ cd $LOG_HOME/appl/op
Check for Data Dictionary Corruption
Run the $AD_TOP/patch/115/sql/adzddtsfix.sql script, following the usage instructions provided.
Run the $AD_TOP/sql/ADZDDBCC.sql script to identify whether logical data dictionary corruption is present.
If no corruption is found, proceed with the upgrade.
If corruption is present, follow Step 3.2 below.
$ sqlplus apps/TEST @$AD_TOP/patch/115/sql/adzddtsfix.sql
appltest@TEST21:…/apps/TEST_TEST21/logs/appl/op$ sqlplus apps/TEST @$AD_TOP/patch/115/sql/adzddtsfix.sql
SQL*Plus: Release 10.1.0.5.0 - Production on Fri Apr 16 17:59:35 2021
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
exec sys.utl_recomp.recomp_parallel
exit;
appltest@TEST21:…/apps/TEST_TEST21/logs/appl/op$ ls -ltr
total 2
-rw-r--r-- 1 appltest TEST 42 Apr 16 18:00 adzddtsfixout.sql
No Corruption Detected.
Run the following Readiness reports:
$ sqlplus system @$AD_TOP/sql/ADZDPSUM.sql
$ mv adzdpsum.txt adzdpsum_pre_dbprep.txt
$ vi adzdpsum_pre_dbprep.txt
Unregistered schemas that depend on EBS Objects
Schema Object Type Number of Objects
-------------------- -------------------- -----------------
BACKUP_TABLES SYNONYM 86
BI SYNONYM 17
TEST VIEW 3
3 rows selected.
Run the below scripts to register the below schemas :
sqlplus apps @$AD_TOP/patch/115/sql/ADZDREG.sql TESTmgr apps BACKUP_TABLES
sqlplus apps @$AD_TOP/patch/115/sql/ADZDREG.sql TESTmgr apps BI
sqlplus apps @$AD_TOP/patch/115/sql/ADZDREG.sql TESTmgr apps TEST
SQL*Plus: Release 10.1.0.5.0 - Production on Sat Apr 17 15:26:01 2021
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Connected.
Session altered.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
ERROR: Installing APPS_DDL packages failed. Run the sql files adaddls.pls, adaaddls.pls, adaddlb.pls, adaaddlb.pls from $AD_TOP/patch/115/sql directory
Commit complete.
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
appltest@TEST21:~$
Note : APPS_DDL packages instllation ERROR is expected and can be ignored.
appltest@TEST21:~$ sqlplus apps @$AD_TOP/patch/115/sql/ADZDREG.sql TESTmgr apps BACKUP_TABLES
SQL*Plus: Release 10.1.0.5.0 - Production on Sat Apr 17 15:27:29 2021
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Connected.
Session altered.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
ERROR: Installing APPS_DDL packages failed. Run the sql files adaddls.pls, adaaddls.pls, adaddlb.pls, adaaddlb.pls from $AD_TOP/patch/115/sql directory
Commit complete.
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
appltest@TEST21:~$ sqlplus apps @$AD_TOP/patch/115/sql/ADZDREG.sql TESTmgr apps BI
SQL*Plus: Release 10.1.0.5.0 - Production on Sat Apr 17 15:27:40 2021
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Connected.
Session altered.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
ERROR: Installing APPS_DDL packages failed. Run the sql files adaddls.pls, adaaddls.pls, adaddlb.pls, adaaddlb.pls from $AD_TOP/patch/115/sql directory
Commit complete.
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
appltest@TEST21:~$ sqlplus apps @$AD_TOP/patch/115/sql/ADZDREG.sql TESTmgr apps TEST
SQL*Plus: Release 10.1.0.5.0 - Production on Sat Apr 17 15:27:53 2021
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Connected.
Session altered.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
ERROR: Installing APPS_DDL packages failed. Run the sql files adaddls.pls, adaaddls.pls, adaddlb.pls, adaaddlb.pls from $AD_TOP/patch/115/sql directory
Commit complete.
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
appltest@TEST21:~$
appltest@TEST21:…/apps/TEST_TEST21/logs/appl/op$ sqlplus system @$AD_TOP/sql/ADZDPSUM.sql
DOC> Unregistered schemas that depend on EBS Objects
DOC>
DOC> The listed schemas are not currently registered as Custom EBS Schemas,
DOC> but contain objects which depend on EBS objects. The Online Patching
DOC> enablement process requires that Custom EBS Schemas be registered with
DOC> EBS and enabled for editioning.
DOC>
DOC> For each schema reported below, please do one of the following:
DOC>
DOC> - If the schema should be retained and will continue to depend on
DOC> EBS objects, then register it as a Custom EBS Schema. Custom EBS
DOC> Schemas will need to comply with new EBS Custom Development
DOC> Standards. See the ADZDPCUST.sql template file instructions
DOC> on how to register custom schemas.
DOC> - If the schema should be retained, but should not depend on EBS
DOC> objects, then leave the schema unregistered and correct any
DOC> object-level violations in the next phase of the readiness check.
DOC> - If the schema is unused, drop it.
DOC>
DOC> Oracle recommends you perform the chosen fix by customizing template file
DOC> $AD_TOP/sql/ADZDPCUST.sql
DOC>
DOC> EBS objects in CTXSYS get dropped as part of EBR enablement, and will not
DOC> show up here due to that
DOC>
DOC>#
no rows selected
$ sqlplus system @$AD_TOP/sql/ADZDPMAN.sql
$ mv adzdpman.txt adzdpman_pre_dbprep.txt
$ sqlplus system @$AD_TOP/sql/ADZDPAUT.sql
$ mv adzdpaut.txt adzdpaut_pre_dbprep.txt
Fix Violations Listed in the Online Patching Readiness Report that Require Manual Intervention
Verify database tablespace free space
Set the HOSTNAME environment variable before executing the online patching tool adop.
Check to ensure the environment variable HOSTNAME is set by running the following:
$ echo $HOSTNAME
If the HOSTNAME environment variable is not set, then run the following:
$ export HOSTNAME=TEST21
Select the next option - 'Free Space in Important Tablespaces' Enter the password when prompted.
Ensure the following:
appltest@TEST21:…/apps/TEST_TEST21/logs/appl/op$ perl $AD_TOP/bin/adzdreport.pl apps
Enter the APPS Password:
Online Patching Diagnostic Reports Main Menu
--------------------------------------------
1. Run edition reports
2. Patch edition reports
3. Other generic reports
4. Exit
Enter your choice [4]: 3
Other Generic Reports Sub Menu
------------------------------
1. Editions summary
2. Editioned objects summary
3. Free space in important tablespaces
4. Status of critical AD_ZD objects
5. Actual objects in current edition
6. Objects dependencies
7. Objects dependency tree
8. Editioning views column mappings
9. Index details for a table
10. Inherited objects in the current edition
11. All log messages
12. Materialized view details
13. Database sessions by edition
14. Table details (Synonyms, EV, etc.)
15. Count and status of DDL execution by phase
16. Back to main menu
Enter your choice [16]: 3
===============================================================================
=========================================================================
= Important Tablespace Status
=========================================================================
TABLESPACE_NAME TOTAL_SPACE(GB) USED_SPACE(GB) FREE_SPACE(GB) PCT_USED
------------------------------ --------------- -------------- -------------- --------
APPS_TS_SEED 7.19 3.12 4.07 43.37
APPS_TS_TX_DATA ###### ###### 64.23 87.69
APPS_TS_TX_IDX ###### ###### 11.91 91.51
SYSTEM 26.54 17.33 9.21 65.29
Above report is captured in file : /u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/out/adzdshowts.out.
===============================================================================
Please review the above messages and press <return> to go back to menu:
Minimum size for Tablespace Level :
SYSTEM Tablespace: has a minimum of 25 GB of free space
APPS_TS_SEED Tablespace: has a minimum of 5 GB of free space
Other Generic Reports Sub Menu
------------------------------
1. Editions summary
2. Editioned objects summary
3. Free space in important tablespaces
4. Status of critical AD_ZD objects
5. Actual objects in current edition
6. Objects dependencies
7. Objects dependency tree
8. Editioning views column mappings
9. Index details for a table
10. Inherited objects in the current edition
11. All log messages
12. Materialized view details
13. Database sessions by edition
14. Table details (Synonyms, EV, etc.)
15. Count and status of DDL execution by phase
16. Back to main menu
Enter your choice [16]: 3
===============================================================================
=========================================================================
= Important Tablespace Status
=========================================================================
TABLESPACE_NAME TOTAL_SPACE(GB) USED_SPACE(GB) FREE_SPACE(GB) PCT_USED
------------------------------ --------------- -------------- -------------- --------
APPS_TS_SEED 10.19 3.12 7.07 30.61
APPS_TS_TX_DATA ###### ###### 64.23 87.69
APPS_TS_TX_IDX ###### ###### 11.91 91.51
SYSTEM 44.34 17.33 27.01 39.08
Above report is captured in file : /u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/out/adzdshowts.out.
===============================================================================
Run the Online Patching Enablement - Status Report
Set the current directory to $LOG_HOME/appl/op:
$ cd $LOG_HOME/appl/op
$ sqlplus apps @$AD_TOP/sql/ADZDEXRPT.sql
Save the output as pre_dbprep for future reference, such as:
$ mv adzdexrpt.txt adzdexrpt_pre_dbprep.txt
Note : Ensure that all Application Tier Oracle E-Business Suite services are shut down
Back up Oracle E-Business Suite
Perform a full Oracle E-Business Suite backup of the application and database.
Guranteed Restore point :
Below restore point created after applying 12.2.0 upgrade driver
SQL> CREATE RESTORE POINT PDB_bef_r122_online_enable_patch FOR PLUGGABLE DATABASE TEST GUARANTEE FLASHBACK DATABASE;
$ nohup rman cmdfile=rman_incr_bkp_19c.rcv log=rman_incr_bkp_before_online_patch.log &
$ tar -zcvf TEST_r122_bef_online_patch.tar.gz fs1 fs2 fs_ne
Extra Fixes for Online Patch Enablement Patch :
Patch 1354362 - 12.2 ONLINE ENABLEMENT PATCH Hangs on Script ADZDWRKR.sql With No Details in The Log and Does Not Progress For Long Time (Doc ID 1946877.1)
1. Check the current max_dump_file_size parameter in the system:
SQL> show parameter max_dump_file_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_dump_file_size string 20480
2. Increase the max_dump_file_size:
a. Change the max_dump_file_size = unlimited.
b. Restart the Database
oratest@TEST21:/u03/oracle/scripts$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 18 16:10:51 2021
Version 19.10.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0
SQL> show con_name;
CON_NAME
------------------------------
CDB$ROOT
SQL> select SERVICE_ID,NAME from all_services;
SERVICE_ID NAME
---------- ----------------------------------------------------------------
1 SYS$BACKGROUND
2 SYS$USERS
3 ebs_patch
5 CDBTESTXDB
6 CDBTEST
SQL> begin
DBMS_SERVICE.STOP_SERVICE(service_name =>'ebs_patch');
DBMS_SERVICE.DELETE_SERVICE(service_name =>'ebs_patch');
end;
/
PL/SQL procedure successfully completed.
SQL> select SERVICE_ID,NAME from all_services;
SERVICE_ID NAME
---------- ----------------------------------------------------------------
1 SYS$BACKGROUND
2 SYS$USERS
5 CDBTESTXDB
6 CDBTEST
SQL> show parameter service;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string CDBTEST, TEST, ebs_patch
SQL> alter system set service_names='CDBTEST','TEST' scope=both;
System altered.
SQL> alter system register;
System altered.
SQL> show parameter service;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string CDBTEST, TEST
SQL>
Download and apply the Online Patching Enablement patc
$ cd /u03/oracle/patches/12_2_upg_patches/12_2_upg/13543062
$ time adpatch options=hotpatch,forceapply driver=u13543062.drv logfile=u13543062_TEST.log
Time Taken : 8 hrs
Monitor the Online Patching Enablement patch application.
Use the below script to Monitor the online enablement patch :
$ sqlplus apps/TEST @$AD_TOP/sql/ADZDSHOWDDLS.sql
Compile Invalid Objects
Connect to sqlplus as 'apps' and run the following:
$ exec sys.utl_recomp.recomp_parallel
Re-run the Online Patching Enablement Status Report after the Online Patching
$ cd $LOG_HOME/appl/op
Run the Status Report immediately after the enablement patch completes:
sqlplus apps/TEST @$AD_TOP/sql/ADZDEXRPT.sql
The purpose of running this report at this stage is to identify and fix any errors that occurred during the enablement process.
Re-run the Online Patching Enablement Readiness Report after the Online Patching Enablement patch has been applied
$ cd $LOG_HOME/appl/op
Run the Readiness Report after the enablement patch completes:
$ sqlplus system/TESTmgr @$AD_TOP/sql/ADZDPSUM.sql
$ 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.
Run the Online Patching Database Compliance Checker report to check for coding standards violations
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 @$AD_TOP/sql/ADZDDBCC.sql
Database Initialization Parameters
Below parameters should have set to the below values :
recyclebin=off
_SYSTEM_TRIG_ENABLED=true
SQL> show parameter recycle;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
buffer_pool_recycle string
db_recycle_cache_size big integer 0
recyclebin string OFF
SQL> show parameter _SYSTEM_TRIG_ENABLE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_system_trig_enabled boolean TRUE
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string CDBTEST, TEST
SQL> alter system set service_names='CDBTEST','TEST','ebs_patch' scope=both ;
SQL> alter system register;
SQL> show parameter service;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string CDBTEST, TEST, ebs_patch
Backup before upgrading to latest code levels
SQL> CREATE RESTORE POINT PDB_bef_r122_latest_code_lvl FOR PLUGGABLE DATABASE TEST GUARANTEE FLASHBACK DATABASE;
Restore point created.
8. Upgrading to the Latest Code Level
Apply the Latest AD and TXK for Release 12.2:
Apply the latest AD and TXK patchsets (required)
Apply the Latest Oracle E-Business Suite Release Update Pack for Release 12.2:
Oracle E-Business Suite Release 12.2.10 Readme (Doc ID 2666934.1)
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
Section 2: Apply Required Database Patches and Update Database Initialization Parameters
2.1 Apply Required Database Patches
AD-TXK Delta 12 requires a number of database bug fixes to install and operate correctly.
Ensure all the required ETCC database objects will be found by the Delta 12 RUP installation process. This means that you must still run the latest version of ETCC on your database, even if you already have all the required database patches installed.
oratest@TEST21:/u03/oracle/patches$ cd /u03/oracle/patches/12_2_upg_patches/DB/ETCC
Checking Mapping XML file for 19.10.0.0.210119DBRU
All the required one-off bugfixes are present in Database ORACLE_HOME.
Stored Technology Codelevel Checker results in the database TEST successfully.
Finished checking fixes for Oracle Database: Tuesday, April 20, 2021 at 9:48:17 AM BST
Log file for this session: /u03/oracle/patches/12_2_upg_patches/DB/ETCC/log/checkDBpatch_18411.log
$ cd /u03/oracle/patches/12_2_upg_patches/12_2_MT/ETCC_MT
appltest@TEST21:…_2_upg_patches/12_2_MT/ETCC_MT$ ./checkMTpatch.sh
2.2 Set Database Parameters (Conditional)
SQL> show parameter optimizer_adaptive_features
SQL> show parameter optimizer_adaptive_plans
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
optimizer_adaptive_plans boolean TRUE
2.2.2 Parameter: _disable_actualization_for_grant (applicable to Oracle Database 19c, Oracle Database 12.1.0.2, and Oracle Database 11.2.0.4)
_disable_actualization_for_grant=true
You can verify the parameter was set correctly by running the following command, which should return the value 'TRUE'.
SQL> show parameter _disable_actualization_for_grant
SQL> show parameter _disable_actualization_for_grant
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_disable_actualization_for_grant boolean TRUE
SQL>
3.1 Path A: Upgrade and New Installation Customers
Note: Follow Path A if any of the following conditions apply:
You are upgrading to Release 12.2 from Release 11i/12.0.x/12.1.x.
You are performing a new installation.
You are in the process of upgrading to Release 12.2 and have applied a previous AD-TXK delta but not applied the E-Business Suite Release Update Pack.
+3.1.1 Run ETCC
If you do not execute the latest version of ETCC (see Section 2), the patch application procedure will fail.
Upgrade Customers
appltest@TEST21:…_2_upg_patches/12_2_MT/ETCC_MT$ ./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/oracle/TEST/fs1/inst/apps/TEST_TEST21/appl/admin/TEST_TEST21.xml
Starting Application Tier Technology Codelevel Checker
Version: 120.0.12020000.43.
Tuesday, April 20, 2021 at 11:25:36 AM BST
Log file for this session: /u03/oracle/patches/12_2_upg_patches/12_2_MT/ETCC_MT/log/checkMTpatch_27839.log
Bugfix XML file version: 120.0.12020000.49
This file will be used for identifying missing bugfixes.
Mapping XML file version: 120.0.12020000.35
This file will be used for mapping bugfixes to patches.
Checking for prerequisite bugfixes in File Edition: run
Enter the password for the APPS user:
Connecting to database.
Database connection successful.
The installed AD.C codelevel does not support storing the results in the database.
===============================================================================
Oracle Forms and Reports
===============================================================================
Now examining product Oracle Forms and Reports.
Oracle Home = /u01/oracle/TEST/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.
Checking required bugfixes for RSF within Forms 10.1.0.5.0.
All required bugfixes are present for RSF within Forms.
===============================================================================
Oracle Fusion Middleware (FMW) - Web Tier
===============================================================================
Now examining product Oracle Fusion Middleware (FMW) - Web Tier.
Oracle Home = /u01/oracle/TEST/fs1/FMW_Home/webtier.
Product Version = 11.1.1.9.0
Checking required bugfixes for FMW - Web Tier 11.1.1.9.0.
All required bugfixes are present for FMW - Web Tier.
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.
===============================================================================
Oracle Fusion Middleware (FMW) - oracle_common
===============================================================================
Now examining product Oracle Fusion Middleware (FMW) - oracle_common.
Oracle Home = /u01/oracle/TEST/fs1/FMW_Home/oracle_common.
Product Version = 11.1.1.9.0
Checking required bugfixes for FMW - oracle common 11.1.1.9.0.
All required bugfixes are present for FMW - oracle common.
===============================================================================
Oracle WebLogic Server (WLS)
===============================================================================
Now examining product Oracle WebLogic Server (WLS).
Oracle Home = /u01/oracle/TEST/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.
All required patches are present for Oracle WebLogic Server (WLS).
===============================================================================
All required one-offs are confirmed as present.
Finished checking prerequisite patches for File Edition: run.
Tuesday, April 20, 2021 at 11:26:36 AM BST
Log file for this session: /u03/oracle/patches/12_2_upg_patches/12_2_MT/ETCC_MT/log/checkMTpatch_27839.log
3.1.2 Run Installation Steps
Source the run edition environment file.
$ cd /u01/oracle/TEST/fs1/EBSapps/appl
appltest@TEST21:…01/oracle/TEST/fs1/EBSapps/appl$ . APPSTEST_TEST21.env
Start up only the Oracle Weblogic Admin Server on the run edition application tier file system.
UNIX:
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
Unzip patches and run adgrants.
Download and unzip the following patches:
Patch 30628681 (R12.AD.C.Delta.12)
Patch 30735865 (R12.TXK.C.Delta.12)
Location : /u03/oracle/patches/12_2_upg_patches/12_2_upg
Copy the above patches to Patch top and unzip :
appltest@TEST21: /u03/oracle/patches/12_2_upg_patches/12_2_upg$ cp p30628681_R12.AD.C_R12_SOLARIS64.zip p30735865_R12.TXK.C_R12_GENERIC.zip /u01/oraacle/TEST/fs_ne/EBSapps/patch
unzip p30628681_R12.AD.C_R12_SOLARIS64.zip
unzip p30735865_R12.TXK.C_R12_GENERIC.zip
Execute adgrants by following the instructions in the readme of Patch 30628681, which includes the latest version of adgrants.
oratest@TEST21:/tmp/ad_12_adgrants$ ls
adgrants.sql
oratest@TEST21:~$ . CDBTEST_TEST21.env
oratest@TEST21:~$
oratest@TEST21:~$ export ORACLE_PDB_SID=TEST
oratest@TEST21:/tmp/ad_12_adgrants$ sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Apr 20 11:58:48 2021
Version 19.10.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> @adgrants.sql APPS
Below warnings found in adgrants.sql :
The following ERRORS and WARNINGS have been encountered during this adgrants session:
TIME_STAMP SESSION_ID LOG_MODULE LOG_LEVEL
-------------------- ---------- ------------------------------------------ ----------
LOG_MESSAGE
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2021/04/20 11:59:36 909 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/04/20 11:59:36 909 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/04/20 11:59:37 909 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/04/20 11:59:37 909 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 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0
oratest@TEST21:/tmp/ad_12_adgrants$
On the run edition application tier file system, apply Patch 30628681 (R12.AD.C.Delta.12) in hotpatch mode.
Note: Do not merge Patch 30628681 with any other patches.
UNIX:
$ adop phase=apply patches=30628681 hotpatch=yes workers=16
appltest@TEST21:…e/EBSapps/patch/30628681/admin$ adop phase=apply patches=30628681 hotpatch=yes restart=yes
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Please wait. Validating credentials...
Enter the RUN file system context file name [/u01/oracle/TEST/fs1/inst/apps/TEST_TEST21/appl/admin/TEST_TEST21.xml]: /u01/oracle/TEST/fs1/inst/apps/TEST_TEST21/appl/admin/TEST_TEST21.xml
[STATEMENT] ADPATCH Log directory: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/2/apply_20210420_120622/TEST_TEST21/30628681/log
[STATEMENT] Running: adpatch abandon=yes workers=15 options=hotpatch flags=autoskip console=no interactive=no defaultsfile=/u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/adalldefaults.txt patchtop=/u01/oracle/TEST/fs_ne/EBSapps/patch/30628681 driver=u30628681.drv logfile=u30628681.log stdin=yes
Applying patch 30628681.
Log: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/2/20210420_163005/apply/TEST21/30628681/log/u30628681.log
Successfully created out directory
Running finalize actions for the patches being applied.
Log: @ADZDSHOWLOG.sql "2021/04/20 16:42:40"
Running cutover actions for the patches being applied.
Creating workers to process cutover DDL in parallel
Log: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/2/20210420_163005/apply/TEST21/log/cutover.log
Performing database cutover in Quick mode
Generating post apply reports.
Generating log report.
Output: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/2/20210420_163005/apply/TEST21/adzdshowlog.out
The apply phase completed successfully.
adop exiting with status = 0 (Success)
Time taken : 1 hr
alter system set service_names='CDBTEST','TEST','TEST_ebs_patch' scope=both ;
alter system register;
Another way To start the service :
sqlplus / as sysdba
alter session set container=TEST;
begin
DBMS_SERVICE.start_service(service_name =>'TEST_ebs_patch');
end;
/
appltest@TEST21:…oracle/TEST/fs_ne/EBSapps/patch$ cd /u01/oracle/TEST/fs_ne/EBSapps/patch
appltest@TEST21:…oracle/TEST/fs_ne/EBSapps/patch$ cp /u03/oracle/patches/12_2_upg_patches/12_2_upg/p31904550_R12.TXK.C_R12_GENERIC.zip .
On the run edition application tier file system, use hotpatch mode to apply Patch 30735865 (R12.TXK.C.Delta.12) plus any additional critical patches (see note box).
UNIX:
$ time adop phase=apply patches=30735865,31904550 hotpatch=yes merge=yes
Time taken : 1 hr
Source the run edition environment file.
UNIX:
$ . <EBS_ROOT>/EBSapps.env run
Note: <EBS_ROOT> represents the Oracle E-Business Suite base install directory. For example, /u01/oracle.
Run the Middle Tier EBS Technology Codelevel Checker (MT-ETCC).
Run MT-ETCC checkMTpatch.sh (checkMTpatch.cmd on Microsoft Windows) on the run file system.
Stop Oracle WebLogic Server's Admin Server and Node Manager services.
To apply a patch in downtime mode, you must shut down all application tier services, including the Oracle WebLogic Server Admin Server and Node Manager.
Stop the Oracle Weblogic Server Admin Server on the run file system.
UNIX:
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
Stop the Oracle WebLogic Server Node Manager service on the run file system. UNIX:
$ sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
Update the database tier with the latest patches.
Before you proceed with the rest of the steps, you must update the database tier with the latest patches by referring to Section 5: Migrate Latest Code to Database Tier.
4.1 Apply Required Database Patches
Ensure all the required ETCC database objects will be found by the AD-TXK Delta 12 RUP installation process. This means that even if you already have all the required database patches installed, you must still run the latest version of ETCC on your database.
Section 4: Apply Additional Critical Patches
4.1 Critical AD Patches
There are currently no critical AD patches.
4.2 Critical TXK Patches
Patch 31904550:R12.TXK.C — Fix to ensure fs_clone duration is not impacted by symbolic links of large size in APPL_TOP or COMMON_TOP.
Section 5: Update Database Tier to Latest Code
Update all database tier nodes with the latest code, by performing the following steps:
On the application tier (as the applmgr user):
Source the run edition environment file.
UNIX:
$ . <EBS_ROOT>/EBSapps.env run
Execute the admkappsutil.pl utility to create the appsutil.zip file in <INST_TOP>/admin/out.
$ perl $AD_TOP/bin/admkappsutil.pl
appltest@TEST21:~$ perl $AD_TOP/bin/admkappsutil.pl
Starting the generation of appsutil.zip
Log file located at /u01/oracle/TEST/fs1/inst/apps/TEST_TEST21/admin/log/MakeAppsUtil_04201923.log
output located at /u01/oracle/TEST/fs1/inst/apps/TEST_TEST21/admin/out/appsutil.zip
MakeAppsUtil completed successfully.
On the database tier (as the oracle user):
Source the environment for RDBMS ORACLE_HOME.
UNIX:
$ cd /u02/oracle/TEST/db/19.0.0/dbhome_1
oratest@TEST21:…/oracle/TEST/db/19.0.0/dbhome_1$ . ./TEST_TEST21.env
Copy or FTP the appsutil.zip file to <RDBMS ORACLE_HOME>.
Uncompress appsutil.zip, under <RDBMS ORACLE_HOME>.
oratest@TEST21:…/oracle/TEST/db/19.0.0/dbhome_1$ cp -pr appsutil appsutil_aft_delta_12
$ cd $ORACLE_HOME
$ unzip -o appsutil.zip
Run AutoConfig on <RDBMS ORACLE_HOME>.
UNIX:
$ sh <RDBMS_ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>/adautocfg.sh
$cd /u02/oracle/TEST/db/19.0.0/dbhome_1/appsutil/scripts/TEST_TEST21
./adautocfg.sh
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.
Run AutoConfig on the run file system.
As the applmgr user, run AutoConfig on all application tier nodes by executing whichever of these commands applies to your system:
UNIX:
appltest@TEST21:~$ cd
appltest@TEST21:~$ . EBSapps.env run
$ sh $INST_TOP/admin/scripts/adautocfg.sh
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.
Section 6: Known Issues
There are no known issues at present. You should periodically check this Document 1617461.1 on My Oracle Support for updates, which are always noted in the change log.
Backup before 12.2.10 upgrade :
appltest@TEST21:/u01/oracle/TEST$ scp TEST_r122_aft_upg_driver.tar.gz TEST_r122_bef_online_patch.tar.gz admin@192.168.177.29:/u03/oracle/TEST_bkp/TEST_apps_bkp/12_2_apps_bkp
Guranteed Restore point :
Below restore point created after applying 12.2.0 upgrade driver
alter session set container=TEST;
SQL> CREATE RESTORE POINT PDB_bef_r12210_upg FOR PLUGGABLE DATABASE TEST GUARANTEE FLASHBACK DATABASE;
Level 0 FULL BACK UP :
$ nohup rman cmdfile=rman_full_bkp_19c.rcv log=rman_full_bkp_before_12210_upg.log &
cd /u01/oracle/TEST
$ tar -zcvf TEST_r122_bef_12210_upg.tar.gz fs1 fs2 fs_ne
Optimizer Adaptive Optimization
If you are using Oracle Database 12.1.0.2, optimizer adaptive features are controlled by the database initialization parameter optimizer_adaptive_features. this parameter should always be set to 'false'. This setting should be completed before proceeding with the next steps and should not be changed thereafter.
Note: If you are using Oracle Database 19c, optimizer adaptive features are no longer controlled by the database initialization parameter optimizer_adaptive_features. Instead, these features are controlled by two new parameters: optimizer_adaptive_plans, which defaults to TRUE, and optimizer_adaptive_statistics, which defaults to FALSE.
For more information, see My Oracle Support Knowledge Document 396009.1, Database Initialization Parameters for Oracle E-Business Suite Release 12.
optimizer_adaptive_features=false
You can verify the parameter was set correctly by running the following command, which should return the value FALSE:
SQL>show parameter optimizer_adaptive_features
SQL> show parameter optimizer_adaptive_plans
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
optimizer_adaptive_plans boolean TRUE
optimizer_adaptive_statistics boolean FALSE
_disable_actualization_for_grant (applicable to Oracle Database 11.2.0.4, Oracle Database 12.1.0.2, and Oracle Database 19c)
Set the parameter _disable_actualization_for_grant to true.
_disable_actualization_for_grant=true
You can verify the parameter was set correctly by running the following command, which should return the value TRUE:
SQL>show parameter _disable_actualization_for_grant
SQL> show parameter _disable_actualization_for_grant
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_disable_actualization_for_grant boolean TRUE
Path A — Upgrade and New Installation Customers upgrading to Oracle E-Business Suite 12.2.10 Release Update Pack
Source the run edition applications environment.
UNIX:
$ . <INSTALL_BASE>/EBSapps.env run
appltest@TEST21:…A/fs_ne/EBSapps/patch/30399999$ cd $ADMIN_SCRIPTS_HOME
appltest@TEST21:…apps/TEST_TEST21/admin/scripts$ sh adadminsrvctl.sh status
Stop Oracle WebLogic Server's Admin Server and Node Manager services.
To apply a patch in downtime mode, you must shut down all application tier services, including the Oracle WebLogic Server Admin Server and Node Manager.
Stop the Oracle WebLogic Server Admin Server on the run file system.
UNIX:
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
Stop the Oracle WebLogic Server Node Manager service on the run file system.
UNIX:
$ sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
Apply Oracle E-Business Suite 12.2.10 Release Update Pack Patch 30399999 on the run edition application environment, using downtime mode.
UNIX:
$ cd /u03/oracle/patches/12_2_upg_patches/12_2_upg/12_2_10_patcheset_sparc_64
$ cp p30399999*.zip /u01/oracle/TEST/fs_ne/EBSapps/patch
$ cd /u01/oracle/TEST/fs_ne/EBSapps/patch
$ unzip 'p30399999*.zip'
$cd /u01/oracle/TEST/fs_ne/EBSapps/patch/30399999
appltest@TEST21:…A/fs_ne/EBSapps/patch/30399999$ cd /u01/oracle/TEST/fs_ne/EBSapps/patch/30399999/admin
appltest@TEST21:…e/EBSapps/patch/30399999/admin$ mkdir /tmp/ad_12_adgrants
appltest@TEST21:…e/EBSapps/patch/30399999/admin$ cp adgrants.sql /tmp/ad_12_adgrants/
oratest@TEST21:~$ cd /tmp/ad_12_adgrants/
oratest@TEST21:/tmp/ad_12_adgrants$ ls
adgrants.sql
oratest@TEST21:~$ . CDBTEST_TEST21.env
oratest@TEST21:~$ export ORACLE_PDB_SID=TEST
oratest@TEST21:/tmp/ad_12_adgrants$ sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Apr 20 10:51:07 2021
Version 19.10.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> @/tmp/ad_12_adgrants/adgrants.sql APPS
Connected.
$ adop phase=apply apply_mode=downtime patches=30399999
$ time adop phase=apply apply_mode=downtime patches=30399999
appltest@TEST21:…A/fs_ne/EBSapps/patch/30399999$ echo $CONTEXT_FILE
/u01/oracle/TEST/fs1/inst/apps/TEST_TEST21/appl/admin/TEST_TEST21.xml
appltest@TEST21:…A/fs_ne/EBSapps/patch/30399999$ echo $FILE_EDITION
run
appltest@TEST21:/u01/oracle/TEST$ time adop phase=apply apply_mode=downtime patches=30399999
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Please wait. Validating credentials...
real 5h20m0.19s
user 5h14m30.70s
sys 30m6.17s
appltest@TEST21:/u01/oracle/TEST$ time adop phase=apply apply_mode=downtime patches=30399999 restart=yes
Total Time :
real 18h2m19.37s
user 9h31m52.19s
sys 43m56.92s
Apache Issue :
Error :
vi /u01/oracle/TEST/fs1/FMW_Home/webtier/instances/EBS_web_TEST_OHS1/diagnostics/logs/OHS/EBS_web_TEST/console~OHS~1.log
21/04/22 09:17:51 Start process
--------
/u01/oracle/TEST/fs1/FMW_Home/webtier/ohs/bin/apachectl startssl: execing httpd
httpd.worker: Syntax error on line 1039 of /u01/oracle/TEST/fs1/FMW_Home/webtier/instances/EBS_web_TEST_OHS1/config/OHS/EBS_web_TEST/httpd.conf: Syntax error on line 128 of /u01/oracle/TEST/fs1/FMW_Home/webtier/instances/EBS_web_TEST_OHS1/config/OHS/EBS_web_TEST/ssl.conf: Could not open configuration file /u01/oracle/TEST/fs1/FMW_Home/webtier/instances/EBS_web_TEST_OHS1/config/OHS/EBS_web_TEST/oracle_apache_ssl.conf: No such file or directory
appltest@TEST21:…apps/TEST_TEST21/admin/scripts$ cd $INST_TOP/appl/admin
appltest@TEST21:…st/apps/TEST_TEST21/appl/admin$ cp TEST_TEST21.xml TEST_TEST21.xml_aft_12210_upg
appltest@TEST21:…st/apps/TEST_TEST21/appl/admin$ vi TEST_TEST21.xml
Before Changes :
appltest@TEST21:…apps/TEST_TEST21/admin/scripts$ grep -i s_ohs_installed $CONTEXT_FILE
<config_option type="techstack" oa_var="s_ohs_installed">false</config_option>
After Changes :
appltest@TEST21:…st/apps/TEST_TEST21/appl/admin$ grep -i s_ohs_installed $CONTEXT_FILE
<config_option type="techstack" oa_var="s_ohs_installed">generateEBSOHSConfigFiles</config_option>
UNIX:
$ sh $ADMIN_SCRIPTS_HOME/adstrtal.sh
Perform adop cleanup action.
UNIX:
$ time adop phase=cleanup
real 2h20m36.94s
user 0m46.63s
sys 0m11.07s
Synchronize file systems
Synchronize the file systems using the command shown below. This action will copy the new run edition code and configuration to the other file system, to ensure that both file systems are in sync before applying patches using the regular adop cycle on the other file system.
$ time adop phase=fs_clone
real 1h46m15.48s
user 38m55.74s
sys 30m1.79s
SQL> @?/rdbms/admin/utlrp.sql
$ vi /u01/oracle/TEST/fs1/inst/apps/TEST_TEST21/ora/10.1.2/network/admin/tnsnames.ora
TEST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=TEST21.ebs.com)(PORT=1524))
(CONNECT_DATA=
(SERVICE_NAME=ebs_TEST)
(INSTANCE_NAME=CDBTEST)
)
)
TEST_patch=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=TEST21.ebs.com)(PORT=1524))
(CONNECT_DATA=
(SERVICE_NAME=TEST_ebs_patch)
(INSTANCE_NAME=CDBTEST)
)
)
Mandatory Post Upgrade Steps for All Upgrade Customers
Required Action: Refer to Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID: 1320300.1) and perform all applicable post upgrade steps in Section 1: Notes for All Customers, and Section 3: Notes for Upgrade Customers such as 'Create Snapshot'.
Create Snapshot
After applying the latest suite-wide release update pack (as detailed in the subsequent parts of this document), run the AD Administration Maintain Snapshot option.
Run AD Administration (adadmin).
From the Main Menu, choose Maintain Applications Files > Maintain Snapshot Information.
Select Option 2, Update Current View Snapshot. Then, from the Snapshot sub-menu, select Option 1, Update Complete APPL_TOP.
Run adadmin :
2. Maintain Applications Files menu
4. Maintain snapshot information
2. Update current view snapshot
1. Update Complete APPL_TOP
Time Taken : 1hr
Additional Tasks
This section points to additional tasks that may be necessary, and suggests documentation that describes those tasks.
AFTER INSTALLING OR UPGRADING
Net Service Listeners in Multi-User Installations
Net Service Listeners use the /var/tmp/.oracle directory to store temporary files. To give all users write privileges in a multi-user installation, update /var/tmp/.oracle with 777 permissions:
$ chmod 777 /var/tmp/.oracle
root@TEST21:/usr# chmod 777 /var/tmp/.oracle
Backing Up Oracle E-Business Suite
Oracle strongly recommends that you perform a full system backup of your Oracle E-Business Suite 12.2 including the Run and Patch file systems (fs1 and fs2), the Non-Edition file system (fs_ne), all technology stack component Oracle homes, and the database.
Logging On to Oracle E-Business Suite
To start Oracle E-Business Suite and access all Oracle E-Business Suite products, go to the Oracle E-Business Suite Login page, located at the following URL:
http://<host name>.<domain name>:<HTTP port>/OA_HTML/AppsLogin
For example:
http://oraapps1.example.com:8000/OA_HTML/AppsLogin
The system administrator should log on the first time using the SYSADMIN logon account that is pre-configured in the Applications installation. Use the System Administrator responsibility to launch an Oracle E-Business Suite session where you can complete the required implementation steps.
Ensure you reset the following init.ora parameters after completion of the Release 12.2 upgrade.
recyclebin = off (off already)
parallel_max_servers = 8
job_queue_processes = 2
Database and
System Administration Tasks
You must complete all of the tasks in this section to finish the
upgrade. All tasks must be completed during system downtime on the Release 12.2
Oracle E-Business Suite instance.
Verify completion of concurrent programs
(required)
The upgrade process creates numerous
concurrent program requests. Once you bring up the application tier, these
programs run automatically to complete tasks such as data cleanup and upgrades
to historical data, among others.
Note:
Before you continue, ensure that all concurrent
programs generated by the upgrade have run successfully. Refer to Managing
Concurrent Processes, page A-1 of this guide for a sample
list of concurrent programs.
Drop
dangling synonyms (optional)
After dropping obsoleted product schema, you must run the following script to drop
dangling synonyms:
$ sqlplus APPS/****@DB @$AD_TOP/sql/adzd_drop_synonyms.sql
$ sqlplus APPS/TEST@TEST @$AD_TOP/sql/adzd_drop_synonyms.sql
SQL*Plus: Release 10.1.0.5.0 - Production on Fri Apr 23 11:43:14 2021
Copyright (c) 1982, 2005, Oracle.
All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
DOC> "Dropping (public)
synonyms
DOC> - that point to
non-existent EBS Objects
DOC> - of qsma schema
which are like oracle/qsma/* or *_Qsma*
and
DOC> their parent
objects don't exist".
DOC>
DOC> You can check diagnostic
log messages from APPS.AD_ZD_LOGS
DOC> for module
'ad.plsql.adzd_drop_synonyms'.
DOC>
DOC>#
PL/SQL procedure successfully completed.
Commit complete.
Reset ORACLE schema passwords (recommended)
Change the WLS Admin default
password (recommended)
For security purposes, you should now change the default password
for the WLS Admin account as follows:
Run the following command to stop all
application tier services except the Node Manager and the Admin Server:
$ EBSAPPS.env run
$ $ADMIN_SCRIPTS_HOME/adstpall.sh -skipNM -skipAdmin
Run the following command to change
the WLS Admin password:
$ perl $FND_TOP/patch/115/bin/txkUpdateEBSDomain.pl
-action=updateAdminPassword
Note:
You will be prompted for the password information.
Restart all services with the following command:
$ adstrtal.sh
Install
online help Driver (recommended)
To install the American English online help,
run the database portion of the online help patch (u10201000.drv). It is
located in $AU_TOP/patch/115/driver directory. You must apply the American
English online help patch driver ($AU_TOP/patch/115/driver/u10201000.drv) using
AD Online Patching (adop) with phase=apply hotpatch=yes and
options=nocopyportion,nogenerateportion, forceapply.
$ adop phase=apply patchtop=$AU_TOP/patch/115 patches=driver:
u10201000.drv options=nocopyportion,nogenerateportion,forceapply hotpatch=yes
$ time adop phase=apply patchtop=$AU_TOP/patch/115
patches=driver:u10201000.drv options=nocopyportion,nogenerateportion,forceapply
hotpatch=yes
real 45m45.97s
user 27m39.57s
sys 43m39.25s
Apply online help for Oracle
E-Business Suite Release Update Pack (recommended)
Action: Refer to the Oracle
E-Business Suite Release
Update Pack Readme (applied in the Performing the Upgrade chapter) and apply the
corresponding Oracle E-Business Suite Release Online Help patch.
Apply Oracle E-Business Suite
Release 12.2.10 Online Help
Apply Oracle E-Business Suite
Release 12.2.10 Online Help Patch 30399996 using adop hotpatch mode on the run file system.
$ cd
/u03/oracle/patches/12_2_upg_patches/12_2_upg/12_2_10_patcheset_sparc_64
$ time adop phase=apply patches=30399996
hotpatch=yes
Works assigned default : 32
real 24m35.93s
user 11m49.76s
sys 16m52.33s
Apply
mandatory interoperability patches (required for Oracle Database 19c)
Note:
This step is applicable if you have upgraded to
Oracle E- Business Suite Release 12.2 with Oracle Database 19c.
The mandatory interoperability patches are listed
in Database Preparation Guidelines for an Oracle E-Business Suite Release 12.2
(Doc ID: 1349240.1). In the Upgrade
Paths section, click Path D. In the Path D : Customers on 12.1.3 on 19c section,
apply the mandatory
interoperability patches listed in the step '7. Apply latest 12.2 Release
Update Pack (RUP) and complete remaining Database related steps'.
The mandatory interoperability patches are listed
in Database Preparation Guidelines for an Oracle
E-Business Suite Release
12.2 (Doc ID: 1349240.1).
select bug_number,last_update_date from ad_bugs where bug_number IN
('26521736',
'29618853',
'25452805',
'31088182');
BUG_NUMBER
LAST_UPDATE_DATE
------------------------------ ------------------
25452805
21-APR-21
Location : /u03/oracle/patches/12_2_upg_patches/12_2_upg
$ time adop phase=apply patches=26521736,28732161,31088182 hotpatch=yes
merge=yes
real 9m18.02s
user 1m51.62s
sys 0m25.08s
- Start the services :
Unlock through Command Line
Utility
If a user with local system
administrator privileges is not available, you can access the Secure Configuration
Console by using the AdminSecurityCfg utility.
This utility is provided
for the following tasks:
To take the system out of
locked down mode.
To compute the status of a
certain configuration or all configurations.
To configure a certain
configuration or all configurations of type "Autofixable".
To view the status of a
certain configuration or all configurations.
For example: java oracle.apps.fnd.security.AdminSecurityCfg
-check DBC=<DBC File Path> CODES=FND_DB_DEF_PSWD,FND_PROF_ERRORS
java
oracle.apps.fnd.security.AdminSecurityCfg -unlock DBC= /u01/oracle/TEST/fs1/inst/apps/TEST_TEST21/appl/fnd/12.0.0/secure/TEST.dbc
$ time adop phase=apply patches=31948857
hotpatch=yes
appltest@TEST21:…apps/TEST_TEST21/admin/scripts$
java oracle.apps.fnd.security.AdminSecurityCfg \
-unlock \
DBC=/u01/oracle/TEST/fs1/inst/apps/TEST_TEST21/appl/fnd/12.0.0/secure/TEST.dbc
All output, errors and information can be
found in the log file at /u01/oracle/TEST/fs1/inst/apps/TEST_TEST21/logs/adminsecuritycfg_23_04_2021_19_16.log
Enter APPS username: apps
Enter APPS password:
*** Time [23/04/2021 19:16] ***
Running AdminSecurityCfg for UNLOCK mode
AdminSecurityCfg completed successfully.
If you do not specify a
CODES attribute, then the utility will check all configurations.
-fix - Runs the utility in fix mode. You can specify the
configurations to fix by adding
[CODES=<code1>,<code2>,<code3>...] to the command.
For example: java oracle.apps.fnd.security.AdminSecurityCfg
-fix DBC=<DBC File Path> CODES=FND_UNREST_REDIR,FND_AUDIT_PROF
If you do not specify a
CODES attribute, then the utility will fix all configurations of type
"Autofixable".
-status - Determines the status of all configurations. Specifying
the CODES attribute is not necessary for this mode.
-lock - Places the system in locked down mode.
-unlock - Takes the system out of locked down mode.
Apply
latest product patches (required)
Determine the latest product-specific
patches. Then, download the American English patches. You must apply the patches
using AD Online Patching (adop).
Additional
Information: See Patch Wizard Main Page in Oracle E- Business Suite Maintenance Procedures Guide.
If you have languages other than American
English registered in your system, then follow instructions in the following
step.
Grant
flexfield value set access to specific users
(required)
Re-enable
custom triggers, constraints, and indexes (conditional).
$ cd /u03/oracle/scripts
oratest@TEST21:/u03/oracle/scripts$ sqlplus apps/TEST@TEST
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Apr 23 16:41:17 2021
Version 19.10.0.0.0
Copyright (c) 1982, 2020, Oracle.
All rights reserved.
Last Successful login time: Fri Apr 23 2021 16:41:02 +01:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0
SQL> @customindex_enable.sql
SQL> @custom_constraint_enable.sql
SQL> @customTrigger_enable.sql
Migrate
the CUSTOM library (conditional)
$ cd $AU_TOP/resource/
$ cp CUSTOM.pll CUSTOM.pll_orig
$ cp CUSTOM.plx CUSTOM.plx_orig
$ cd /u01/oracle/TEST/fs1/EBSapps/appl/au/12.0.0/resource
$ cp CUSTOM.pll /u01/oracle/TEST/fs1/EBSapps/appl/au/12.0.0/resource
$ cd /u02/oracle/TEST/apps/apps_st/appl/
$ cp -pr TEST /u01/oracle/TEST/fs1/EBSapps/appl
$ cp customTEST_TEST21.env $APPL_TOP
$ vi customTEST_TEST21.env
- update the path to 12.2 structure
$ time
adop phase=fs_clone
Developing and Deploying
Customizations in Oracle E-Business Suite Release 12.2 (Doc ID 1577661.1)
- Copy TEST_TOP from 12.1
to 12.2 Appl top run file system.
- FS_CLONE will take care
of copying to patch file system
Section 1:
Create Custom Application Using AD Splice
Download Patch 3636980 from My Oracle Support. (This Support
Diagnostics patch for AD Splice can be used with any 12.x release, not just
12.2.)
Manually copy the three .txt files from
the 3636980\izu\admin directory to your own temporary directory.
Rename izuprod.txt to TESTprod.txt.
In this example, we will use xxmzprod.txt.
Rename izterr.txt to TESTterr.txt.
In this example, we will use xxmzterr.txt.
Open newprods.txt in a text editor.
In this example, the modified version of the newprods.txt file will
look like the following:
product=xxmz
base_product_top= *APPL_TOP*
oracle_schema=xxmz
sizing_factor=100
main_tspace= USER_DATA
index_tspace=USER_IDX
temp_tspace=TEMP
default_tspace= USER_DATA
product=xxmz
base_product_top= *APPL_TOP*
oracle_schema=xxmz
sizing_factor=100
main_tspace= USER_DATA // This will be ignored by adsplice.
index_tspace=USER_IDX // This will be ignored by adsplice.
temp_tspace=TEMP
default_tspace= USER_DATA // This should be set to APPS_TS_TX_DATA, the default
tablespace for your new custom schema user.
Do not include the comments, which are preceded by
"//".
SQL> select decode(count ,0, 'Selected number is available', 'Selected number is
already in use')
Status, &&enter_custom_applID selected_number
from
(
select count(*) as count from
(
select 'x' from fnd_oracle_userid
where oracle_id= &&enter_custom_applID
union
select 'x' from fnd_application
where application_id= &&enter_custom_applID
)
);
select * from fnd_application where application_short_name='TEST';
application_id - 20003
Copy the files below to $APPL_TOP/admin
$cd /u03/oracle/scripts/custom_top/
$cp TESTterr.txt newprods.txt TESTprod.txt $APPL_TOP/admin
cp $AU_TOP/resources/CIE* /tmp/custompll/ (R12.1 Instance)
cp /tmp/custompll/CIE* $AU_TOP/resources (R12.2 instnace)
FNDCPASS apps/TEST 0 Y system/TESTmgr ORACLE TEST TESTTEST
Change directory to the admin directory under $APPL_TOP.
Run AD Splice.
Note: In
Oracle E-Business Suite Release 12.2, AD Splice first makes the new user
edition-enabled, and then enables Edition-Based Redefinition (EBR) for the
custom objects.
AD Splice must be run from the admin directory under $APPL_TOP, and is
invoked by running the command:
$cd $APPL_TOP
$ adsplice
When prompted for the following, you can press
Enter to accept the default location:
Enter the directory where your AD Splicer control
file is located.
The default directory is [/oracle/VIS/apps/apps_st/appl/admin] :
When prompted for the following, you can press
Enter to accept the default filename:
Please enter the name of your AD Splicer control
file [newprods.txt] :
When prompted for the following, you can press Enter
to accept the default value and regenerate the environment file:
Do you wish to regenerate your environment file
[Yes] ?
AutoConfig will be run automatically as part of
this procedure.
/u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/log/adsplice.log
Review the AD Splice log file to ensure the
splicing part of the procedure completed successfully.
Review the AutoConfig log file to ensure the
AutoConfig run completed successfully.
Section 2: Verify Creation of Custom Product in the Database
Log in to SQL*Plus as APPS, and run the following
SQL to confirm that the fnd_application table has one row:
SQL> select * from fnd_application where
application_short_name = 'TEST';
This statement should return one row only.
Run the following SQL to check the product installations
table has one row for your custom product:
SQL> select * from
fnd_product_installations where APPLICATION_ID = 20003;
This statement should return a single row.
Both queries returned one row
Run the following SQL to check the database user:
SQL> select * from dba_users where
username = 'TEST';
This statement should return one row only.
To ensure the new environment file is picked up,
log out and back in again as applmgr, then run the following command to confirm
the $XXMZ_TOP environment variable is correctly set:
$ env | grep TEST
Run the following command to check the file system
has been created correctly. You should see a directory listing returned as
shown:
$ ls $TEST_TOP
admin log mesg out sql
Note: If you
have registered any schemas using the fnd_oracle_user_pkg.load_row API,
their passwords will not be encrypted. As a result, adpatch and adsplice will
fail. To correct this, you need to run the FNDCPASS utility to set the password
for the schemas.
To implement this there are 2
actions required:
The first is to change
profile option:
1. Login to Applications as System Administrator.
2. Select: System Administrator > Profile - System.
3. Query profile "Corporate Branding Image for Oracle Applications".
4. Change the SITE level value to “TEST_logo_r12sm.gif”
5. Save the change.
The second action is performed on the Application server:
1. Open a telnet/PuTTY session to the Application server and source
Applications environment.
2. Navigate to the $OA_MEDIA directory.
3. Copy the custom image file to this directory and make sure the image size is
155*20 pixels
and permissions are set properly.
# Update Profile Value: Site Name
DECLARE
stat boolean;
BEGIN
dbms_output.disable;
dbms_output.enable(100000);
stat := FND_PROFILE.SAVE('SITENAME', 'TEST R12.2.10 TEST Environment - cloned from 03/03/2021 Copy of TEST
Production', 'SITE');
IF stat THEN
dbms_output.put_line( 'Stat =
TRUE - profile updated' );
ELSE
dbms_output.put_line( 'Stat =
FALSE - profile NOT updated' );
END IF;
commit;
END;
/
10.
REFERENCES
Oracle E-Business Suite Installation and Upgrade Notes
Release 12 (12.2) for Oracle Solaris on SPARC (64-bit) (Doc ID 1330702.1)
Useful E-Business Suite 12.2 Documents (Doc ID 1585889.1)
Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID
1320300.1)
Database Preparation Guidelines for an E-Business Suite
Release 12.2 Upgrade (Doc ID 1349240.1)
Document 1383621.1, Cloning Oracle E-Business Suite Release
12.2 with Rapid Clone.
Oracle E-Business Suite Release 12.2: Upgrade Sizing and
Best Practices, My Oracle Support Knowledge Document 1597531.1,
Oracle E-Business Suite Release 12.2.5 Upgrade Sizing and
Best Practices 2115481.1
Configuring Oracle E-Business Suite Release 12.x Using
Logical Host Names (Doc ID: 1968231.1)
Using Load-Balancers with Oracle E-Business Suite Release
12.2 (Doc ID: 1375686.1)
Sharing The Application Tier File System in Oracle
E-Business Suite Release 12.2 (Doc ID: 1375769.1)
Business Continuity for Oracle E-Business Suite Release 12.2
using Virtual Hosts with Oracle 12c Physical Standby Database (Doc
ID:2088692.1)
Oracle E-Business Suite Release 12.2 Configuration in a DMZ
(DocID: 1375670.1)
Using Active Data Guard Reporting with Oracle E-Business
Suite Release 12.2 and an Oracle 11g or 12c Database (Doc ID: 1944539.1)
Business Continuity for Oracle E-Business Suite Release 12.2
using Virtual Hosts with Oracle 12c Physical Standby Database (Doc
ID:2088692.1)
Using Active Data Guard Reporting with Oracle E-Business
Suite Release 12.2 and an Oracle 11g or 12c Database (Doc ID: 1944539.1)
Online Patching Readiness Report in Oracle E-Business Suite
Release 12.2 (Doc ID:1531121.1).
R12.1 and 12.2 Oracle E-Business Suite Preinstall Patches Report
(Doc ID 1448102.2)
