This tutorial is a supplement 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.[youtube]http://www.youtube.com/watch?v=637Kf2nyl-U[/youtube]
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)
5. Run the image loader script (5:25)
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.
In the video we touch on the arguments for the APEX install command. We installed a full developers environment. You can also install APEX in a run time mode. The primary difference 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 recommended ones by Oracle for a clean install. If you are upgrading, or had different tablespaces, you would substitute 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.