Amazon s3 服务与 Oracle 11g 集成

Question

我正在尝试将我们的s3服务与Oracle Apex应用程序集成。点击此链接后：http://www.oracle.com/technetwork/developer-tools/apex/application-express/integration-086636.html#S3

我构建的应用程序假设连接亚马逊服务，并应返回存储桶的内容。

此外，我添加了ACL规则以允许与亚马逊服务进行通信，这篇非常有用的文章：

http://blog.whitehorses.nl/2010/03/17/oracle-11g-access-control-list-and-ora-24247/

我创建了以下异常：

begin
   dbms_network_acl_admin.create_acl (
         acl         => 'utl_http.xml',
         description => 'HTTP Access',
         principal   => 'my_user',
         is_grant    => TRUE,
         privilege   => 'connect',
         start_date  => null,
         end_date    => null
       );
  dbms_network_acl_admin.add_privilege (
         acl        => 'utl_http.xml',
         principal  => 'my_user',
         is_grant   => TRUE,
         privilege  => 'resolve',
         start_date => null,
         end_date   => null
       );

       dbms_network_acl_admin.assign_acl (
         acl        => 'utl_http.xml',
         host       => ' *.amazonaws.com’,
             lower_port => 80,
         upper_port => 80
       );
  commit;
end;

我还为我的用户授予了utl_http执行权限。无论如何，每当我运行应用程序时，我都会收到以下错误消息：

ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1130 ORA-24247: network access denied by access control list (ACL)
    Technical Info (only visible for developers)
    is_internal_error: false
    ora_sqlcode: -29273
    ora_sqlerrm: ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1130 ORA-24247: network access denied by access control list (ACL)
    component.type: APEX_APPLICATION_PAGE_PROCESS
    component.id: 5598811807578444
    component.name: Web Service Request
    error_backtrace:
    ORA-06512: at "SYS.UTL_HTTP", line 1130
    ORA-06512: at "APEX_040200.WWV_FLOW_WEB_SERVICES", line 550
    ORA-06512: at "APEX_040200.WWV_FLOW_WEB_SERVICES", line 1171
    ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS", line 397

甲骨文 11g，顶点 4.2

任何帮助非常感谢。

Answer 1

您仍然ORA-24247，因此表明您的ACL不正确。您为哪些用户提供了连接权限？
您需要将连接权限授予

• 解析架构用户
• 当前 APEX 安装的技术顶点用户。对于顶点4.2 这是APEX_040200