Oracle Application Express is a rapid web development platform that provides you necessary tools to build web applications at a high rate. They are powerful and easy-to-use platform that provides you with a WYSIWYG (What You See Is What You Get) interface to build attractive web applications. Unlike other web development platform, Oracle Application Express works on Oracle database completely, taking the full advantage of CPU. Oracle Apex or Application Express is bundled with the Oracle Database. The Oracle Application Express 4.0 is bundled with the popular Oracle 11g XE. In this tutorial, let us see how to install Oracle Application Express 4.0 virtually.
This video will show you how to install Oracle Express Edition on your computer. Oracle Express runs on a Windows PC and allows you to easily use an Oracle d. Oracle Database Express Edition (XE) is a community supported edition of the Oracle Database family. Please go to the Oracle Database XE Community Support Forum for help, feedback, and enhancement requests. Note: Oracle Support Services only provides support for Oracle Database Enterprise Edition (EE) and Oracle Database Standard Edition 2 (SE2) in conjunction with a valid Oracle. Oracle Database 11g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 11g Release 2 code base. Programs for query ″download oracle 11g express edition″ Devart ODBC Driver for Oracle.
How to install Application Express 4.0 on Virtual Box?
Here is a step-by-step procedure to guide you through the installation process of Oracle Application Express 4.0. As Oracle Application Express is bundled with the database, we need to install the database and then setup for Application Express.
- Download Virtual Box from here for your operating system.
- Install Virtual Box.
- You can install any Linux operating system image but I am showing you with the Oracle Linux. To download Oracle Linux, you need to have an Oracle account to download from Oracle Software Delivery Cloud.
- You need to download two images from Oracle Software Delivery Cloud.
- One is Boot ISO image.
- Another one is the source installation image (x86). Download both DVD images if they are separated.
- After downloading Oracle Linux images, open VirtualBox and click on New.
- Name: Oracle Linux
- Set a memory size.
- Hard Disk: Create a virtual hard disk now.
- Choose VDI > Dynamically allocated > Specify a size.
(As you choose 'Dynamically allocated', the hard disk file will grow as you start storing files on the VM. This allows you to save disk space.)
- Choose VDI > Dynamically allocated > Specify a size.
- Choose the VM that you have created and click on Settings.
- Go to Storage.
- Under Controller IDE, add an optical drive and choose the Boot ISO image.
- Again, add an optical drive and choose the source installation images. This will be the source for installation of Oracle Linux.
- Click OK.
- Click on the VM and hit Start.
- Choose 'Install Oracle Linux'.
- Select the language that you want to use.
- Specify the installation source and hard disk destination.
- Hit Begin Install to start installation.
- While installing, the wizard shows you an option to set root password and also to create a new user. We need both to install Application Express 4.0. So, set a root password and create a new user and make the user as administrator.
- The installation will take several minutes to complete depending upon the specifications you have provided.
- After the installation, power off your Virtual Machine.
- Choose your Virtual Machine in VirutalBox and click Settings. You need to specify network details.
- Go to Network tab.
- Set 'Attached To' to Bridged Adapter.
- Select your hardware name.
- Now, power on your Virtual Machine.
- Go to Oracle Database Express Edition 11g Release 2 downloads page and download the RPM file to your downloads directory. Note that Oracle Application Express comes with the Oracle Database.
- Go to Applications Menu > Files > Downloads directory.
- Extract the compressed file that you have downloaded and you will get a Disk 1 folder. Enter into Disk 1 folder and you will find a RPM file.
- Right click anywhere on the File browser and choose 'Open in Terminal'.
- Execute the following command.
- After the installation process succeeds, you should configure Oracle 11g XE using:
- The configuration will prompt for several details regarding the port and password.
- Provide the default port as 8080.
- Specify Database Listener port as 1521.
- Specify any password for SYS and SYSTEM database users. Please make sure that you remember this password.
- Specify 'y' if it asks to start Oracle database on boot.
- Now we need to setup environment variables. Oracle Database comes with a shell script where it sets default environment variable values.
- Open up .bash_profile in your favourite text editor. Here, I am using Vim.
- Just above the the line
export PATH
, add the below line.. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
- Reload the .bash_profile by:
- We need to verify whether our VM's hostname matches with the configuration file of Oracle database.
- To determine the hostname of your Virtual Machine, execute the following and this will give you the hostname of your Virtual Machine.
- Go to listener.ora file and check if the LISTENER contains HOST value as your hostname. This is the listener file of Oracle and you need to specify your hostname.
- Now you need to restart your Virtual Machine.
- After your Virtual Machine turns on, make sure that your Listener Control has started and listening to your LISTENER that you have specified in listener.ora file.
- Start Listener Control using:
- Check status of Listener Control using:
- As we use a Bridged Adapter from host to connect to the network, make sure that you turn off firewall.
- Go to Applications Menu on the top > Others > Get Started with Oracle Database.
- In the homepage, Click on Application Express button.
- Enter 'sys' (without quotes) as username and the password that you provided during configuring the Oracle Database and login. Database Username is your Apex workspace.
- Click on Create Workspace.
- Now navigate to http://YOUR_VM_IP_ADDRESS:8080/apex from your host machine and login to the Application Express using the credentials that you created now.
- Start building powerful web applications at lightning fast! Happy Coding!
Oracle Application Express provides common tools for CRUD operations, authentication schemes and authorization roles, however, to achieve a dynamic functionality, you need to create packages and call them from Oracle Application Express. The future versions of Oracle Application Express has improved and a lot of new features are yet to be announced. Who knows? The future might be Oracle Application Express.
Oracle Express 11g Tutorial
Oracle Application Express 4.0 is a popular platform compared to other versions. We will soon cover upgrading to newer versions and also, a tutorial to install without Virtual Box.
What is your thoughts on Oracle Application Express? Are you already working on it or a beginner? Share your thoughts in the comments below.
- Download
Thank you for using our software library. Use the link given below and proceed to the developer's website in order to download Oracle Database 11g Express Edition free.
We wish to warn you that since Oracle Database 11g Express Edition files are downloaded from an external source, FDM Lib bears no responsibility for the safety of such downloads. We recommend checking your downloads with an antivirus. FDM Lib takes it upon itself to provide free download links and inform users when the developing company starts providing a version of Oracle Database 11g Express Edition for direct download.
Often downloaded with
- Devart ODBC Driver for OracleDevart ODBC Driver for Oracle provides high-performance and feature-rich...$149.95DOWNLOAD
- Oracle ODBC DriverDevart ODBC Driver for Oracle provides high-performance and feature-rich...$149.95DOWNLOAD
- Oracle ODBC driver (32/64 bit)Devart ODBC Driver for Oracle provides high-performance and feature-rich...$149.95DOWNLOAD
- Devart dbExpress driver for OracledbExpress is a database-independent layer that defines common interface for...$149.95DOWNLOAD
- Oracle MaestroOracle Maestro is an Oracle admin tool for database management, control and...$129DOWNLOAD
Backup & Restore
Backup & Restore
Backup & Restore
Devart dbForge Data Compare for Oracle Express EditionDatabase Tools
OpenLink Ingres ODBC Driver (Express Edition)System Optimization
Oracle Express 11g 64
KONICA MINOLTA Print Status NotifierOracle Express 11g
Device Assistants