Home  >  Blog  >   Oracle Apex

How to Install Oracle Apex

Are you facing difficulties in the installation of Oracle APEX? Your search for the best installation guide for Oracle APEX ends here. This detailed article gives a detailed guide on Oracle APEX, its features, and its installation on your system. By the time you finish reading this article, you will have Oracle APEX successfully running on your system.  

Rating: 4.6
  
 
1414

Developing software and applications is a need for all organizations, but not all can manage the complex coding and development workflows for their changing business requirements. Therefore, they need a tool that can help them to create the application without any programming experience. Oracle APEX helps us to address this issue by providing a low-code environment for creating the software application. 

In this comprehensive guide, we will walk you through the complete installation process of Oracle APEX on your Windows system including its overview and features. So, let us start without any delay. 

Table of Contents

Overview of Oracle APEX

The Oracle APEX is a low-code development tool that enables us to develop and deploy secure enterprise applications. We can create the Enterprise Application with faster speed, without any complex programming workflow. The architecture of APEX contains a web browser, Oracle REST Data Services (the web server), and an Oracle database containing APEX. 

Thus, due to the simple architecture, it has extremely low-latency data access. As a result, we can develop data-driven applications with powerful search and retrieval capabilities. Now, let us see some latest features of the Oracle APEX. 

Features of Oracle APEX

  • It simplifies the debugging tasks: 

If the application has some bugs or errors, we can create a working copy of the application and solve the bug or error. After this, we can merge the copy into the main application. This makes debugging tasks simple and easy. 

  • It supports advanced Components for Application:

APEX provides various advanced functionalities for our applications such as new Combobox, Image Upload, and QR Code Generator items. Thus, we do not need to use third-party API for complex JavaScript code for such features. 

  • Oracle APEX is portable: 

Users can run Oracle APEX on various platforms such as Cloud or On-premises systems. We can run it in any environment according to our requirements. 

  • It supports Stateless and Serverless configuration: 

The APEX Application has a Stateless and Serverless configuration. Additionally, the states of the connections are stored in the tables so that they can be reused again. Therefore, we can develop applications with less number of connections. 

  • It helps us in SaaS integrations: 

We can easily integrate our ERP System with the Oracle APEX platform to simplify the business processes. We can also integrate the REST Web Services and other databases for data access. 

MindMajix YouTube Channel

With these features, it becomes a useful platform for application development. Now, let us what is required before we move on to APEX installation. 

Prerequisites for Installation

  • Oracle APEX is supported on a JavaScript-enabled browser. It supports multiple browsers namely Google Chrome, Mozilla Firefox, Apple Safari, and Microsoft Edge.
  • To run the Oracle APEX on your Windows System, Oracle Database 19c or later has to be installed and configured. 
  • ORDS Server configuration requires Java installation. Thus, it is recommended to install the latest version of JDK (Java Development Kit).
  • APEX also requires the Oracle REST Data Services (ORDS) version 20.0 or later. It is a Java-based server that will used for Database Actions, Oracle APEX access, and REST APIs for our databases. 

Follow the steps mentioned in the subsequent sections to configure the prerequisites and Oracle APEX on your Windows System. 

Oracle Database Installation and Configuration

Oracle Apex Database Installation and Configuration 1

  • Step 2: Accept the license and click on the ‘Download’ button.

Oracle Apex Database Installation and Configuration 2
 

  • Step 3: Locate the file and extract its contents as depicted below:

Oracle Apex Database Installation and Configuration 3

  • Step 4: Now, open the extracted folder and scroll down to find the setup file. Double-click on it to start the installation. 

Oracle Apex Database Installation and Configuration  4

  • Step 5: The installation wizard appears as shown below. Choose the ‘Set up software’ option and click ‘Next.’

Oracle Apex Database Installation and Configuration 5

  • Step 6: Keep the options of Single database instance selected by default and click ‘Next.’ 

Oracle Apex Database Installation and Configuration 6

  • Step 7: Leave the ‘Enterprise Edition’ option as selected and click on ‘Next.’ 

