Install Application

This section lists the steps that are required to deploy the Oracle Health Insurance application on the Oracle WebLogic Server.

Creating The WebLogic Work Managers

By default, the WebLogic Server uses the default work manager to handle thread management and perform self-tuning. This default Work Manager is used by an application when no other Work Managers are specified in the application’s deployment descriptors. For more information on Work Managers, see WebLogic Server documentation.

For example, the following application-specific work managers can be configured for more fine-grained control and work load monitoring of the system:

  • a work manager to control the Web Services requests, named "wm/ws-work-manager"

  • and a work manager to control the task or activity processing, named "wm/core-work-manager"

If these work managers are not configured, the system issues warnings at startup like the following example and uses the WebLogic default work manager instead:
<Warning> <WorkManager> <BEA-002919> <Unable to find a WorkManager with name wm/core-work-manager. Dispatch policy wm/core-work-manager maps to the default WorkManager for the application OHI-proddef-4.x.x.x.x>

To override the behavior of the default work manager, see to WebLogic Server documentation.

Create global work managers through the Administration Console using the steps that are listed in the following table in the given order. Make sure to associate the work managers with the managed servers.

Table 1. Creating The WebLogic Work Managers
Step Configuration Value

1

Minimum Threads Constraint

Name

core-work-manager-min-threads-constraint

Count

16

2

Maximum Threads Constraint

Name

core-work-manager-max-threads-constraint

Count

16

3

Fair Share Request Class

Name

core-work-manager-fair-share-req-class

Fair Share

40

4

Work Manager

Name

wm/core-work-manager

Request Class

core-work-manager-fair-share-req-class

Minimum Threads Constraint

core-work-manager-min-threads-constraint

Maximum Threads Constraint

core-work-manager-max-threads-constraint

Capacity Constraint

None Configured

Stuck Thread Action

Ignore stuck threads

5

Minimum Threads Constraint

Name

ws-work-manager-min-threads-constraint

Count

10

6

Maximum Threads Constraint

Name

ws-work-manager-max-threads-constraint

Count

100

7

Fair Share Request Class

Name

ws-work-manager-fair-share-req-class

Fair Share

60

8

Work Manager

Name

wm/ws-work-manager

Request Class

ws-work-manager-fair-share-req-class

Minimum Threads Constraint

ws-work-manager-min-threads-constraint

Maximum Threads Constraint

ws-work-manager-max-threads-constraint

Capacity Constraint

None Configured

Stuck Thread Action

Ignore stuck threads

After configuring the work managers, managed servers have to be restarted.

The configuration, such as minimum and maximum thread constraints and the fair share request factors, can be modified at any time in the WebLogic Remote console as required, for example to increase the number of threads used for task processing.

This largely depends on the hardware capacity, system configuration and the load characteristics and typically requires a thorough understanding of the system’s performance.

Configuring The Authentication Providers

The application uses a WebLogic Authentication Provider to connect to a user store for authenticating users. Examples of configurable user identity stores are Oracle Internet Directory (OID) or to a third party LDAP server. This section describes the configuration of an OID or third party LDAP Authentication Provider.

  1. Log in to the WebLogic Remote Console and click the Edit Tree.

    1. Expand the Security drop-down.

    2. Select Realms.

    3. Select myRealm.

    4. Select Authentication Providers.

    5. Click the New to create a new Authentication Provider.

    6. On the Create a New Authentication Provider page, enter the following fields:

      • Name: OHIAuthenticationProvider

      • Type: OracleInternetDirectoryAuthenticator or LDAPAuthenticator if a third‑party LDAP server is being used.

    7. Change the Control Flag to SUFFICIENT and click Create.

    8. Click the Authenticator Parameters tab.

    9. Enter or change the values for various fields as shown below and select the Propagate Cause for Login Exception.

      Table 2. Configure the Authentication Providers
      Field Value

      Host

      LDAP hostname or IP address

      Port

      LDAP Port or SSL Port if the LDAP is SSL enabled. For example: 3060. In case LDAPS is used, make sure to check the SSLEnabled flag as well.

      Principal

      LDAP admin principal: For example: cn=orcladmin

      Credential

      LDAP admin password

      Confirm Credential

      LDAP admin password

      User Base DN

      User Base distinguished name. For example: ou=Users,dc=healthinsurance,dc=oracle,dc=com

      All Users Filter

      For example: (&(uid=*)(objectclass=person))

      User From Name Filter

      For example: (&(uid=%u)(objectclass=person))

      User Name Attribute

      For example: uid

      Group Base DN

      If there are no groups in the LDAP, leave this field empty.
      There are a few more properties (or fields in the page) which are not mentioned in the table above. Change the values of those fields to suit the LDAP settings.

    10. Click Save.

    11. Click the myrealm link and then DefaultAuthenticator link.

    12. Change the Control Flag to SUFFICIENT and click Save.

    13. Restart the WebLogic Server.

