Installing APEX 20.1 on DB System VM on OCI

0

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:

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

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;

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.

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

What Next?

  • Installing APEX using Terraform?

References:

Oracle APEX installation

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

0 0 vote
Article Rating

I am a Cloud Solutions Engineer working with a leading cloud solutions company. I have more than 5 years’ experience in the Tech ecosystem. I began my career as a software developer. I am a tech enthusiast, an autodidact whose interests includes Data Management, Cloud Native Development, Mobile and Bots Development, Integration, Low Code Development, AI, Analytics just to say the least.

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments