0 Replies Latest reply on Jun 2, 2014 6:24 AM by 1063933

    ORA-24247: network access denied by access control list (ACL) - need help

    1063933

      I was facing the below error and I found that no ACL is been assigned.

       

      ORA-24247: network access denied by access control list (ACL)

      ORA-06512: at "SYS_UTIL_TCP", line 17

      ORA-06512: at "SYS_UTIL_TCP", line 246

      ORA-06512: at "SYS_UTIL_SMTP", line 127

      ORA-06512: at "SYS_UTIL_TCP", line 150

      ORA-06512: at line 8


      Then i assigned the ACL to the owf_mgr by executing following codes.


      BEGIN

         DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (

          acl          => 'system.xml',

          description  => 'Permissions to access http://www.aspiresys.com',

          principal    => 'OWF_MGR',

          is_grant     => TRUE,

          privilege    => 'connect');

         COMMIT;

      END;

      /

       

      BEGIN

        DBMS_NETWORK_ACL_ADMIN.assign_acl (

          acl         => 'systems.xml',

          host        => '192.168.7.90',

          lower_port  => 80,

          upper_port  => NULL);

       

       

        DBMS_NETWORK_ACL_ADMIN.assign_acl (

          acl         => 'systems.xml',

          host        => '10.1.10.*',

          lower_port  => NULL,

          upper_port  => NULL);

        COMMIT;

      END;

      /

       

      BEGIN

         DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (

          acl          => 'systems.xml',               

          host         => '*.systems.com');

         COMMIT;

      END;

      /


      But still i am facing same errors.


      Is there any solution for this?


      Thanks in Advance