This discussion is archived
2 Replies Latest reply: Feb 4, 2013 12:19 AM by scott.wesley RSS

error while running DBMS_NETWORK_ACL_ADMIN

anand_gp Newbie
Currently Being Moderated
Hi,
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 11.2.0.2.0

Thanks,
-Anand
  • 1. Re: error while running DBMS_NETWORK_ACL_ADMIN
    anand_gp Newbie
    Currently Being Moderated
    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.
  • 2. Re: error while running DBMS_NETWORK_ACL_ADMIN
    scott.wesley Guru
    Currently Being Moderated
    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.
    http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/otn_install.htm#CBHBABCC

    Your current APEX owner would be APEX_040200, and you should be reading documentation pertinent to your APEX version.

    Scott
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points