Install Oracle Apex 19.2 on Windows Server Step by Step

I'm writing this on behalf of my own experience of the installation of Oracle Apex 19.2 on the Oracle 12c database. You can follow the easy steps to complete the installation of Oracle Apex.

• Download the Oracle Apex from the Oracle website.
  https://apex.oracle.com/en/learn/getting-started/

• Copy the apex folder into the C:\Oracle to install. (C:\Oracle\Apex)
• Connect with SQLPLUS where Oracle 12c database already installed
• Make sure you are on the same path of Oracle Apex.

• C:\>CD Oracle\Apex

• C:\Oracle\Apex> Sqlplus /nolog

• SQL> Connect Sys/sys_password as sysdba;
  Connected.

Run the Scripts as following.
SQL> @apexins.sql sysaux sysaux temp /i/

SQL> @apxrtins.sql sysaux sysaux temp /i/

To change the password, run the following script.

SQL> @apxchpwd.sql

User name: admin
password: Apex111$  (Type your own password here)

Set the Port to access the Oracle Apex interface.

SQL> EXEC DBMS_XDB.SETHTTPPORT(8282);

SQL> ALTER USER APEX_PUBLIC_USER account unlock;

Set the password for the Apex Public User.

SQL> ALTER USER APEX_PUBLIC_USER identified by password;
-- password is apex

Set the listener and apex_rest_public_user password

SQL> @apex_rest_config.sql
-- password: apex

Now load all the apex images from the Apex\images directory, do not enter the apex directory.

SQL> @apex_epg_config.sql C:/Oracle
the above script auto-load the images from the c:/oracle/apex/images

Enable the Anonymous and XDB Accounts.

SQL> ALTER USER ANONYMOUS IDENTIFIED BY anonymous;
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;
SQL> ALTER USER XDB IDENTIFIED BY xdb;
SQL> ALTER USER XDB ACCOUNT UNLOCK;

Open the Browser to check the installation

By default workspace name: internal
localhost:8282/apex

You can create a Workspace for your own applications.

Workspace name: Your workspace name here.
reuse_existing_schema: no
schema name: workspace_apex (Enter the Workspace name_apex as a schema)
schema pass: apex (Enter the schema access password)

Choose Next to set the Admin account to access the above workspace.

Administrator username: ADMIN
password   : set the password
first name  : enter your first name
Last name  : enter your last name
Email         : enter your email here

Create the workspace

It will display the workspace information.

    Identify Workspace (Completed)
    Identify Schema (Completed)
    Identify Administrator (Completed)
    Confirm Request (Active)

Note the information about the tablespace and schema created for your new workspace.

You can now login to the Apex application Administration using Browser.
localhost:8282/apex/apex_admin

You can access the Apex application
localhost:8282/apex/

Now the installation of Oracle Apex 19.2 has been completed. If you have any questions do share it with us.

Thanks.