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
Logging in to a Workspace
Finding Your Workspace Name
Resetting Your Password
Logging Out of a Workspace

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 Tasks, click Request a Workspace.

The Request Service Wizard appears.
Click Next 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 embedded PL/SQL gateway, go to:
```
http://hostname:port/apex
```
Where:
- hostname is the name of the system where Oracle XML DB HTTP Server is installed.
- port is the port number assigned to Oracle XML DB HTTP Server. In a default installation, this number is 8080. See "Verifying the Oracle XML DB HTTP Server Port".
- 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 Oracle HTTP Server (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 Oracle XML DB HTTP Server Port

To verify the port number where the Oracle XML DB HTTP Server is running:

Start SQL*Plus and connect the database where Oracle Application Express is installed as SYS:
- On Windows:
```
SYSTEM_DRIVE:\ sqlplus /nolog
connect sys as sysdba
```
- On UNIX and Linux:
```
$ sqlplus /nolog
connect sys as sysdba
```
When prompted, enter the appropriate username and 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 HTTP Server is disabled.

See Also:

Oracle Database Installation Guide to learn how to enable the Oracle XML DB HTTP 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".
From the Administration list, click Change 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 icon in the upper right corner of the window.