Problem:
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 246
ORA-06512: at "SYS.UTL_SMTP", line 127
ORA-06512: at "SYS.UTL_SMTP", line 150
ORA-06512: at "GEOPP.SEND_MAIL", line 240
ORA-06512: at "GEOPP.SEND_MAIL", line 118
ORA-06512: at "GEOPP.GEOPP_ALARM_MAIL", line 115
ORA-06512: at line 1
Cause:
Solution:
http://www.oracle-base.com/articles/11g/FineGrainedAccessToNetworkServices_11gR1.php
begin
dbms_network_acl_admin.create_acl ( acl => 'utlpkg.xml', description => 'Normal Access', principal => 'GEOPP', is_grant => TRUE, privilege => 'connect', start_date => null, end_date => null );
dbms_network_acl_admin.assign_acl ( acl => 'utlpkg.xml', host => '10.200.123.135', lower_port => 1, upper_port => 1000);
commit;
end;
/
Subscribe to:
Post Comments (Atom)
Windows (powershell) counterparts of Linux commands
You may find Windows mostly powershell equivalent of frequently used Linux commands here. I will update this post, with newer ones by the ti...
4 comments:
Thanks,
It help me lot.
thank you very much. I research it for 5 days. my problem was sloved
what do you use to enter the code? I've tried sql plus and sql command line but it's not working
You may get error messages because of single quotes in varchar2 dataype parameters. I guess while copy pasteing them from editor to wordpress they are changed.
As far as I remember, I had executed the anonymous plsql block from Toad editor.
Post a Comment