Skip to content

Files

Latest commit

 

History

History
 
 

OracleAPEX

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 
 
 
 
 
 
 
 
 

oracle-18c-apex

This Vagrant project provisions Oracle Database XE 18.4 with Oracle Application Express (APEX) automatically, using Vagrant, an Oracle Linux 7 box and a shell script.

Prerequisites

Read the prerequisites in the top level README to set up Vagrant with either VirtualBox or KVM.

Getting started

  1. Clone this repository git clone https://github.com/oracle/vagrant-projects
  2. Change into the vagrant-projects/OracleAPEX directory
  3. Download the Oracle Database XE 18.4 installation rpm file from OTN into this directory - first time only: https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html
  4. Download Oracle APEX into this directory - first time only: https://www.oracle.com/tools/downloads/apex-downloads.html
  5. Download Oracle Rest Data Services (ORDS) into this directory - first time only: https://www.oracle.com/database/technologies/appdev/rest-data-services-downloads.html
  6. Run vagrant up
    1. The first time you run this it will provision everything and may take a while. Ensure you have a good internet connection as the scripts will update the VM to the latest via yum.
    2. The Vagrant file allows for customization, if desired (see Customization)
  7. Connect to the database.
  8. You can shut down the VM via the usual vagrant halt and the start it up again via vagrant up.

Connecting to Oracle

  • Hostname: localhost
  • Port: 1521
  • SID: XE
  • PDB: XEPDB1
  • OEM port: 5500
  • APEX Admin port: 8080 (on Host system)
  • All passwords are auto-generated and printed on install

Other info

  • If you need to, you can connect to the machine via vagrant ssh.
  • You can sudo su - oracle to switch to the oracle user.
  • The Oracle installation path is /opt/oracle/ by default.
  • On the guest OS, the directory /vagrant is a shared folder and maps to wherever you have this file checked out.

Customization

You can customize your Oracle environment by amending the environment variables in the Vagrantfile file. The following can be customized:

  • ORACLE_CHARACTERSET: AL32UTF8
  • ORACLE_PWD: auto generated
  • SYSTEM_TIMEZONE: automatically set (see below)
    • The system time zone is used by the database for SYSDATE/SYSTIMESTAMP.
    • The guest time zone will be set to the host time zone when the host time zone is a full hour offset from GMT.
    • When the host time zone isn't a full hour offset from GMT (e.g., in India and parts of Australia), the guest time zone will be set to UTC.
    • You can specify a different time zone using a time zone name (e.g., "America/Los_Angeles") or an offset from GMT (e.g., "Etc/GMT-2"). For more information on specifying time zones, see List of tz database time zones.

Oracle Application Express Access

Oracle Application Express Access will be available on the host OS by accessing following URL:

  • http://localhost:8080/ords/
  • Workspace: internal
  • User: admin
  • Password: <See auto-generated password>

At the first login you'll be forced to change the default admin password.

Optional plugins

When installed, this Vagrant project will make use of the following third party Vagrant plugin:

  • vagrant-proxyconf: set proxies in the guest VM if you need to access the Internet through a proxy. See the plugin documentation for configuration.

To install Vagrant plugins run:

vagrant plugin install <name>...