My Oracle Support Banner

UTL_HTTP request failed with ORA-01031 in Autonomous Database (Shared) (Doc ID 2930976.1)

Last updated on APRIL 29, 2024

Applies to:

Autonomous Database Serverless - Version N/A to N/A
Information in this document applies to any platform.

Symptoms

The UTL_HTTP.REQUEST failing with ORA-01031 in Autonomous Database (Shared)
All the steps followed in the Note 2776540.1

Example :

 

SQL> select utl_http.request('https:/www.example.com') from dual;
select utl_http.request('https://www.example.com') from dual
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1620
ORA-01031: insufficient privileges
ORA-06512: at "SYS.UTL_HTTP", line 712
ORA-06512: at "SYS.UTL_HTTP", line 1562
ORA-06512: at line 1

 In OCI VM DB system, the same URL fails with below error 

 

select utl_http.request('https://www.example.com',null,'file:/home/oracle/customerdb','XXXX') from dual;

UTL_HTTP.REQUEST('HTTPS://www.example.com',NULL,'FILE:/HOME/ORAC
--------------------------------------------------------------------------------
<html>
<head><title>400 The plain HTTP request was sent to HTTPS port</title></head>
<body>
<center><h1>400 Bad Request</h1></center>
<center>The plain HTTP request was sent to HTTPS port</center>
<hr><center></center>
</body>
</html>

 

Cause

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

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

In this Document
Symptoms
Cause
Solution


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