Here are the step by step instructions to install Oracle Apex 19.1 on Windows systems. You need to perform eleven easy steps to install it. The following are the version details of OS, Oracle Database and Oracle Application Express used in this demonstration:
After downloading, you will get a zip file named something like "apex_19.2_en.zip". Copy the file from the default download folder and paste it to the folder in which you want to install Oracle Apex 19.2 . for example, I moved this file to F:\Software\APEX19, and after extracting the file, I got the “apex” directory here. Now the complete path of my Oracle Apex installation is F:\Software\APEX19\apex.
3. Step into the new APEX directory
From CMD prompt on Windows change the directory to the F:\Software\APEX19\apex as follows:
cd F:\Software\APEX19\apex
4. Run APEX installation scripts
Now you need to run all the Oracle Apex 19.2 installation scripts from this "F:\Software\APEX19\apex" location. Start the SQL*PLUS with SYS user credentials to connect to the Oracle Database as shown in the following example:
sqlplus sys/syspsw@orcl as sysdba
Now run the installation script as following, and note that you can change the tablespace names according to your database
@apexins.sql SYSAUX SYSAUX TEMP /i/
5. complete Apex run time environment settings :
But first, And before running bellow script, you need to reconnect to Oracle Database again because after running the above script it will disconnect you from Oracle database
cd F:\Software\APEX19\apex
sqlplus sys/syspsw@orcl as sysdba
@apxrtins.sql SYSAUX SYSAUX TEMP /i/
6. Run APEX Password Script
Now you need to change password for the ADMIN user as while running bellow script and note that password must follow the complexity rules, for example, I provided the password as Apex#19_2
cd F:\Software\APEX19\apex
sqlplus sys/syspsw@orcl as sysdba
@apxchpwd.sql
7. Copy APEX images to APEX directory
Now run the following script to copy APEX images to APEX directory
Note : As I copied the Oracle Apex zip file to the F:\Software\APEX19 folder, so I am specifying the same directory here for “apex_epg_config.sql” script. Do not include the apex folder in this path
cd F:\Software\APEX19\apex
sqlplus sys/syspsw@orcl as sysdba
@apex_epg_config.sql F:\Software\APEX19\