Zookeeper ORA-24247: Network Access denied access control list (ACL)
Note: The command must be used under the System user.
You must first use dbms_network_acl_admin.create_acl to create an access control list (ACL ),
Use dbms_network_acl_admin.assign_acl to associate the ACL with the email server,
Finally, use dbms_network_acl_admin.add_privilege to grant the user the permission to connect to the mail server.
Begin
Dbms_network_acl_admin.create_acl (
ACL => 'email _ server_permissions.xml ',
Description => 'enables network permissions for the E-mail Server ',
Principal => 'apps ',
Is_grant => true,
Privilege => 'connect ');
End;
/
Begin
Dbms_network_acl_admin.assign_acl (
ACL => 'email _ server_permissions.xml ',
Host => '127. 125.50.132 ', -- SMTP server address
Lower_port => 25,
Upper_port => null );
Commit;
End;
/
-- Drop
Begin
Dbms_network_acl_admin.drop_acl (ACL => 'email _ server_permissions.xml ');
Commit;
End;
/
-- Query
Select host, lower_port, upper_port, ACL from dba_network_acls;
Select ACL,
Principal,
Privilege,
Is_grant,
To_char (start_date, 'dd-MON-YYYY ') as start_date,
To_char (end_date, 'dd-MON-YYYY ') as end_date
From dba_network_acl_privileges;
ORA-24247: Network Access denied access control list (ACL)