I am completely new to APEX and trying out myself.
While Apex 4.2.1 installation, and configuring Embedded PL/SQL Gateway.
Topic: To grant connect privileges to any host for the APEX_040100 database user
getting error while running DBMS_NETWORK_ACL_ADMIN (as per example given in installation doc)
ERROR at line 1:
ORA-44416: Invalid ACL: Unresolved principal 'APEX_040100'
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 252
ORA-06512: at line 29
ORA-01403: no data found
Completely stuck and not able to proceed further....
I found out the issue. Actual DB user referred in doc was different than what was got created when I install APEX.
In example it was mentioned as "APEX_040100". Where as in my DB it was not present. My DB has "APEX_040000" and "APEX_040200".
I changed the script to have APEX_040000 and it worked.
Now again when I changed to script to APEX_040200, and ran, it is failing. Not sure, if we need to run for both users. Any pointers here?