2 Replies Latest reply: Feb 4, 2013 2:19 AM by swesley_perth RSS

    error while running DBMS_NETWORK_ACL_ADMIN

    anand_gp
      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
          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
            swesley_perth
            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