Database Security Products (MOSC)

MOSC Banner

UTL_HTTP for REST service configured with SSL TLS SNI gives HTTP Status 301 on Oracle 12.1

edited Sep 1, 2020 5:42PM in Database Security Products (MOSC) 3 commentsAnswered

I have been using UTL_HTTP to GET/POST information to perform operations on a RESTful service since Database 11g - now on 12.1, but it was interrupted when the web service owner changed their SSL certificates, and started using TLS 1.2 with SNI (Server Name Indication) enabled .

I quickly learned that SNI allows you to configure multiple domain names to a single IP address.  My UTL_HTTP requests were failing, because in their simplest form, they are only able to resolve one domain name at a time and I am receiving HTTP Status 301 - Permanently moved.

Setting the number of redirects for the http request didn't help, the request would just follow the redirects until it ran out, and then a 301 status would be returned.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center