UTL_HTTP for REST service configured with SSL TLS SNI gives HTTP Status 301 on Oracle 12.1
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.