Installing APEX 20.1 on DB System VM on OCI

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.

Prerequisites

1. Login to your DB System compute instance, navigate to the apps folder:

This image has an empty alt attribute; its file name is image.png

2. Download the latest version on APEX from here

Trick:

 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

This image has an empty alt attribute; its file name is image-2-1024x62.png

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.

This image has an empty alt attribute; its file name is image-7.png

The next is to check if there are previous versions of APEX installed both on the CBD and PDB level.

This image has an empty alt attribute; its file name is image-8.png

If APEX exists, uninstall software;

SQL> apxremov.sql

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)

SQL> @apxchpwd.sql

Username: ADMIN

Email: youremailaddress

Password: yourpassword

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.

This image has an empty alt attribute; its file name is image-9.png

The next thing is to set the port 8080.

EXEC DBMS_XDB.SETHTTPPORT(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;

http://<YourIPAddress>:8080/apex
This image has an empty alt attribute; its file name is image-10-1024x511.png

What Next?

  • Installing APEX using Terraform?

References:

Oracle APEX installation

https://apex.oracle.com/en/learn/documentation/

Author: Labanish

I am a Senior Cloud Solutions Architect at Oracle. Am interested in Cloud Automation, Cloud Native Applications dev and Emerging Tech. I have over 6 years work experience handling different tech roles in East Africa, Romania & now in United Kingdom. All views are mine.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: