1 Installing Oracle Application Express Listener

This section describes how to install Oracle Application Express Listener.

Topics:

About Oracle Application Express Listener

Oracle Application Express Listener is a J2EE-based alternative for Oracle HTTP Server (OHS) and mod_plsql. The J2EE implementation offers increased functionality including a Web-based configuration, enhanced security, and file caching. Oracle Application Express Listener also provides increased flexibility by supporting deployments using Oracle WebLogic Server (WLS), Oracle Glassfish Server, and Oracle Containers for J2EE (OC4J) as well as a standalone mode.

The Oracle Application Express architecture requires some form of Web server to proxy requests between a Web browser and the Oracle Application Express engine. Oracle Application Express Listener satisfies this need but its use goes beyond that of Oracle Application Express configurations. Using Oracle Application Express Listener simplifies the deployment process because there is no Oracle home required as connectivity is provided using an embedded JDBC driver.

Supported Java Enterprise Edition Application Servers

Oracle Application Express Listener supports the following Java Enterprise Edition application servers:

Application Server Supported Release
Oracle WebLogic Server 11g Release 1 (10.3.3) or higher
Oracle GlassFish Server Release 3 or higher
Oracle Containers for J2EE Release 10.1.3.4 or higher

About System Requirements

Oracle Application Express Listener system and space requirements are as follows:

  • Oracle Database (Enterprise Edition, Standard Edition or Standard Edition One) release 10.2.0.3 or higher, or Oracle Database 10g Release 2 Express Edition or higher.

  • Java 6 Update 20 JDK or higher.

  • Java Servlet Specification 2.3 or higher.

  • Web browser requirements:

    • Microsoft Internet Explorer 8.0 or higher.

    • Mozilla Firefox 3.0 or higher.

    • Google Chrome 2.0 or higher.

Oracle Application Express Listener Installation Overview

To install Oracle Application Express Listener:

  1. Download and unzip Oracle Application Express Listener. See "Downloading Oracle Application Express Listener".

  2. Install Oracle Application Express Listener. Options include:

  3. Configure Oracle Application Express Listener. See "Configuring Oracle Application Express Listener".

Downloading Oracle Application Express Listener

To install Oracle Application Express Listener:

  1. Download the file apex_listener.version.number.zip from the Oracle Application Express Listener download page. See:

    http://www.oracle.com/technetwork/developer-tools/apex-listener/downloads/index.html
    

    Note that the version.number in the filename reflects the current release number.

  2. Unzip the downloaded zip file into a directory (folder) of your choice:

    • UNIX and Linux: Unzip apex_listener.version.number.zip

    • Windows: Double click the file apex_listener.version.number.zip in Windows Explorer

Installing in Standalone Mode

Although Oracle Application Express Listener supports the Java Enterprise Edition application servers described in "Supported Java Enterprise Edition Application Servers", you also have the option of running in standalone mode. Standalone mode enables you to quickly deploy Oracle Application Express Listener, at the cost of control and manageability gained when using a JEE application server

Topics:

Install and Run in Standalone Mode

To launch Oracle Application Express Listener in standalone mode:

  1. Download and unzip Oracle Application Express Listener. See "Downloading Oracle Application Express Listener".

  2. Execute the following command:

    java –jar <temp directory>\apex.war
    

    Where <temp directory> is the directory location of the unzipped Oracle Application Express Listener.

  3. When prompted, specify the location of the folder containing the static resources used by Oracle Application Express.

  4. When prompted, choose a user name and password for the Oracle Application Express Listener Administrator and Manager roles.

    Tip:

    You will only be prompted for the usernames and passwords the first time you launch Oracle Application Express Listener.

    You default Web browser starts and navigates to:

    http://<host>:<port>/apex/listenerConfigure
    

    Where:

    • <host> is the DNS name or IP address of the Administration Server

    • <port> is the listen port on which the Administration Server is listening for requests (port 8080 by default)

  5. Configure Oracle Application Express Listener. See "Configuring Oracle Application Express Listener".

About Standalone Configuration Options

Oracle Application Express Listener provides several configuration options when running in standalone mode. For example, you can configure the location of the Oracle Application Express images directory, the home directory where Oracle Application Express Listener stores run-time files, and the HTTP listen port. Additionally, you can also remove run-time files from the Oracle Application Express home directory.

To display a full list of available commands, execute the following command:

java –jar <temp directory>\apex.war --help

Where <temp directory> is the directory location of the unzipped Oracle Application Express Listener.

The following output displays:

java [options] -jar apex.war [--help]
 Options: 
 -Dapex.home=/path/to/apex      : Path to the folder used to store the
                                  web container runtime, defaults to:
                                  ${java.io.tmpdir}/apex 

 -Dapex.port=nnnn               : HTTP listen port, default 8080

 -Dapex.ajp=nnnn                : AJP (mod_jk) listen port, default none
                                  If an AJP Port is specified then 
                                  HTTP access is disabled

 -Dapex.images=/images/location : Path to the folder containing static
                                  resources required by APEX

 -Dapex.erase=true              : Erase the contents of ${apex.home} 
                                  before launching

 --help                         : Print this usage message

Consider the following example:

java -Dapex.home=/tmp/apex -Dapex.images=/usr/local/apex/images 
-Dapex.port=8585 -Dapex.erase -jar <temp directory>/apex.war

Specifying the options above produces the following results:

  1. Erase the contents of /tmp/apex.

  2. Extract the run-time files to /tmp/apex.

  3. Configure the run-time to listen on HTTP port 8585.

  4. Use the contents of /usr/local/apex/images for serving the static content required by Oracle Application Express.

About Stopping the Server in Standalone Mode

To stop the Oracle Application Express Listener server in standalone mode, at a command prompt press CTRL+C.

About JServ Protocol (AJP) Support

Standalone mode supports the Apache JServ Protocol (AJP), enabling it to be integrated with Web servers that support AJP (for example, Apache 2.2 and mod_jk). To enable the AJP, use the -Dapex.ajp command line parameter to indicate the port to listen on (usually 8009).

Tip:

Enabling AJP implicitly disables HTTP. It is not possible to listen for both protocols simultaneously.

Installing with Oracle WebLogic Server

You can install Oracle Application Express Listener with Oracle WebLogic Server. Oracle WebLogic Server is available for download from Oracle Technology Network. See:

http://www.oracle.com/technetwork/middleware/weblogic/downloads/weblogic-developer-vm-303434.html

To learn more about installing Oracle WebLogic Server, see Oracle Fusion Middleware Getting Started With Installation for Oracle WebLogic Server and Oracle Fusion Middleware Installation Guide for Oracle WebLogic Server.

Tip:

This section assumes that you have completed the installation process and are familiar with Oracle WebLogic Server. If you are unfamiliar with domains, managed servers, deployment, security, users and roles, refer to your Oracle WebLogic Server documentation.

Topics:

Download and Unzip Oracle Application Express Listener

For more information, see "Downloading Oracle Application Express Listener".

Create Web Archive for Oracle Application Express Images

Before you begin, you must create a Web archive (WAR) file to contain the Oracle Application Express image files. Using the Java Archive (jar) command, enter the following command to create a Web archive file named i.war:

jar –cvf0 <temp directory>\i.war –C <apex directory>\images .

Where:

  • <temp directory> is the directory location of the unzipped Oracle Application Express Listener file.

  • <apex directory> is the directory location of Oracle Application Express.

Tip:

The space and period (.) at the end of the command is required.

Launch the Administration Server Console

To launch the Administration Server console:

  1. Start an Administration Server.

  2. Launch the WebLogic Administration Console by typing the following URL in your Web browser:

    http://<host>:<port>/console
    

    Where:

    • <host> is the DNS name or IP address of the Administration Server

    • <port> is the listen port on which the Administration Server is listening for requests (port 7001 by default)

  3. Enter your WebLogic Administrator username and password.

  4. If your domain is in Production mode, click the Lock & Edit button on the left-pane below the submenu Change Center. If your domain is in Development mode this button will not appear.

Install the Deployment

Tip:

The Oracle Application Express Listener files, apex.war and i.war, must be available before you start this task. See "Downloading Oracle Application Express Listener" and "Create Web Archive for Oracle Application Express Images"

To install the deployment:

  1. Go to the WebLogic Server Home Page. Below Domain Configuration, select Deployments.

    The Summary of Deployments displays.

    Description of wlogic_deploy.gif follows
    Description of the illustration wlogic_deploy.gif

  2. Click Install.

  3. Specify the location of the apex.war file and click Next.

    The apex.war file is located in the folder where you unzipped the Oracle Application Express Listener ZIP file. See "Downloading Oracle Application Express Listener".

    Install Application Assistant appears.

    Description of wlogic_install_app.gif follows
    Description of the illustration wlogic_install_app.gif

  4. Select Install this deployment as an application and click Next.

  5. Select the servers and/or clusters to which you want to deploy the application or module and click Next.

    Tip:

    If you have not created additional Managed Servers or clusters, you will not see this assistant page.
  6. In the Optional Settings, specify the following:

    1. Name - Enter:

      apex
      
    2. Security - Select the following:

      Custom Roles: Use roles that are defined in the Administration Console; use policies that are defined in the deployment descriptor

    3. Source accessibility - Select:

      Use the defaults defined by the deployment's targets

  7. Click Next.

    Description of wlogic_install_sum.gif follows
    Description of the illustration wlogic_install_sum.gif

    A summary page appears.

  8. Under Additional configuration, select one of the following:

    • Yes, take me to the deployment's configuration - Displays the Configuration page.

    • No I will review the configuration later - Returns you to the Summary of Deployments page.

  9. Review the summary of configuration settings that you have specified.

  10. Click Finish.

  11. Repeat the previous steps and deploy the i.war file.

    In the optional settings, specify the following:

    1. Name - Enter:

      i
      
    2. Security - Select:

      DD Only: Use only roles and policies that are defined in the deployment descriptors

    3. Source Accessibility - Select:

      Use the defaults defined by the deployment's targets

  12. If your domain is in Production Mode, then on the Change Center click Activate Changes.

Verifying the State and Health of apex and i

In the Summary of Deployments, select the Control tab and verify that both the apex and i State are Active and the Health status is OK.

Description of wlogic_deploy_state.gif follows
Description of the illustration wlogic_deploy_state.gif

If apex or i are not Active, then enable them. In the Deployments table, select the check box adjacent to apex and/or i. Click Start and select Servicing all requests to make them active.

Create Users and Roles

Oracle Application Express Listener requires users be assigned roles to access Oracle Application Express Listener Administration. This section describes how to create users and roles. For more information on security realms, users, and roles, see your Oracle WebLogic Server documentation.

Topics:

View Security Realms

A security realm consists of a set of configured security providers, users, groups, security roles, and security policies. You must define each user in a security realm in order to access any WebLogic resources belonging to that realm. For more information on security realms, see your Oracle WebLogic Server documentation.

To view a summary of security realms:

  1. If your domain is in Production mode, click Lock & Edit on the left pane below Change Center. If your domain is in Development mode, this button does not display.

  2. On the left pane below Domain Structure, click Security Realms.

    Description of wlogic_sec_realm.gif follows
    Description of the illustration wlogic_sec_realm.gif

    The Summary of Security Realms displays.

Create Users

Next, create two users. Create an administrator user to access the Oracle Application Express Listener Administration page and a manager user to access the Oracle Application Express Listener Status page.

To create users:

  1. In the left pane of the Administration Console, select Security Realms. See "View Security Realms".

  2. Select a security realm by clicking the security realm name (for example, myrealm).

    The Settings page displays.

  3. Click the Users and Groups tab and then click the Users tab.

    The User table displays the names of all defined users.

  4. Click New.

  5. In Name, enter the name of the user. For example:

    adminlistener
    

    User names are case sensitive and must be unique. Do not use commas, tabs or any other characters in the following comma-delimited list:

    <>, #, |, &, ?, ( ), { }
    
  6. In Description, enter a description (optional). For example:

    APEX Listener administrator user
    
  7. From the Provider list, select the Authentication provider for the user.

    Next, define a password for the user. Note that the minimum password length for a user defined in the WebLogic Authentication provider is 8 characters.

  8. In Password, enter a password.

  9. In Confirm Password, reenter the password.

  10. Click OK.

    The user appears in the User table.

  11. Create another user to access the Oracle Application Express Listener Status page. Specify the following:

    • Name - managerlistener

    • Description - APEX Listener manager user

Create Roles

Oracle Application Express Listener requires you assign users roles to access the Application Express Listener Administration. There are two types of roles:

  • Admin - The user has permission to access the Oracle Application Express Listener Administration page.

  • Manager - The user has permission to access the Oracle Application Express Listener Status Information Page.

To create roles:

  1. In the left pane of the Administration Console, select Security Realms. See "View Security Realms".

  2. On the Summary of Security Realms page, select the name of the realm you want to secure the resource (for example, myrealm).

    The Settings page displays.

  3. Select the Roles and Policies tab and then select the Realm Roles.

    The Roles page organizes all of the domain's resources and corresponding roles in a hierarchical tree control.

  4. On the Roles page, expand apex and click Roles.

    1. In the Roles table, expand the Deployment node in the Names column until you find the resource apex.

    2. Expand apex and click Roles.

    Description of wlogic_roles.gif follows
    Description of the illustration wlogic_roles.gif

  5. On the Stand-Alone Web Application Scoped Roles table, click New.

  6. On Create Stand-Alone Web Applications Scoped Roles, specify the following:

    1. Name - Enter Admin

    2. Select the Provider Name for the role mapper (for example, XACMLRoleMapper).

    3. Click OK.

    The Stand-Alone Web Application Scoped Roles table with the Admin role displays.

  7. Click the Admin role.

    The Edit Stand-Alone Web Application Scoped Roles page displays.

  8. Create a role condition, which specifies who is in the scoped role and under which set of conditions:

    1. Under Role Condition, click Add Conditions.

    2. In Predicate List, select User and click Next.

    3. In User Argument Name, add adminlistener. Then, click Add and then Finish.

      The user adminlistener appears.

    4. Click Save.

      A status message appears.

  9. Repeat the steps above starting at step 5 and create another role with the following information:

    1. Name field - Enter Manager

    2. In the Role Conditions Predicate List for Manager, select User and add managerlistener.

    3. Once you have completed creating the Manager role, click Save.

    Description of wlogic_scrope_roles.gif follows
    Description of the illustration wlogic_scrope_roles.gif

  10. If your domain is in Production Mode, in the left pane below the Change Center, click Release Configuration.

Access Oracle Application Express Listener Administration

To access Oracle Application Express Listener Administration, in your Web browser go to:

http://<host>:<port>/apex/listenerConfigure

Next, configure Oracle Application Express Listener. See "Configuring Oracle Application Express Listener".

Installing with Oracle GlassFish Server

You can install Oracle Application Express Listener with Oracle GlassFish Server. Oracle GlassFish Server is available for download from the Oracle Technology Network. See:

http://www.oracle.com/technetwork/java/javaee/downloads/index-jsp-140710.html

To learn more about installing Oracle GlassFish Server, see GlassFish Server Quick Start Guide and Oracle GlassFish Server Installation Guide.

Tip:

This section assumes that you have completed the installation process and are familiar with GlassFish Server. If you are unfamiliar with domains, servers, applications, security, or users, see your Oracle GlassFish Server documentation.

Topics:

Download and Unzip Oracle Application Express Listener

For more information, see "Downloading Oracle Application Express Listener".

Copy Oracle Application Express Images

Before you begin, you must copy Oracle Application Express images.

To copy Oracle Application Express images:

  1. Create folder named i in:

    <glassfish directory>/domains/<domainName>/docroot
    
  2. Copy all files and folders in the Oracle Application Express images directory:

    <apex directory>/images
    

    Tip:

    Do not include the images folder. Copy only the files and folders below the Oracle Application Express images folder.

    Paste the copied files and folder to:

    <glassfish directory>/domains/<domainName>/docroot/i
    

    If the images are not in this location, the Oracle Application Express login page will appear to be missing images and style sheets.

Launch the Administration Console

At least one GlassFish server domain must be started before you start the Administration Console.

To launch the Administration Console:

  1. Launch the Administration Console by typing the following URL in your Web browser:

    http://localhost:4848
    
  2. If prompted, log in to the Administration Console.

    Tip:

    You will be prompted to log in if you chose to require an administration password at the time GlassFish server was installed.

Create Users and Roles

Oracle Application Express Listener requires users be assigned roles to access Oracle Application Express Listener Administration. This section describes how to create users and roles. For more information on security realms, users, group list, or roles, see your Oracle GlassFish Server documentation.

Topics:

About Roles

Oracle Application Express Listener requires you assign users roles to access the Application Express Listener Administration. There are two types of roles:

  • Admin - The user has permission to access the Oracle Application Express Listener Administration page.

  • Manager - The user has permission to access the Oracle Application Express Listener Status Information Page.

You can enable a default principal-to-role mapping on the Application Server using the Admin Console if the group list names is defined the same as the role names

To enable a default principal-to-role mapping:

  1. On the navigation tree, select Configuration and then Security.

    The Security page displays.

  2. Select the check box next to Default Principal to Role Mapping.

  3. Click Save.

Tip:

Enabling the Default Principal to Role requires the Group List to be the same as the role name as described in the sect section.

Create Users

You must create users to access the Oracle Application Express Administration page and Status page.

To create users:

  1. In the navigation tree, expand the Configuration node.

  2. Expand the Security node.

  3. Expand the Realms node.

  4. Select the realm to which to add your user (for example, file).

    The Edit Realm page appears.

  5. On the Edit Realm page, click the Manage Users button.

    The File Users page appears.

  6. On the File Users page, click New.

    The New File Realm User page appears.

  7. On the New File Realm User page, create an Admin user:

    1. User ID - Enter the name of the Oracle Application Express Listener administrator:

      adminlistener

    2. Group List - Enter the role to which the user belong:

      Admin

    3. New Password - Enter a unique password.

    4. Confirm New Password - Enter the password again.

    5. Click OK.

  8. Repeat the previous steps and create another user for the Oracle Application Express Listener manager, by specifying the following:

    1. User ID: managerlistener

    2. Group List: Manager

    3. Click OK.

Install the Deployment

Tip:

The Oracle Application Express Listener files, apex.war must be available before you start this task. See "Downloading Oracle Application Express Listener".

To install the deployment:

  1. On the navigation tree, click the Application node.

    The Applications page displays.

  2. Click the Deploy button.

    The Deploy Applications or Modules page displays.

    Description of glassfish_sel_package.gif follows
    Description of the illustration glassfish_sel_package.gif

  3. Select Packaged File to be Uploaded to the Server and click Browse.

  4. Navigate to the location of the apex.war file, select the file, and click Open.

    The Deploy Applications or Modules page displays.

  5. On the Deploy Applications or Modules page, specify the following:

    1. Type: Web Application

    2. Context Root: apex

    3. Application Name: apex

    4. Status: Enabled

    5. Description: Application Express Listener

    6. Accept all other default settings and click OK.

    Description of glassfish_deploy.gif follows
    Description of the illustration glassfish_deploy.gif

    The Applications page appears. A check mark should appear in the Enabled field for apex

    Description of glassfish_app_pg.gif follows
    Description of the illustration glassfish_app_pg.gif

Tip:

If a check mark does not appear in the Enabled column for apex, then select the check box next to apex and click Enable.

Access Oracle Application Express Listener Administration

To access Oracle Application Express Listener Administration, in your Web browser go to:

http://<host>:<port>/apex/listenerConfigure

Where:

  • <host> is the DNS name or IP address of the Administration Server

  • <port> is the listen port on which the Administration Server is listening for requests

Next, configure Oracle Application Express Listener. See "Configuring Oracle Application Express Listener".

Installing with Oracle Containers for J2EE (OC4J)

You can install Oracle Application Express Listener with Oracle Containers for J2EE (OC4J). Oracle Containers for J2EE (OC4J) is available for download from the Oracle Technology Network. See:

http://www.oracle.com/technetwork/middleware/ias/downloads/utilsoft-090603.html

To learn more about installing Oracle Containers for J2EE (OC4J), see Oracle Containers for J2EE Installation Guide.

Tip:

This section assumes that OC4J is already installed and you are familiar with OC4J. If you are unfamiliar with servers, deployment, security, users, and roles, refer to your Oracle Containers for J2EE documentation.

Topics:

Download and Unzip Oracle Application Express Listener

For more information, see "Downloading Oracle Application Express Listener".

Copy Oracle Application Express Images

Before you begin, you must copy Oracle Application Express images.

To copy Oracle Application Express images:

  1. Create a folder named i in:

    <oc4j install directory>/j2ee/home/default-web-app
    
  2. Copy all files and folders in the Oracle Application Express images directory:

    <apex directory>/images
    

    Tip:

    Do not include the images folder. Copy only the files and folders below the Oracle Application Express images folder.

    Paste the copied files and folder to:

    <oc4j install directory>/j2ee/home/default-web-app/i
    

    If the images are not in this location, the Oracle Application Express login page will appear and be missing images and style sheets.

Start the OC4J Server

The default port for the OC4J Server is 8888. If you must change the port number, edit the following file:

<oc4j install directory>/j2ee/home/config/default-web-site.xml

You must start the OC4J Server before you start the Application Server Control Console. Consider the following example:

cd <oc4j install directory>/j2ee/home
java -jar oc4j.jar

To learn more, see your Oracle for Containers J2EE documentation.

Tip:

If this is your first-time initializing the server, you will be prompted to enter a password for the OC4J administrator account. The username for this account defaults to oc4jadmin.

Start the Application Server Control Console

To start the Application Server Control Console:

  1. Typing the following URL in your Web browser:

    http://localhost:8888/em
    
  2. When prompted, log in with the oc4jadmin account.

Create Users and Roles

Oracle Application Express Listener requires users be assigned roles in order to access Oracle Application Express Listener Administration. This section describes how to create users and roles. For more information on security realms, users, and roles refer to your Oracle for Containers J2EE documentation.

Topics:

Create Roles

Oracle Application Express Listener requires you assign users roles to access the Application Express Listener Administration. There are two types of roles:

  • Admin - The user has permission to access the Oracle Application Express Listener Administration page.

  • Manager - The user has permission to access the Oracle Application Express Listener Status Information Page.

To create roles:

  1. On the OC4J Home page, click the Administration tab.

  2. Expand the Security node.

  3. Locate Security Providers and click the Go To Task icon.

  4. Click Instance Level Security.

    The Instance Security Level page displays.

  5. Click the Realms tab.

  6. Use an existing realm or create a realm.

  7. Click the selected realm's Roles number.

    The Roles page displays.

  8. Create the role, Admin:

    1. Click the Create button.

    2. On the Name field enter Admin.

    3. Click OK.

  9. Create the role, Manager:

    1. Click the Create button.

    2. In Name, enter Manager

    3. Click OK.

Create Users

You must create users to access the Oracle Application Express Administration page and Status page.

To create users:

  1. In the Instance Security Level page, click the selected realm's Users number.

    The Users page displays.

  2. Create a user for the Oracle Application Express Listener admin:

    1. Click the Create button.

    2. In Name, enter adminlistener and a password.

    3. For Selected Roles, select Admin.

    4. Click OK.

  3. Create another user for the Oracle Application Express Listener manager:

    1. Click the Create button.

    2. In Name, enter managerlistener and specify a password.

    3. For Selected Roles, select Manager.

    4. Click OK.

  4. On the top page, click the OC4J:home link.

Install the Deployment

Tip:

The Oracle Application Express Listener files, apex.war must be available before you start this task. See "Downloading Oracle Application Express Listener".

To install the deployment:

  1. On the OC4J Home page, click the Applications tab.

    The Applications page displays.

  2. Click the Deploy button.

    The Deploy: Select Archive page displays.

  3. On the Deploy: Select Archive page:

    1. Select Archive is present on local host. Upload the archive to the server where Application Server Control is running.

    2. Specify the location of the apex.war. file.

    3. Click Next.

    The Deploy: Application Attributes page displays.

  4. In the Application Name field, enter apex and click Next.

    The Deploy: Deployment Settings displays.

  5. In the Deployment Tasks, click Configure Class Loading's Go To Task.

    The Deployment Settings: Configure Class Loading page displays.

  6. On the Deployment Settings: Configure Class Loading page:

    1. In the Import Shared Libraries, deselect the Inherit parent application's shared library imports check box.

      Oracle Application Express Listener contains its own libraries in the apex.war file and does not use the OC4J Shared Libraries. Also, verify that the Import column check boxes for all the Shared Library deselected.

    2. Click OK.

  7. Click the Deploy button.

    A confirmation message with the following message displays:

    The Application “apex” has been successfully deployed.
    
  8. Return to the Application page by clicking the Return button.

  9. Verify that apex is listed on the Applications page and the Status displays a green up-arrow indicating that it is Active.

Access Oracle Application Express Listener Administration

To access Oracle Application Express Listener Administration, in your Web browser go to:

http://<host>:<port>/apex/listenerConfigure

Next, configure Oracle Application Express Listener. See "Configuring Oracle Application Express Listener".

Upgrading Oracle Application Express Listener

Upgrading Oracle Application Express Listener requires that you redeploy the application.

Tip:

Before you begin the upgrade process, you must download and unzip Oracle Application Express Listener. See "Downloading Oracle Application Express Listener".

Topics:

Redeploy Oracle WebLogic Server

This section describes how to upgrade Oracle Application Express Listener when Oracle WebLogic Server.

To redeploy Oracle WebLogic Server:

  1. Download and unzip Oracle Application Express Listener. See "Downloading Oracle Application Express Listener".

  2. Start an Administration Server domain.

  3. Launch the Administration Server console:

    1. Start an Administration Server.

    2. Launch the WebLogic Administration Console by typing the following URL in your Web browser:

      http://<host>:<port>/console
      

      Where:

      • <host> is the DNS name or IP address of the Administration Server

      • <port> is the listen port on which the Administration Server is listening for requests (port 7001 by default)

    3. Enter the WebLogic Administrator username and password.

    4. If your domain is in Production mode, click the Lock & Edit button on the left-pane below the submenu Change Center. If your domain is in Development mode this button will not appear.

  4. Go to the WebLogic Server Home Page. Below the Domain Configuration, select Deployments.

    The Summary of Deployments displays.

  5. Click the check box next to apex to enable the Update button.

  6. Click the Update button.

    The Update Application Assistant displays.

  7. Specify the location of your apex.war file.

  8. Click Next.

  9. Review your choices and click the Finish button.

    The Summary of Deployments. Messages appear indicating the status of apex deployment.

  10. Follow any additional instructions provided in the Messages.

  11. If your domain is in Production Mode, on the Change Center click Activate Changes.

Redeploy Oracle GlassFish Server

To redeploy Oracle GlassFish Server:

Tip:

At least one GlassFish server domain must be started before you start the Administration Console.
  1. Unzip Oracle Application Express Listener. See "Downloading Oracle Application Express Listener".

  2. Launch the Administration Console:

    1. Launch the Administration Console by typing the following URL in your Web browser:

      http://localhost:4848
      
    2. If prompted, log in to the Administration Console.

      Tip:

      You will be prompted to log in if you chose to require an administration password at the time GlassFish server was installed.
  3. On the navigation tree, click the Application node.

    The Applications page displays.

  4. Select the check box next to apex.

  5. Click the Disable button.

    An X appears in the Enabled field next to apex.

  6. Click the Redeploy link for apex.

    The Redeploy Applications or Modules page displays.

  7. Specify the location of your apex.war file.

  8. Click OK.

    The Application page appears.

  9. Verify that a check mark displays on the Enabled field next to apex.

Redeploy Oracle Containers for J2EE (OC4J)

To redeploy Oracle Containers for J2EE (OC4J):

  1. Unzip Oracle Application Express Listener. See "Downloading Oracle Application Express Listener".

  2. Start the OC4J Server. See "Start the OC4J Server".

    Tip:

    You must start the OC4J Server before you start the Application Server Control Console.
  3. To start the Application Server Control Console:

    1. Typing the following URL in your Web browser:

      http://localhost:8888/em
      
    2. When prompted, log in with the oc4jadmin account.

  4. On the navigation tree, click the Application node.

    The Applications page displays.

  5. Click the check box next to apex and then select the Redeploy button.

    The Redeploy: Select Archive and deployment plan page displays.

  6. Specify the location of your apex.war file.

  7. Click Next.

    The Redeploy: Application Attributes page displays.

  8. Review the information.

  9. Click Next.

    The Redeploy: Deployment Settings displays.

  10. Click the Redeploy button.

    The Applications tab appears.

  11. Verify that the apex Status displays a green up-arrow indicating that the Status is Up (Active).

Upgrading Oracle Application Express Images

If you are upgrading Oracle Application Express, you must copy the Oracle Application Express images from the upgraded version. Having Oracle Application Express images on your application server from a previous release, will result in errors.

Topics:

Copy Application Express Images When Using Oracle WebLogic Server

To copy Application Express images when using Oracle WebLogic Server:

  1. Create a Web archive for the images directory. See "Create Web Archive for Oracle Application Express Images".

  2. Start an Administration Server domain.

  3. Launch the Administration Server console:

    1. Start an Administration Server.

    2. Launch the WebLogic Administration Console by typing the following URL in your Web browser:

      http://<host>:<port>/console
      

      Where:

      • <host> is the DNS name or IP address of the Administration Server

      • <port> is the listen port on which the Administration Server is listening for requests (port 7001 by default)

    3. Enter the WebLogic Administrator username and password.

    4. If your domain is in Production mode, click the Lock & Edit button on the left-pane below the submenu Change Center. If your domain is in Development mode this button will not appear.

  4. Go to the WebLogic Server Home Page. Below the Domain Configuration, select Deployments.

    The Summary of Deployments displays.

  5. Click the check box next to i to enable the Update button.

  6. Click the Update button.

    The Update Application Assistant displays.

  7. Specify the location of your i.war file.

  8. Click Next.

  9. Review your choices and click the Finish button.

    The Summary of Deployments. Messages appear indicating the status of apex deployment.

  10. Follow any additional instructions provided in the Messages.

  11. If your domain is in Production Mode, on the Change Center click Activate Changes.

Copy Application Express Images When Using Oracle GlassFish Server

To copy Application Express images when using GlassFish Enterprise Server:

  1. Delete all files and folders in folder i in:

    <glassfish directory>/domains/<domainName>/docroot/i
    
  2. Follow the instructions in "Copy Oracle Application Express Images".

Copy Application Express Images When Using Oracle Containers for J2EE (OC4J)

To copy Application Express images when using J2EE (OC4J):

  1. Delete all files and folders in folder i in:

    <oc4j install directory>/j2ee/home/default-web-app/i
    
  2. Follow the instructions in "Copy Oracle Application Express Images".