Want to get started on APEX development but don't want to muck around with Linux too much, then this guide's for you! As a follow-up to our second ORCLAPEX-YVR meetup on June 17, 2015, and to supplement Trent Schafer's excellent post on how you could build an Oracle APEX instance, here's a simple procedure that you can use to stand up your personal APEX development environment in probably much less than 30 minutes depending on your Internet connection bandwidth!
- Download and save the following installation packages on your computer:
- Oracle Database Express Edition 11g Release 2
- Oracle Application Express 5.0
- Oracle REST Data Services 3.0
- Download and install Git (you may use other Git clients if preferred, e.g. SourceTree)
- Download and install OracleVirtualBox (version 5.0.x)
- Download and install Vagrant (version 1.7.x)
- Start a terminal session or the Command Prompt for the next few steps. Note: "vagrant" should have been added to your system path during the installation.
- Clone the oraclexe-apex project:
$ git clone https://github.com/OraOpenSource/OXAR.git
- Change your working directory to oraclexe-apex
$ cd OXAR
- Copy the installation files into files subdirectory.
- Update the config.properties. Specify the location and filenames of the installation files. ![OXAR Project Configuration Changes]./assets/oraclexe-apex-project-config-changes-300x74.png)
- Execute the command:
$ vagrant up
- Done! Wait for the build process to complete and then test your instance using your browser and point to http://localhost:50080/ords/. If you see the APEX login page, then you are good to go! By default, the Vagrant is configured to use the Centos 7 base box provided by Puppet Labs. If Ubuntu is preferred, then try switching the base box ubuntu/trusty64. To do so, update the vagrantfile and set the desired base box.
For the trust64 base box provided by Ubuntu, the Oracle REST Data Services (ORDS) application may not run out-of-the-box (pun intended). If the time-zone for the guest OS has not been defined, then that might result in a JDBC connection error (ORA-01882). If you encounter a similar issue, please perform the following steps to fix the problem:
- Login to the guest OS using SSH. The username and password are both "vagrant".
$ ssh -l vagrant -p 2222 localhost
- Execute the command and then use the wizard to set the correct timezone for your system:
$ sudo dpkg-reconfigure tzdata
- Reboot the server:
$ sudo /sbin/reboot