Database Administration (MOSC)

MOSC Banner

Sending mail from oracle db 12c results ORA-24247: network access denied by access control list (ACL

edited Feb 2, 2018 4:10AM in Database Administration (MOSC) 5 commentsAnswered ✓

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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center