- 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
- Log in to the compute node as the oracle user.
- Log in to SQL Plus as the SYS user.
- Upload Oracle Application Express 18.1 to the compute node: /home/oracle/tmp
- Go to /home/oracle/tmp directory unzip to /u01/app/oracle/product/apex/18.1.0.00.45 directory:
- Final directory preview
- Go to /u01/app/oracle/product/apex/18.1.0.00.45/ directory
- Make sure you can connect using ORDS_PUBLIC_USER, by default will have same password like sys,system on DBaaS creation.
- Intall APEX 18.1
- Log in to SQL Plus as the SYS user and install
- 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)
- Create a link to the APEX images in ORDS' docroot by executing the below command as the oracle user
- Configure Oracle Application Express by executing the Oracle REST Data Services (ORDS) assistant:
- Log in to the compute node as the opc user
- Start a root-user shell:
- Change to the ords directory:
- Execute the ORDS assistant:
- Restart ORDS:
- Exit the root-user shell and log out of the compute node.
unzip apex_18.1_en.zip mv /home/oracle/tmp/apex/ /u01/app/oracle/product/apex/18.1.0.00.45/
sqlplus /nolog SQL> CONNECT ORDS_PUBLIC_USER Password: Connected. SQL>
ALTER SESSION SET CONTAINER=PDB1; @dbcsins.sql SYSAUX SYSAUX TEMP /i/18.1.0.00.45/ <ORDS_PUBLIC_USER_PASSWORD>
SELECT VERSION, STATUS, SCHEMA FROM DBA_REGISTRY WHERE COMP_ID = 'APEX';
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
$ sudo -s
# cd /var/opt/oracle/ocde/assistants/ords
# ./ords -out="/var/opt/oracle/ocde/res/ords.out" -ords_action="configure_apex"
# /etc/init.d/ords restart
Reference
