Table of Contents
- List of Examples
- List of Tables
- Title and Copyright Information
- Preface
- Changes in Release 22.2 Oracle REST Data Services Installation and Configuration Guide
-
1
Oracle REST Data Services
Installation Checklist
- 1.1 System Requirements
- 1.2 Supported Java EE Application Servers
- 1.3 Supported Oracle Application Express (APEX) Versions
- 1.4 ORDS Installer Privileges Script
- 1.5 Privileges Granted to the Oracle REST Data Services Users
- 1.6 About the Database Users Used by Oracle REST Data Services
- 1.7 About Command-Line Interface
- 1.8 About Online Help
-
2
Installing and Configuring Oracle REST Data
Services
-
2.1
Installing Oracle REST Data Services
- 2.1.1 Downloading ORDS
- 2.1.2 Setting Up the Configuration Folder Structure
-
2.1.3
Interactive Command-Line Interface
Installation
- 2.1.3.1 Entering a Number to Select the Type of Installation
- 2.1.3.2 Entering a Number to Select the Database Pool
- 2.1.3.3 Entering the Database Pool Name
- 2.1.3.4 Entering a Number to Select the Database Connection
- 2.1.3.5 Entering the Database Host Name
- 2.1.3.6 Entering the Database Listener Port
- 2.1.3.7 Entering the Database Service Name
- 2.1.3.8 Entering the TNS Location
- 2.1.3.9 Entering a Number to Select the TNS Network Alias
- 2.1.3.10 Entering the Custom Database URL
- 2.1.3.11 Entering the Administrator Username
- 2.1.3.12 Entering the Database Password
- 2.1.3.13 Entering the Default Tablespace
- 2.1.3.14 Entering a Number to Select Additional Feature(s)
- 2.1.3.15 Entering a Number to Configure and Start ORDS in Standalone Mode
- 2.1.3.16 Entering a Number to Use HTTP or HTTPS Protocol
- 2.1.3.17 Entering the HTTP Port
- 2.1.3.18 Entering the HTTPS Port
- 2.1.3.19 Entering a Number to Select the Certificate Type
- 2.1.3.20 Entering the SSL Hostname
- 2.1.3.21 Entering the Path for the SSL Certificate
- 2.1.3.22 Entering the Path for the SSL Certificate’s Private Key
- 2.1.3.23 Entering the APEX Static Resources Location
- 2.1.4 Non-Interactive Command-Line Interface Installation (Silent)
- 2.2 Repairing the Oracle REST Data Services Installation
- 2.3 Upgrading Oracle REST Data Services
-
2.4
Uninstalling Oracle REST Data Services
-
2.4.1
Interactive Uninstall CLI
- 2.4.1.1 Entering a Number to Select the Database Pool
- 2.4.1.2 Entering a Number to Select the Database Connection Type
- 2.4.1.3 Entering the Database Host Name
- 2.4.1.4 Entering the Database Listener Port
- 2.4.1.5 Entering the Database Service Name
- 2.4.1.6 Entering the TNS Location
- 2.4.1.7 Entering a Number to Select the TNS Network Alias
- 2.4.1.8 Entering the Custom Database URL
- 2.4.1.9 Entering the Administrator Username
- 2.4.1.10 Entering the Database Password for SYS AS SYSDBA
- 2.4.1.11 Entering an Option for Uninstalling ORDS
- 2.4.2 Non-Interactive Uninstall CLI
-
2.4.1
Interactive Uninstall CLI
- 2.5 Updating the Configuration Settings
-
2.1
Installing Oracle REST Data Services
- 3 Configuring Oracle REST Data Services for Multiple Databases
-
4
Miscellaneous Configuration Options of Oracle
REST Data Services
- 4.1 Using the REST Enabled SQL Service with MySQL Database
- 4.2 Support for Oracle RAC Fast Connection Failover
- 4.3 Configuring ORDS with Kerberos Setup
- 4.4 Authorizing Oracle REST Data Services to Access Oracle Data Guard Protected Users
- 4.5 Configuring REST-Enabled SQL Service Settings
- 4.6 Configuring the Maximum Number of Rows Returned from a Query
- 4.7 Configuring ICAP Server Integration for Virus Scan
- 4.8 Configuring the Custom Error Pages
- 4.9 Managing ORDS Administrator Privilege
- 4.10 Managing ORDS Runtime Privilege
- 4.11 Using OAuth2 in Non-HTTPS Environments
- 4.12 Configuring ORDS Metadata Cache
-
5
Deploying and Monitoring Oracle REST Data
Services
-
5.1
Deploying Oracle REST Data Services
- 5.1.1 Serve Commands for Running in Standalone Mode
-
5.1.2
Oracle WebLogic Server
- 5.1.2.1 About Oracle WebLogic Server
- 5.1.2.2 Configuring Oracle Application Express Images
- 5.1.2.3 Launching the Administration Server Console
- 5.1.2.4 Deploying ORDS on Oracle WebLogic Server
- 5.1.2.5 Configuring WebLogic to Handle HTTP Basic Challenges Correctly
- 5.1.2.6 Verifying the State and Health of ords and i
- 5.1.3 Apache Tomcat
- 5.1.4 Oracle Cloud Infrastructure
- 5.2 Monitoring Oracle REST Data Services
-
5.1
Deploying Oracle REST Data Services
-
6
Using the Multitenant Architecture with Oracle REST Data Services
- 6.1 Setting Up ORDS in a CDB Environment
-
6.2
Setting Up ORDS in an Application Container
- 6.2.1 Prerequisites for Creating ORDS in an Application Container
- 6.2.2 Installing ORDS in the Application Root Container
- 6.2.3 Creating an Application Seed
- 6.2.4 Creating an Application PDB from the Application Seed
- 6.2.5 Configuring the PLSQL Gateway for APEX
- 6.2.6 ORDS Configuration Files Setup
- 6.2.7 Running ORDS
- 6.2.8 Upgrading ORDS in the Application Container
- 6.2.9 Uninstalling ORDS from the Application Container
- 6.2.10 Verifying ORDS in the Application Container
- 6.3 Making All PDBs Addressable by Oracle REST Data Services (Pluggable Mapping)
-
7
Installing and Configuring Customer Managed
ORDS on Autonomous Database
- 7.1 About Customer Managed Oracle REST Data Services on Autonomous Database
- 7.2 Downloading Wallet and Verifying Connection to Autonomous Database
- 7.3 Creating an Oracle REST Data Services Runtime Database User
- 7.4 Downloading and Configuring Oracle REST Data Services
- 7.5 Preparing and Starting ORDS
- 8 Migration of Legacy Configuration
-
A
Non-Interactive ORDS CLI Commands
Examples
- A.1 Non-Interactive Install/Upgrade
- A.2 Non-Interactive Install/Upgrade (create a proxied PLSQL Gateway User)
- A.3 Non-Interactive Install/Upgrade (specify PLSQL Gateway User and not using RESTful Services)
- A.4 Non-Interactive Install/Upgrade (disable a configured PLSQL Gateway)
- A.5 Non-Interactive Uninstall ORDS
- A.6 config CLI Examples
- B ORDS Legacy Commands and New ORDS CLI Commands
- C About the Oracle REST Data Services Configuration Files
- Index