How to Revert EM Express 19c Back to Flash-Based

  • by

Since Oracle database 19c, we have a new UI of Enterprise Manager Express (EM Express) which is based on Java JET technology.

Oracle EM Express 19c - Java JET Technology

Oracle EM Express 19c - Java JET Technology

As you can see, some functions we used in EM Express 12c are not available anymore in the new UI. On the positive side, it responds very fast, very express. But maybe it's too simplified to be useful for DBA. Luckily, we can revert the UI back to flash-based.

SQL> @?/rdbms/admin/execemx emx

Session altered.


no rows selected

old   1: select nvl( '&1','omx') p1 from dual
new   1: select nvl( 'emx','omx') p1 from dual

P1
---
emx


PL/SQL procedure successfully completed.


Session altered.

If you don't know what @ or ? means, you can check the post: What Symbols are Used in Oracle Database.

After that, please re-logon to make it work.

Oracle EM Express 19c - Flash-Based Technology

Oracle EM Express 19c - Flash-Based Technology

To go back to Java JET based UI, you can do this:

SQL> @?/rdbms/admin/execemx omx

For more information about EM Express 19c, you can refer to: Introduction to Oracle Enterprise Manager Database Express 19c.

Leave a Reply

Your email address will not be published. Required fields are marked *