Optionally, verify that the authentication provider is configured successfully (after the WebLogic Server is restarted) by following the steps mentioned below:

  1. Expand the Security drop‑down list.

  2. Click Realms.

  3. Click myRealm.

  4. Select the Users and Groups tab.

  5. Verify that the list shows users from OHIAuthenticationProvider (in addition to the default users from DefaultAuthenticator).

Set Up JDBC Data Sources

The application connects to the Oracle database through a Data Source that needs to be specified in the WLS Server.

For security reasons, the database connections used by the application connect to database schemas that do not own database objects. These schemas are only granted the required privileges to use the objects.

The following sections describe setting up data sources for connecting to:

  • an Oracle database that is running on a single machine

  • an RAC-enabled Oracle database that is running on multiple machines

Data Source for Connecting to an Oracle Database That is Running on a Single Machine

The following table lists details for the Data Source that must be configured in WLS before installing the application for use with an Oracle database that is executed on a single machine (not clustered):

Table 3. Data Source for Connecting to an Oracle Database That is Running on a Single Machine
Data Source Parameters Non-Clustered database Explanation

Data Source Type

Generic Data Source

Data Source Name

ohi-application-datasource

Logical name

JNDI Name

jdbc/proddefUserOhiApplicationDS

Used by the application to resolve the Data Source

Database Type

Oracle

Database Driver

Oracle’s Driver (Thin) for Instance connections; Versions:Any

Oracle’s Driver (Thin) for Service connections; Versions:Any

Database Name

SID or service name of the database

If the name of the Oracle driver that was selected contains the words "for Instance connections" enter the SID.

If the name of the Oracle driver contains the words "for Service connections" enter the service name.

Host Name

Name or IP address of the machine where the database is running

Port

Port on which the database is running

Database User Name

ohi_proddef_user

Fixed value, do not change

Password & Confirm Password

Password of "ohi_proddef_user"

The schema password as selected during the installation
Table 4. Data Source for Operational Reports for Connecting to an Oracle Database that is Running on a Single Machine
Data Source Parameters Non-Clustered database Explanation

Data Source Type

Generic Data Source

Data Source Name

ohi-operational-reporting-datasource

Logical name

JNDI Name

jdbc/proddefReportingExtractUserDS

Used by the application to resolve the Data Source

Database Type

Oracle

Database Driver

Oracle’s Driver (Thin) for Instance connections; Versions:Any

Oracle’s Driver (Thin) for Service connections; Versions:Any

Database Name

SID or service name of the database

If the name of the Oracle driver that was selected contains the words "for Instance connections" enter the SID.

If the name of the Oracle driver contains the words "for Service connections" enter the service name.

Host Name

Name or IP address of the machine where the database is running

Port

Port on which the database is running

Database User Name

ohi_proddef_rpt_user

Fixed value, do not change

Password & Confirm Password

Password of "ohi_proddef_rpt_user"

The schema password as selected during the installation

Data Source for Connecting to an Oracle RAC Database that is Running on Multiple Machines

To support Oracle RAC features within the Oracle WebLogic Server, Oracle recommends using the Oracle WebLogic Server GridLink Data Source. A single GridLink data source provides connectivity between WebLogic Server and an Oracle Database service targeted to an Oracle RAC cluster. It uses the Oracle Notification Service (ONS) to adaptively respond to state changes in an Oracle RAC instance. An Oracle Database service represents a workload with common attributes that enables administrators to manage the workload as a single entity.

To configure this, the following steps need to be performed. For more information about GridLink Data Source configuration, see to the Oracle WebLogic Server documentation.

