Adobe Flash De-Support And Impact On Oracle Enterprise Manager

Tech

Oracle Enterprise Manager (OEM) Updates The end of life of Adobe Flash has been well advertised for 31 December 2020. Not only is Adobe discontinuing Flash, but Flash based content will be blocked from running in Flash Player after that date. So, it is not adequate to simply leave your Flash based systems at older […]

Oracle Enterprise Manager (OEM) Updates

The end of life of Adobe Flash has been well advertised for 31 December 2020. Not only is Adobe discontinuing Flash, but Flash based content will be blocked from running in Flash Player after that date. So, it is not adequate to simply leave your Flash based systems at older versions after the EOL date.

The impact of Flash on Oracle Enterprise Manager (OEM) is detailed in Oracle support documents:

How does Oracle Enterprise Manager (OEM) use Flash?

Oracle Enterprise Manager (OEM) in its Cloud Control and Database Control iterations has used Flash to display the dynamic performance pages (performance home, top activity, real-time SQL monitoring etc). If you have Diagnostic and Tuning Packs available, then the corresponding OEM functionality will stop working when Flash goes end of life.

To retain functionality, it will be necessary to install or upgrade to Cloud Control to OEM 13.4 RU 7. While there is some functionality that is replaced from 13.3, 13.4 RU7 completely replaces Flash functionality with Oracle JavaScript Extension Toolkit (JET).

EM Express, the standalone version of OEM for single databases will similarly need to be upgraded. If your database is below the version required to replace Flash functionality then you will have to upgrade the database and its EM Express version to access performance pages.

Legacy Database Support

If you have 11.2.0.4 databases and use Database Control (DB Console) then the only options are to:

Install a Cloud Control system at the latest version and monitor the database from there. OEM 13.4 is certified to manage databases back as far as 11.2.0.4.
Use SQL Developer Web
Use SQL Developer, noting that the dynamic pages detailed below are not available from this console

Performance Hub

The Advisor Webcast listed above provides details on the reorganisation and new functions of the performance pages via the Performance Hub in the newest versions of OEM.

Non-OEM Options

While OEM is the best tool to review up to date information via Top Activity (now ASH Analytics) and Performance Home, there are other tools available that will provide information if you have the diagnostic pack available.

SQL Developer provides diagnostic tools including:

Dynamic generation of AWR and ADDM reports
ASH details
Waits for the past hour
Sessions by status (active/inactive), counts, etc, and
Top SQL by CPU, Disk, Executions, Waits
Real time SQL monitoring

A very limited sub-set of these is available (particularly Waits for the past 1 hour) without the diagnostic pack license, but most of the others interact with AWR.

Oracle

Learn More.

Blue Crystal graduates from the Australian Centre for Business Growth

Blue Crystal Solutions is proud to announce its successful graduation from the Growth Modules Program at the Australian Centre for Business Growth (AUCBG), University of South Australia. Over the past 9 months, our leadership team gained expert insights, actionable strategies, and a clear roadmap to accelerate our growth.

Oracle Database 23ai Blue Crystal Solutions: Efficient Cloud Migration and Technology Integration

New Features in Oracle Database 23ai: Security Improvements for Oracle Schema

Discover how Oracle Database 23ai levels up privilege management with schema-level privileges. This innovative feature simplifies security and enhances database control by enforcing the Principle of Least Privilege (PoLP), ensuring compliance, and streamlining user access. Dive into the methodology, advantages, and practical examples for leveraging schema-level privileges effectively.

Oracle Premier Support Extension: Database 19c

Premier Support Extension for Oracle Database 19c to December 31, 2029 gives organisations more time to plan their database upgrade strategy. With bug fixes, security patches, upgrades and 24x7 Oracle database monitoring by Blue Crystal Solutions, you can manage your Oracle 19c support effectively.

Blue Crystal Solutions: your trusted & innovative IT partner.

Australian owned and operated since 2004, we provide information technology services locally, nationally and beyond.

We are a specialised supplier of Cloud, Application, Database & Infrastructure, Operating System Management, Modernisation and Transformation services. With security at the forefront of everything we do, we can also work with your cyber teams to significantly improve your security posture whilst ensuring all your services with us are fortified by our integrated outage protection and 24×7 monitoring tool, BlueDiamond.