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 Introduction to Oracle REST Data Services for more information.
- In the location where ORDS is installed, create an ORDS configuration folder
(this creates a folder and sets up the ORDS configuration environment and
settings). For example:
java -jar ords.war configdir ./ORDSConfig_2
On Oracle Cloud Infrastructure with Linux with a YUM repository the ORDS configuration folder is:
- Edit the ORDS configuration file created in the preceding step
./ords/conf/apex_pu.xmlto add or update the following:
<?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd"> <properties> <entry key="db.username">ORDS_PUBLIC_USER2</entry> <entry key="db.password">!password</entry> <entry key="db.wallet.zip.service">dbname_low</entry> <entry key="db.wallet.zip"><![CDATA[contents_of_wallet_NAME.zip.b64]]></entry> </properties>
The extra "
!" in front of the password causes the password to be encrypted the next time the ORDS service starts.
db.wallet.zipentry (contents_of_wallet_NAME.zip.b64) includes the contents of the
base64encoded wallet archive that you prepared previously. Ensure that this text is enclosed in a CDATA block (this is a long string of characters). See Downloading Wallet and Verifying Connection to Autonomous Database for details on how to create the
db.username, specified as ORDS_PUBLIC_USER2 is the database username you previously defined. See Creating Customer Managed Oracle REST Data Services User Role for more information.
./ords/defaults.xmlas required for your ORDS installation. See Understanding Configurable Parameters for more information.
- Ensure the plsql gateway is enabled for APEX support:
If you want use ORDS with APEX, then you need to enable the PL/SQL gateway in ORDS.