1. Set up ec2 instance using OL7.2-x86_64-HVM-2015-12-10 Amazon Machine Image (AMI), now using 7.3 for OL
2. Setup a elastic IP against the server
3. Login via MobaXterm as ec2-user and change password, I use putty
   • sudo passwd ec2-user
4. Install packages needed for instance
   • sudo yum install wget zip unzip -y
   • sudo yum install perl-libwww-perl.noarch -y
   • sudo yum install java-1.8.0-openjdk.x86_64 -y
   • sudo yum install updates
5. Create apex user and make it so user can connect
   • sudo useradd -d /home/apexuser apexuser
     sudo passwd apexuser
     cd ~
     mkdir .ssh
     chmod 700 .ssh
     touch .ssh/authorized_keys
     chmod 600 .ssh/authorized_keys
     GET http://169.254.169.254/latest/meta-data/public-keys/0/openssh-key>.ssh/authorized_keys
     log out and login as apexuser
6. Make directories for apexlistener, oracle client, and ORDS
   • mkdir /home/apexuser/apexlistener
   • mkdir /home/apexuser/orclclient
   • mkdir /home/apexuser/ORDS
7. Upload files and unzip in respective directories
   • unzip apex_5.0.3_en.zip -d /home/apexuser/apexlistener
   • upload oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm into /home/apexuser/orclclient
   • upload oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm into /home/apexuser/orclclient
   • unzip ords.3.0.3.351.13.24.zip -d /home/apexuser/ORDS
8. Install oracle client
   • su ec2-user
   • cd /home/apexuser/orclclient
   • rpm -ivh oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
   • rpm -ivh oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
9. Update bash profile of apex user for client
   • su apexuser
   • cd ~
   • vi ~/.bash_profile
     • export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib:$LD_LIBRARY_PATH
     • export PATH=/usr/lib/oracle/12.1/client64/bin:$PATH
   • source ~/.bash_profile
   • sqlplus SYS/PASSWORD@HOSTNAME:1521/orcl as sysdba
10. Go to your database server & uninstall apex from container database
    • !!!!!!!Make sure you uninstall or unplug any pluggable databases before you do this!!!!!!
    • /u01/app/oracle/product/12.1.0/dbhome_1/apex
    • sqlplus / sys as sysdba
    • @apxremov_con.sql
11. Create pluggable database & add USERS tablespace
    • Go to SQL Developer for these tasks
    • Create pluggable database and open read / write
    • Connect to pluggable database
    • Create Users tablespace on pluggable database
      • CREATE TABLESPACE “USERS” DATAFILE
        ‘/u01/app/oracle/oradata/orcl/pdbseed/users01.dbf’ SIZE 5242880
        AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M
        LOGGING ONLINE PERMANENT BLOCKSIZE 8192
        EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
        NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;
12. Install apex on your container database, change apex admin user and create rest data services user
    • ALTER SESSION SET CONTAINER =PDBORCL (your pluggable database name)
    • @apexins.sql SYSAUX SYSAUX TEMP /i/
    • @apxchpwd.sql
    • @apex_rest_config.sql
    • ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Password1 ACCOUNT UNLOCK;
13. Go to your Apex server and Run ORDS set up
    • cd /home/apexuser/ORDS
    • java -jar ords.war
    • /home/apexuser/ORDS/config/ (configuration directory)
    • /home/apexuser/apex/images (static resources directory)
    • add tcp rule for 8080 (or port you used if you haven’t already when you created server)
    • stop server using ctrl c and start with nohup
      • nohup java -jar ords.war &
    • if you need to stop server issue top command and find java process running under apexuser and kill process number
      • top -u apexuser
      • kill [process]
14. At this point your APEX UI should be available at http://HOSTNAME:8080/ords