If you want to learn how to install Oracle APEX. Yes, you are in the right place. In this post, we will explain how to install APEX 20.1 on Oracle Database 18c. First, we assume that you already have installed Oracle Database 11.2 or higher and running it up. If you face any problem to install Oracle Database, please check the post on how to install it on Windows.
Introduction
Oracle APEX 20.1 is fully supported through Oracle Support Services on all Editions (EE, SE2, SE, and SE1) of the Oracle database, 11.2.0.4, or higher with a valid Oracle Database Technical Support agreement. APEX 20.1 can also be used with Oracle Database 18c Express Edition (XE) but is supported only through the OTN discussion forum, and not through Oracle Support Services.
Download and unzip Oracle Apex
You will need to download the APEX 20.1 installation files in zip format. Note that you need to login and agree with the license agreement before you can proceed with the download. After downloading, you will get a zip file and unzip it to the folder in where you want to install Oracle Apex 20.1, for example, I moved this file to D:\apex.
Install Oracle Apex
Step 1. Press Window+R to open the run window. Type cmd and press enter.
Step 2. Login Oracle database by following command one by one:
1 2 3 4 5 6 7 8 9 10 | --- Write sqlplus and press enter C:\Users\Ahmed> sqlplus /nolog --- Enter database user name and press enter Enter user-name: sys as sysdba --- Enter database password and press enter (my password is 1920) Enter Password: 1920 |
or you can write the above three line as like:
1 2 3 | C:\Users\Ahmed> sqlplus sys/1920@orcl as sysdba |
Step 3: At first you need to check datafile location and tablespace information by the following command
1 2 3 4 5 6 7 | --- To check tablespace, write and press enter SQL> select name from v$tablespace; --- To check datafile, write and press enter SQL> select name from v$datafile; |
Step 4: To Install Oracle apex, you need to create a tablespace with datafile first. You should write the following command
1 2 3 4 5 | SQL> CREATE TABLESPACE APEX DATAFILE 'C:\ORACLE\SUPPORT\ORADATA\ORCL\APEX.DBF' SIZE 100M AUTOEXTEND ON; |
Step 5: Now exit SQL developer by exit command
Step 6: You need to change the current directory to where you want to install Oracle Apex. We use D:\apex directory.
1 2 3 4 5 6 7 8 9 10 11 | --- Press cd.. for going back/up directory and press enter C:\Users\Ahmed> cd.. C:\Users>cd.. -- when you reach c drive, enter d: for d drive C:\> d: -- now press cd apex to change directory to apex folder and press enter D:\> cd apex |
Step 7: You need to connect the Oracle Database like step 2.
Step 8: Now write the following command to install Oracle Apex. It will take about 25/30 minutes depends on your computer performance.
1 2 3 | SQL> @apexins APEX APEX TEMP /i/ |
Step 9: Now you need to create an image directory. Enter the value for 1: d: (as our installation drive)
1 2 3 | SQL> @apxldimg.sql |
Step 10: After successful completion of step 9, connect the database again, and run below command.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | --- Write the following command to create apex administrator instance SQL> @apxconf.sql --- Enter oracle apex administrator name Enter Administrator Name: Ahmed --- Enter oracle apex administrator email Enter Administrator email: admin@tachaid24.com --- Enter oracle apex administrator password Enter Administrator password: Techaid24#@! --- If you want to change oracle apex application port, enter here (8080 is default) ENTER A PORT FOR THE XDB HTTP LISTENER [8080]: 8080 |
Step 11: After successful completion of step 10, connect the database again, and run below command to unlock user one by one
1 2 3 4 5 6 | SQL> ALTER USER ANONOYMOUS ACCOUNT UNLOCK; SQL> ALTER USER XDB ACCOUNT UNLOCK; SQL> ALTER USER FLOWS_FILES ACCOUNT UNLOCK; SQL> ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK; |
Congratulation! you have installed Oracle Apex 20.1. Let’s start exploring Oracle. You follow Oracle Apex Guide for a serial tutorial to learn Oracle Apex.
The article was published on June 17, 2020 @ 10:43 AM
Leave a Comment