Tuesday, June 20, 2017

useful APEX related URL

Mark down some useful APEX related URL for look back.

https://oracle-base.com/articles/misc/oracle-application-express-apex-5-0-installation
https://community.oracle.com/community/database/developer-tools/application_express/packaged-applications
http://www.odtug.com/apexblogroll
https://mikesmithers.wordpress.com/2015/05/24/migrating-the-xe-database-management-application-to-a-new-version-of-apex/
http://www.oracle.com/technetwork/developer-tools/apex/application-express/upgrade-apex-for-xe-154969.html


ords

https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-3-installation-on-tomcat-7
https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-standalone-mode


Excerpt below from last two articles, which is important to me.


$ $JAVA_HOME/bin/java -jar ords.war configdir /u01/ords/conf
Dec 24, 2016 4:43:18 PM
INFO: Set config.dir to /u01/ords/conf in: /u01/ords/ords.war
$
Configure ORDS using the following command. This is the equivalent of specifying the "install simple" command line parameters. Make sure you agree to configure the PL/SQL Gateway and not to enable "standalone mode".

Auto SSL (HTTPS)

ORDS will automatically create a self-signed certificate for use with SSL if you don't specify a valid certificate and key.

Edit the "/u01/ords/conf/ords/standalone/standalone.properties" file, setting the following parameters. Adjust the port as desired.

jetty.secure.port=8443
ssl.cert=
ssl.cert.key=
ssl.host=
Restart ORDS.

~/scripts/stop_ords.sh
~/scripts/start_ords.sh