oracle发送https请求

1. 通过浏览器下载对应网址证书
   
   

2. 进入oracle用户创建wallet

• 将su文件里的session限制关掉，不让进不了oracle用户

  vi /etc/pam.d/su
  #session include system-auth
  su - oracle
  

• 生成wallet

  mkdir -p /u01/app/oracle/admin/orcl/wallet
  orapki wallet create -wallet /u01/app/oracle/admin/orcl/wallet -pwd WalletPasswd123 -auto_login
  

• 添加证书

  orapki wallet add -wallet /u01/app/oracle/admin/orcl/wallet -trusted_cert -cert "your_cert.cer" -pwd WalletPasswd123
  

3. 创建展示网页过程

   
   CREATE OR REPLACE PROCEDURE show_html_from_url (p_url  IN  VARCHAR2,
                                                   p_username IN VARCHAR2 DEFAULT NULL,
                                                   p_password IN VARCHAR2 DEFAULT NULL) AS
     l_http_request   UTL_HTTP.req;
     l_http_response  UTL_HTTP.resp;
     l_text           VARCHAR2(32767);
   BEGIN
     -- Make a HTTP request and get the response.
     l_http_request  := UTL_HTTP.begin_request(p_url);
   
     -- Use basic authentication if required.
     IF p_username IS NOT NULL and p_password IS NOT NULL THEN
       UTL_HTTP.set_authentication(l_http_request, p_username, p_password);
     END IF;
   
     l_http_response := UTL_HTTP.get_response(l_http_request);
   
     -- Loop through the response.
     BEGIN
       LOOP
         UTL_HTTP.read_text(l_http_response, l_text, 32766);
         DBMS_OUTPUT.put_line (l_text);
       END LOOP;
     EXCEPTION
       WHEN UTL_HTTP.end_of_body THEN
         UTL_HTTP.end_response(l_http_response);
     END;
   EXCEPTION
     WHEN OTHERS THEN
       UTL_HTTP.end_response(l_http_response);
       RAISE;
   END show_html_from_url;
   

4. 测试请求

   begin
    UTL_HTTP.set_wallet('file:/u01/app/oracle/admin/orcl/wallet');
    show_html_from_url('www.domain.com');
   end;