Create an Oracle Application Express app

Create an Oracle Application Express app in Access Gateway.

  1. Sign in to the Access Gateway Admin UI console.
  2. Click the Applications tab.
  3. Click +Add.
  4. Select Oracle Application Express. Click Create.

  5. In the Essentials pane specify the following:

    Field Value
    Label A name for the app.
    Public Domain A fully qualified host name such as <yourexteralname>.<your domain> (for example,

    app-ex.externalexample.com).

    Protected Web Resource

    The URL of the internal, protected app. For example, app-ex.internalexample.com:port, where

    • port: The port Oracle Application Express listens on for HTTP requests.

    See Configure load balancing.

    Group Enter the group containing the users who should have access to the application.

    Post Login URL

    Enter or modify the Post Login URL. By default this field is enabled and contains the value:

    app-ex.externalexample.com/apex

    Description Optional. An appropriate description for your application.
  6. Click Next. The Attributes pane appears.

Configure load balancing

Only use Access Gateway as the load balancer. See Load balancing.

  1. Expand the Protected Web Resource tab.
  2. Enable Load Balancing By Access Gateway.

    A table of hostnames and weights representing the target load balancing instances appears. This table is initially empty. Click edit to modify an entry in the table, or click delete to delete an entry.

  3. Choose either HTTP or HTTPS as the URL scheme. Each protected web resource that you add inherits this scheme.
  4. Optional. Enable and specify Host Header value.
  5. Complete the following steps to add a host, repeat as required:
    1. Click Add protected web resource.
    2. Enter a fully qualified hostname:port combination (for example, https://backendserver1.atko.com:7001).
    3. Enter a weight from 1 to 100. Enter 0 to specify that a host is disabled.

      Weights represent the percentage of requests that will be routed to this host.

      For example, two hosts of weights 2:1 would result in requests being routed ~66% to the host weighted 2 and ~33% to the host weighted 1.

    4. Click Okay.
  6. Optional. Configure health checks, which use GET operations to confirm that back-end resources are functional.

    New requests aren't routed to resources that have been labeled unhealthy by the health checks.

    1. Enable Load Balancer Health Check.
    2. Click Edit to modify health check settings.
    3. Modify settings as required.
      FieldValue

      Default

      PathThe URI path to the resource used in health check./
      MethodThe HTTP method used.Always GET
      Status codeThe HTTP status code used to determine health.200
      IntervalThe interval between health checks in seconds.10
      Request timeoutThe health check request timeout in seconds.1
      Healthy thresholdThe number of requests that must succeed before a host is considered healthy.3
      Unhealthy thresholdThe number of requests that must fail before a host is considered unhealthy.3
    4. Click Save to save changes or click Cancel to exit without saving.

Next steps

Configure certificates