EBS Upgrade Part 10 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7
Now the current state of the EBS and DB is 12.1.3 / 19c multi-tenant running on OEL6.
At this stage you can move upgrade the OS from OEL6 to OEL7 and then proceed further. If upgrade is not possible you can perform a outplace migration from OEL6 to OEL7 and then proceed further.
Upgrade from 12.1.3 to 12.2
- Software / Patch Download and Software Staging
- Source Environment Review
- Backup
- Gather Database Stats -- exec dbms_stats.gather_database_stats(estimate_percent => 15);
- Implement fix : Fresh Install of EBS 12.2 File System Failed With RW-50004 On /tmp Directory (Doc ID 2311816.1) -- correct the file system
- Gather System Stats -- exec dbms_stats.gather_system_stats
- Rapid Insall - Create Upgrade File System
- ETCC to the base 12.2 ( weblogic bsu slowness fixed by a patch)
- Gather SYS, Fixed Object and Dictionary Statistics (required) -- Page 4-39 -- run this task and perform the validation
- Gather Schema Stats - skip
- Drop event alert triggers in custom schemas - no custom top prefixed with XX found - skipping this step
- OATM verification - verified
- Application DBA (AD) Tasks Matching - $AD_TOP/sql/adutconf.sql - skipping because version is 12.1.3
- Oracle E-Business Suite Integrated SOA Gateway - skipping because integration is not in use
- GUEST user_id - matching to 6 and end_date is null
- Customer Relationship Management Tasks - does not apply to 12.1.3
- Financials and Procurement Tasks - Advanced Collections - IEX module is Inactive in FND_APPLICATIONS
- Financials and Procurement Tasks - Subledger Accounting - XLA.B.3 is Shared - apply Patch 13420532:R12.XLA.B for R12.1.x - Patched
- Human Resource Management (HRMS) - Object Name : INSERT_POSITION_TXN_INFO -- modified the package from LONG to CLOB
- Supply Chain Management Tasks - Install Base is Inactive --skipping
- Supply Chain Management Tasks - Order Management is Shared -- affected column is with NON-NULL status --- verified
- Supply Chain Management Tasks - Product Hub is Inactive --skipping
- Supply Chain Management Tasks - Packing Hierarchy Structure Type --skipping
- Supply Chain Management Tasks - Backing Up User Defined Attributes Data for Items --skipping
- Supply Chain Management Tasks - Checking for Duplicate Records --validated , as per note and patch instructions there are no duplication rows
- select 'exec dbms_ijob.broken('||job||',true);' from dba_jobs where broken='N'; , change db to spfile , restart , unlock all the locked stats table
- Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1) - validation
- create table bkup_dba_objects_pre_upg_122 as select * from dba_objects;
- Disable AOL Audit Trail (conditional)
- Shutdown Apps
- Download PSU and Apply Latest PSU to Both the RAC Database [ p29141015_121020_Linux-x86-64.zip] and run datapatch post install
- Install ETCC and Apply all Patches p29408621_12102190416_Linux-x86-64.zip
- Run DB ETCC to verify recommendations
- JDK 1.7 Upgrade
- Init.ora verified
- Set FAILED_LOGIN_ATTEMPTS to UNLIMITED
- Maintenance Mode Enabled
- Trigger Disabled
- recycle bin verification
- Apply AD 12.2 upgrade driver , merge with AD Consolidated Upgrade Patch , for adgrants.sql use the one from the merge driver folder + adadmin post install
- prepare the CPU + PreInstall driver and apply in preinstall mode
- Review tablespace and TEMP
- Apply known issues for 12.2
- Apply Consolidated Upgrade Patch 12.2.0 after merging with preinstall drivers
- create table bkup_dba_objects_post_upg_122 as select * from dba_objects; --- 263 invalids
- Disable Maintenance Mode
- DB appsutil and autoconfig
- JRE on DB home
- Configuring the Oracle E-Business Suite Release 12.2 Application Tier
- Enable Online Patching , ETCC ( db only , mt done during staging )
- Gather system stats
- Apply GSCC patch and report review and fix violation action
- create table bkup_dba_objects_post_adop_122 as select * from dba_objects;
- Review and Extend APPS_TS_TX_DATA & APPS_TS_TX_IDX
- Review and run the fix by note 2066607.1 for AD ZD invalid objects
- Apply Online Patching adpatch
- alter system set cluster_database=true scope=spfile; / srvctl stop database -d prod ; srvctl start database -p prod
- Page 4-64 Database Initialization Parameters
- Compile Invalids
- page 4-62 GSCC reports
- DB Parameters settings
- AD and TXK for Release 12.2
- RUP 12.2.10
- Product Interoperatability Patch - oracle workflow
Post Upgrade Task
- Start services , Health Check
- Concurrent Manager Post Upgrade Programs
- check for running job and make sure all finish
- Obsolete Schema drop
- Drop dangling synonyms
- shutdown application
- Online help patch 12.2.0
- Online help patch 12.2.10
NLS task
- apply base NLS patch 12.2.0
- apply NLS and TXK AR patch
- apply NLS patch 12.2.10
- apply base NLS help patch 12.2.0
- apply base NLS help patch 12.2.10
- wf patch
Post Upgrade Release Task
- Application Customization Migration
- Additional Licensing
- Patch 28984562 for workflow
- Patch as per 2357700.1 for workflow
- Connection Leak Patches
- Instance Stabilization - oacore sizing 4 per node with 2gb heap , 2 forms servlet engine per node with 2gb heap
- run fs_clone force=yes
- Create Mainfest File for NLS
- hrglobal
- dummy cutover
- Mailer Configuration
- UTL Folder Update
- Node Addition
- LB Configuration
With this we are done with the upgrade to EBS 12.2 on Database 19c
Refer to the Index Page to see the full flow of the upgrade.