Configure the GridLink Data Source

  1. Login to the WebLogic Remote Console and click the Services/Data Sources link.

  2. Click thr New button .

  3. On the Create a New Data Source page, set the following fields:

    • Name: ohi-application-datasource

    • JNDI Name: jdbc/claimsUserOhiApplicationDS

  4. Select the required Targets from Available targets list and move them to Chosen.

  5. Select GridLink Data Source from the Data Source Type drop down.

    Make sure to specify the managed server as target for the GridLink Data.

  6. Select the option One Phase Commit from the Global Transactions Protocol drop down

  7. If the Oracle RAC database is accessed via SCAN (Single Client Access Name):

    1. Select Enter complete JDBC URL.

    2. Otherwise, select Enter individual listener information.

  8. Enter the below Connection Properties

    • enter the values of various fields as outlined in the table below if option Enter complete JDBC URL is selected:

    Table 5. Configuring The GridLink Data Source
    Parameters Value Explanation

    Complete JDBC URL

    jdbc:oracle:thin:@{scan-listener-host}:{scan-listener-port}/{service-name}

    JDBC URL using SCAN

    Database User Name

    ohi_proddef_user

    Fixed value, do not change

    Password & Confirm Password

    Password of "ohi_proddef_user"

    The schema password as selected during the installation

    • or enter the values of various fields as outlined in the table below if option Enter individual listener information is selected:

    Table 6. For Enter individual listener information Option
    Parameters Value Explanation

    Service Name

    Oracle RAC service name

    Host and Port

    hostname1:port hostname2:port

    Individual RAC node details. The format is <HOSTNAME>:<PORT>

    Database User Name

    ohi_proddef_user

    Fixed value, do not change

    Password & Confirm Password

    Password of "ohi_proddef_user"

    The schema password as selected during the installation
    For Operational Reports, you need to create another datasource and enter Database User Name as ohi_proddef_rpt_user and Password and Confirm Password as password of ohi_proddef_rpt_user, rest all the steps are same.

  9. In the Test GridLink Database Connection page, click the Test All Listeners to verify that the connection is successful.

  10. After the test succeeds, enter the ONS client configuration details as outlined in the table below then click Next.

    Table 7. ONS Client Configuration Details
    Parameters Value Explanation

    Fan Enabled

    Check-box selected

    Enables the data source to subscribe to and process the Oracle FAN events. This attribute is only applicable for the RAC configurations that publish the FAN notification events using the ONS protocol.

    ONS Nodes

    For example: hostname1:6200,hostname2:6200

    A comma-separated list of the ONS daemon listen addresses and ports to connect to for receiving the ONS-based FAN events.

    ONS Wallet File

    Location of ONS Wallet File (including the file name)

    The location of the Oracle wallet file in which the SSL certificates are stored. Only required when the ONS client is configured to communicate with the ONS daemons using SSL.

    ONS Wallet Password and Confirm the ONS Wallet Password

    The wallet password

    The wallet password attribute that is included as part of the ONS client configuration string. This attribute is only required when the ONS is configured to use the SSL protocol.

  11. Click Test All ONS Nodes to see if the connection is successful. Once the connection test succeeds, click Next.

Make sure to specify the managed server as target for the GridLink Data

Setting Advanced Properties for the Data Source

Whether for a single machine or RAC - the Data Source that has been created needs some additional advanced settings.

  1. Select the newly created Data Source

  2. Click table Connection Pool.

  3. Expand the Advanced node at the bottom of the page to display all the properties and set the following:

    Table 8. Setting Advanced Properties for the Data Source
    Property Value

    Initial Capacity

    0

    Test Connections On Reserve

    Checked

    Test Frequency

    300

    Connection Creation Retry Frequency

    30

    Seconds to Trust an Idle Pool Connection

    10

    Statement Cache Size

    The default value is 10. Increasing this to a higher value results in a better performance. Consult WebLogic documentation for more details on this.

    Wrap Data Types

    Unchecked

    Init SQL

    When the users are in a different time zone then the database, the session time zone must be set with this statement:

    SQL ALTER SESSION SET TIME_ZONE = '<time zone>', where <time zone> is the name of an Oracle RDBMS supported time zone.
    The time zone names can be found in V$TIMEZONE_NAMES.

    Set the following driver property:

    Table 9. Driver Property
    Property Value

    oracle.net.CONNECT_TIMEOUT

    10000

  4. Finally Click on Save

Install the Oracle Health Insurance Application Through the WebLogic Remote Console

Oracle Health Insurance applications are delivered in a so-called Java Enterprise Archive (EAR) and installed through the WebLogic Remote Server Console. To install them, perform the following steps.

  1. Log in to the WebLogic Remote Console.

  2. Click the Deployment link and then click the New.

  3. Enter the application Name for example, ohi-claims)

  4. . In the Targets option, select the Clusters target.

  5. In the Source option select the path where the EAR file is located.

  6. Click Create, the Oracle Health Insurance application is now installed.

  7. Select Install this deployment as an application and click Next as shown below:

Installing The Oracle Health Insurance Application Through REST API

Post :http://<HOST-NAME>:<PORT-NUMBER>/management/weblogic/latest/domainRuntime/deploymentManager/deploy
{
"name": "<OHI-APPLICATION-NAME>.",
"applicationPath": "<PATH-OF-OHI-APPLICATION-EAR>",
"targets": ["<NAME-OF-CLUSTER>"],
"plan": "<PATH-OF-PLAN.xml>",
"deploymentOptions": {}
}

Changing the Context-Root for UI or Web Services

Oracle Health Insurance applications consists of multiple modules. Each module is shipped with a default context-root. To change the default context-root of an Oracle Health Insurance application web application or an Oracle Health Insurance application web service, deploy the application with a customized deployment plan.

For more details, see Configuring Applications for Production Deployment in Oracle WebLogic Server documentation.

Changes That Require a Restart

There are some changes to the system that require a restart for the changes to take effect. Following is the list of such changes:

Table 10. Changes That Require a Restart
Change Description

Add/Remove Insurable Entity Types

If new insurable entity types are added then the system needs to create and assign dynamic tables for the type which requires a restart. If insurable entity types are removed then these tables need to be removed which also requires a restart.

Changing default currencies

If the default currency is changed then a restart is required for the application adapt to these changes.

Setting/Changing dateFormat fields in Countries page

If the dateFormat fields is/are changed the Countries page, a restart is required for the application adapt to these changes.