Logging In to Oracle Application Express as a Developer

Requesting a Workspace

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:

1. 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.

2. Under Tasks, click Request a Workspace.

   The Request Service Wizard appears.

3. Click Next and follow the on-screen instructions.

   
   

   See Also: "Creating Workspaces"

   
   

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:

1. 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. You can find information about your Oracle HTTP Server installation's port number from the following file:

       ORACLE_BASE\ORACLE_HOME\install\portlist.ini
       
       

       However, be aware that if you change a port number, it is not updated in the portlist.ini file, so you can only rely on this file immediately after installation.

     • 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_HOME\Apache\Apache\conf\httpd.conf
       
       

     • 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_HOME\Apache\modplsql\conf\dads.readme for more information on database access descriptors

       
       

   The Login page appears.

2. 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.

3. Click Login.

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

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:

1. On the Login page, click Find My Workspace on the Tasks list.

2. 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:

1. Log in to Oracle Application Express. See "Logging In to Oracle Application Express".

2. From the Administration list, click Change Password.

   The Change Password page appears.

3. 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.

4. Click Apply Changes.

Logging Out of a Workspace

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