1.2 Signing In To Oracle Application Express

Note:

This information does not apply to Oracle Database Cloud Service (Database Schema).

This section describes how to sign in to Oracle Application Express. In addition to describing the sign in steps, this section also discusses browser requirements, available user roles, and configuration option.

Browser Requirements
About Application Express User Roles
Overview of Configuring Oracle Application Express
Signing In and Out of a Workspace as a Developer

1.2.1 Browser Requirements

Because Oracle Application Express relies upon standards-compliant HTML5, CSS3, and JavaScript, Oracle recommends that you use the latest web browser software available for the best experience. To learn more, see "Browser Requirements" in Oracle Application Express Installation Guide.

1.2.2 About Application Express User Roles

To access the Oracle Application Express development environment, users sign in to a shared work area called a workspace. Users are divided into four primary roles:

End users do not have access to development or administrative capabilities. End users cannot sign into a workspace and create applications. End users can only run existing database or Websheet applications.
Developers are users who create and edit applications.
Workspace administrators are users who perform administrator tasks specific to a workspace such as managing user accounts, monitoring workspace activity, and viewing log files.
Instance administrators are superusers that manage an entire hosted instance using the Application Express Administration Services application. Instance administrators manage workspace provisioning, configure features and instance settings, and manage security.

Tip:

The role of Instance administrator is not available in Oracle Database Cloud Service (Database Schema).

1.2.3 Overview of Configuring Oracle Application Express

Note:

This information does not apply to Oracle Database Cloud Service (Database Schema).

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 Instance administrator, you must sign in to the Oracle Application Express Administration Services application and perform the steps described in this section.

Signing In To Oracle Application Express Administration Services
Specifying a Provisioning Mode
Creating a Workspace
Signing In To the Workspace

1.2.3.1 Signing In To Oracle Application Express Administration Services

To sign in to Oracle Application Express Administration Services:

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 Oracle REST Data Services, go to:
```
http://hostname:port/apex/apex_admin
```
  Where:
  - hostname is the name of the system where Oracle REST Data Services is installed.
  - port is the port number assigned when configuring Oracle REST Data Services. In a default installation, this number is 8080. To learn more, see Oracle REST Data Services Installation, Configuration, and Development Guide.
  - apex is the service name defined when configuring Oracle REST Data Services.
- 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 HTTP Server is installed.
  - port is the port number assigned to HTTP on the Oracle XML DB HTTP Server. In a default installation, this number is 8080. If you are using the Oracle Database 12c Pluggable Databases architecture, then each PDB will have a distinct port number. See "Verifying the Port Assigned to HTTP on the Oracle XML DB HTTP 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 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.
    
    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 Instance administrator.
The Login page appears.
In Username, enter the username of an Instance administrator.
In Password, enter your Instance administrator account password.

Tip:
admin is the default Instance administrator account. As a post installation step, administrators can run the script apxchpwd.sql to create one or more Instance administrator accounts or change passwords for these accounts. To learn more, see the "Creating or Updating Your Instance Administration Account" section for your Web Listener in Oracle Application Express Installation Guide. To create and manage additional Instance administrator accounts, see also "Creating New User Accounts in Administration Services" in Oracle Application Express Administration Guide.
Click Sign In to Administration.

Oracle Application Express Administration Services appears.

See Also:

"Creating New User Accounts" in Oracle Application Express Administration Guide

1.2.3.2 Specifying a Provisioning Mode

The Instance administrator determines how the process of provisioning (or creating) a workspace works for a specific Oracle Application Express instance. To determine how provisioning works, an Instance Administrator selects one of the following options on the Instance Settings page:

Manual - In this mode, an Instance administrator creates new workspaces and notifies the Workspace administrator of the login icon.
Request - Users request workspaces directly in a self-service fashion. Users click a link on the login page to access a request form. After the workspace request has been granted, users are automatically emailed the appropriate login information.
Request with Email Verification - In this mode, users request workspaces directly by clicking a link on the login page to access a request form. Each user receives an initial email containing a verification link. Clicking this link validates the user's email address and then the request is processed. Then another email is sent to the user containing login credentials (that is, the workspace name, username, and password).

1.2.3.3 Creating a Workspace

A workspace enables 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 Also:

"Creating Workspaces" and "Managing Workspace and Change Requests" in Oracle Application Express Administration Guide

1.2.3.4 Signing In To the Workspace

Once a workspace has been created in Oracle Application Express Administration Services, the final step is to sign in to your workspace to the Oracle Application Express Login page and sign in to that workspace.

See Also:

"Signing In To a Workspace"

1.2.4 Signing In and Out of a Workspace as a Developer

Note:

This information does not apply to Oracle Database Cloud Service (Database Schema).

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

Requesting a Workspace
Signing In To a Workspace
Signing Out of a Workspace
Recovering Your Workspace Name
Resetting Your Password from the Sign In Page

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 and "Changing Your Password"

1.2.4.1 Requesting a Workspace

Note:

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

See Also:

"Creating Workspaces" in Oracle Application Express Administration Guide

Before you can sign 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 Sign In page.

Tip:
If you do not know the URL for Oracle Application Express Login page, see step 1 in "Signing In To a Workspace".

The Sign In page appears.
Under Workspace, click Request a Workspace.

The Request Service Wizard appears.
Select the type of workspace. Options include:
- Application Development
- Packaged Apps Only
Follow the on-screen instructions.

1.2.4.2 Signing 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.

See Also:

"Creating Workspaces" in Oracle Application Express Administration Guide

To sign in to Oracle Application Express:

In a web browser, navigate to the Oracle Application Express Login page.
- If your setup uses the Oracle REST Data Services, go to:
```
http://hostname:port/apex
```
  Where:
  - hostname is the name of the system where Oracle REST Data Services is installed.
  - port is the port number assigned to Oracle REST Data Services. In a default installation, this number is 8080. To learn more, see Oracle REST Data Services Installation, Configuration, and Development Guide
  - apex is the service name defined when configuring the Oracle REST Data Services.
- 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 HTTP on the Oracle XML DB HTTP Server. In a default installation, this number is 8080. See "Verifying the Port Assigned to HTTP on the Oracle XML DB HTTP 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 Descriptor
On the Sign In page:
- 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 Sign In.

The workspace home page appears.

Tip:

Depending on your setup, you might be required to change your password when you sign in for the first time.

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

The embedded PL/SQL gateway runs in the Oracle XML DB Protocol Server in the Oracle database.

To verify the port number assigned to HTTP on the Oracle XML DB HTTP 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 HTTP Server is disabled.

See Also:

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

1.2.4.3 Signing Out of a Workspace

To sign out of Oracle Application Express workspace:

Select the Account Menu in the upper right corner of the window and click Sign out.

See Also:

"Account Menu"

1.2.4.4 Recovering 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 Sign In page, click Reset Password.
Click Find My Workspace.
Enter your email address and click Find Workspace.

You will receive an email listing all workspaces associated with the email address you provided.

1.2.4.5 Resetting Your Password from the Sign In Page

To reset your password from the Sign In page, you must provide your email address and workspace name.

To reset your password from the Sign In Page:

Under Sign in, click Reset Password.
Enter your email address and workspace name, and click Reset Password.

You will receive an email containing new passwords for all accounts associated with the email address and workspace name you provided.
On the Sign In page, enter your workspace, username, and the new password and click Sign In.

Tip:
Passwords are case sensitive. Do not copy and paste the new password.
On Change Password, enter:
1. Current Password - Enter the current password provided by the email.
2. New Password - Enter your new password.
3. Confirm Password - Enter your new password again.
4. Click Apply Changes.

See Also:

"Changing Your Password"