How to Install Oracle APEX 18.2 on Oracle 12c

Hello everyone, today we are going to learn how to install Oracle APEX 18.2 on top of Oracle 12c database. I am running the Oracle 12c database on Windows 10 Professional. You may want to check out my previous tutorial on how to install and configure Oracle 12c on Windows 10 Pro. Oracle APEX is a great piece of development software that allows us to build simple to complex database application. To read more about Oracle APEX, please visit this official page.

If you don’t want to install Oracle APEX locally, you can use the official Oracle Apex service where you can learn to build your database applications. Please visit this page to start creating Oracle Apex workspace for free. You can also download and run the Oracle Database Development Labs virtualbox. Its the easiest way to test Oracle 18c and Oracle APEX on Windows/Linux.

Steps to Install Oracle APEX 18.2 on Oracle 12c

Before we install the Oracle APEX, make sure you have the Oracle 12c installed and configured properly. This tutorial is based on the official guide to install Oracle APEX. I was successfully installed Oracle APEX 18.2 on my Windows 10 Professional and Oracle 12c.

Step 1. Install and Configure Oracle Database 12c

Please read and follow my previous tutorial to install and configure Oracle 12c on Windows 10. Make sure Oracle 12c runs properly on your system.

Step 2. Download Apex Installation File

Navigate to this page to download the latest Oracle APEX installation file. You will get a zip file containing files for APEX installation. Next, extract the zip file to a temporary folder. For example, I extract this file to C:\temp.

Step 3. Install Apex

Next, open Windows command prompt and then cd to C:\temp\apex. We need to execute the .sql file from the apex directory.

cd c:\temp\apex

Now login to Oracle using sqlplus command.

sqlplus /nolog
connect sys as sysdb

You will need to enter the sys password. And then let’s install Apex using the following command:

@apexins.sql SYSAUX SYSAUX TEMP /i/

The installation process should start and it takes some times. Once completes, we can continue to create administrator user for Apex.

sqlplus /nolog
connect sys as sysdb
alter session set container=mydb01;
@apxchpwd.sql

Do not forget to change mydb01 with your pluggable database. You will need to create new admin user, email and password. The command above will create a new admin user for the APEX. You will need this user and password to manage the APEX workspaces etc.

Step 4. Configuring the Embedded PL/SQL Gateway

After installing Apex on the step 3, now we need to configure the Embedded PL/SQL Gateway.

##run sqlplus from Windows command prompt
sqlplus /nolog
connect sys as sysdba
alter session set container=mydb01;
@apex_epg_config.sql c:\temp

As you can see the command @apex_epg_config.sql c:\temp. Note the C:\temp at the end of the command. This is the parent directory of the apex extract directory. For example if you extract the Apex installation file to C:\Download\Apex, then you should modify the command into this;

@apex_epg_config.sql C:\Download

This process will take some times. Please be patient.

Unlock the Anonymous account

alter user anonymous account unlock;

Step 5. Verifying HTTP Port on the Oracle XML DB Server

First, lets verify the port number for the XML DB Protocol Server. Do the following to verify the Oracle XML DB Protocol Server port number

sqlplus /nolog
connect sys as sysdba
enter password:
SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

If the port number returns 0, the Oracle XML DB Protocol Server is disabled. Continue the following steps to assign the port number.

Step 6. Enabling Oracle XML DB Protocol Server

This section will guide you how to enable the Oracle XML DB Protocol Server and assign port number. First, lets connect to Oracle via sqlplus

sqlplus /nolog
connect sys as sysdba
enter password:
EXEC DBMS_XDB.SETHTTPPORT(8080);

You can also use another port such as 8282. Change 8080 with your new port number.

Once complete, you can login to the APEX admin page using your favorite web browser. The address should be something like this:

http://localhost:8080/apex/apex_admin

If you are accessing from another computer, change the “localhost” with the IP address of the computer running APEX. For more help, please visit the official Oracle APEX documentation below:

https://docs.oracle.com/database/apex-18.2/index.htm

Closing Words

Installing Oracle APEX is complicated for new user. I tried to install it several times until I get it up and running on my VirtualBox. I hope this tutorial can help you to install Oracle APEX on your Windows 10. See you on the next tutorials.

Be the first to comment

Leave a Reply

Your email address will not be published.


*