HomeContact

Install Oracle APEX

By Shady Nagy
Published in Oracle
July 18, 2021
1 min read
Install Oracle APEX

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
    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 create
  • Select Desktop class then click next.
    select desktop
    select desktop
  • Select Windows Built-in Account then click next and confim yes.
    select built in account
    select built in account
    select built in account click yes
    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
    config
  • If windows firewall asks for access click allow access.
    allow access
    allow access
  • Click Close when finished.
    install finshed
    install finshed
    Now Oracle server was installed successfully.

Install APEX.

  • Copy apex folders after extraction to C:\oracle\apex
    Copy apex folder
    Copy apex folder
  • Open cmd from run.
  • Go to apex fodler by this code.
$ C:
$ cd C:\oracle\apex
  • Login on SQL
$ 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.


Tags

#Oracle#Apex#Oracle Apex#sql

Share


Previous Article
Install Microsoft SQL on Centos
Shady Nagy

Shady Nagy

Software Innovation Architect

Topics

AI
Angular
dotnet
GatsbyJS
Github
Linux
MS SQL
Oracle

Related Posts

Updating Oracle Database Configuration After Changing the Server IP Address
Updating Oracle Database Configuration After Changing the Server IP Address
May 16, 2024
2 min

Quick Links

Contact Us

Social Media