ORDS
Previously known as the APEX Listener.
Requires J2EE Application Server: WebLogic (WLS), Glassfish, Apache Tomcat or a built-in Jetty server for "Standalone" mode.
ORDS, OHS and the Embedded PL/SQL Gateway can be run in parallel.
The mod_plsql plugin for OHS has been deprecated in OHS as of OHS 12.1
The mod_plsql plugin for OHS and the embedded PL/SQL Gateway have been deprecated in APEX since APEX 20.1 and desupported since APEX 20.2
ORDS does not work on AIX
"Oracle REST Data Services is a Java EE-based alternative for Oracle HTTP Server and mod_plsql. The Java EE implementation offers increased functionality including a command line based configuration, enhanced security, file caching, and RESTful web services. Oracle REST Data Services also provides increased flexibility by supporting deployments using Oracle WebLogic Server, GlassFish Server, Apache Tomcat, and a standalone mode.
The Oracle Application Express architecture requires some form of web server to proxy requests between a web browser and the Oracle Application Express engine. Oracle REST Data Services satisfies this need but its use goes beyond that of Oracle Application Express configurations. Oracle REST Data Services simplifies the deployment process because there is no Oracle home required, as connectivity is provided using an embedded JDBC driver."
Version
Version
Check version from target database server using...
SELECT version
FROM ords_metadata.ords_schema_version;
Check version from ORDS server (22+) using...
/tomcat/ords/bin/ords --version
Validate
Validate
cd /u01/app/ords
java -jar ords.war validate
Startup (Standalone)
Startup (Standalone)
/u01/dba/ords/scripts/start_ords.sh
Assumes script creation described in ORDS Install has been completed.Shutdown (Standalone)
Shutdown (Standalone)
/u01/dba/ords/scripts/stop_ords.sh
Assumes script creation described in ORDS Install has been completed.Bibliography
Bibliography
https://support.oracle.comCritical Patch Update (CPU) Program Apr 2020 Patch Availability Document (PAD) (Doc ID 2633852.1)Note 1945619.1 - Future Direction for Application Express (APEX) and the Oracle HTTP Server (OHS) / Mod_plsqlNote 1576588.1 - Oracle Web Tier - Statement of Direction. Oracle REST Data Services (ORDS) / APEX Listener General FAQ (Doc ID 1536052.1)How to Configure ORDS to Run APEX and MOD_PLSQL URLs (Doc ID 2228856.1)ORDS working in HTTP and not working with HTTPS (SSL) when IBM-AIX JVM is used (Doc ID 2758589.1)No Supported Ciphers - Error When Starting ORDS in HTTPS / SSL Mode on AIX (Doc ID 2711967.1)
https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/index.htmlhttps://docs.oracle.com/en/database/oracle/oracle-rest-data-services/23.1/books.html (Books)
https://www.oracle.com/database/technologies/appdev/rest.htmlhttps://www.oracle.com/tools/technologies/faq-rest-data-services.html
https://community.oracle.com/community/groundbreakers/database/developer-tools/oracle_rest_data_serviceshttps://community.oracle.com/thread/3726473 (How do I migrate from OHS to ORDS)
https://blogs.oracle.com/fusionmiddlewaresupport/future-direction-for-application-express-apex-and-the-oracle-http-server-ohs-modplsql-v2https://blogs.oracle.com/apex/post/oracle-rest-data-services-the-only-supported-web-listener-for-oracle-apex
https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-installation-on-tomcathttps://oracle-base.com/articles/misc/oracle-rest-data-services-ords-standalone-mode
http://dgielis.blogspot.com/2015/09/ords-yes-we-can.htmlhttps://www.slideshare.net/DimitriGielis/oracle-application-express-apex-and-microsoft-sharepoint-integration
https://www.slideshare.net/KrisRice/oracle-rest-data-services-best-practices-overview
https://www.thatjeffsmith.com/oracle-rest-data-services-ords/https://content.dsp.co.uk/apex/ordsinary
REST Data Services Installation and Configuration Guidehttps://docs.oracle.com/cd/E37099_01/doc.20/e25066/install.htm (Release 2.0)https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/19.4/aelig/installing-REST-data-services.html (Release 19.4)
Supporthttps://apex.world/ords/f?p=100
Oracle Autonomous Databasehttps://dgielis.blogspot.com/2020/08/free-oracle-cloud-custom-domain-name.html
Authenticationhttps://blogs.oracle.com/developers/ords-basic-authentication-with-oracle-apex-v3https://blogs.oracle.com/developers/ords-oauth-20-authentication-with-oracle-apex-v2
mod_plsql to ORDShttps://docs.oracle.com/en/database/oracle/oracle-rest-data-services/19.1/aelig/migrating-mod_plsql-ords.htmlhttps://docs.oracle.com/en/database/oracle/oracle-rest-data-services/21.4/aelig/migrating-mod_plsql-ords.html
ORDS 23.1https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/23.1/books.html
https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/index.htmlhttps://docs.oracle.com/en/database/oracle/oracle-rest-data-services/23.1/books.html (Books)
https://www.oracle.com/database/technologies/appdev/rest.htmlhttps://www.oracle.com/tools/technologies/faq-rest-data-services.html
https://community.oracle.com/community/groundbreakers/database/developer-tools/oracle_rest_data_serviceshttps://community.oracle.com/thread/3726473 (How do I migrate from OHS to ORDS)
https://blogs.oracle.com/fusionmiddlewaresupport/future-direction-for-application-express-apex-and-the-oracle-http-server-ohs-modplsql-v2https://blogs.oracle.com/apex/post/oracle-rest-data-services-the-only-supported-web-listener-for-oracle-apex
https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-installation-on-tomcathttps://oracle-base.com/articles/misc/oracle-rest-data-services-ords-standalone-mode
http://dgielis.blogspot.com/2015/09/ords-yes-we-can.htmlhttps://www.slideshare.net/DimitriGielis/oracle-application-express-apex-and-microsoft-sharepoint-integration
https://www.slideshare.net/KrisRice/oracle-rest-data-services-best-practices-overview
https://www.thatjeffsmith.com/oracle-rest-data-services-ords/https://content.dsp.co.uk/apex/ordsinary
REST Data Services Installation and Configuration Guidehttps://docs.oracle.com/cd/E37099_01/doc.20/e25066/install.htm (Release 2.0)https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/19.4/aelig/installing-REST-data-services.html (Release 19.4)
Supporthttps://apex.world/ords/f?p=100
Oracle Autonomous Databasehttps://dgielis.blogspot.com/2020/08/free-oracle-cloud-custom-domain-name.html
Authenticationhttps://blogs.oracle.com/developers/ords-basic-authentication-with-oracle-apex-v3https://blogs.oracle.com/developers/ords-oauth-20-authentication-with-oracle-apex-v2
mod_plsql to ORDShttps://docs.oracle.com/en/database/oracle/oracle-rest-data-services/19.1/aelig/migrating-mod_plsql-ords.htmlhttps://docs.oracle.com/en/database/oracle/oracle-rest-data-services/21.4/aelig/migrating-mod_plsql-ords.html
ORDS 23.1https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/23.1/books.html