Since I had a bit of time this morning and a lot of curiosity, I thought I would try installing ORDS locally (where I have my personal version of 12c installed). I found it surprisingly easy and the steps provided by Oracle were pretty good. I had to figure a couple things out, but what good is documentation if it doesn’t miss out on some key steps? J
1. In the sqldeveloperords folder, I located the Java war file to be used to install (and later run) ORDS.
2. The first thing we want to do is open the command prompt, migrate to the folder and call Java to open the ords.war file. Since this is our first time opening this file, it will run us through the process to install ORDS. Note that if it is already installed, you will not be asked to go through the installation process.
3. The first thing the process asks is where you would like to store your configuration data.
4. The Oracle documentation states that if you do not want to specify the location, you can just hit enter. However, when I did that it asked me for the location again, so I gave the same sqldeveloperords location as the war file was located.
5. Enter the database server. Since I am installing it locally, I used localhost.
6. Enter database listen port. I used the standard 1521.
7. Choose if you would rather specify the database service name or the database SID. I chose service name.
8. Enter the service name or SID.
9. Choose and enter a password for ORDS_PUBLIC_USER.
10. Confirm the ORDS_PUBLIC_USER password.
11. Enter a user with SYSDBA privilege to create the ORDS schema.
12. Choose 1 if you want to use PL/SQL Gateway, or 2 to skip it. I chose to skip it.
Choose and enter a password for APEX_PUBLIC_USER.
13. Confirm the password for APEX_PUBLIC_USER.
14. Choose if you want to create a password for Application Express RESTful Services database users. I chose yes (1).
15. Choose and enter (then confirm for both) passwords for APEX_LISTENER and APEX_REST_PUBLIC_USER.
16. The script will run, showing on the screen.
17. Choose if you want to install ORDS in standalone mode or not. I chose to do so.
18. Here is another place where I had to go off-notes from Oracle because I wasn’t sure what it was asking. I couldn’t Google effectively for “APEX static resources location”, so I instead searched my machine for their documentation for “apeximages”. I found it at the location below on the screenshot.
19. The script will run again, showing the live results on screen.
20. At this point, the installation is complete. I wanted to validate the install, so I typed “java –jar ords.war validate” in the command prompt, provided the requested information, and it finished!
21. Finally, I created a listener administrator using the code “java –jar ords.war user adminlistener “Listener Administrator” and gave the user a password.
22. At this point, your ORDS installation is complete! The documentation I used as my guide is located here: