Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to understand the database ORA-24247 problem", the content of the article is simple and clear, easy to learn and understand, now please follow the editor's train of thought slowly in depth, together to study and learn "how to understand the database ORA-24247 problem"!

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

Develop and write a stored procedure for oracle to send mail, which was previously used in the 10G version, but now it is used in the 11.2.0.4 version, and debugging cannot be used.

If an error ORA-24247 is found, the online inquiry information is as follows:

1. You need to create an access control list (ACL) using DBMS_NETWORK_ACL_ADMIN.CREATE_ACL first

BEGIN

DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (

Acl = > 'email_server_permissions.xml'

Description = > 'Enables network permissions for the e-mail server'

Principal = > 'smp'

Is_grant = > TRUE

Privilege = > 'connect')

END

/

two。 Then use DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL to associate this ACL with the mail server

BEGIN

DBMS_NETWORK_ACL_ADMIN.assign_acl (

Acl = > 'email_server_permissionsr.xml'

Host = > 'stcmail.cn.simplo.com',-SMTP server address

Lower_port = > 25

Upper_port = > NULL)

COMMIT

END

/

3. Delete the ACL list.

-- drop

BEGIN

DBMS_NETWORK_ACL_ADMIN.drop_acl (acl = > 'email_server_permissions.xml')

COMMIT

END

/

-query ACL list

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

Thank you for your reading, the above is the content of "how to understand the database ORA-24247 problem". After the study of this article, I believe you have a deeper understanding of how to understand the database ORA-24247 problem, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.