Configuring Oracle Application Express 3.0 in Oracle Database 11g

Purpose

This tutorial describes how to configure Oracle Application Express 3.0 in Oracle Database 11g.

Time to Complete

Approximately 30 minutes

Topics

This tutorial covers the following topics:

	Overview
	Prerequisites
	Configuring the Embedded PL/SQL Gateway
	Creating a New Workspace and Workspace Administrator
	Creating a Developer User
	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 in Oracle Database 11g has become much easier. In Oracle Database 11g, Oracle Application Express is installed when the database is installed. All you need to do is configure the PL/SQL gateway. In prior releases of the Oracle Database, you needed to install Apache, which is no longer needed although you can still use that option in Oracle Database 11g.

Back to Topic List

Prerequisites

Before you perform this tutorial, you should:

Install Oracle Database 11g.

Back to Topic List

Configuring the Embedded PL/SQL Gateway

In Oracle Database 11g, you configure the embedded PL/SQL gateway by running the configuration script apxconf.sql. Running this script enables you to configure the port for the Oracle XML DB HTTP server and to specify a password for the Oracle Application Express ADMIN account. Then you unlock the ANONYMOUS account. Perform the following steps:

1.	Open a terminal window and enter the following commands: cd $ORACLE_HOME/apex sqlplus sys/<sys_password> as sysdba @apxconf
2.	Enter an administrator password, in this case, oracle, for the Application Express Administrator account and press Enter.
3.	Enter 8080 for the port for the XDB HTTP server and press Enter. This is also the default port.
4.	The embedded PL/SQL gateway has been configured.
5.	The last step is to unlock the anonymous user. From your terminal window, enter the following command: ALTER USER ANONYMOUS ACCOUNT UNLOCK;

Back to Topic List

Creating a New Workspace and Workspace Administrator User

Before you create an application, you should create a workspace and a workspace administrator user. Perform the following steps:

1.	Open your browser and enter the following URL: http://<hostname>:8080/apex/apex_admin Enter admin as the username and enter your password oracle (or whatever password you specified during the installation). Then click Login.
2.	The first time you login, you need to change your password. Enter your current password oracle and then enter a new password and click Apply Changes.
3.	Click Return.
4.	You need to login again and specify your new password. Then click Login.
5.	Under Manage Workspaces, click Create Workspace.
6.	Enter obe as the Workspace Name and click Next.
7.	For "Re-use Existing Schema?" select No. Enter obe in the Schema Name and Password fields, and select 5 for the Space Quota. Then click Next.
8.	Enter obe as the Administrator Username, and enter your Administrator Password and your e-mail address. Then click Next. Note: A new administrator user will be created in addition to the workspace.
9.	Review your workspace request, and then click Create.
10.	Your workspace and user are now created. Click Done.
11.	You now want to log in as the obe user for the obe workspace. Click Logout.

Back to Topic List

Creating a Developer User

You want to create a developer user. This is someone who uses Oracle Application Express to create database objects and applications. Perform the following steps:

1.	Click Login.
2.	Enter the following details, and click Login. Workspace: obe Username: obe Password: <your password>
3.	In the Administration area on the right side of the window, select Manage Application Express Users.
4.	Click Create.
5.	Enter dev1 in the User Name field and oracle in the Password and Confirm Password fields. Enter your e-mail address and click Create User.
6.	A developer user has been created. Now you can log out and log in as DEV1. Click Logout.

Back to Topic List

Logging In

You want to log in to the OBE workspace as the developer user. Perform the following steps:

1.	Click Login.
2.	Enter the following details, and click Login. Workspace: obe Username: dev1 Password: <your password>
2.	The first time you login, you need to change your password. Enter your current password and then enter a new password and click Apply Changes.
3.	Click Return.
4.	You need to login again and specify your new password. Then click Login.
3.	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
	Create a developer user
	Log in to Oracle Application Express

Back to Topic List