# Oracle ORDS and Apache Before using ORDS, you need a database and APEX. Go [here](https://books.clusterapps.com/books/deployments/page/oracle-database-19c-ee) to do that. Download [ORDS at Oracle](https://www.oracle.com/database/technologies/appdev/rest-data-services-downloads.html). ### Installation of ORDS The Oracle Rest Data Services (ORDS) installation consists of unzipping the downloaded archive, running the configuration command, then deploying. This setup is going to run ORDS in standalone mode with Apache HTTP to proxy requests. As **oracle** user. Download the ORDS zip to /tmp. Extract the installer. ```shell cd /tmp mkdir -p /u01/ords unzip ords-20.*.zip -d /u01/ords ``` Make a backup of the original properties file ```shell mv /u01/ords/params/{ords_params.properties,ords_params.properties.orig} ``` Create a ords\_params.properties file. ```shell cat > /u01/ords/params/ords_params.properties < Create the `apex.conf` file in the `etc/httpd/conf.d/` directory with the contents as below: ```shell # proxy ORDS # ServerName example.com # ServerAlias www.example.com # alias for APEX static files Alias "/i" "/var/www/apex/images/" # uncomment the line below if you want # to redirect traffic to ORDS from root path # RedirectMatch permanent "^/$" "/ords" # proxy ORDS requests to tomcat ProxyRequests off ProxyPass "https://localhost:8443/ords" ProxyPassReverse "https://localhost:8443/ords" ``` Tell SELinux (Yes, that should be running) to allow Apache to communicate to ORDS. ```shell setsebool httpd_can_network_connect on ```