Install Oracle APEX

Published in Oracle

July 18, 2021

2 min read

Oracle APEX Introduction

Oracle Application Express (APEX) is a low-code development platform that enables you to build scalable, secure enterprise apps, with world-class features, that can be deployed anywhere. Using APEX, developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value. You won’t need to be an expert in a vast array of technologies to deliver sophisticated solutions. Focus on solving the problem and let APEX take care of the rest.

Install Oracle Server 19C

Copy extracted folders to C:\oracle\db_home

move setup folder
Open the setup file C:\oracle\db_home\setup.exe
Select create and configugre a single instance database then click next.

select create
Select Desktop class then click next.

select desktop
Select Windows Built-in Account then click next and confim yes.

select built in account

select built in account click yes
config like this then click next.

Oracle base: C:\oracle
Database location: C:\oracle\oradata
Global database name: orcldb
Password: <add your password>
Uncheck Create as Container database.

config

If windows firewall asks for access click allow access.

allow access
Click Close when finished.

install finshed

Now Oracle server was installed successfully.

Install APEX.

Copy apex folders after extraction to C:\oracle\apex

Copy apex folder
Open cmd from run.
Go to apex fodler by this code.

$ C:
$ cd C:\oracle\apex

$ sqlplus sys@orcldb as sysdba

Run install command

$ @apexins.sql sysaux sysaux temp /i/

Set admin password

@apxchpwd.sql

Set passwords for users

$ @apex_rest_config.sql

Alter users and unlock.

alter user anonymous account unlock identified by <password>;
alter user apex_listener account unlock identified by <password>;
alter user apex_public_user account unlock identified by <password>;
alter user apex_rest_public_user account unlock identified by <password>;
alter user apex_210100 account unlock identified by <password>; // do not forget to change apex version to your version

Exit from SQL

$ exit

Now apex installed.

Install ORDS

Copy apex folders after extraction to C:\oracle\ords
Copy images folder from apex to ords C:\oracle\apex\images to C:\oracle\ords\images
Create config folder on ords C:\oracle\ords\config
Go to ords folder by this code.

$ C:
$ cd C:\oracle\ords

Run the installer

$ java -jar ords.war install

When ask you for config write this C:\oracle\ords\config
When ask you for images write this C:\oracle\ords\images
Most of the options is the default (press enter) Now ORDS installed and live so you can open from browser http://localhost:8080/ords/apex_admin

That is all, now you have APEX fully installed locally.