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....
OS: WinXP professional,
DB: Oracle Database 11g Express Edition Release 188.8.131.52.0
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?
Thanks in advance.
Having multiple APEX_0% users suggests your database has originally started with APEX 4.0 and has been upgraded as subsequent versions are released (4.1.x, 4.2.x).
These accounts should be removed, as per the installation guide.
Your current APEX owner would be APEX_040200, and you should be reading documentation pertinent to your APEX version.
blog: [url grassroots-oracle.com]grassroots-oracle.com
twitter: [url twitter.com/swesley_perth]@swesley_perth
-- please mark any useful posts as helpful or correct, in the end it helps us all