Oracle Apex Database Installation and Configuration 7

  • Step 8: Specify your preferred username and password and continue by clicking on the ‘Next’ button. 

Oracle Apex Database Installation and Configuration 8

  • Step 9: Specify the path to the directory where you want to install the Oracle database. 

Oracle Apex Database Installation and Configuration 9

  • Step 10: Now, prerequisite checks will be performed as shown below. Click on ‘Install’ to start the installation. 

Oracle Apex Database Installation and Configuration 10

  • Step 11: Installation starts as shown below. 

Oracle Apex Database Installation and Configuration 11

  • Step 12: Close the installation wizard after it is completed. 

Oracle Apex Database Installation and Configuration 12

  • Step 13: Search for the ‘Net Configuration Assistant’ and select ‘Run as administrator’ as shown below: 

Oracle Apex Database Installation and Configuration 13

  • Step 14: Choose ‘Listener Configuration’ and click ‘Next.’

Oracle Apex Database Installation and Configuration 14

  • Step 15: Choose the ‘Add’ option and select ‘Next.’

Oracle Apex Database Installation and Configuration 15

  • Step 16: Keep the name ‘LISTENER’ by default and enter your password which we set in step 8. Then, click ‘Next.’

Oracle Apex Database Installation and Configuration 16

  • Step 17: Keep the settings by default and continue to ‘Next.’ 

Oracle Apex Database Installation and Configuration 17

  • Step 18: Select to use the standard port and click ‘Next.’ 

Oracle Apex Database Installation and Configuration 19

  • Step 19: Now, click the ‘No’ option and select the ‘Next’ option.

Oracle Apex Database Installation and Configuration 19

  • Step 20: Again, click on ‘Next.’

Oracle Apex Database Installation and Configuration 20

 

  • Step 21: Finally, select ‘Finish’ to exit the configuration wizard. 

Oracle Apex Database Installation and Configuration 21

  • Step 22: Now, search for ‘Database Configuration Assistant’ and run it as administrator as shown below.

Oracle Apex Database Installation and Configuration 22

  • Step 23: Select the ‘Create Database’ option and click ‘Next.’

Oracle Apex Database Installation and Configuration 23

  • Step 24: Select the ‘Advanced Configuration’ and continue to ‘Next.’ 

Oracle Apex Database Installation and Configuration 24

  • Step 25: Leave the settings as default and continue to ‘Next.’ 

Oracle Apex Database Installation and Configuration 25

  • Step 26: Select a name for your database. Here, we are using the name ’apexdb.’ Uncheck the ‘Create as Container Database’ option and then, click ‘Next.’ 

Oracle Apex Database Installation and Configuration 26

  • Step 27: Keep the settings as default and then select the ‘Next’ option to proceed ahead. 

Oracle Apex Database Installation and Configuration 27

  • Step 28: Again, leave the default settings unchanged and continue to ‘Next.’

Oracle Apex Database Installation and Configuration 28

  • Step 29: After the Listeners are identified, click on the ‘Next’ button. 

Oracle Apex Database Installation and Configuration 29

  • Step 30: Without changing the default settings, continue to ‘Next.’

Oracle Apex Database Installation and Configuration 30

  • Step 31: In the Sample Schemas Tab, mark the ‘Add sample schemas to database’ and click on the next.’ 

Oracle Apex Database Installation and Configuration 31

  • Step 32: Leave the port as default and click the ‘Next’ button to continue. 

Oracle Apex Database Installation and Configuration 32

  • Step 33: In this step, we are adding the same passwords for all kinds of administrative accounts, for simplicity. You can prefer passwords according to preference. 

Oracle Apex Database Installation and Configuration 33

  • Step 34: Click on the ‘Next’ button to continue. 

Oracle Apex Database Installation and Configuration 34

  • Step 35: Click on the ‘Finish’ button. 

Oracle Apex Database Installation and Configuration 35

  • Step 36: The setup starts creating the database as demonstrated below: 

Oracle Apex Database Installation and Configuration 36

  • Step 37: After the setup is done, click on password management. Set a password for the ‘HR’ user as shown below: 

