18.5 Managing Remote Servers

A Remote Server is separate entity that stores Web Source server information. Remote Servers can be shared among multiple Web Sources, thus enabling you to information such as the Base URL or Authentication.

• About Remote Servers
  
• Creating a Remote Server
  
• Editing or Deleting a Remote Server
  
• Viewing Remote Server Utilization
  
• Viewing Remote Server History
  

18.5.1 About Remote Servers

Oracle Application Express splits the endpoint URL of a Web Source Module into two parts. The first part is server-specific part and is stored as a separate entity called the Remote Server. You can reuse a Remote Server with multiple Web Source Modules if each one uses the same server, port, and URL Path Prefix (context root). Remote Servers are stored at the workspace-level and therefore visible in all applications.

The second part of the endpoint URL and is specific to the Web Source module. Multiple Web Source modules can share one Remote Server, thus sharing information such as the Base URL and Authentication. If you change Remote Server attributes, the change impacts all Web Source Modules using the Remote Server. Remote Servers make it easy to move a collection of Web Source Modules. For example, you can move from a test system to a production system by changing the URL within the Remote Server object.

Exporting and Importing Remove Server Information

When you export an application, referenced Remote Servers are added to the export file. When you import the application into another workspace, Application Express checks whether the target workspace already contains Remote Servers with the same static ID. If a Remote Server already exists, the application uses it. Otherwise the Remote Servers from the import file are created in the target workspace.

See Also:

"Managing Web Source Modules"

18.5.2 Creating a Remote Server

To create a Remote Server object:

1. Navigate to the Remove Server page:
   • From Workspace Utilities:

     1. On the Workspace home page, click App Builder.

     2. Click Workspace Utilities.

     3. Click Remote Server.

   • From Shared Components:

     1. On the Workspace home page, click App Builder.

     2. Select an application.

     3. On the Application home page, click Shared Components in the center of the page.

     4. Under Workspace Objects, select Remote Servers.

2. On the Remote Servers page, click Create.
3. Name - Enter a name for the remote server object. Remote Server names must be unique within the application.
4. Static ID - Enter a static ID for the Remote Server.
5. Server Type - Select one of the following:
   • Web Source
   • Authentication
6. Base URL - Enter the base URL of the remote server. 
7. Prompt on Install - Select Yes to have Oracle Application Express prompt for the Base URL after the application installs into another workspace.
8. Comments - Enter any comments or notes here. These comments never display when running the application.
9. Click Create.

18.5.3 Editing or Deleting a Remote Server

To edit a Remote Server:

1. Navigate to the Credentials page:
   • From Workspace Utilities:

     1. On the Workspace home page, click App Builder.

     2. Click Workspace Utilities.

     3. Click Remote Server.

   • From Shared Components:

     1. On the Workspace home page, click App Builder.

     2. Select an application.

     3. On the Application home page, click Shared Components in the center of the page.

     4. Under Security, select Remote Server.

2. On the Remote Server page, click the name of the Remote Server.
   The Edit Remote Server dialog appears.
3. To delete the current Remote Server, click Delete. Otherwise, edit the appropriate attributes.

   Tip:

   Remote Servers which are referenced within an application cannot be deleted.

4. To edit the attributes:
   1. Name - Enter a descriptive name.
   2. Static ID - Enter a name for the remote server object here. Remote Server names must be unique within the application.
   3. Server Type - Select either:

      • Web Source

      • Authentication

   4. Base URL - Enter the base URL of the remote server. 
   5. Prompt on Install - If Yes, Application Express prompts for the Base URL after the application has been installed into another workspace.
   6. HTTPS Host Name - The host name to be matched against the common name (CN) of the remote server's certificate for an HTTPS request. It can also be a domain name like *.example.com. If NULL, the host name in the given URL is used.
      HTTPS Host Name only displays if you are using Oracle Database 12.2 or higher.
   7. Comments - Enter any comments or notes. These comments only display within App Builder and never display when running the application.
   8. To save your changes, click Apply Changes.

18.5.4 Viewing Remote Server Utilization

To view Web Source Modules utilization:

1. Navigate to the Remove Server page:
   • From Workspace Utilities:

     1. On the Workspace home page, click App Builder.

     2. Click Workspace Utilities.

     3. Click Remote Server.

   • From Shared Components:

     1. On the Workspace home page, click App Builder.

     2. Select an application.

     3. On the Application home page, click Shared Components in the center of the page.

     4. Under Workspace Objects, select Remote Servers.

2. On the Remote Servers page, click Utilization.
   The Utilization page displays where Remote Servers page used within the current workspace.

18.5.5 Viewing Remote Server History

To view recent modifications to Remote Servers:

1. Navigate to the Remove Server page:
   • From Workspace Utilities:

     1. On the Workspace home page, click App Builder.

     2. Click Workspace Utilities.

     3. Click Remote Server.

   • From Shared Components:

     1. On the Workspace home page, click App Builder.

     2. Select an application.

     3. On the Application home page, click Shared Components in the center of the page.

     4. Under Workspace Objects, select Remote Servers.

2. On the Remote Servers page, click History.
   The History page displays recent modifications made to Remote Servers in the current workspace.