top of page
Search
nieshahansberry794

Download Oracle APEX 21 and Discover the Power of Low-Code Development



How to Download Oracle APEX 21




Oracle Application Express (APEX) is a low-code, zero latency, feature-rich web application development framework that runs directly out of the Oracle Database. A web browser is all you need to develop robust, secure, and scalable database-driven applications.


In this article, we will show you how to download and install Oracle APEX 21, the latest version of this powerful platform. We will also highlight some of the new features and benefits of Oracle APEX 21 that make it easier and faster to build amazing apps.




download oracle apex 21




What is Oracle APEX 21?




Oracle APEX 21 is the newest release of Oracle Application Express, which was first launched in 2004. Oracle APEX 21 introduces a brand-new Maps component, Application Data Loading, support for Calendars and Maps with Faceted Search, and several major enhancements to REST Data Sources, Reporting, Security, Universal Theme, Theme Roller, and a far superior developer experience.


Features and benefits of Oracle APEX 21




Some of the major improvements in Oracle APEX 21 include:


  • Maps: Displaying spatial data within your APEX apps has never been easier. The all-new native Map component allows you to add powerful, feature-rich, and interactive maps to your APEX apps within minutes. They are powered by Oracle eLocation Service so it is ready to use, no API Key required. You can easily customize the look and feel of your maps, use the built-in color schemes for thematic visualizations and heat maps, and select from a variety of built-in SVG shapes and marker icons to make your maps shine. You can also create maps with layers for points, lines, polygons, 3D polygons, and heat maps; set them up with faceted search; or go deeper with dynamic actions and the JavaScript API.



  • Application Data Loading: You can easily add data import capabilities to allow users to upload CSV, XLSX, XML, and JSON data formats to your applications with the new Data Loading process. Data loading is as simple as selecting a file to upload, viewing a preview of the data, and then loading it in. Data Loading can be configured to append, replace, or merge data, perform data conversions using transformation rules and lookup queries, and even load data into tables or collections. You can also use simple names or regular expressions to pre-assign column mappings and use the new apex_data_loading API for custom Data Load processing.



  • Faceted Search Enhancements: Faceted search now supports Maps and Calendar region types, and provides additional end-user flexibility for showing or hiding facets, enabling you to easily hide advanced or rarely used facets that can be made available on demand.



REST Data Sources Enhancements




Oracle APEX 21 makes it easier to work with RESTful services and data sources. You can now use the new REST Data Source Wizard to quickly create and test REST Data Sources, and use the new REST Data Source Test Utility to validate and troubleshoot your REST Data Sources. You can also use the new REST Enabled SQL service to execute SQL and PL/SQL statements over HTTPS from any REST client, such as Oracle APEX or ORDS.


Reporting Improvements




Oracle APEX 21 offers several enhancements to the reporting capabilities of your applications. You can now use the new PDF Printing option to generate PDF documents from your APEX apps without requiring any additional software or configuration. You can also use the new Interactive Grid Download API to programmatically download Interactive Grid data in CSV, XLSX, or PDF formats. Additionally, you can use the new Chart Region Type to create stunning charts with declarative settings, interactive features, and dynamic actions.


Security Updates




Oracle APEX 21 provides several security updates to protect your applications and data. You can now use the new Social Sign-In feature to allow users to authenticate with their Google, Facebook, or Microsoft accounts. You can also use the new Password Policy feature to enforce strong passwords for your application users. Moreover, you can use the new Security Scan feature to scan your applications for common security vulnerabilities and get recommendations on how to fix them.


Developer Experience Enhancements




Oracle APEX 21 delivers a superior developer experience with several new features and improvements. You can now use the new App Builder Dark Mode to reduce eye strain and improve contrast when developing your applications. You can also use the new Page Designer Layout View to see a visual representation of your page layout and easily drag and drop components. Furthermore, you can use the new Code Editor component to edit code in your applications with syntax highlighting, auto-completion, code folding, and more.


How to download Oracle APEX 21




To download Oracle APEX 21, you need to have an Oracle account. If you don't have one, you can create one for free at . Once you have an Oracle account, follow these steps:


download oracle apex 21.1 all languages


download oracle apex 21.2 english language only


download oracle apex 21 patch set bundle


download oracle apex 21 release notes


download oracle apex 21 installation guide


download oracle apex 21 documentation and tutorials


download oracle apex 21 for linux x86


download oracle apex 21 for windows x64


download oracle apex 21 for oracle solaris on sparc


download oracle apex 21 for ibm aix on power systems


download oracle apex 21 for hp-ux itanium


download oracle apex 21 for microsoft windows (32-bit)


download oracle apex 21 for ibm linux on system z


download oracle apex 21 for hp-ux pa-risc


download oracle apex 21 for oracle database 19c free developer release


download oracle apex 21 for oracle database express edition (xe)


download oracle apex 21 md5 checksum


download oracle apex 21 sha256 checksum


download oracle apex 21 static resources from cdn


download oracle apex 21 known issues


how to download and install oracle apex 21


how to upgrade to oracle apex 21 from previous versions


how to use oracle apex 21 new features and enhancements


how to troubleshoot oracle apex 21 installation and configuration issues


how to get support for oracle apex 21 through oracle support services or otn discussion forum


how to migrate applications from older versions of oracle apex to oracle apex 21


how to backup and restore oracle apex 21 workspace and applications


how to secure oracle apex 21 environment and applications


how to optimize performance of oracle apex 21 applications and database


how to integrate oracle apex 21 with other oracle products and services


how to develop low-code web applications with oracle apex 21


how to create interactive reports and charts with oracle apex 21


how to build mobile-friendly responsive user interfaces with oracle apex 21


how to implement authentication and authorization with oracle apex 21


how to use restful web services and apis with oracle apex 21


how to use sql workshop and utilities with oracle apex 21


how to use team development and feedback features with oracle apex 21


how to use app builder and page designer with oracle apex 21


how to use dynamic actions and javascript with oracle apex 21


how to use plugins and custom components with oracle apex 21


how to use faceted search and data loading features with oracle apex 21


how to use automated testing and debugging tools with oracle apex 21


how to use translation and globalization features with oracle apex 21


how to use email, printing, and exporting features with oracle apex 21


how to use calendars, maps, charts, and media list components with oracle apex 21


Download the software from Oracle website




  • Go to .



  • Select the Oracle APEX 21.1.0 ZIP file and click Download.



  • Accept the license agreement and sign in with your Oracle account.



  • Save the file to your local machine.



Verify the checksum of the downloaded file




To ensure that the file you downloaded is not corrupted or tampered with, you should verify its checksum. A checksum is a unique value that identifies a file based on its contents. You can use a tool like MD5 or SHA-256 to generate and compare checksums. Here are the steps:


  • Go to .



  • Copy the checksum value for Oracle APEX 21.1.0 ZIP file.



  • Use a tool like MD5 or SHA-256 to generate the checksum of the file you downloaded.



  • Compare the two checksums and make sure they match.



How to install Oracle APEX 21




To install Oracle APEX 21, you need to have an Oracle Database 11g or later. You also need to have access to a web server that can serve static files, such as Oracle REST Data Services (ORDS) or Apache Tomcat. There are two ways to install Oracle APEX 21: with standalone ORDS or with existing ORDS or Apache Tomcat. Here are the steps for each method:


Install Oracle APEX 21 with standalone ORDS




with Oracle APEX 21 and can be used for development and testing purposes. Here are the steps:


  • Unzip the downloaded file to a directory of your choice.



  • Open a command prompt and navigate to the apex directory.



  • Run the following command to install Oracle APEX 21:java -jar apex.war



  • Follow the prompts and enter the required information, such as the database connection details, the passwords for the APEX accounts, and the port number for the web server.



  • Wait for the installation to complete and note down the URL for accessing Oracle APEX 21.



Create your Instance Administration Account




The Instance Administration account is used to manage the Oracle APEX instance, such as creating workspaces, managing users, and configuring settings. To create your Instance Administration account, follow these steps:


  • Open a web browser and go to the URL provided by the installation process.



  • Click Sign In and enter admin as the workspace name.



  • Enter admin as the username and the password you specified during the installation.



  • Click Sign In and follow the instructions to change your password and set up your email address.



Configure the APEX_PUBLIC_USER Account