Oracle Apex Database Installation and Configuration

  • Step 38: Therefore, the database has been successfully created. 

Oracle Apex Database Installation and Configuration 38

  • Step 39: Now, we will connect to our database. Open the SQLPlus CLI Interface as shown below:

Oracle Apex Database Installation and Configuration 39

  • Step 40: First, execute the command ‘SYS/SYS AS SYSDBA’ and connect the database. Then, run the ‘CONN SYS/SYS@apexdb AS SYSDBA’ command to connect to the ‘apexdb’ database that we created. The terminal should appear as shown below. 

Oracle Apex Database Installation and Configuration

JDK Installation

 JDK Installation 1

  • Step 2: Locate the file and double-click on it to start the installation. After the installation wizard launches, click on the ‘Next’ button.  

 JDK Installation 2

  • Step 3: Specify the destination path where the JDK will be installed. Then, Click on the Next Button. 

 JDK Installation 3

  • Step 4: The installation process begins as outlined below.

 JDK Installation  4

  • Step 5: Close the wizard after the installation is done successfully. Now, we need to configure the environment variable of our system so that the necessary libraries and modules for the Java Program execution can be easily found.

 JDK Installation 5

  • Step 6:  Find the bin folder inside the JDK 17 directory and copy its path.

 JDK Installation 6

  • Step 7: Open the control panel then, go to the advanced system settings, and click on the ‘Environment Variables’ as outlined below.

 JDK Installation

  • Step 8: Select the ‘PATH’ under the System Variables. Click on the ‘Edit’ button. 

 JDK Installation  7

  • Step 9: Now, click on the ‘New’ option and add the location of the bin folder of the JDK folder to the PATH variable as illustrated below.

 

 JDK Installation 9

After this, close the Advanced System Settings wizard. 

  • Step 10: To verify your installation, pen the command prompt and run the command ‘java -version’ outlined below.

 JDK Installation  10

Thus, JDK has been successfully installed on our system. 

Steps to Install Oracle APEX 

Apex Installation and Configuration 

Oracle Apex Installation

  • Step 2: Locate the zip folder and extract its contents as shown below. After the contents have been extracted, rename the folder to ‘oracle_apex’ for simplicity. 

Oracle Apex Installation 2

  • Step 3: Now, navigate to the ‘apex’ subfolder folder inside the main directory ‘oracle_apex’ as shown below:

Oracle Apex Installation 3

  • Step 4: In this location, type ‘cmd’ and press ‘Enter’ to open the ‘command prompt’ as shown below. 

Oracle Apex Installation 4

  • Step 5: Now, we will connect to the database in this location. Minimize the command prompt, then go to the bin folder of the Oracle database 19c folder and locate the file ‘sqlplus.exe.’ This will be used to connect to the database to install the Apex on your system.

Oracle Apex Installation 5

  • Step 6: In the command prompt (inside the apex folder), execute the command ‘C:\WINDOWS.X64_193000_db_home\bin\sqlplus.exe /nolog’ to use the Oracle database. The terminal should appear as shown below.

Oracle Apex Installation 6

  • Step 7: Run the command ‘CONN SYS/SYS@apexdb AS SYSDBA’ to connect to the database. 

Oracle Apex Installation 7

  • Step 8: We will now create a tablespace to handle the APEX installation. Use the location to database location that we specified in step 9 of the ‘Oracle Database installation’ to create the table space. You can find the location as shown below.

Oracle Apex Installation 8

  • Step 9: Run the query ‘CREATE TABLESPACE APEX321 DATAFILE 'C:\app\User_123\oradata\APEXDB\APEX321.dbf' SIZE 1000M AUTOEXTEND ON NEXT 1M;’ to create the table space as outlined below. 

Oracle Apex Installation 9

  • Step 10: Run the script ‘@apexins.sql APEX321 APEX321 TEMP /i/’ to start the apex installation. 

Oracle Apex Installation 10

  • Step 11: The installation begins as outlined below. 

