This post will show you how to install Oracle APEX on Oracle DB System VM or previously known as DBCS.This an Oracle Database in Oracle Cloud Infrastructure.
- Oracle DB system provisioned
- APEX 20.X downloaded
- SSH client ie. Putty or MobaXterm
1. Login to your DB System compute instance, navigate to the apps folder:
2. Download the latest version on APEX from here
Click on the download, accept the agreement, pause the download then grab the download url. Use wget to download it in your compute instance as root user
Unzip the file in a new directory, assign the owner to ‘oracle‘
[root@dbcs tmp]# unzip apex_20.1_en.zip?AuthParam=1552035503_zxxxx /u01/app/ -d /u01/app/ [root@dbcs apex]# cd /u01/app [root@dbcs]# chown -R oracle:oinstall apex/ [root@dbcs# cd apex [root@dbcs]# su oracle
Login to the Oracle Database 19c.
The next is to check if there are previous versions of APEX installed both on the CBD and PDB level.
If APEX exists, uninstall software;
Otherwise install APEX using;
SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/
Once installed the next step is to change the password of APEX administrator. (Store it safely, you shall use it later)
The next thing is to copy APEX images folder
SQL > @apxldimg.sql /u01/app
NB. Note i am copying from the path >> /u01/app, i have not entered the apex folder.
The next thing is to set the port 8080.
Then unlock the anonymous & XBD accounts. (at the CBD Level)
alter session set container = CDB$ROOT; ALTER USER ANONYMOUS ACCOUNT UNLOCK; ALTER USER XDB ACCOUNT UNLOCK;
Tip: Make sure port 8080 is open on the security Lists of your VCN.
Now login to your APEX application;
- Installing APEX using Terraform?