Install/Upgrade Oracle APEX 18.1 on Oracle Database Cloud Service (DBaaS)

Assumption

• You can connect to DBaaS through Putty and FileZilla
• Oracle Database 12c Release 2 install on plugable db: PDB1
• You have the required version of the cloud tooling

Steps

1. Log in to the compute node as the oracle user.
2. Log in to SQL Plus as the SYS user.
3. Upload Oracle Application Express 18.1 to the compute node: /home/oracle/tmp
4. Go to /home/oracle/tmp directory unzip to /u01/app/oracle/product/apex/18.1.0.00.45 directory:

unzip apex_18.1_en.zip
mv /home/oracle/tmp/apex/ /u01/app/oracle/product/apex/18.1.0.00.45/

5. Final directory preview

6. Go to /u01/app/oracle/product/apex/18.1.0.00.45/ directory
7. Make sure you can connect using ORDS_PUBLIC_USER, by default will have same password like sys,system on DBaaS creation.

sqlplus /nolog 
SQL> CONNECT ORDS_PUBLIC_USER 
Password: 
Connected. 
SQL>

8. Intall APEX 18.1
• Log in to SQL Plus as the SYS user and install

ALTER SESSION SET CONTAINER=PDB1; 
@dbcsins.sql SYSAUX SYSAUX TEMP /i/18.1.0.00.45/ <ORDS_PUBLIC_USER_PASSWORD> 

• Check the installation went fine by issuing the following command (Using the same sqlplus session or at lease issuing the statement to the same container you installed APEX into)



SELECT VERSION, STATUS, SCHEMA FROM DBA_REGISTRY WHERE COMP_ID = 'APEX';

9. Create a link to the APEX images in ORDS' docroot by executing the below command as the oracle user



ln -sfn /u01/app/oracle/product/apex/18.1.0.00.45/images/ /u01/app/oracle/product/ords/conf/ords/standalone/doc_root/i/18.1.0.00.45 



10. Configure Oracle Application Express by executing the Oracle REST Data Services (ORDS) assistant:


11. Log in to the compute node as the opc user
12. Start a root-user shell:

$ sudo -s 

13. Change to the ords directory:

# cd /var/opt/oracle/ocde/assistants/ords

14. Execute the ORDS assistant:

# ./ords -out="/var/opt/oracle/ocde/res/ords.out" -ords_action="configure_apex"

15. Restart ORDS:

# /etc/init.d/ords restart

16. Exit the root-user shell and log out of the compute node.

Reference

• Upgrading from Oracle Application Express 5.1.0 or 5.1.3 to 5.1.4 for Oracle Database 12c and Oracle Database 18c
• SR support