Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Revert Oracle EM Express to utilize Flash interface

Per OTN support Doc ID 2500405.1, we are supposedly able to "downgrade" the 19C EM interface from Jet to Flash since the Jet version in 19c is not yet fully functional.
To that end, the related DocID provides a command that fails when copied-n-pasted directly from the OTN DocID:
SQL> @?/rdbms/admin/execemx emx
It fails with:
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'PRVT_EMX' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
See attached ullustration
Can someone please explain how it is that an Oracle supplied SQL file supplied in this installation created folder (\rdbms\admin) fails to execute?
And, more importantly, can someone please provide a viable, working command that we can execute in order to revert to utilizing the EM Flash interface instead of the not-ready-for-prime time Jet-based Em interface, pleeeeease?
Best Answer
-
Hi,
the solution is simple:
Please run "@?/rdbms/admin/execemx emx" as SYS, not as SYSTEM or any other user.
HTH
Markus
Answers
-
Hi,
the solution is simple:
Please run "@?/rdbms/admin/execemx emx" as SYS, not as SYSTEM or any other user.
HTH
Markus
-
Hi there Markus:
Thank yo for such a fast response. We tried logging in as SYS but received the response:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER -
Using SQLDvlp as well
-
Markus:
We got it to run.
Thanks again!
Mariano
-
Hi,
please run
sqlplus "sys as sysdba"
to connect
Regards
Markus
-
I'm glad that you solved the problem.
Please mark the thread as "answered" - thank you.
Best regards
Markus