The APEX_PUBLIC_USER account is used to access Oracle APEX applications without authentication. To configure this account, follow these steps:


  • Log in to SQL*Plus as SYSDBA and run the following command:ALTER USER APEX_PUBLIC_USER IDENTIFIED BY ACCOUNT UNLOCK;Replace with a strong password of your choice.



  • Log in to Oracle APEX as an Instance Administrator and go to Manage Instance > Security > Database Accounts.



  • Click Edit on the APEX_PUBLIC_USER row and enter the same password you used in step 1.



  • Click Apply Changes.



Configure RESTful Services




RESTful Services allow you to create and consume web services using standard HTTP methods. To configure RESTful Services, follow these steps:


  • Log in to SQL*Plus as SYSDBA and run the following command:@apex_rest_config.sql Replace with a strong password of your choice. This will create a database user named APEX_LISTENER with the specified password.



  • Log in to Oracle APEX as an Instance Administrator and go to Manage Instance > Security > Database Accounts.



  • Click Edit on the APEX_LISTENER row and enter the same password you used in step 1.



  • Click Apply Changes.



Install Oracle APEX 21 with existing ORDS or Apache Tomcat




This method is recommended if you have an existing web server that can serve static files, such as ORDS or Apache Tomcat. You need to have ORDS 19.4 or later or Apache Tomcat 8.5 or later installed and configured on your machine. Here are the steps:


Unzip the downloaded file and copy the images directory




The images directory contains all the static files required by Oracle APEX 21, such as CSS, JavaScript, images, and icons. You need to copy this directory to your web server's document root. Here are the steps:


  • Unzip the downloaded file to a directory of your choice.



  • Copy the images directory from the apex directory to your web server's document root. For example, if you are using ORDS, copy it to <ords_home>/docs. If you are using Apache Tomcat, copy it to <tomcat_home>/webapps/ROOT.



Run the installation script and follow the prompts




the steps:


  • Open a command prompt and navigate to the apex directory.



  • Run the following command to install Oracle APEX 21:sqlplus /nolog @apexins.sql SYSAUX SYSAUX TEMP /i/The parameters are the names of the tablespaces for APEX data, APEX files, temporary data, and the virtual image directory. You can change them according to your preferences.



  • Follow the prompts and enter the required information, such as the passwords for the APEX accounts.



  • Wait for the installation to complete and note down the URL for accessing Oracle APEX 21.



Configure ORDS or Tomcat to serve APEX images




You need to configure your web server to serve the static files from the images directory. Here are the steps for ORDS and Apache Tomcat:


  • ORDS: Edit the <ords_home>/conf/defaults.xml file and add the following line inside the <entry key="misc"> element:<entry key="images"^>/i/</entry>This will map the virtual image directory to the images directory in your document root.



  • Apache Tomcat: Edit the <tomcat_home>/conf/server.xml file and add the following line inside the <Host> element:<Context docBase="images" path="/i" />This will map the virtual image directory to the images directory in your webapps/ROOT directory.



Conclusion




In this article, we have shown you how to download and install Oracle APEX 21, a low-code platform for enterprise apps. We have also highlighted some of the new features and benefits of Oracle APEX 21 that make it easier and faster to build amazing apps. Whether you are a beginner or an expert, Oracle APEX 21 can help you create powerful, secure, and scalable web applications with minimal coding and maximum productivity. To learn more about Oracle APEX 21, visit .


FAQs




Here are some frequently asked questions about Oracle APEX 21:


  • Q: How much does Oracle APEX 21 cost?A: Oracle APEX 21 is free to use with any edition of Oracle Database 11g or later. You only need to pay for the database license and support.



  • Q: How can I upgrade from an older version of Oracle APEX to Oracle APEX 21?A: You can use the same installation script that you used to install Oracle APEX 21. Just make sure you back up your existing applications and data before upgrading. For more details, see .



  • Q: How can I access Oracle APEX 21 online without installing it?A: You can use Oracle APEX Application Development, a fully managed cloud service that provides a preconfigured environment with Oracle APEX 21 and Oracle Database. You can sign up for a free trial at .



  • Q: How can I learn more about Oracle APEX 21?A: You can find various resources to help you learn and master Oracle APEX 21, such as documentation, tutorials, videos, blogs, forums, and more at .



  • Q: How can I get help or support for Oracle APEX 21?A: You can get help or support for Oracle APEX 21 from various sources, such as Oracle Support, Oracle Community, Stack Overflow, Twitter, and more at .



44f88ac181


0 views0 comments

Recent Posts

See All

Comentários


bottom of page