Install Oracle Apex 3.2 on XE and XP Pro - Video Walkthrough Tutorial

By M&S Consulting (Kevin) on May 27th, 2009
Filed Under Technical Tips // Tags: oracle apex, oracle xe, video training

This tutorial is a supplment to the install video linked to below. It takes you through the process of installing and verifying APEX version 3.2 installed to an Oracle XE database on a Windows XP Professional computer.

High Level Steps

1. Ensure you are logged into Windows XP with Administrator rights
2. Create home directory for APEX and extract software to that directory (0:50)
3. Using SQLPLUS, install the APEX software against the XE database you already installed (2:31)

@apexins SYSAUX SYSAUX TEMP /i/

4. Change the APEX ADMIN account password (4:35)

@apxchpwd

5. Run the image loader script (5:25)

@apxldimg.sql C:\temp

6. Verify the install was applied properly. (6:36)

The times in parenthesis are the approximate start times for that step in the video.

Note: The password being used is “Consult1ng” (without the quotes)

Notes and Resources

The APEX software can be downloaded from this location: APEX Download

The compressed file is universal, and can be used against any supported Oracle database product that is version 9 or newer.

The APEX homepage also contains links to documentation and samples you can use. Some of these will be the subject of future tutorial articles and videos.

APEX Downloads - All OS’s

Oracle XE download artice

Oracle XE Install Tutorial

Details

In the video we touch on the arguments for the APEX install command. We installed a full developers enviornment. You can also install APEX in a run time mode. The primary differance is that in run time mode, the users cannot edit the applications, only run them.

The developer mode install command is: @apexins

The run time mode install command is: @apxrtins

The arguments you provide are formally:

<install command> <tablespace_apex> <tablespace_files> <tablespace_temp> <images dir>

What this distills down to is you must provide the name of the tablespace that is to be used for the APEX system, the files system, and the temp space, as well as a directory for the SQL images. The ones listed in the video (SYSAUX SYSAUX TEMP /i/) are the reccomended ones by Oracle for a clean install. If you are upgrading, or had different tablespaces, you would substitiute those in where needed.

The full explanation of them is also in the formal documentation.

The APEX login screen does differ a little bit from the base one we saw in the Oracle XE tutorial. With the release of APEX 3, you now must supply a workspace name at login. In this tutorial, we used the SYSTEM workspace to login to, as it is the default space for the SYSTEM user.

Related Information:

Oracle XE 10g Windows Install - Video Walkthrough Tutorial

This tutorial article is meant to provide a visual guide to the process of installing Oracle express edition (XE) onto...

Resetting Oracle APEX Admin Password - Video Walkthrough Tutorial

Oracle recommends that the password for the Oracle APEX administrator be changed on new installations, or on migrations from runtime...

APEX 3.2 Tutorial Preparation and OEHR Sample Data - Video Walkthrough

This tutorial video and article is meant to help you setup your APEX installation so you can proceed through the...

Oracle APEX Advanced Tutorial 1 - Creating a Tabular Form - Video Walkthrough

This tutorial is designed to walk you through section 2 of the Oracle APEX Advanced Tutorial, Creating a Tabular Form....

Upgrading to APEX 4 on Oracle XE and Windows

Overview
 This tutorial article and it's associated video will help guide you through the process of upgrading a previously installed...

Oracle APEX Tutorial 8 - Up and Downloading Files - Part 1 - Video Training

Reports and data entry constitue the bulk of what most of these tutorials cover, and what many businesses need. However,...

Oracle APEX Tutorial 3 - Drilldown Report Part 1- Video Training

This tutorial covers section 4 of the Oracle APEX Advanced Tutorials, Creating a drilldown report...

Oracle APEX Tutorial 10 - Access Control - Part 2 - Video Training

Security. We hear about it everywhere. Make this more secure, make this less secure. In the computer industry this is...

13 Responses to “Install Oracle Apex 3.2 on XE and XP Pro - Video Walkthrough Tutorial”

Kranthi
Aug 12, 2009

Hi,

Its really awesome of you to provide such a video for beggineers and it as much of help.Really its very nice of you.

Same way hope you provide some of the basic things i mean reports and stuff at the early stages
ashok.aggarwal
Aug 12, 2009

Hi Kranthi,

Thank you for your kind comments. We have focused on videos for APEX advanced tutorials thus far, but we will discuss your request for more basic information to be added as well. We are adding valuable content regularly and glad that you have found this useful.
Craig Glendenning
Aug 12, 2009

Thanks!

These tutorials are really nice. I have gotten APEX 3.2 on 10g using the PL/SQL gateway working via the http server in XML DB. Even though this is not an “officially” supported configuration by Oracle (they support apex on 10g with an external web server) it works fine…hopefully this little step-by-step will help others wrestling with the common issues like images not displaying, annoying pop-ups, etc. etc.
http://cglendenningoracle.blogspot.com/2009/08/how-to-install-oracle-application.html

Thanks again!
Craig
Dariusz
Aug 19, 2009

Best tutor for the upgrade out there. clear, clean and efficient. Well done!
Subramanian Kaushik
Sep 12, 2009

Hi MS,
That’s really a great effort.
I blindfoldedly installed migrated Oracle apex from 2.0 to 3.2 without any problems.

I really appreciate your effort in creating a nice video.

Thanks for your video.

regards,
Subramanian Kaushik Gurumoorthy
Paul Guidry
Dec 12, 2009

Great tutotial, but at the end I had to log into apex using sys and not system. I recieved the same result though (Application Express 3.2.1.00.11) at the bottom right hand of the screen.
Dave Bull
Jan 19, 2010

At last! a tutorial which explains everything!

And you make it look so easy as well

Very well doen chaps
rageragg
Apr 22, 2010

These videos are very helpful for people who can not directly access the new technologies.
Dangana
Apr 28, 2010

Thank you for the Excellent Presentation, We are proud of people like.
Rami
May 13, 2010

very nice tutorial can we use oracle 11g database?
because i get some error messages using it.
karthik
May 14, 2010

hi,
i have successfully installed the apex 3.2 ,but wen i try to connect to database using WORKSPACE:SYSTEM,USERNAME:SYSTEM AND PASSWORD:MANAGER…I am not able to log-in..please let me know how to overcome this problem..
masum
Jun 09, 2010

i have a probleam plz tell me about the oralc apex
Cyrex
Jul 02, 2010

Hey man why I cant install Apex 4? is there anyone can help me.,?