X

The Latest Oracle E-Business Suite Technology News direct from
Oracle E-Business Suite Development & Product Management

Check Your EBS Database Upgrade with the New EBS Database 19c Upgrade Analyzer

Elke Phelps, and contributing author: David Heisler

In addition to helping customers resolve issues via Oracle Service Requests, Oracle Support builds free diagnostic tools called analyzers for Oracle E-Business Suite. Oracle Support Analyzers are non-invasive scripts that run health checks on your EBS environments. The analyzers look for common issues and generate standardized reports that provide solutions for known issues and recommendations based on best practices.

The following document includes an inventory of all EBS analyzers:

Spotlight on the New E-Business Suite Database 19c Upgrade Analyzer

Oracle Support recently released a new analyzer that helps with the upgrade to Oracle Database 19c for Oracle E-Business Suite 12.x environments. The Database 19c Upgrade analyzer for EBS 12.x provides guidance and recommendations based upon the documented upgrade process in the following:

The Database 19c Upgrade analyzer for EBS 12.x evaluates your environment before, during  and after the database upgrade.  It performs validation of critical database upgrade steps and checks for known issues.  The results of the analysis are provided in an easy to read HTML report. Troubleshooting issues with the database upgrade is also easier when using this analyzer. 

The EBS Database 19c Upgrade Analyzer is available for download from the following document:

The following are key features of the Database 19c Upgrade for EBS 12.x Analyzer:
  • Runs as a standalone java program
  • Analyzes your E-Business Suite database environment in an easy-to-read HTML report
  • Checks operating system requirements
  • Evaluates system setup and configuration, applied E-Business Suite patches, and critical database patching data
  • Displays potential errors or missed steps based on the progress of your database upgrade
  • Provides recommended actions
  • Collects all log files associated with the upgrade patching
References

Related Articles

Join the discussion

Comments ( 5 )
  • Roy Saturday, September 19, 2020
    After each upgrade of ebs some or other sql changes its execution plan and started performing poorly. Can this analyzer identity those sql whose plan has changed before and after the upgrade, and help in proactive fixing for those.
  • YZ Monday, September 21, 2020
    Hi Elke,
    quick question about
    "Oracle Database 19c Upgrade Analyzer
    for Oracle E-Business Suite (Doc ID 2704990.1)"

    It seems to me it only applies to 12.2

    Oracle Applications DBA - Version 12.2 to 12.2.9 [Release 12.2Cloud to 12.2]
    Oracle E-Business Suite Technology Stack - Version 12.2 to 12.2.9 [Release 12.2]

    could it be applied to 12.1? or is there a similar doc for 12.1?

    Thanks for your attention.
  • Elke Phelps (Oracle Development) Monday, September 21, 2020
    YZ - Thanks for the comment.

    The "APPLIES TO" section of MOS Note 2704990.1 states - Version 12.2 to 12.2.9; however, this is misleading.
    I will request that the owner of the MOS Note update this to clarify that
    Database 19c Upgrade Analyzer described in MOS Note 2704990.1 applies to both EBS 12.1 and EBS 12.2.

    Please refer to the details in the MOS Note as the interoperability MOS Note for 12.1 is analyzed and example upgrade guidance is provided for both EBS 12.2 and EBS 12.1.

    Thanks.
    Elke
  • Elke Phelps (Oracle Development) Tuesday, September 22, 2020
    YZ - I wanted to provide you an update on the support of EBS 12.1.3 with the DB 19c Upgrade Analyzer.

    The APPLIES section of MOS note 2704990.1 has been updated as follows:
    Oracle Applications DBA - Version 12.1.3 to 12.2.9 [Release 12.1 to 12.2]
    Oracle E-Business Suite Technology Stack - Version 12.1.3 to 12.2.9 [Release 12.1 to 12.2]

    Thanks for bringing this to our attention.

    Regards,
    Elke
  • David Heisler (Oracle Support) Tuesday, September 22, 2020
    Hello Roy,

    There was a similar post on out Technology Stack community page about this same issue. I am looking into this request to be added into the analyzer in the very near future.

    Thank you for you suggestion to improve the analyzer.

    Dave
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.

Recent Content