ORDS 3.0.6 install

We utilize Apache Tomcat and Apache HTTPD to run our web server for our Oracle APEX application.  Recently, ORDS 3.0.6 was released, and since I had heard at Kscope16 that, finally, there is a production ready ORDS 3.0.x, namely ORDS 3.0.6, I decided to install ORDS 3.0.6 within our DEV and TEST environments.

Installation / Upgrade instructions (Windows):
1) delete old ORDS files (not required in a new install) and Tomcat must be already installed (which means a JDK is already installed)
2) place the ORDS files and directories in C:\ORDS
3) open command prompt, navigate to C:\ords
4) java -jar configdir c:\ords
5) java -jar install advanced
6) enter the name of the database server
7) enter the database listen port
8) enter 1 to specify the database service name, or 2 to specify the database SID (we use database SID)
9) enter the database SID
10) enter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step (we want to verify/install Oracle REST Data Services)
11) enter the database password for ORDS_PUBLIC_USER and confirm the password
12) enter 1 if you want to use PL/SQL Gateway of 2 to skip this step (we want to use PL/SQL Gateway)
13) enter the PL/SQL Gateway database user name
14) enter the database password for APEX_PUBLIC_USER and confirm the password
15) enter 1 to specify passwords for Application Express RESTful Services database users or 2 to skip this step (we want to specify passwords)
16) enter the database password for APEX_LISTENER and confirm the password
17) enter the database password for APEX_REST_PUBLIC_USER and confirm the password
18) The proper ORDS schema is installed if it isn't already there.
19) enter 1 if you wish to start in standalone mode or 2 to exit (we want to exit)
20) copy the ords.war file into the Tomcat webapps directory and Tomcat will automatically deploy it.
21) Congrats ORDS is setup and deployed.

However, there is an issue with ORDS 3.0.6 and Chrome.  You will get a Cross Origin Sharing 403 error if you attempt to login to either the APEX developer or your app.  To correct this issue, add RequestHeader set Origin http://localhost:8080 in the Apache HTTPD http.conf file.   The other option of solving the issue is to add ProxyPreserveHost On to the Apache HTTPD http.conf file.  That option did not work well for me though, as it messed up the redirect functionality I had setup within Apache.

reference: https://twitter.com/chrisfreeman99/status/751462158991372289

Kscope16 (drive home from Chicago)

Shane and I drove home (Hibbing, MN) from Chicago via I90 and pay LOTS of tolls.  We stopped in Madison and drove up to the Wisconsin state capitol building which is neat.

Kscope16 day 4 (06/30/2016)

Deep Dive Session
We did not attend this session, instead spending time with Markus and Cristian from FOEX.

Kscope16 day 3 (06/29/2016)

Session 13 (8:30am-9:30am) A quick guide of Free Oracle Tuning Tools - Bjoern Rost
Chris:
PLSQLPLUS
SQLCL
WEB-ASH
MOATS
SNAPPER
ORASASH
SQLT
EDB360
SQLD360
TUNAS360

Shane:
?

Session 14 (10:15-11:15) Affordable workflow options for our APEX app - Niels de Bruijn
Chris:
PL/Flow - http://plflow.sourceforge.net old, last updated 2004, easy to install.
Flow Control - https://github/j-sieben/FCT very new, released 06/2016
Camunda - Camunda community edition (java app can run in Tomcat), supports BPMN 2.0 standards

Shane:
?

Session 15 (12:45-13:45) Release the brakes: Why is my APEX app slow - Peter Raganitsch
Chris & Shane:



Session 16 (14:00-15:00) APEX security: exposing your application to the internet - Nathan Catlow
Chris:
-He did a google search and found about 3000 APEX applications.
-Keep your infrastructure up to date (APEX version, Apache Tomcat version, Apache HTTPD version, ORDS version).
-Remove builder and SQL workshop (runtime only)
-Use the ORDS validation function
-Make sys and system passwords different than ORDS users.



Shane:
?


