I am trying to install APEX 19.1 on ORACLE XE 18c but the problem is that APEX_LISTENER and APEX_REST_PUBLIC_USER are not being created. While I execute apex_rest_config.sql script via sqlplus, an error message appears saying: GetConsoleMode failed, Last Error=|6|
Then I check the list of users and I see that these two users are not created. Is this a bug of APEX installation? Please can anybody help?
Best Answer
That is because you tried installing APEX in the root container, I was able to reproduce the error.
Oracle Express Edition 18c uses the CDB architecture, meaning you have a root container and a pluggable database called XEPDB1.
Whatever you did, you should do it inside the
XEPDB1
pluggable database instead of theCDB$ROOT
root container. I am not saying it can not work like that, I just would not bother with it.Understanding the Installation Choices
So if you log in with
sqlplus / as sysdba
, you can change toXEPDB1
like this:To fix what you have, just log in with
sqlplus / as sysdba
and remove everything withapxremov.sql
. Then log in like above, into theXEPDB1
pluggable database, and try again installing APEX. You can use these steps:Downloading and Installing Oracle Application Express