ORA-29273 http request failed. ORA-24247: network access denied by access control list (ACL)
本文共 1067 字，大约阅读时间需要 3 分钟。
ORA-29273 http request failed.和ORA-24247: network access denied by access control list (ACL)；
Oracle的一个存储过程要调WebService，报上述错误：
oracle11.2.0.4版本。
处理办法：
select acl,PRINCIPAL,PRIVILEGE,IS_GRANT from dba_network_acl_privileges;BEGIN dbms_network_acl_admin.create_acl(acl => '/sys/acls/utlpkg.xml', description => '/sys/acls/utlpkg.xml', principal => 'GISTAR', -- 赋予权限给哪个用户 is_grant => TRUE, -- true表示授予权限 false表示取消权限 privilege => 'connect'); dbms_network_acl_admin.add_privilege(acl => '/sys/acls/utlpkg.xml', principal => 'GISTAR', is_grant => TRUE, privilege => 'connect'); dbms_network_acl_admin.assign_acl(acl => '/sys/acls/utlpkg.xml', host => '*'); COMMIT;END;/select acl,PRINCIPAL,PRIVILEGE,IS_GRANT from dba_network_acl_privileges;
参考：
http://blog.itpub.net/8520577/viewspace-1295182/
转载地址：http://risof.baihongyu.com/
你可能感兴趣的文章
(PAT 1115) Counting Nodes in a BST (二叉查找树-统计指定层元素个数)
查看>>
(PAT 1143) Lowest Common Ancestor (二叉查找树的LCA)
查看>>
(PAT 1061) Dating (字符串处理)
查看>>
(PAT 1079) Total Sales of Supply Chain (树的深度优先遍历)
查看>>
(PAT 1004) Counting Leaves (树的广度优先)
查看>>
1034 Head of a Gang (深度优先遍历寻找连通分量)
查看>>
(PAT 1053) Path of Equal Weight (树的深度优先遍历+剪枝)
查看>>
(PAT 1077) Kuchiguse (字符串暴力枚举)
查看>>
(PAT 1141) PAT Ranking of Institutions (排序+unorded_map的使用)
查看>>
(PAT 1118) Birds in Forest (并查集)
查看>>
(PAT 1114) Family Property (并查集)
查看>>
(PAT 1127) ZigZagging on a Tree (二叉树建立+层序遍历)
查看>>
(PAT 1155) Heap Paths (堆+完全二叉树遍历)
查看>>
(PAT 1142) Maximal Clique (图中顶点与顶点之间的关系)
查看>>
(PAT 1126) Eulerian Path (欧拉图/欧拉回路判断)
查看>>
(PAT 1130) (二叉树加括号的表达式)
查看>>
(PAT 1122) Hamiltonian Cycle (哈密顿图)
查看>>
数据结构 拓扑排序
查看>>
(PAT 1146) Topological Order (拓扑排序)
查看>>
(PAT 1108) Finding Average (字符串处理)
查看>>