Install Oracle Database

To install Oracle APEX you must first install Oracle Database. You can download the latest version of Oracle Database from the official Oracle website. Once you have downloaded the installer, run it and follow the prompts to install Oracle Database.

See the official documentation for installing Oracle Database 21c Express Edition (free) on Windows: https://docs.oracle.com/en/database/oracle/oracle-database/21/xeinw/installing-oracle-database-xe.html and Linux: https://docs.oracle.com/en/database/oracle/oracle-database/21/xeinl/installing-oracle-database-free.html

Installing Oracle APEX on Windows:

Step 1: Download Oracle APEX

After installing Oracle Database, you need to download Oracle APEX from the official Oracle website. Choose the version of APEX that matches the version of Oracle Database that you installed.

Step 2: Extract Oracle APEX

Once you have downloaded the APEX installation file, extract it to a directory of your choice using an archiving tool like 7zip or WinRAR.

Step 3: Configure Oracle APEX

To configure APEX, open a command prompt and navigate to the directory where you extracted the APEX installation files. Run the following command:

sqlplus /nolog

This will open the SQL*Plus command prompt. Connect to your Oracle Database by running the following command:

connect sys as sysdba

Enter your database username and password when prompted. Once you are connected, run the following command to create the APEX schema:

@apexins.sql APEX APEX TEMP /i/

This command will create the APEX schema in your Oracle Database and install APEX.

Step 4: Accessing Oracle APEX

After installation, you can access Oracle APEX by navigating to the following URL in your web browser:

http://localhost:8080/apex/

This will open the Oracle APEX login page. Enter your workspace name, username, and password to access APEX.

Installing Oracle APEX on Linux:

Step 1: Download Oracle APEX

After installing Oracle Database, you need to download Oracle APEX from the official Oracle website. Choose the version of APEX that matches the version of Oracle Database that you installed.

Step 2: Extract Oracle APEX

Once you have downloaded the APEX installation file, extract it to a directory of your choice using the following command:

unzip apex_*.zip

Step 3: Configure Oracle APEX

To configure APEX, open a terminal and navigate to the directory where you extracted the APEX installation files. Run the following command to configure APEX:

cd apex
./apexins.sh APEX APEX TEMP /i/

This command will create the APEX schema in your Oracle Database and install APEX.

Step 4: Accessing Oracle APEX

After installation, you can access Oracle APEX by navigating to the following URL in your web browser:

http://localhost:8080/apex/

This will open the Oracle APEX login page. Enter your workspace name, username, and password to access APEX.

That’s it! You have successfully installed Oracle APEX on your local computer. For further configuration and fine tuning consult the official Oracle documentation.

Workspace Administrator login and what to do if you lost your password

In Oracle APEX 20.2 and later versions, the default password for the administrator account is randomly generated during the installation process and stored in a file named apex_admin_password located in the APEX installation directory.

If you don’t remember the password you set during the installation process and the apex_admin_password file is not available, you can reset the password by logging in to the Oracle Database using SQL*Plus or SQL Developer with a privileged account and executing the following SQL statement:

ALTER USER ADMIN IDENTIFIED BY <new_password>;

Replace <new_password> with the new password you want to set for the ADMIN account. Once you reset the password, you can log in to APEX using the new password.