19c Database Upgrade - Self Guided Assistance with Best Practices for EBS

 19c Database Upgrade - Self Guided Assistance with Best Practices (Doc ID 1919.2)

EBS Related Documents for Upgrading Oracle Database to 19c

• Information Center: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 (Doc ID 2655839.2)
  
• 19c Database with Oracle E-Business Suite R12 Known Issues & Solutions (Doc ID 2662860.1)
  
• Oracle Database 19c Upgrade Analyzer for Oracle E-Business Suite(Doc ID 2704990.1)

Recommended Training

Database Performance Basic Session (Video)

Database - Performance Considerations Before Upgrading to Oracle Database 19c [video] (Doc ID 2656534.1)

This one-hour session will discuss following topics to help with successful upgrade of older version of Oracle database to 19c, help identify any regressed SQLs and to maintain better performance in the database going forward:

Topics Include:

• Proactively avoid sources of slower Database Upgrade
  
  
• Proactively avoid known 19c Database Problems
  
  
• Proactively alleviate known SQL Tuning and Wrong Result problems
  
  
• Proactively Manage 19c Databases in a better way
  
  
• Effectively use a few important Oracle Support Tools
  
  

Please download the PDF file attached to the video training for important step by step instructions mentioned in the training.

 

Oracle Database Patching Best Practices (Video)

Overview of Routine Oracle Database Maintenance: Patching [video] (Doc ID 2663346.1)

This one-hour session will discuss an overview of routine Oracle Database Maintenance patching tips and guidelines.

Topics Include:

• Types of Patches
  
  
• Patch Delivery Methods
  
  
• Conflict Resolution
  
  
• Testing Patches
  
  
• Applying Patches
  
  
• Other Patching Related News

 

Oracle Database 19c Upgrade Virtual Classroom Series (Video)

Attend all four sessions to complete the learning path on Oracle Database Upgrade.

• Oracle Database 19c Upgrade Virtual Classroom Series (link)

Topics Include:

• Session 1: Release Strategy and Patching Best Practices
  
  
• Session 2: Upgrade to Oracle Database 19c using AutoUpgrade
  
  
• Session 3: Performance Stability, Tips, Tricks & Underscores
  
  
• Session 4: Migrate to Multi-tenant Architecture

 

SQL-T (SQLTXPLAIN) (Video)

Oracle Database - SQLT (SQL Tuning) for Everyone [video] (Doc ID 2656521.1)

 

This one-hour session will help the customer analyze a SQL tuning problem whether the performance is seen due to upgrade of the database to Oracle 19c or even in an existing database because of various other reasons.

Topics Include:

• Brief Overview on SQLT (SQL Tuning) tool
  
  
• How do we use it to Analyze a SQL Tuning problem or a wrong result problem?
  
  
• What are the alternative tools available for similar analysis?
  
  
• Using SQL Monitor report for analysis of a SQL tuning problem

 

SQL Plan Management: (SPM) Overview and Best Practices (Video)

Oracle Database 19c - SQL Tuning Using Plan Stability Methods SPM and SQL Quarantine [video] (Doc ID 2656520.1)

 

This one-hour session will discuss details about various plan stability methods in Oracle 19c database to help maintain a better performing execution plan for a SQL statement. Execution plan of a SQL can change for various reasons. We will discuss following topics:

Topics Include:

• Brief overview of SQL Plan Management (SPM) and SQL Quarantine (SQ) Features
  
  
• What Plan Stability methods are available in 19c EE/SE DBs?
  
  
• How Plan Stability methods are implemented in 19c?
  
  
• What to do if SPM is not usable as a plan stability method?
  
  
• How SQL Quarantine feature compliments SPM?
  
  
  
  

Additional Resources

 

Upgrade Checklist Documents