Oracle Apex Installation 10

  • Step 12: After the installation has been done, run the command ‘@apxchpwd.sql’ to specify the administrator’s username and password. You have to make sure that the password must be according to Oracle’s password policy. 

Oracle Apex Installation 11

  • Step 13: After the instance is created, the terminal should appear as depicted below. 

Oracle Apex Installation 13

  • Step 14: Now, again run the command ‘CONN SYS/SYS@apexdb AS SYSDBA’ to connect to the database. 

Oracle Apex Installation 14

  • Step 15: Run the following SQL commands one by one to unlock the database accounts. 
    • ALTER USER anonymous ACCOUNT UNLOCK;
    • alter user APEX_PUBLIC_USER identified by APEX321 account unlock;
    • ALTER USER flows_files ACCOUNT UNLOCK;

The terminal should appear as shown below.

Oracle Apex Installation 15

  • Step 16: Now, we will create the required users for the ORDS web listener. Run the command ‘@apex_rest_config.sql’ and enter the passwords as illustrated below.

Oracle Apex Installation 18

  • Step 17: Now, disable the Oracle XML DB Protocol Server by using the following commands: 
    • SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
    • EXEC DBMS_XDB.SETHTTPPORT(0);

The terminal shows the output as demonstrated below.

Oracle Apex Installation 18

  • Step 18: Now, execute two more SQL queries which are stated below:
    • alter user APEX_LISTENER identified by APEX321 account unlock;
    • alter user APEX_REST_PUBLIC_USER identified by APEX321 account unlock;

The terminal should appear as shown below.

Oracle Apex Installation 18

Configuring ORDS Server

Now, we will need to configure the Oracle REST Data Server so that our Oracle APEX can run on the server using the browser.

Oracle Apex Configuring ORDS Server Step 1

  • Step 2: Locate the file and extract its contents in the same location. Then, rename the folder to the ‘oracle_ords.’ After this, move that folder inside the ‘oracle_apex’ folder.  

Oracle Apex Configuring ORDS Server Step 2

  • Step 3:  Also, inside the ‘oracle_ords,’ create a new folder with the name ‘config’.

Oracle Apex Configuring ORDS Server Step 3

  • Step 4:  Navigate to the folder ‘oracle_ords’ and type ‘cmd’ in the path specifier. Then, press enter to open the command prompt

Oracle Apex Configuring ORDS Server Step 4

  • Step 5:  Now, execute the command  ‘ java -jar ords.war --config C:\oracle_apex\oracle_ords\config  install ’ to start ORDS installation. The installation begins as demonstrated below. 

Oracle Apex Configuring ORDS Server Step 5

  • Step 6: Enter 2 for the first option and press the ‘Enter’ button. In the option for making the request, choose to make a request with a custom database string which is ‘jdbc:oracle:thin:@localhost:1521:apexorcl’ as demonstrated below. 

Oracle Apex Configuring ORDS Server Step 6

  • Step 7: Now, enter the default table space we created. Then, press ‘Enter’ in all of the options. 


Oracle Apex Configuring ORDS Server Step 7

  • Step 8: Now, in the Apex directory, locate the ‘images’ folder and copy its path as shown below. 

Oracle Apex Configuring ORDS Server Step 8

  • Step 9: Specify the copied path in the destination for static resources as demonstrated below. Then, press ‘Enter.’ The ORDS installation starts as shown below. 

Oracle Apex Configuring ORDS Server Step 9

  • Step 10: Once the installation is done, the terminal appears as depicted below. 

Oracle Apex Configuring ORDS Server Step 10

  • Step 11: Open the ‘ http://localhost:8080/ords/apex_admin ’ on your browser. The home screen of the ORDS server is demonstrated below. Click on the ‘Go’ button in the Oracle APEX section.

Oracle Apex Configuring ORDS Server Step 11

  • Step 12: Enter the administrator name and password and sign in to your account. 

Oracle Apex Configuring ORDS Server Step 12

  • Step 13: The homescreen of the Oracle APEX appears as outlined below. 

