Oracle Database Express Edition Download

Posted : admin On 12/26/2021
  1. Download Oracle Database 11g Express Edition

Oracle 11g XE is a free edition of Oracle database which supports most of the functionality of Standard edition. 11g XE is available (at least) for Windows and Linux. As with all free versions of databases, XE also has limitations: The maximum database size is 11 GB. The maximum amount of RAM XE can use is 1 GB.

  1. Download the Oracle Database 10 g Express Edition installer. It can be found at You will need to select the Windows download and accept the license agreement before the download will commence.
  2. At the time of writing this book, Oracle Database 11g XE is available on the Windows 32-bit and Linux 64-bit platforms. Oracle Database 11g XE software is 301 MB and 312 MB in size for Linux and Windows operating systems, respectively. As mentioned earlier, Oracle Database 11g XE is a free software.
  3. Oracle Database Enterprise Edition 10.2, 11.x, 12.x, and 18c are available as a media or FTP request for those customers who own a valid Oracle Database product license for any edition. To request access to these releases, follow the instructions in Oracle Support Document 1071023.1 (Requesting Physical Shipment or Download URL for Software.

Oracle Database 10g Express Edition is free to download, free to develop, deploy, and distribute.Oracle database administrators and PL/SQL developers can get Oracle download for free from Oracle web site.


Now there is a starter level, downloadable free database Oracle Database 10g Express Edition or also known as Oracle Database XE.Oracle professionals can download free database Oracle Database 10g Express for Microsoft Windows from Oracle Database 10g Release 2 (10.2.0.1) Express Edition for Microsoft Windows.Also there is free database version of Oracle Database XE for Linux operating systems which can be download by Oracle database administrators and PL/SQL developers.You can download Oracle XE for Debian, Mandriva, Novell, Red Hat and Ubuntu Linuz systems from Oracle Database 10g Release 2 (10.2.0.1) Express Edition for Linux x86.

Oracle.exe has a total size of 157 MB for download.Developers and administators can also download Oracle Database Express Edition Getting Started Guide.Besides the Oracle Database Express Edition 2 Day DBA course documentation is available for free download.This documentation is a guide and also a how to information for Oracle Database Express administrators.It will guide Oracle database administrators with the Oracle Database systems basis and main administration topics.

After download is completed, downloaders can finish the installation as easy as a MS SQL Server database.The Oracle Express Edition also has a web graphical user interface (GUI) for administring the database.You can start immediately learning and studying the basis of database administration and database development with the sample data or sample database included with the Oracle XE Edition.

Download Oracle Database 11g Express Edition

If you are a developer working on PHP, Java or as well as .NET applications you can get use of this free Oracle Database XE.You can also distribute your Oracle Database XE applications free of charge.

You will find more information about Oracle 10g XE at Oracle Database 10g Express Edition (Oracle Database XE) product page.

Free Database Downloads

IBM DB2 Express-C is free to download, free to develop, deploy, and distribute

Learn how to download and install Oracle Application Express.

This section describes how to download and install Oracle Application Express. How you install Oracle Application Express depends upon by the type of database you into which you are installing.

  • Installing Application Express
    Install Oracle Application Express by downloading a ZIP file from the Oracle Application Express download page.
  • Creating or Updating Your Instance Administration Account
    Learn how to create or update your Instance Administrator account.
  • Restart Processes
    Restart the processes that you stopped before you began the installation.

See Also:

'Utilizing the Multitenant Architecture in Oracle Database 12c or Later.'

Parent topic:Installing Application Express and Configuring Web Listener - Embedded PL/SQL Gateway (Deprecated)

A.3.1 Installing Application Express

Install Oracle Application Express by downloading a ZIP file from the Oracle Application Express download page.

  1. For installations where the development will be in English only, download the file apex_20.1_en.zip from the Oracle Application Express download page. If the development will include languages other than English, download apex_20.1.zip from the Oracle Application Express download page. See:

    Note that the actual file name may differ if a more recent release has shipped since this document was published.

  2. Unzip downloaded zip file:
    • If English only, unzip apex_20.1_en.zip as follows, preserving directory names:

      • UNIX and Linux: $ unzip apex_20.1_en.zip

      • Windows: Double click the file apex_20.1_en.zip in Windows Explorer

    • If multiple languages, unzip apex_20.1.zip as follows, preserving directory names:

      • UNIX and Linux: $ unzipapex_20.1.zip

      • Windows: Double click the file apex_20.1.zip in Windows Explorer

    Note:

    You should keep the directory tree where you unzip the files short and not under directories that contain spaces. For example, within Windows unzip to C:TEMP.

  3. Change your working directory to apex.
  4. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. For example:
  5. Disable any existing password complexity rules for the default profile. See “Configuring Password Protection” in Oracle Database Security Guide.
  6. Select the appropriate installation option.

    Full development environment provides complete access to the App Builder environment to develop applications. A Runtime environment enables users to run applications that cannot be modified.

    Available installation options include:

    • Full development environment. Run apexins.sql passing the following four arguments in the order shown:

      Where:

      • tablespace_apex is the name of the tablespace for the Oracle Application Express application user.

      • tablespace_files is the name of the tablespace for the Oracle Application Express files user.

      • tablespace_temp is the name of the temporary tablespace or tablespace group.

      • images is the virtual directory for Oracle Application Express images. For installations using EPG, /i/ is the required value for the images argument. To support future Oracle Application Express upgrades, define the virtual image directory as /i/.

      Example:

      Note:

      If you receive the following error, exit SQL*Plus and change your working directory to where you unzipped the installation file, for example C:TEMP in Windows, before starting SQL*Plus:

      SP2-0310: unable to open file 'apexins.sql'

    • Runtime environment. Run apxrtins.sql passing the following arguments in the order shown:

      Where:

      • tablespace_apex is the name of the tablespace for the Oracle Application Express application user.

      • tablespace_files is the name of the tablespace for the Oracle Application Express files user.

      • tablespace_temp is the name of the temporary tablespace or tablespace group.

      • images is the virtual directory for Oracle Application Express images. To support future Oracle Application Express upgrades, define the virtual image directory as /i/.

      Example:

When Application Express installs, it creates the following database accounts:

  • APEX_200100 - This account owns the Application Express schema and metadata.

  • FLOWS_FILES - This account owns the Application Express uploaded files.

  • APEX_PUBLIC_USER - This minimally privileged account is used for Application Express configuration with Oracle REST Data Services or Oracle HTTP Server and mod_plsql.

  • APEX_INSTANCE_ADMIN_USER - A minimally privileged account used for the REST Administration Interface.

    Tip:

    To learn more about the REST Administration Interface, see 'About the REST Administration Interface' in Oracle Application Express Administration Guide

Note:

In an environment where EPG is used to access Oracle Application Express, the existing minimally privileged account ANONYMOUS is used.

Oracle

If you are upgrading from a previous release, then FLOWS_FILES already exists and APEX_PUBLIC_USER is created if it does not already exist.

Tip:

Oracle Application Express must be installed from a writable directory on the file system. See 'Reviewing a Log of an Installation Session.'

See Also:

  • 'Configuring Password Protection' in Oracle Database Security Guide

  • 'About the Oracle Application Express Runtime Environment'

  • 'SQL*Plus User's Guide and Reference for more information about SQL*Plus'

  • 'Reviewing a Log of an Installation Session'

Parent topic:Downloading and Installing Oracle Application Express

A.3.2 Creating or Updating Your Instance Administration Account

Learn how to create or update your Instance Administrator account.

This section describes how to create or update your Instance Administrator account.

Tip:

Skip this section if you are upgrading from a previous release of Oracle Application Express. In an upgrade scenario, the Instance Administrator account and password is preserved and carried over from the prior release.

  • What Is an Instance Administrator?
    Instance administrators are superusers that are responsible for managing an entire Oracle Application Express instance, including managing workspace provisioning, configuring features and instance settings, and managing security.
  • About apxchpwd.sql
    Run the apxchpwd.sql script to create or update your Instance Administrator account.
  • Running apxchpwd.sql
    Run the apxchpwd.sql script to create and update your Instance Administrator account.

Parent topic:Downloading and Installing Oracle Application Express

A.3.2.1 What Is an Instance Administrator?

Free

Instance administrators are superusers that are responsible for managing an entire Oracle Application Express instance, including managing workspace provisioning, configuring features and instance settings, and managing security.

To perform these tasks, an Instance administrator signs in to the Oracle Application Express Administration Services application.

See Also:

'Oracle Application Express Administration Services' in Oracle Application Express Administration Guide

Parent topic:Creating or Updating Your Instance Administration Account

A.3.2.2 About apxchpwd.sql

Run the apxchpwd.sql script to create or update your Instance Administrator account.

Running the apxchpwd.sql script enables your to create or update your Instance Administrator account. You must run the apxchpwd.sql script in the following scenarios:

  • New Oracle Application Express installations - Run apxchpwd.sql to create an Instance Administrator account and password.

  • Converting of a runtime environment to a development environment - Run apxchpwd.sql to change the Instance Administrator account password.

  • Changing Your Instance Administrator Password -Run apxchpwd.sql to change the password for an existing Instance Administrator account.

  • Unlocking Your Instance Administrator Account - Run apxchpwd.sql to unlock an existing Instance Administrator account.

Tip:

You do not need to run apxchpwd.sql when upgrading from a previous release of Oracle Application Express. In an upgrade scenario, the Instance Administrator account password is preserved and carried over from the prior release.

Parent topic:Creating or Updating Your Instance Administration Account

A.3.2.3 Running apxchpwd.sql

Run the apxchpwd.sql script to create and update your Instance Administrator account.

To create or update your Instance Administrator account:

  1. Change your working directory to the apex directory where you unzipped the installation software.
  2. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. For example:

    If Application Express was installed in a CDB, change your container to the PDB where you want to change the Administrator account password. For example: alter session set container = 'PDB1'

  3. If Application Express was installed in a CDB, change your container to the PDB where you want to change the Administrator account password. For example:
  4. Run apxchpwd.sql. For example:

    Follow the on-screen instructions. You will be prompted provide a username, password, and email address. If the account username does not exist, it will be created for you.

See Also:

SQL*Plus User's Guide and Reference for more information about SQL*Plus

Parent topic:Creating or Updating Your Instance Administration Account

A.3.3 Restart Processes

Restart the processes that you stopped before you began the installation.

After you install Oracle Application Express, you must restart the processes that you stopped before you began the installation.

Parent topic:Downloading and Installing Oracle Application Express