Oracle by Example brandingUnderstanding Virtual Hosts Setup

section 0Before You Begin

This 20-minute tutorial shows you how to verify that a system has been setup correctly for running as a virtual batch host with a virtual batch queueing environment.

Background

Virtual batch queues will enable EnterpriseOne to meet cloud elasticity needs for batch processing. By using a virtual host name, you can tie multiple EnterpriseOne batch processing servers to that virtual host name to facilitate simple scaling of EnterpriseOne batch processing. For example, a job submitted to QBATCH on one enterprise server could be processed by any physical node on that virtual host.

What Do You Need?

You must have completed the following tasks:

  • All servers must be on Tools Release 9.2.5 or higher and the latest Tools ESU must have been applied.
  • All servers used in a batch cloud must be on the same operating system, database type, and on the same port.
  • All servers used in a batch cloud must have the File in Database enabled.
  • All servers used in a batch cloud must share the same server map, SY or SVM, and packages.
  • Required print queues must be set up identically.
  • Security servers must have been federated to accept the same tokens.
  • Unused columns with obsolete data must be cleaned from F986110.


section 1Verifying that the UBE Output to Database Option is Enabled

  1. Navigate to the P98617 program.
  2. Click Search to populate data.

Note: The Default Output Location column must be set to either database (recommended) or filesystem+database (recommended not as a default value, but as an override value for specific reports if needed).

Work With Default Output Locations Form
Work With Default Output Locations Form


section 1Verifying Virtual Hosts Configuration

  1. Navigate to the Work With Locations and Machines Web program (P9654W).
  2. Click Search to select the data you will use to define the location.
  3. In the lower section of the powerform, select the Virtual Host tab.
  4. Verifying Virtual Host Configuration
    Verifying Virtual Host Configuration

    Note that the Virtual Host section shows that the virtual host is configured with the machine name vbqcloud and is on port 6017. It is also host type 35, which is Linux.

    The Machine Name section show that two the enterprise servers jdeent1-2 and jdeent1-3 have been added as participants of the virtual host.


section 1Verifying Database Data Sources

  1. Navigate to System Administration Tools (GH9011), Database Data Sources.
  2. Verify that the Database Data source is set as System - 920 for one of the servers. This is used by the JAS and FAT clients.
  3. Reconfirm the same in the jdeent1-2 - 920 Svr Map data source (all the servers should be sharing the same database data source tables, and therefore you should see identical data when configured correctly).
  4. Select the row with System – 920 and click OK.
  5. Database Data Sources
                    – Work With Data Sources Form
    Database Data Sources – Work With Data Sources Form
  6. Click Search and then enter SVM920 in the Object Owner field to see all the database mapping records used by the JAS and development clients.
  7. Database Data Sources
                    – Work With Data Sources Form
    Database Data Sources – Work With Data Sources Form

You have now seen that the actual and virtual hosts have valid database data source records in the client and the server database mapping tables.



section 1Verifying Logical Data Sources

  1. Navigate to GH9011, Logical Data Sources.

    In this application, you will confirm the Logical Data sources in the System – 920 data source, which is used by the JAS and development clients and you will reconfirm in the jdeent1-2 - 920 Svr Map data source (all the servers should be sharing the same server map tables, and therefore you should see identical data when configured correctly).

  2. Select the row with System – 920 and click OK.
  3. Logical Data Sources - Machine Search & Select Form
    Logical Data Sources - Machine Search & Select Form
  4. Click the Search option to view the list of available virtual hosts and their corresponding machines.
    Logical Data Sources - Work With Data Sources Form
    Logical Data Sources - Work With Data Sources Form
  5. Note that the actual servers jdeent1-2 and jdeent1-3 have their regular logical map sources. The virtual host vbqcloud also has a logical map data source.

  6. Repeat steps 2 and 3, selecting “jdeent1-2 - 920 Svr Map” in step 3\2, verifying the server map records used by the enterprise servers. (“jdeent1-3 - Svr Map” and “vbqcloud - 920 Svr Map” should show data from the same table).

You have now verified that the actual and virtual hosts have valid logical data source records in the client and the server logical data source tables.


section 1Verifying OCM Configuration for UBEs on Virtual Host

