Oracle Documentation<\/a>.<\/p>\n\n\n\nSolutions:<\/h2>\n\n\n\n
<\/p>\n\n\n\n
Adjust Your Application<\/strong>: Configure your application to expose the endpoint using the HTTPS protocol on port 443.<\/span><\/p>\n\n\n\nOR<\/p>\n\n\n\n
Move to a Private Subnet<\/strong> (Recommended): Transition your Autonomous Database to a private subnet with a NAT Gateway and update the ACL accordingly.After moving the database to the private subnet and configuring routes to use the NAT Gateway, update the ROUTE_OUTBOUND_CONNECTIONS<\/code> parameter:<\/span><\/p>\n\n\n\n\n- Enable Private Endpoint Routing<\/strong>:<\/span><\/li>\n<\/ul>\n\n\n\n
ALTER DATABASE PROPERTY SET ROUTE_OUTBOUND_CONNECTIONS = ‘PRIVATE_ENDPOINT’;<\/p>\n\n\n\n
\n- Disable Private Endpoint Routing<\/strong>(if you want to revert to default):<\/li>\n<\/ul>\n\n\n\n
ALTER DATABASE PROPERTY SET ROUTE_OUTBOUND_CONNECTIONS = ”;<\/p>\n\n\n\n
\n- Update the ACL<\/strong> (just an example):<\/li>\n<\/ul>\n\n\n\n
begin\n dbms_network_acl_admin.create_acl (\n acl => 'acl_ai.xml',\n description => 'Enable ACL to XYZ Host',\n principal => 'USER_THAT_NEEDS_ACL',\n is_grant => TRUE,\n privilege => 'connect',\n start_date => null,\n end_date => null\n );\n \n dbms_network_acl_admin.add_privilege (\n acl => 'acl_ai.xml',\n principal => 'USER_THAT_NEEDS_ACL',\n is_grant => TRUE,\n privilege => 'resolve',\n start_date => null,\n end_date => null\n );\n \n dbms_network_acl_admin.assign_acl (\n acl => 'acl_ai.xml',\n host => '*.YOUR_DOMAIN',\n lower_port => 80,\n upper_port => 80\n );\n commit;\nend;\n\/\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"If you’re using an Autonomous Database Serverless (ADB-S) and attempting to call HTTP (not HTTPS) endpoints, encountering the ORA-01031 error is common. While your first step might be to check the Access Control List (ACL) or grant permissions to the user calling the package, this alone won’t resolve the issue. Here’s how to fix it: […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"material-hide-sections":[],"footnotes":""},"categories":[56,45,8,6],"tags":[5,29,4,3],"class_list":["post-1545","post","type-post","status-publish","format-standard","hentry","category-atp","category-database","category-oci","category-oracle","tag-banco-de-dados","tag-cloud","tag-database","tag-oracle"],"_links":{"self":[{"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1545","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=1545"}],"version-history":[{"count":7,"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1545\/revisions"}],"predecessor-version":[{"id":1552,"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1545\/revisions\/1552"}],"wp:attachment":[{"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=1545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=1545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adrianotanaka.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=1545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}