3 Installing and Configuring Customer Managed ORDS on Autonomous Database
This section explains how to install and configure Customer Managed Oracle REST Data Services (ORDS) on Autonomous Database.
Topics:
3.1 About Customer Managed Oracle REST Data Services on Autonomous Database
When you provision an Autonomous Database instance, by default Oracle REST Data Services (ORDS) is preconfigured and available for the instance. With the default ORDS, Oracle performs any required configuration, patching, and maintenance. Additionally, you can also configure Autonomous Database to use ORDS running in a customer managed environment.
When you use the default ORDS on Autonomous Database, you cannot modify any of the ORDS configuration options.
For example, with the default configuration, the JDBC connection pools have a maximum of
100 connections and the connections for ORDS are preconfigured to use the
LOW
database service. Use a customer managed environment if you
want manual control of the configuration and management of Oracle REST Data Services. For example, use this option when your applications require
larger connection pools or if you need more control over the ORDS configuration
options.
When ORDS runs in a customer managed environment, you are responsible for configuration, patching, and maintenance of ORDS in the customer managed environment. After you configure Autonomous Database to use your customer managed ORDS in addition to the existing autonomously managed ORDS, you can route ORDS HTTPS traffic through your environment. The default Autonomous Database web server and ORDS are still running and ORDS traffic goes to the ORDS running in the customer managed environment. This provides an additional and alternative HTTPS solution for Autonomous Database.
Installing and configuring a customer managed environment for ORDS allows you to run ORDS with configuration options that are not possible using the default Oracle managed ORDS available with Autonomous Database.
Note:
- Oracle REST Data Services 19.4.6 or higher is required to use a customer managed environment for ORDS with Autonomous Database.
- Installing and configuring a customer managed environment for ORDS is currently only supported with Autonomous Database on Shared Exadata Infrastructure.
3.2 Downloading Wallet and Verifying Connection to Autonomous Database
You need to configure ORDS to connect to the Autonomous Database. With Oracle REST Data Services (ORDS) running in a customer managed environment, you need to obtain the Autonomous Database wallet on the system that runs the customer managed ORDS. Perform the following steps to download the wallet and verify the connection to the Autonomous Database:
3.3 Creating Customer Managed Oracle REST Data Services User Role
To use Autonomous Database
with Oracle REST Data Services (ORDS) running in a customer managed environment on your Autonomous Database, you must create a user, grant
privileges to the user, and run the procedure
ORDS_ADMIN.PROVISION_RUNTIME_ROLE
.
Perform the following steps to create a user for the ORDS JDBC Connection Pool and prepare the Autonomous Database instance for using Oracle REST Data Services in a customer managed environment:
3.4 Downloading and Configuring Oracle REST Data Services
To use Autonomous Database with Oracle REST Data Services (ORDS) running in a customer managed environment you need to install ORDS.
Note:
Oracle REST Data Services 19.4.6 or higher is required for a customer managed environment with Autonomous Database.Depending on where you install Oracle REST Data Services for your customer managed environment, do the following:
-
If your customer managed environment for Oracle REST Data Services runs in Oracle Cloud Infrastructure, then use an Oracle YUM repository and perform a YUM install of ORDS.
-
If your customer managed environment for Oracle REST Data Services runs in some other environment, then download ORDS from the Oracle REST Data Services Download page. See Installing Oracle REST Data Services for more information.
3.5 Preparing and Starting ORDS
To use customer managed Oracle REST Data Services (ORDS) on Autonomous Database, on the system where ORDS runs you need to perform additional configuration steps and then start ORDS.
Note: