Logging In To Oracle Application Express

When you log in to Oracle Application Express you log in to a workspace. A workspace is an area within the Oracle Application Express development environment where developers can create applications.

How you log in to Oracle Application Express depends upon whether you have configured your development environment:

If you have recently installed Oracle Application Express, you must configure your development environment. See "Configuring Your Oracle Application Express Environment".
If you are a developer logging into a previously configured development environment, an administrator must grant you access to a workspace. See "Configuring Your Oracle Application Express Environment".

Topics:

About Browser Requirements

o view or develop Oracle Application Express applications, web browsers must support Java Script and the HTML 4.0 and CSS 1.0 standards. The following browsers are required to develop applications in Oracle Application Express:

Microsoft Internet Explorer 7.0 or later version
Mozilla Firefox 14 or later version
Google Chrome 21 or later version
Apple Safari 5.0 or later version

Application Express applications can be developed that support earlier web browser versions, including Microsoft Internet Explorer 6.0.

Configuring Your Oracle Application Express Environment

How you set up Oracle Application Express depends upon your user role. If you are a developer accessing a hosted development environment, an administrator must grant you access to a workspace. If you are an Oracle Application Express administrator, you must perform the following steps:

Log in to Oracle Application Express Administration Services. Oracle Application Express Administration Services is a separate application for managing an entire Oracle Application Express instance. You log in using the ADMIN account and password created or reset during the installation process.
1. In a web browser, navigate to the Oracle Application Express Administration Services application. By default, Oracle Application Express Administration Services installs to the following location:
  - If your setup uses the Oracle Application Express Listener, go to:
```
http://hostname:port/apex/apex_admin
```
    Where:
    
    hostname is the name of the system where Oracle Application Express Listener is installed.
    
    port is the port number assigned when configuring the Oracle Application Express Listener. In a default installation, this number is 8080. To learn more, see Oracle Application Express Listener Installation and Configuration Guide.
    
    apex is the service name defined when configuring the Oracle Application Express Listener.
  - If your setup uses the embedded PL/SQL gateway, go to:
```
http://hostname:port/apex/apex_admin
```
    Where:
    
    hostname is the name of the system where Oracle XML DB Protocol Server is installed.
    
    port is the port number assigned to HTTP on the Oracle XML DB Protocol Server. In a default installation, this number is 8080. If you are using the Oracle Database 12c multitenant architecture, then each PDB will have a distinct port number. See "Verifying the Port Assigned to HTTP on the Oracle XML DB Protocol Server".
    
    apex is the database access descriptor (DAD) defined in the configuration file.
  - If your setup uses Apache and mod_plsql, go to:
```
http://hostname:port/pls/apex/apex_admin
```
    Where:
    
    hostname is the name of the system where Oracle HTTP Server is installed.
    
    port is the port number assigned to HTTP on the Oracle HTTP Server. In a default installation, this number is 7777.
    
    pls is the indicator to use the mod_plsql cartridge.
    
    apex is the database access descriptor (DAD) defined in the mod_plsql configuration file.
2. On the Login page:
  - In Username, enter admin.
  - In Password, enter the Oracle Application Express administrator account password you specified when you installed Oracle Application Express.
  - Click Login.
See Also:

"Logging In To Oracle Application Express Administration Services" in Oracle Application Express Administration Guide
Specify a provisioning mode. In Oracle Application Express Administration Services you must determine how the process of creating (or provisioning) a workspace works. See "About Workspace Provisioning" in Oracle Application Express Administration Guide.
Create a Workspace. A workspace is a virtual private database allowing multiple users to work within the same Oracle Application Express installation while keeping their objects, data and applications private. Each workspace has a unique ID and name. An Oracle Application Express administrator can create a workspace manually or have users submit requests. See "Creating Workspaces" and "Managing Workspace Requests" in Oracle Application Express Administration Guide.
Log in to a Workspace. Once you create a workspace in Oracle Application Express Administration Services, return to the Oracle Application Express Login page and log in to that workspace. See "Logging In To Oracle Application Express as a Developer".

Logging In To Oracle Application Express as a Developer

When you log in to Oracle Application Express, you log in to a workspace. If you are a developer, an administrator must grant you access to a workspace.

Note:

Before users can request a workspace or change their passwords, an Oracle Application Express administrator must configure Oracle Application Express environment preferences.

See Also:

"Managing Environment Settings" in Oracle Application Express Administration Guide

Topics:

Requesting a Workspace

Note:

This section applies only if your Oracle Application Express administrator has configured Oracle Application Express to support workspace requests.

Before you can log in to Oracle Application Express, an administrator must grant you access to a workspace. Each workspace has a unique ID and name.

To request a workspace:

In a web browser, navigate to the Oracle Application Express Login page.

If you do not know the URL for logging in to Application Express, see "Logging In To a Workspace".

The Login page appears.
Under Workspace, click Request a Workspace.

The Request Service Wizard appears.
Click Get Started and follow the on-screen instructions.

See Also:

"Creating Workspaces" in Oracle Application Express Administration Guide

Logging In To a Workspace

After an Oracle Application Express administrator approves a workspace request, an e-mail arrives with your login credentials (the workspace name, user name, and password).

Note that if your administrator selected Email Verification as the automated method for handling new workspace requests, you might first receive an email containing a verification link. This step ensures that your email is a valid one before the workspace request is approved.

To log in to Oracle Application Express:

In a web browser, navigate to the Oracle Application Express Login page. By default, Oracle Application Express installs to the following location:
- If your setup uses the Oracle Application Express Listener, go to:
```
http://hostname:port/apex
```
  Where:
  - hostname is the name of the system where Oracle Application Express Listener is installed.
  - port is the port number assigned to Oracle Application Express Listener. In a default installation, this number is 8080. To learn more, see Oracle Application Express Listener Installation and Configuration Guide
  - apex is the service name defined when configuring the Oracle Application Express Listener.
- If your setup uses the embedded PL/SQL gateway, go to:
```
http://hostname:port/apex
```
  Where:
  - hostname is the name of the system where Oracle XML DB Protocol Server is installed.
  - port is the port number assigned to HTTP on the Oracle XML DB Protocol Server. In a default installation, this number is 8080. If you are using the Oracle Database 12c multitenant architecture, then each PDB will have a distinct port number. See "Verifying the Port Assigned to HTTP on the Oracle XML DB Protocol Server".
  - apex is the database access descriptor (DAD) defined in the configuration file.
    
    For users who have upgraded from earlier releases, or who have a custom configuration, this value may be htmldb or something else. Verify your DAD with your Oracle Application Express administrator.
- If your setup uses Apache and mod_plsql, go to:
```
http://hostname:port/pls/apex
```
  Where:
  - hostname is the name of the system where Oracle HTTP Server is installed.
  - port is the port number assigned to Oracle HTTP Server. In a default installation, this number is 7777. You can find information about your Oracle HTTP Server installation's port number from either of the following files:
```
ORACLE_BASE\ORACLE_HOME\install\portlist.ini
ORACLE_BASE\ORACLE_HTTPSERVER_HOME\Apache\Apache\conf\httpd.conf
```
    Be aware that if you change a port number, it is not updated in the portlist.ini file. You can only rely on this file immediately after installation.
  - pls is the indicator to use the mod_plsql cartridge.
  - apex is the database access descriptor (DAD) defined in the mod_plsql configuration file.
    
    For users who have upgraded from earlier releases, or who have a custom configuration, this value may be htmldb or something else. Verify your DAD with your Oracle Application Express administrator.
    
    See Also:
    
    "Managing Oracle Database Port Numbers" in Oracle Database Installation Guide and ORACLE_BASE\ORACLE_HTTPSERVER_HOME\Apache\modplsql\conf\dads.readme for more information on database access descriptors
The Login page appears.
Under Login, enter the following:
- In the Workspace field, enter the name of your workspace.
- In the Username field, enter your user name.
- In the Password field, enter your case-sensitive password.
Click Login.

Note that, depending on your setup, you might be required to change your password when you log in for the first time.

Verifying the Port Assigned to HTTP on the Oracle XML DB Protocol Server

To verify the port number assigned to HTTP on the Oracle XML DB Protocol Server:

Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. For example:
- On Windows:
```
SYSTEM_DRIVE:\ sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password
```
- On UNIX and Linux:
```
$ sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password
```
Enter the following statement to verify the port number:
```
SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
```
If the port number returns 0, the Oracle XML DB Protocol Server is disabled.

See Also:

Oracle Application Express Installation Guide to learn how to enable the Oracle XML DB Protocol Server

Finding Your Workspace Name

If you cannot remember your workspace name, you can request a list of all workspace names associated with your email address.

To find your workspace name:

On the Login page, click Find My Workspace on the Tasks list.
Enter your email address and click Find Workspace.

An email with the list workspace names is sent to you.

Resetting Your Password

You can reset your password by clicking the Change Password link on the Workspace home page.

To reset your password from the Workspace home page:

Log in to Oracle Application Express. See "Logging In To Oracle Application Express".
Click the Administration icon.

The Administration page appears.
From the Administration list, click Change My Password.

The Change Password page appears.
In Change Password, enter the following:
- Enter Current Password - Enter your current password.
- Enter New Password - Enter your new password.
- Confirm New Password - Enter your new password again.
Click Apply Changes.

Tip:

You can also reset your password on the Login page by clicking the Reset Password link.

See Also:

"Changing an End User Password" in Oracle Application Express Administration Guide

Logging Out of a Workspace

To log out of Oracle Application Express, click the Logout link in the upper right corner of the window.