Oracle Application Express Install

0 Flares Twitter 0 Facebook 0 Google+ 0 StumbleUpon 0 Email -- Filament.io 0 Flares ×

In this post I will discuss the steps needed to install Oracle Application Express 4.2.1.

First you need to make sure you have an Oracle DB installed on your computer. You can get a free version here.

Oracle 11G Express Edition

Here you need a login to the Oracle site. If you don’t have one don’t worry, it’s free to create one! Accept the license agreement then download the DB and install(I may write a blog post about how to install later).

Now to install Oracle Application Express.

Installing Oracle Application Express

Just like the Oracle DB, you need to download it from the Oracle site

Oracle Application Express 4.2

Once downloaded you will need to unzip the folder and move to your desired location. You will notice that all the files  inside the folder are  SQL files and no executable files of any kind. Open a DOS windows and navigate to the location of the apex files. Then run SQL*Plus from the cmd prompt. Login as the sysdba(password was set during DB installation)

Oracle Application Express
After connecting to the Oracle DB you need to run the apexins script.
An example of what parameters to use is shown below

@apexins.sql SYSAUX SYSAUX TEMP /i/

The first parameter is the tablesspace to use for the application user
The second parameter is the table space to use for the files user
The third parameter is the temp tablespace
The fourth parameter is the virtual directory for the application images

 

After that script gets everything setup the next step is to change the admin password. Again you run a script to accomplish this

@apxchpwd.sql

Here you will be prompted for a new password. Make sure the password has at least one capital letter, one number and one special character. I think a minimum of 6 characters are required. If you do not meet the password requirements you will not get any notification of it, the script will simply fail.

 

APEX2

After this step you are now ready to kick off Oracle Apex and begin making apps. I will cover this part in a separate blog post later.

Here is the Installation Guide made by Oracle for further reading.

Oracle Apex Installation Guide