Oracle Apex Configuring ORDS Server Step 13

Now, you have successfully installed Oracle APEX on your Windows System. You are now capable of accelerating your low-code development with APEX. 

Oracle Apex Frequently Asked Questions

1. What is Apps and Plugin Support in APEX? 

Apps and Plugins extend the capabilities of the application which are not available in the native platforms. Oracle APEX has Sample App support for Charts, Map, Data Loading, Grid, etc. It also has Action Plug-Ins, Region Plug-Ins, and REST Source Plug-Ins support. 

2. Can I connect MongoDB with the application? 

The Oracle Rest Data Services provides API for MongoDB which you can easily integrate with your NoSQL database for data transfer. 

3. What libraries of JavaScript are supported in APEX? 

APEX supports various JavaScript libraries such as Backbone.js 1.4.1, DOMPurify 3.0.5, FullCalendar 6.1.8, jQuery Migrate 3.4.1, lodash 4.17.21, and many other libraries to enable the advanced functionalities for application development. 

4. Should I purchase a license for Oracle Database and Oracle APEX separately?

No, if you have purchased a license for Oracle Database, you do not need to purchase the license separately for the APEX. You can use it without any additional cost. However, if do not have an Oracle Database license, then you can download its free version or you should purchase its license. 

5. How to find the resource or course to learn Oracle APEX?

Oracle Provides resources so that you get started with the Oracle APEX. It provides documentation support, certifications, and other learning materials. We recommend visiting the official site https://apex.oracle.com/en/learn/training/ for more information about learning Oracle APEX. 

Troubleshooting for Oracle APEX Installation

1. How to resolve the ‘ora-12514: tns:listener does not currently know of service requested in connect descriptor’ error

This error occurs because the service requested through the command line interface is not registered in the listener. The error message is shown below. 

Troubleshooting Oracle Apex Installation 1

To solve this issue, make the request with the customs connection database string with the format “jdbc:oracle:thin:@[HOST][:PORT]:SID” as demonstrated below: 

Troubleshooting Oracle Apex Installation 2

2. How to resolve the ‘The tablespace TEMP/i/ does not exist’ error while Oracle APEX Installation?

This error can occur because of the incorrect format of the Apex installation script command. If you run the ‘@apexins APEX123 APEX123 TEMP/i/’ command,  the error message appears as shown below. 

Troubleshooting Oracle Apex Installation 2

The correct script is ‘@apexins APEX123 APEX123 TEMP /i/’ There is a space between ‘TEMP’ and the ‘/i/’ parameter. 

3. What is the solution for ‘ORA-20001: Prerequisite checks failed; unable to proceed with APEX installation, ORA-06512: at line 317’ 

This error can occur if the the APEX has already been installed. It is shown below. 

Troubleshooting Oracle Apex Installation 4

If you want to reinstall the Oracle APEX, then remove it using the command ‘@apxremov.sql’ as the admin user. And, then install it using the command ‘@apexins APEX123 APEX123 TEMP /i/’ where ‘APEX123’ is the name of your tablespace in the database. 

Conclusion

Oracle APEX helps us to easily implement various complex business logic such as routing, engaging user approvals, user action tasks, calling REST or PL/SQL APIs, and sending an email or push notifications. Hence, it becomes very easy for us to develop our enterprise application with less time. We can also convert our spreadsheet into an interactive web app within a short amount of time. Its new Workflow Component provides a fully functional interface to design, execute, and monitor the components of our application.

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
Oracle Apex TrainingApr 23 to May 08View Details
Oracle Apex TrainingApr 27 to May 12View Details
Oracle Apex TrainingApr 30 to May 15View Details
Oracle Apex TrainingMay 04 to May 19View Details
Last updated: 27 Feb 2024
About Author

 

Madhuri is a Senior Content Creator at MindMajix. She has written about a range of different topics on various technologies, which include, Splunk, Tensorflow, Selenium, and CEH. She spends most of her time researching on technology, and startups. Connect with her via LinkedIn and Twitter .

read more
Recommended Courses

1 / 15