Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORDS 22 Standalone HTTPS support for multiple domains?

AndyHApr 20 2023

We're using ORDS to support our APEX applications. We host some of our applications for our customers; they are assigned a subdomain of our domain for each application.

Currently, we have an Apache HTTPS front-end HTTP proxying to Tomcat using AJP to run multiple ORDS war files, each associated with a customer/application/environment e.g. app1.cust1.ourdomain.com, app2.cust1.ourdomain.com, app2.cust2.ourdomain.com.

We'd like to simplify our environment and make it more secure by reducing the number of ORDS instances and running them in standalone mode with HTTPS, with Apache/Nginx as a proxy.

We thought we could either use one ORDS for all the environments or break them down by customer and environment (e.g. production, test, training). In this case we could have something like:

Apache > ORDS1 supporting app1.cust1.ourdomain.com, training.app1.cust1.ourdomain.com, etc. and

Apache > ORDS2 supporting app1.cust2.ourdomain.com, test.app1.cust2.ourdomain.com, etc.

OR

Apache > ORDS1 supporting app1.cust1.ourdomain.com, app1.cust2.ourdomain.com, etc.

Apache > ORDS2 supporting training.app1.cust1.ourdomain.com, test.app1.cust1.ourdomain.com. test.app1.cust2.ourdomain, etc.

Is this possible? Can we have a single ORDS instance supporting multiple domains? If so, how do we configure this? Our current sticking point is creation/use of SSL certificates and SNI: we thought we could just concatenate all the applicable certificates into the standalone location, and Jetty would select the appropriate one when proxied to - but this doesn't seem to be happening.

Any ideas/thoughts?

This post has been answered by AndyH on May 17 2023
Jump to Answer
Comments
Post Details
Added on Apr 20 2023
1 comment
400 views