You should never be prompted for username and password when the EPG is properly configured for an Application Express installation. When you get that prompt, usually it indicates 1 of 3 things:
- EPG was not configured properly
- ANONYMOUS is not unlocked
- Images have not been loaded properly
Since you followed my blog post, I assume you ran apex_epg_config_con.sql (and not apex_epg_config.sql) connected to CDB$ROOT. To rule out 1 and 3, view the logs apex_epg_config_con*.log and look for any errors reported. If the issue is with ANONYMOUS, make sure the PDB is open that you configured APEX in, and do the following:
sqlplus / as sysdba
show con_name -- should show CDB$ROOT
alter user ANONYMOUS account unlock;
You are totally right
In my first apptemp I did NOT run the apex_epg_config_con.sql.
I wanted to use the embedded PL SQL gateways , and I thought the EPG is optional.
After all - I never ran it on my 11g installation,
Is it mandatory to run it in this case ?
when I ran it - all worked fine
Yes, it is mandatory in this case, and that is because you ran apxremov_con.sql prior to installation 4.2.2 into the CDB. apxremov_con.sql (which calls apxremov.sql) will also remove the /apex "DAD" from EPG. Since /apex is no longer known to EPG after running apxremov_con.sql, you need to run apex_epg_config_con.sql to restore it.
Maybe you should make a small correction in your blog.
you state in step 7 :
- If you want to configure EPG as your web listener, do the following additional steps:
I think you should note that this is NOT optional , but mandatory in that specific case when you remove the container installation
thank you very much
I appreciate your time