Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2012
    Posts
    1

    Question Unanswered: Enable Network Access to Apex

    Hi guys, I have been trying to allow network access to oracle apex 11g.

    I had 4 errors when executing the commands ra 44416 invalid acl unresolved principal flows 030000
    ora 06512 at sys_dbms_network_acl_admin
    ora 06512 at line 20
    ora 01403 no data found
    HELP PLS ~ Am' I doing anything wrong here?

    Commands (copied and pasted everything except the comments) entered:

    DECLARE
    ACL_PATH VARCHAR2(4000);
    ACL_ID RAW(16);
    BEGIN
    -- Look for the ACL currently assigned to 'localhost' and give APEX_030000
    -- the "connect" privilege if APEX_030000 does not have the privilege yet.
    SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS
    WHERE HOST = 'localhost' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;
    -- Before checking the privilege, ensure that the ACL is valid
    -- (for example, does not contain stale references to dropped users).
    -- If it does, the following exception will be raised:
    --
    -- ORA-44416: Invalid ACL: Unresolved principal 'APEX_030000'
    -- ORA-06512: at "XDB.DBMS_XDBZ", line ...
    --
    SELECT SYS_OP_R2O(extractValue(P.RES, '/Resource/XMLRef')) INTO ACL_ID
    FROM XDB.XDB$ACL A, PATH_VIEW P
    WHERE extractValue(P.RES, '/Resource/XMLRef') = REF(A) AND
    EQUALS_PATH(P.RES, ACL_PATH) = 1;
    DBMS_XDBZ.ValidateACL(ACL_ID);
    IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_030000',
    'connect') IS NULL THEN
    DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,
    'APEX_030200', TRUE, 'connect');
    END IF;
    EXCEPTION
    -- When no ACL has been assigned to 'localhost'.
    WHEN NO_DATA_FOUND THEN
    DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('local-access-users.xml',
    'ACL that lets power users to connect to everywhere',
    'APEX_030200', TRUE, 'connect');
    DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('local-access-users.xml','localhost');
    END;
    /
    COMMIT;

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Sorry, I'm incapable of debugging your code (lack of knowledge). However, *maybe* you'd want to check Oracle 11g: Access Control List (...) and see if it helps.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •