Skip Headers
Oracle® Database 2 Day + Application Express Developer's Guide
Release 3.1.2

Part Number E10498-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

2 Accessing Your Development Environment

This section guides you through the steps to access an Oracle Application Express development environment for your use. Then, you and other developers can begin building applications within Oracle Application Express.

This section contains the following topics:

Before You Begin

Before you begin this section, do the following:

Accessing the Hosted Demo Environment

To try out Oracle Application Express without installing the product locally, go to the hosted demo environment and sign up for a workspace.

To access the hosted demo environment:

  1. In a Web browser, go to:

    http://apex.oracle.com

  2. Under the Login button, click Sign up for an account.

    The Registration Wizard appears. Note the steps included in the wizard appear in a flowchart on the left side of the page. The highlighted block indicates the step you are performing.

  3. On the Welcome page, review the information and click Next.

  4. For Identify Administrator, enter valid information and click Next.

    The system will generate an email with your login credentials and send it to the email address you enter.

  5. For Workspace, enter a name for your workspace.

    Workspace names must be unique. Requesting a duplicate name might delay your request. In general, enter a name that is significant to you. For example, enter your own name, your company name, or the name of the project or department to which your applications pertain.

    To use the same name for your workspace and your schema (defined in the next step) use alphabetic characters when naming your workspace. Schema names are restricted to alphabetic characters.

  6. For New or Existing Schema, select Request a new schema and click Next.

  7. For Database Schema, do the following:

    1. New schema to create - Enter a name containing only alphabetic characters.

    2. Initial Space Allocation - Select at least 10 MB to accommodate the space needed for creating the objects required for this guide.

    3. Click Next.

  8. For Service Description, enter the requested information and click Next.

  9. For Confirmation:

    1. Enter the displayed numeric and alphabetic characters in the Verification Code field. Be sure to use the correct capitalization because the verification code is case-sensitive.

      Description of setuphst1_vericode.gif follows
      Description of the illustration setuphst1_vericode.gif

    2. Review the information and click Submit Request.

You will receive an initial email that contains a link. Click the link to complete the workspace provisioning process. This step verifies that your email address is valid before approving a workspace. After that, you will receive an email with your login credentials. Use those credentials to log in to the hosted demo environment and begin using Oracle Application Express.

Logging In to the Hosted Demo Environment

Using the login credentials you received in an email, log in to your dedicated workspace on the hosted demo environment.

To log in to the hosted demo environment:

  1. In a Web browser, go to:

    http://apex.oracle.com

  2. On the Login page, enter your login credentials.

  3. Click Login.

    The Workspace home page appears. You might be prompted to change your password. If not, you can change it manually by clicking the Change Password link on the right side of the Workspace home page. Then, enter in the information requested on the page that appears.

    To continue with the tutorials, skip the rest of this section and go to "Getting Started with Oracle Application Express".

Setting Up Your Own Local Environment

Instead of using the hosted demo environment, you can install Oracle Application Express locally. If you do a local installation, you must set up your development environment. The general steps you need to perform include:

  1. Log in to Application Express Administration Services, as described in "Logging In to Administration Services".

  2. Create a workspace, as described in "Creating a Workspace".

  3. (Optional) Create additional users with developer or administrator privileges, as described in "Creating Additional User Accounts".

Note:

This tutorial explains a simplified method for setting up your development environment so that you can begin using Oracle Application Express. However, when you want to set up your development environment to accommodate your real-life development needs, review "Oracle Application Express Hosted Instance Adminitration" in Oracle Application Express Administration Guide.

Logging In to Administration Services

To set up your local development environment, you first need to log in to Oracle Application Express Administration Services. This is a separate application for managing an entire Oracle Application Express instance.

To log in to the Oracle Application Express Administration Services:

  1. In a Web browser, go to the Oracle Application Express Administration Services application. By default, Oracle Application Express Administration Services installs to one of the following locations:

    • 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 Oracle XML DB HTTP Server. In a default installation, this number is 8080.

      • apex is the database access descriptor (DAD) defined in the configuration file.

        For users who have upgraded from earlier versions, 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:

      "Verifying the Oracle XML DB HTTP Server Port" in Oracle Application Express Application Builder User's Guide
    • If your setup uses the Oracle HTTP Server (Apache) with 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. 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 versions, or who have a custom configuration, this value may be htmldb or something else. Verify the DAD with your Oracle Application Express administrator.

        See Also:

        "Managing Oracle Database Port Numbers" in Oracle Application Express Installation Guide and ORACLE_BASE\ORACLE_HTTPSERVER_HOME\Apache\modplsql\conf\dads.readme for more information on database access descriptors

    The Login page appears.

  2. In Username, enter the username you specified when you installed Oracle Application Express.

  3. In Password, enter the Oracle Application Express administrator account password you specified when you installed Oracle Application Express.

  4. Click Login.

    Oracle Application Express Administration Services appears.

Creating a Workspace

From Administration Services, you need to create a workspace. A workspace is a shared work area within the Oracle Application Express development environment that has a unique ID and name. All users in the workspace can access all its applications and scripts. For more information about workspaces, see "About Workspaces".

To create a workspace:

  1. Log in to Oracle Application Express Administration Services.

    The Home page appears for Administration Services.

    Description of adminsvc.gif follows
    Description of the illustration adminsvc.gif

  2. Click Manage Workspaces.

  3. Under Manage Workspaces, click Create Workspace.

    Description of setuphst1_crtwksp.gif follows
    Description of the illustration setuphst1_crtwksp.gif

    The Create Workspace Wizard appears.

  4. For Identify Workspace, enter the following information:

    1. Workspace Name - Enter a unique workspace name. This guide uses 2DayPlus for the workspace name.

      In general, you want to enter a workspace name that is significant to you. For example, you might enter your own name, your company name, or the name of the project or department to which your application pertains.

      If you want to use the same name for both your workspace and schema, enter a workspace name that contains only alphabetic characters. Schema names are restricted to alphabetic characters.

    2. Description - Enter a workspace description.

    3. Click Next.

    Description of cr_wkpc1.gif follows
    Description of the illustration cr_wkpc1.gif

  5. For Identify Schema, enter the following information:

    1. Re-use existing schema - Select No if you are creating your first workspace.

      A schema is a logical container for database objects. In this step, you are creating the container for database objects you will add later.

    2. Schema Name - Enter a schema name. This guide uses TWODAYPLUS for the schema name.

      You must use only alphabetic characters in your schema name.

    3. Schema Password - Enter a case-sensitive password.

    4. Space Quota (MB) - Select at least 10 MB to accommodate the necessary space for creating the objects required for this guide.

    5. Click Next.

    Description of cr_wkspc_schema.gif follows
    Description of the illustration cr_wkspc_schema.gif

  6. For Identify Administrator, enter the following information:

    1. Administrator Username - Accept the default, ADMIN, or enter another user name to be used in Oracle Application Express.

      You are creating an account for only one user, yourself as an administrator, at this time. To see instructions for creating additional users, see "Creating Additional User Accounts".

    2. Administrator Password - Enter a case-sensitive password.

    3. Enter the remaining information, including your valid email address, and click Next.

      The login credentials for accessing Oracle Application Express will be sent to the email address you enter here, if you have configured the email settings for your Oracle Application Express environment.

      Description of cr_wkspc_admin.gif follows
      Description of the illustration cr_wkspc_admin.gif

  7. Confirm your selections and click Create.

Logging In to Your Local Instance

To log in to your local instance of Oracle Application Express, you must have this information:

  • URL where you can access Oracle Application Express

  • Workspace name you use to develop applications

  • Username set up for you for this workspace within Oracle Application Express

  • Password set up for you for this workspace within Oracle Application Express

If you set up your development environment, you have your login credentials. Otherwise, contact the person who created your user account to supply the information.

To log in to Oracle Application Express:

  1. In a Web browser, go to the Oracle Application Express Login page. By default, Oracle Application Express installs to one of the following locations:

    • If your setup uses the embedded PL/SQL gateway:

      http://hostname:port/apex
      
    • If your setup uses the Oracle HTTP Server (Apache) with mod_plsql:

      http://hostname:port/pls/apex
      

    For an explanation of the URLs, see "Logging In to Administration Services".

    The Login page appears.

  2. Under Login, enter your login credentials.

    Description of login.gif follows
    Description of the illustration login.gif

  3. Click Login.

Creating Additional User Accounts

As an administrator, you inherit all the privileges associated with the developer role. If you want to start developing the application shown in this guide, skip this section and go to "Logging In to Your Local Instance".

However, you might want to create user accounts for other developers who will be sharing this workspace. Associating users with the workspace grants them access to all applications and scripts within that workspace. You can also create additional user accounts for workspace administrators.

To create user accounts:

  1. Log in to the Workspace where you want to add users. See "Logging In to the Hosted Demo Environment" or "Logging In to Your Local Instance".

    The Workspace home page appears.

  2. From the Administration links list on the right, click Manage Application Express Users.

  3. Under the Tasks list on the right, click either the Create Developer or Create Workspace Administrator link.

    The Create User page appears.

    Description of deploy_cr_enduser.gif follows
    Description of the illustration deploy_cr_enduser.gif

  4. Under Account Control:

    • Set Account Availability - Select Unlocked.

    • Require Change of Password On First Use - Select No if you do not want to force this user to change his or her password at first log in.

  5. Under User Identification, enter the appropriate information:

    1. User Name - Enter a user name for this end user.

    2. Password and Confirm Password - Enter a case-sensitive password for this account.

    3. Email Address - Enter the valid email address for this end user.

      This email address must be valid so that users can receive the login credentials to log in to the application.

  6. Under Developer Privileges:

    1. Accessible Schemas (null for all) - Leave this blank to allow the end user to access all applications in the workspace, or enter a colon-delimited list of schemas to restrict the end user's access.

      If a user does not have access to the schema that an application is built on, the user cannot access the application.

    2. Default Schema - Accept the default, the schema you set up for this guide.

    3. User is a developer - Accept the default.

    4. User is a workspace administrator - Accept the default.

  7. Under User Groups, you can select a user group.

    You can use groups to restrict access to parts of an application. Groups are primarily useful when using Application Express Authentication.

  8. Under Additional Attributes, you can enter additional user information.

  9. Click Create User or Create and Create Another.

See also:

"Managing Application Express Users" in Oracle Application Express Administration Guide