Oracle 19c - The Server tab is missing in Enterprise Manager

scervenka

I installed Oracle 19c database. I logged as System user into Enterprise Manager.

I want to create new user and set permissions to him, but the Server tab is missing. There is only Performance tab.

Can you help me, please ?

Markus Flechtner

Hi,

the Enterprise Manager Database Express which is delivered with Oracle Database 19c is based on Oracle JET (Javascript-Extension-Toolkit) and provides performance-reporting functionality only.

So it is intended that there is no server-tab.

You can revert back to the flash-based Enterprise Manager Database Express which was delivered with Oracle 12.1 to 18c with the SQL command (as SYS)

"@?/rdbms/admin/execemx emx"

Re-enabling the JET-based is done with "@?/rdbms/admin/execemx omx"

HTH

Markus

Markus Flechtner

Hi,

the Enterprise Manager Database Express which is delivered with Oracle Database 19c is based on Oracle JET (Javascript-Extension-Toolkit) and provides performance-reporting functionality only.

So it is intended that there is no server-tab.

You can revert back to the flash-based Enterprise Manager Database Express which was delivered with Oracle 12.1 to 18c with the SQL command (as SYS)

"@?/rdbms/admin/execemx emx"

Re-enabling the JET-based is done with "@?/rdbms/admin/execemx omx"

HTH

Markus

scervenka

It works perfectly.

Thank you very much.

Markus Flechtner

You're welcome.

Please do not forget to mark your question as "answered" - thank you.

Markus

Memed ROCMA

HI,

please help me to solve this problem, in fact i have the same problem as scervenka, i have to execute the command  "@?/rdbms/admin/execemx omx " ;  but it does not work it gives me this results :

Markus Flechtner

Obviously, you try to run a script against a database instance which is not up and running.

(Read the error messages: "ORA-1034 Oracle not available")

Are your OS-environment settings (ORACLE_SID, ORACLE_HOME) correct and is the instance up and running?

Regards

Markus

P.S. And do not forget to change your display name as described in https://community.oracle.com/welcome

Memed ROCMA

yes OS-environment settings (ORACLE_SID, ORACLE_HOME) is correct , thus instance up and running ,

Can you help me, please ?

Memed ROCMA

I checked everything, and the whole configuration is as it should;

and still the same problem ,

Markus Flechtner

I'm sorry, but according to the messages you had posted, your database instance is not running, which contradicts your statement "everything is as it should".

And I've never seen Oracle reporting "ORA-1034" although everything is OK.

Memed ROCMA

yes you are right sir, I had an error on the scipt of database instance,

problem solved,

thank you very much.

scervenka

Hi Markus,

if flash is off (will be turned off in 2020),

what way, for example, how to create a user and set permissions, via UI, of course ?

Thank you in advance for your answer.

Markus Flechtner

Hi,

either Oracle extends the JET based Oracle Enterprise Manager DB Express or you have to use another GUI tool, e.g. SQL Developer

Regards

Markus

User_CZFXK

Hi @Markus Flechtner

Now, when flash was removed from web browsers and I re-enabled JET. How can I see Server tab, please ?