• Oracle 19c - Complete Checklist for Manual Upgrades to Non-CDB Oracle Database 19c - (Doc ID 2539778.1)
  
  
• Oracle 19c - Complete Checklist for Upgrading to Oracle Database 19c (19.x) using DBUA (Doc ID 2545064.1)
  
  
• Oracle 19c - Complete Checklist for upgrading Oracle 12c, 18c Container Database (CDB) to Oracle 19c Release using DBUA (Doc ID 2543981.1)
  
  
• Oracle 19c - Complete checklist for Manual Upgrade for upgrading Oracle 12.x, 18c Container database (CDB) to Oracle 19c (19.x) (Doc ID 2549866.1)
  
  
• Patches to apply before upgrading Oracle GI and DB to 19c (Doc ID 2539751.1)

 

LiveLabs – Interested in learning more about specific areas of 19c?  Try out Oracle LiveLabs which gives you access to tools and technologies to run a wide variety of labs and workshops for 19c.

Exadata GI and DB Upgrade

• 19c Grid Infrastructure and Database Upgrade steps for Exadata Database Machine running on Oracle Linux (Doc ID 2542082.1) 

Multitenant, CDB and PDB

• Best Practices for Pluggable Database End User and Application Connection and Open on Database Startup (Doc ID 2833029.1)
• Best Practices for memory parameters in PDBs (Doc ID 2881438.1)

EBS Related Documents for Upgrading Oracle Database to 19c

• Information Center: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 (Doc ID 2655839.2)
  
• 19c Database with Oracle E-Business Suite R12 Known Issues & Solutions (Doc ID 2662860.1)
  
• Oracle Database 19c Upgrade Analyzer for Oracle E-Business Suite(Doc ID 2704990.1)

 

SAP and 19c Upgrade - there are several SAP Support notes (accessible by SAP customers) which provide important information on the prerequisites, configuration, required patches etc. for an upgrade to 19c.

• SAP Note 2799900   is a must read as it summarizes all information on SAP NetWeaver with 19c.  Start with this note.
  
  
• SAP Note 2800001   describes the actual upgrade process and must be strictly followed for a successful upgrade.  Note:   Upgrade is done via DBUA,  AutoUpgrade is NOT supported.
  
  

Additional Recommended Notes and Blog Posts to Review

• Database Upgrade Quick Start Guide (link)
  
• Additional Patches to Install (Doc ID 2781612.2)
  
• Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (Doc ID 2118136.2)
  
• Oracle Database 19c Proactive Patch Information (Doc ID 2521164.1)
  
  
• AutoUpgrade Tool (Doc ID 2485457.1)
  
  
• Oracle service to assist in upgrading to 19c (Advanced Services for Upgrade to Oracle Database 19c)
  
  
• 19c/Exadata Stabilization and Support Service – ACS provides in-depth technical analysis to resolve post 19c upgrade issues
  

Oracle Database AutoUpgrade 19c (VIDEO)

• Upgrading 2 databases in parallel
  
  
• Oracle Database (RDBMS) on Unix AIX,HP-UX,Linux,Solaris and MS Windows Operating Systems Installation and Configuration Requirements Quick Reference (12.1/12.2/18c/19c) (Doc ID 1587357.1)
  
  
• How long will my database upgrade take ? Revisited (link)  - Upgrade your Database - NOW! (Blog post)
  
  
• Master Note for Database Proactive Patch Program - (Doc ID 888.1)
  
• RAT Testing FAQ: Database Upgrade Using Real Application Testing (Doc ID 1600574.1)
  
  
• Database Features and Licensing App (link) - View feature availability across releases and to see what features are new in 19c
• 
  

• information Center: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 (Doc ID 2655839.2)
• 19c Database with Oracle E-Business Suite R12 Known Issues & Solutions (Doc ID 2662860.1)
• Oracle Database 19c Upgrade Analyzer for Oracle E-Business Suite (Doc ID 2704990.1)
• For Oracle E-Business Suite On Premises Databases and Databases on OCI Compute VM, customers are strongly recommended to follow:
  • Interoperability Notes: Oracle E-Business Suite Release 12.2 with Oracle Database 19c (Doc ID 2552181.1)
  • Interoperability Notes: Oracle E-Business Suite Release 12.1 with Oracle Database 19c (Doc ID 2580629.1)