In this task, you will learn how to verify that your OCM mappings are configured correctly for clients and servers for UBE submission when using a virtual host.

  1. Fast path to navigate to OCM, then select System - 920 to examine the client OCM.
  2. Machine Search and Select Form
    Machine Search and Select Form
  3. Now set selection in the header of the form before searching for the UBE using the following values:

    Environment: JPD920

    Object Name: DEFAULT

    Object Type: UBE

  4. Click Search.
  5. Work With Object Mappings Form
    Work With Object Mappings Form"

    Note that the AV (active) mapping in the Object Status column is of the virtual host VBQCLOUD.

  6. Use the Fast Path to navigate to OCM, then select jdeent1-2 - 920 to examine the enterprise server OCM.
  7. Machine Search and Select Form
    Machine Search and Select Form
  8. Use the header filters to filter records with the following values:

    Environment: JPD920

    Object Name: DEFAULT

    Object Type: UBE

  9. Click Search.
  10. Work With Object Mappings Form
    Work With Object Mappings Form

    Note that the AV (active) mapping in the Object Status column is of the virtual host VBQCLOUD.

    You have now confirmed that the default UBE mapping for the client and the server will be the virtual host for the JPD920 environment.


section 1Verifying Default Queue Configuration

In this exercise, you will learn how to verify that a default queue is configured for a virtual host.

  1. Navigate to GH9013, Batch Processing Setup, Job Queues.
  2. On the Job Queues – Work With Job Queues form, select Virtual Host Queues from the Form exit to see the queues configured for the virtual host.
  3. The top half of the powerform shows virtual host default queues.

  4. 3. If no records are displayed, click Search.
  5. Work With Job Queues Form
    Work With Virtual Host Job Queues Form

    You can see in the powerform that QBATCH is the default queue for the virtual host vbqcloud. You can also see, in the lower section of the powerform, the queues of all the hosts that are part of the virtual batch host, and if those queues are active or not.

    Work With Job Queues Form
    Work Actual Hosts job Queues

The search will not yield any result if default queues are not defined for any virtual host .

You have now confirmed that a default queue is available for the virtual batch host.


section 1Verifying Configuration of Virtual Host Enterprise Servers

In this exercise, you will learn how to submit a report to a non-default job queue by overriding the job queue when a report is submitted. This practice will be used throughout the rest of this workshop for all jobs submitted.

  1. Navigate to the Work With Virtual Host program (P9655).
  2. Work With Virtual Hosts Form
    Work With Virtual Hosts Form

    This application shows that both jdeent1-2 and jdeent1-3 are up and actively scheduling jobs.

    When one of these servers has its EnterpriseOne services stopped in Server Manager Console, the Queue Kernel Status column for the server will be set to Inactive, while the Allow Batch Processing field will remain enabled, that is, the field will display a green circle. When services are restarted, the queue kernel will resume scheduling jobs.

    At any time, if you click on the Allow Batch Processing button again, this first column will be set to green. If the server is up, the queue kernel will immediately start scheduling any available jobs on the virtual batch host that are available.

    You have now confirmed that the enterprise servers are functional and available for scheduling jobs.


section 1Additional Configuration Notes: Server Manager

In this exercise, you will configure hosts that participate in a virtual batch cloud to make their needed kernel types operational when the server is brought up, to be ready to process jobs. You must configure the hosts to automatically start the kernels, especially the Queue and XMLPublisher kernels, so that they can poll for work and process jobs without receiving messages. The kernels can only perform these tasks if they are autostarted.

  1. Using your access to Server Manager, ensure to:
    • Autostart one queue kernel per VBQ host
    • Autostart at least one UBE kernel per VBQ host
    • Autostart at least one XMLPublisher kernel per VBQ host
  2. In the Server Manager, after clicking on the enterprise server, set the Configuration tab to Basic.
  3. For each server in the Virtual Batch host, confirm that one queue kernel is set to be autostarted.
  4. Queue Kernel
    Queue Kernel
  5. For each server in the Virtual Batch host, confirm that one UBE kernel is set to be autostarted.
  6. UBE Kernel
    UBE Kernel
  7. If you use embedded BI Publisher, for each server in the Virtual Batch host, confirm that at least one XML Publisher kernel is to be autostarted.
  8. XML Kernel
    XML Kernel