Hi,
[1].In our application there is requirement as database job access the http link(http://example.com:8894/) to send reports and our db is in 11.2.0.4 version so I have created ACL to access the web but getting below error.
Syntax used is :
BEGIN
DBMS_NETWORK_ACL_ADMIN.create_acl (
acl => 'utl_http_file.xml',
description => 'ACL functionality for http',
principal => 'scott',
is_grant => TRUE,
privilege => 'connect',
start_date => SYSTIMESTAMP,
end_date => NULL);
COMMIT;
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.assign_acl (
acl => 'utl_http_file.xml',
host => 'example.com',
lower_port => 80,
upper_port => NULL);
COMMIT;
END;
/
Error
-------
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1722
ORA-24247: network access denied by access control list (ACL)
[2].So now what I did is I have changed port range since I suspect some issue is with port values(lower port=>1 and upperport=>65535) after seeing oracle DOC ID 1316035.1).Now error is changed to
Error
-----------
ERROR at line 1:
ORA-20011: ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00243: element attribute value must be enclosed in quotes
Just want to know if I am creating ACL's in right way or not to access the http links?And is there any thing to check before adding port range?Pls help me.Thanks
SELECT utl_http.request('http://example.com') from DUAL
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1720
ORA-12541: TNS:no listener
ORA-06512: at line 1