ORA-24247错误的含义 ORA-24247错误表示“network access denied by access control list (acl)”,即网络访问被访问控制列表(ACL)拒绝。这是一个Oracle数据库错误,通常发生在尝试从数据库服务器外部访问数据库时,但访问控制列表阻止了这种访问。 可能导致ORA-24247错误的原因 ACL配置不当:Oracle数据库的ACL可能未正确...
方法/步骤 1 BEGINdbms_network_acl_admin.create_acl(acl => 'email_server_permissions.xml', --新文件名DESCRIPTION => 'Normal Access',principal => 'CONNECT', --赋予角色 CONNECTis_grant => TRUE,PRIVILEGE => 'connect',start_date => NULL,e...
8 /DECLARE*ERROR at line 1:ORA-24247: network access denied by access control list (ACL)ORA-06512: at "SYS.UTL_TCP", line 17ORA-06512: at "SYS.UTL_TCP", line 267ORA-06512: at "SYS.UTL_SMTP", line 161ORA-06512: at "SYS.UTL_SMTP", line 197ORA-06512: at line 6SQL> sho use...
ORA-24247: network access denied by access control list (ACL) ORA-06512: at “SYS.DBMS_DEBUG_JDWP”, line 68 ORA-06512: at line 1 Process exited. Disconnecting from the database USERXXX. 从Oracle 12c开始,如果通过基于JDWP(Java Debug Wire Protocol)协议的调试器(如SQL Developer, JDeveloper)调...
ORA-24247: network access denied by access control list (ACL)错误: ERROR at line 1: ORA-24247: network access denied by access control list (ACL) ORA-06512: at "SYS.'UTL_INADDR", line 654 ORA-06512: at "SYS.'UTL_INADDR", line 671 ...
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]: ORA-24247: network access denied by access control list (ACL) using RESOLVE privi
ORA-24247: network access denied by access control list (ACL) ORA-06512: at “SYS.UTL_MAIL”, line 662 ORA-06512: at “SYS.UTL_MAIL”, line 679 ORA-06512: at line 2 Solution: From 11g onward, to send mail using UTL_MAIL or UTL_SMTP , ACL need to be created in the database....
Oracle11gR2下PL/SQL访问网络的错误ORA-24247 原有系统运行在10g下面,有很多程序是使用utl_smtp, utl_http等包进行网络访问。最近升级到11gR2之后,wait4friend遇到ORA-24247错误。错误信息如下 ORA-24247: network access denied by access control list (ACL)...
简介:配置ACL报ORA-24247的解决方法前言: 在通过ORACLE11往外部发送邮件的时候,ORA-24247的错误,详细的错误错误信息如下:ERROR at line 1:ORA-24247: network access denied by access control list (ACL)ORA-06512: at "SYS. 配置ACL报ORA-24247的解决方法 ...
1. 创建ACL控制XML BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL ( acl => 'email_server_permissions.xml', description => 'Enables network permissions for the e-mail server', principal => 'CENTER_ADMIN', --需要访问oracle 的用户 is_grant => TRUE, ...