Wallet / ACL / Network Access - Revision history

Stuart at 09:05, 23 May 2017

2017-05-23T09:05:51Z

Stuart: /* Open the wallet and use UTL_HTTP to retrieve a web page */

2017-05-23T09:05:30Z

‎Open the wallet and use UTL_HTTP to retrieve a web page

Stuart: /* Open the wallet and use UTL_HTTP to retrieve a web page */

2017-05-23T09:05:10Z

‎Open the wallet and use UTL_HTTP to retrieve a web page

Stuart at 08:50, 23 May 2017

2017-05-23T08:50:08Z

Stuart at 08:49, 23 May 2017

2017-05-23T08:49:45Z

Stuart: Created page with "===Create a wallet===

 mkdir /home/oracle/wallet orapki wallet create -wallet /home/oracle/wallet -pwd MyWallePassword999 -auto_login orapki wallet add    -wallet /home/o..."

2017-05-23T08:48:31Z

Created page with "===Create a wallet=== <pre> mkdir /home/oracle/wallet orapki wallet create -wallet /home/oracle/wallet -pwd MyWallePassword999 -auto_login orapki wallet add -wallet /home/o..."

New page

===Create a wallet===
<pre>
mkdir /home/oracle/wallet
orapki wallet create -wallet /home/oracle/wallet -pwd MyWallePassword999 -auto_login
orapki wallet add -wallet /home/oracle/wallet -trusted_cert -cert /tmp/cert1.cer -pwd MyWallePassword999
orapki wallet add -wallet /home/oracle/wallet -trusted_cert -cert /tmp/cert2.cer -pwd MyWallePassword999
orapki wallet add -wallet /home/oracle/wallet -trusted_cert -cert /tmp/cert3.cer -pwd MyWallePassword999
</pre>
===Create an ACL===
<pre>
begin
dbms_network_acl_admin.create_acl ( acl => 'utl_http.xml'
, description => 'my acl'
, principal => 'MCDONAC'
, is_grant => TRUE
, privilege => 'connect'
, start_date => null
, end_date => null
);
commit;
end;
/
</pre>
===Add privilege to ACL===
<pre>
begin
dbms_network_acl_admin.add_privilege ( acl => 'utl_http.xml'
, principal => 'MCDONAC'
, is_grant => false
, privilege => 'connect'
, position => null
, start_date => null
, end_date => null
);

commit;
end;
/
</pre>
===Open the wallet and use UTL_HTTP to retrieve a web page===
<pre>
set serverout on
declare
l_url varchar2(100) := 'https://www.litle.com/';
l_req utl_http.req;
l_result utl_http.resp;
l_data varchar2(32767);
begin
utl_http.set_wallet('file:/home/oracle/wallet', 'MyWallePassword999');
l_req := utl_http.begin_request(l_url);
l_result := utl_http.get_response(l_req);

begin
loop
utl_http.read_text(l_result, l_data, 1000);
dbms_output.put_line (l_data);
end loop;
exception
when utl_http.end_of_body then
utl_http.end_response(l_result);
end;
end;
/
</pre>

@@ Line 65: / Line 65: @@
 </pre>
-===Configure Fine-Grained Access to External Network Services=
+===Configure Fine-Grained Access to External Network Services===
 * From [http://docs.oracle.com/cd/B28359_01/server.111/b28300/afterup.htm#UPGRD12428 Oracle 11g Upgrade Manual]
 Oracle Database 11g Release 1 (11.1) includes fine-grained access control to the UTL_TCP, UTL_SMTP, UTL_MAIL, UTL_HTTP, or UTL_INADDR packages using Oracle XML DB.<br />

@@ Line 64: / Line 64: @@
+/
 </pre>
 ===Configure Fine-Grained Access to External Network Services=
 * From [http://docs.oracle.com/cd/B28359_01/server.111/b28300/afterup.htm#UPGRD12428 Oracle 11g Upgrade Manual]

@@ Line 63: / Line 63: @@
 end;
+/
 </pre>

@@ Line 1: / Line 1: @@
 ===Create a wallet===
 <pre>
 mkdir /home/oracle/wallet