My Oracle Support Banner

Configuring Wallet Manager To Enable HTTPS Connections Via UTL_HTTP.REQUEST (Doc ID 169768.1)

Last updated on SEPTEMBER 14, 2021

Applies to:

Advanced Networking Option - Version 8.1.5 to 19.9.0.0.0 [Release 8.1.5 to 19.0]
Oracle Security Service - Version 8.1.7.4.0 to 19.11.0.0.0 [Release 8.1.7 to 19.0]
Information in this document applies to any platform.

Purpose

This article has been written to address the following errors that can be encountered when trying to use UTL_HTTP.REQUEST with a URL that is of type HTTPS :

Oracle 8i and lower:




Note that the line number for the first ORA-06512 is line 174 or 1556.
If this is reported as any other number it is unlikely that the information reported will be useful in resolving.
Continue to check on other references as well as the ORA-xxxxx value.


Scope

The article has been written to address RDBMS versions 8.1.6.x and 8.1.7.x as these both use V2.1 of Wallet Manager.
Starting with Oracle9i newer versions of Wallet Manager are being used and, whilst this article can still be used for configuration, the error messages reported have been improved to recognize what part of the SQL is incorrect (as reported earlier).

It has also been written to assume no knowledge of OAS/9iAS and is solely to address the first stage of being able to test that we can access the HTML source of the webpage via a SQLPlus session.



The article describes how to set up UTL_HTTP.REQUEST and the wallet manager for a generic website.
By making appropriate changes it should be able to extend to any website that the customer has 'https' access to.
A main point to note is that if the local browser on the Database server cannot access the URL, we will not be able to make calls via this mechanism.
The article is not intended to describe the HTTPS/SSL mechanism in any detail or why it might be required.


A final point is that the certificate saving from a browser was done with Chrome, and so the steps may be different on different browsers.
The primary values and selections should be considered in those cases.



Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.