Installing and Configuring Oracle Application Express 2.2

Purpose

This tutorial describes how to install and configure Oracle Application Express 2.2 into an existing Oracle Database 10g Release 2.

Time to Complete

Approximately 30 minutes

Topics

This tutorial covers the following topics:

	Overview
	Prerequisites
	Installing Oracle HTTP Server
	Installing Oracle Application Express 2.2
	Copying Images
	Configuring HTTP Server
	Creating a New Workspace
	Creating a Workspace Administrator
	Logging In
	Summary

Viewing Screenshots

Place the cursor over this icon to load and view all the screenshots for this tutorial. (Caution: This action loads all screenshots simultaneously, so response time may be slow depending on your Internet connection.)

Note: Alternatively, you can place the cursor over an individual icon in the following steps to load and view only the screenshot associated with that step. You can hide an individual screenshot by clicking it.

Overview

Installation of Oracle Application Express requires you to run a SQL script that loads all the PL/SQL packages into your database so that you can run APEX. In addition, Oracle Application Express requires that HTTP Server be installed and configured.

Back to Topic List

Prerequisites

Before you perform this tutorial, you should:

Perform the Installing Oracle Database 10g on Windows tutorial.

Back to Topic List

Installing Oracle HTTP Server

Oracle Application Express is an application that runs using Oracle HTTP Server. Oracle HTTP Server is installed from the Oracle Database 10g Companion CD or Oracle Application Server 10g. In this tutorial, you install Oracle HTTP Server from the Oracle Database 10g Companion CD. Perform the following steps:

1.	Download and unzip the Oracle Database 10g Companion CD.
2.	Execute the installer via setup.exe.
3.	At the Welcome window, click Next.
4.	Select the third option Oracle Database 10g Companion Products and click Next.
5.	You need to install Oracle HTTP Server in a new Oracle Home. Specify the Name and Path, then click Next.
6.	Select Apache Standalone and click Next.
7.	The installation verifies that your system has the minimum requirements. When done, click Next.
8.	Click Install.
9.	The progress window appears.
10.	The Configuration Assistant window appears.
11.	Once the installation completes successfully, click Exit, then Yes.
12.	Before you can install HTML DB, you need to make sure your PATH Environment Variable is set correctly. Select Start > Settings > Control Panel, then double-click on System.
13.	Click the Advanced tab. Then click Environment Variables.
14.	In the System variables section, select Path and click Edit.
15.	Make sure that the first directory in the path is set to your Oracle Database 10g Database home, not the Apache HTTP Server home. Then click OK.

Back to Topic List

Installing Oracle Application Express 2.2

To install the Oracle Application Express 2.2 software, perform the following steps:

Download the software from OTN here.

Unzip apex_2.2.zip.

Open a terminal window and execute the following commands:

cd <apex dir>
sqlplus /nolog
connect / as sysdba
@apexins oracle SYSAUX SYSAUX TEMP /i/ orcl

The above statement is dependent on your configuration

@apexins <password> <tablespace_htmldb> <tablespace_files> <tablespace_temp>
 <images> <connect>

Oracle Application Express is installed into the database.

Back to Topic List

Copying Images

You need to copy the images that Oracle Application Express uses to the appropriate directory. Perform the following steps:

Open a DOS window and execute the following commands:

cd <http_install_home>/Apache/Apache   
mkdir images   
cd images   
xcopy /s <apex_software_location>/images/*.*

<http_install_home> is the directory during the HTTP install where you specified the oracle_home (i.e. c:\oracle\product\10.2.0\http_1)

<apex_software_location> is the directory where you unzipped the apex zip file and made available for install.

Note: you may also copy the files using Windows Explorer.

Back to Topic List

Configuring HTTP Server

In order to run Oracle Application Express, you need to configure an application in HTTP Server. Perform the following steps:

Create the <HTTP_ORACLE_HOME>\Apache\modplsql\conf\dads.conf file and add the following statements:

Alias /i/ "<http_oracle_home>\Apache\Apache\images/" 
AddType text/xml       xbl 
AddType text/x-component       htc 
 <Location /pls/apex>
	 SetHandler pls_handler
	 Order deny,allow
	 Allow from all
	 AllowOverride None
	 PlsqlDatabaseUsername      APEX_PUBLIC_USER
	 PlsqlDatabasePassword      oracle
	 PlsqlDatabaseConnectString <dbhostname>:1521:<dbsid>
	 PlsqlDefaultPage           apex
	 PlsqlDocumentTablename     wwv_flow_file_objects$
	 PlsqlDocumentPath          docs
	 PlsqlDocumentProcedure     wwv_flow_file_manager.process_download
	 PlsqlAuthenticationMode    Basic
	 PlsqlNLSLanguage           AMERICAN_AMERICA.AL32UTF8
</Location>

Note:
<dbhostname> refers to the name of the host where your database is resides.
<dbsid> refers to the connect string to your database

Stop and start the HTTP Server with the following commands:

cd <http_oracle_home>\opmn\bin
opmnctl stopall
opmnctl startall

Back to Topic List

Creating a New Workspace

Before you create an application, you need to create a workspace. Perform the following steps:

1.	Open your browser and enter the following URL: http://<hostname>:7777/pls/apex/apex_admin Enter admin as the username and enter your password oracle (or what ever the password you specified during the installation). Then click Login.
2.	Under Manage Workspaces, click Create Workspace.
3.	Enter OBE as the Workspace Name and click Next.
4.	For "Re-use Existing Schema?" select No. Enter obe for the Schema Name and Password, and select Medium: 5 Megabytes for the Space Quota. Then click Next.
5.	Enter obe as the username, and enter your password (must be atleast 4 characters) and your e-mail address. Then click Next. Note: A new administrator user is created in addition to the workspace.
6.	Review your workspace request, and then click Create.
7.	Your workspace and user is now created. Click Done.
8.	You now want to login as the obe user for the obe workspace. Click Logout.

Back to Topic List

Creating a Workspace Administrator

You want to create a Workspace Administrator. Perform the following steps:

1.	Click Login.
2.	Enter the following details, and click Login. Workspace: OBE Username: admin Password: oracle
3.	In the Administration area on the right side of the window, select Manage Application Express Users.
4.	Select Create Workspace Administrator.
5.	Enter obe for the User Name and oracle for the Password and Confirm Password. Enter your email address and click Create User.
6.	The OBE Workspace Administrator User has been created. Now you can logout and login as OBE. Click Logout.

Back to Topic List

Logging In

You want to log in to the OBE workspace as the OBE Workspace Administrator User. Perform the following steps:

Click Login.

Enter the following details, and click Login.

Workspace: OBE
Username: obe
Password: oracle

The Workspace Home Page appears.

Back to Topic List

Summary

In this tutorial, you learned how to:

	Install and configure Oracle Application Express
	Create a new workspace and workspace administrator
	Log in to Oracle Application Express

Back to Topic List