Sending mail from oracle db 12c results ORA-24247: network access denied by access control list (ACL
Hello!
Please help me to diagnose such issue:
We upgraded our oracle rac db from 11c to 12c. After this we're getting error ORA-24247 when we try to send mail from db from user TEST_USER
TEST_USER isn't dba user. It was assigned to acl list with command:
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE (
host => 'smtp.ourcompany.net',
lower_port => null,
upper_port => null,
ace => xs$ace_type(privilege_list => xs$name_list('connect','resolve'),
principal_name => 'TEST_USER',
principal_type => XS_ACL.PTYPE_DB));
END;
/
Results of query
select PRINCIPAL,host,lower_port,upper_port,privilege from dba_host_aces