Session 17 (15:15-16:15) Instrumentation for Oracle DB development - Alex Nuijten
Chris:
LOGGER, newer versions support recording parameters.

Shane:
?

Session 18 (16:30-17:30) Writing SQL that sucks less - Bjoern Rost
Chris & Shane:

Kscope16 day 2 (06/28/2016)

Session 7 (8:30am-9:30am) Avoid network issues and polling with websockets - Kai Donato
Chris:
We could improve our IM functionality within Vireo.

Shane:

Session 8 (9:45-10:45)
/Chris:


Shane:


Session 9 (11:15-12:15) 
Chris:
?

Shane:


Session 10 (14:00-15:00)
Chris:
?

Shane:

Session 11 (15:30-16:30) PLSQL and SQL Outtakes - Helen Sanders
Chris:

Shane:

Session 12 06/28/2016 16:45-17:45
Session 12 (16:45-17:45) It wasn't me: finding bugs in APEX applications - Peter Raganitsch
Chris:
Its wasn't me: finding bugs in APEX applications - Peter Raganitsch

Shane:

Kscope16 day 1 (06/27/2016)

Session 1 (8:30am-9:30am) 5 Ways of building Oracle Applications - Sten Vesterli
Chris:
Sten gave this presentation back in 1998, and there were 5, with Forms being the only common technology.
http://oratoolwatch.com
1) Forms - Data driven UI, Chrome already will not accept browser plugins, although Forms has a solution to launch java without a browser, so Forms is running via the web without a browser.  Sounds like client/server....
2) APEX - Data driven UI, Oracle has over 70,000 APEX applications.
3) ADF - MVC process driven UI.
4) JET - UI only, a toolkit, not a framework, needs LOTS of javascript code.
5) MAF - "Mobile first is stupid, Mobile only is worse!".  Only if the interaction is less than 2 minutes does anyone want it to be "Mobile".

Shane:

Session 2 (10:15am-11:15am) ORDS tips and tricks - Kris Rice
Chris:
Example of the Oracle Chicago cloud data center: 5 HTTPD servers over 2 Weblogic servers running ORDS which connect to 100s of DBs.
Size your connection pools according to your concurrent users.
select * from pool_config;
Shane:


Session 3 (11:30-12:30) APEX 5 plugins - Alan Arentson
Chris:
An APEX plugin is a collection of HTML, CSS, JS, and PLSQL.
Plugins are WAY easier in APEX 5.
Chris will be creating a Topaz signature pad plugin.

Shane:


Hands on Training (14:00-16:15) Build something IoT - Anton Nielsen
Chris:
this was AWESOME!  Built a thermostat that also logs the current temperature and current heat/AC status in an APEX.ORACLE.COM application built by my own hands.


Session 4 (14:00-15:00) ?
Session 4  06/27/2016 14:00-15:00
Shane:

Session 5 (15:15-16:15) ?
Session 5 06/27/2016 15:15-16:15
Shane:



Session 6 (16:30-17:30) The Ultimate APEX dashboard for your JIRA environment - Oliver Lemm
Chris:
Interesting application of APEX and interesting dashboard.


Shane:

Kscope16 APEX Symposium

APEX 5.1 - Shakeeb
-Cards
-Live Template
-Font APEX
-Universal theme - look at example apps for examples.
APEX 5.1 page designer - Marc Sewtz
-lots of productivity enhancements
APEX 5.1 Jet Charts - Marc Sewtz
APEX 5.1 Interactive grids - Patrick Wolf
APEX 5.1 Other New Features - Patrick Wolf
Update from development - Joel Kallman
-The Azimuth of APEX, which is a HPRAD (High Performance Rapid Application Development) tool.
-"Nothing is given, everything is earned".

We are really excited for the release for APEX 5.1, as it will improve our development productivity.

Kscope16 travel day (drive to Chicago)

Shane and I drove from Hibbing, MN to Chicago, IL via Milwaukee.  Nice trip.  Seeing the Milwaukee port and bridge was neat.  It seemed that there were less tolls coming into Chicago from the North.