Skip Headers
Oracle® Health Sciences Network Installation Guide
Release 2.0.0.0

E65879-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

2 Installing the Platform

This chapter provides the instructions to install the Platform services of the Health Sciences Network (HSN).

This chapter contains the following sections:

2.1 Installing HSN Database

This section contains the following topics:

2.1.1 Creating HSN Tablespace

To create tablespace for the HSN database, perform the following:

  1. Edit hsnp_create_tablespace.sql.

  2. Enter the following details:

    • appropriate path for data file (line starting with data file)

    • size and auto extend size (line starting with SIZE)

  3. Log in to the database as a user with privilege to create tablespace and execute the script.

  4. Enter the name of the tablespace you want to create when prompted.

See also Section 3.1.

2.1.2 Creating HSN Database User

To create HSN database user, perform the following:

  1. Log in to the database as a user with privilege to create user using SQLPlus.

  2. In the SQLPlus prompt, execute the @hsnp_create_user.sql script.

  3. Enter the corresponding values as prompted.

    Note:

    Ensure that you specify the tablespace name created in Section 2.1.1 when prompted.
  4. Exit SQLPlus.

2.1.3 Installing HSN Database Objects

This section describes how to create database objects for HSN and initialize the database with seed data.

To install the HSN database objects, perform the following:

  1. Log in to the database as HSN user (created in Section 2.1.2) using SQLPlus.

  2. In the SQLPlus prompt, execute the HSNP_ddl.sql script.

    This creates the required database objects.

  3. Update the SOA and ManApp service URL in the BPEL_PROCESS_MASTER and MANAGEMENT_CONFIGURATION tables as per the environment in HSNP_seed.sql.

  4. Execute the HSNP_seed.sql script.

    This inserts the seed data in the database objects created.

  5. Exit SQLPlus.

Running Post-Installation Scripts

During schema creation, access rights are granted to the schema user which are required only for database configuration. Post database schema creation, the access rights need to be revoked. The access rights can be revoked using the post installation scripts.

  1. Connect to the database as a user with sysdba privilege.

  2. Execute the @hsnp_post_install.sql script.

2.2 Installing HSN ManApp

This section contains the following topics:

2.2.1 Enabling JPA 2.0

To enable JPA 2.0, perform the following:

  1. Edit the <MIDDLEWARE_HOME>/wlserver_10.3/common/bin/commEnv.sh file to add the PRE_CLASSPATH variable at the end of the file.

  2. Verify the JAR version number in the <MIDDLEWARE_HOME>/modules folder and update the following statement accordingly:

    PRE_CLASSPATH=${MODULES_DIR}/javax.persistence_1.1.0.0_2-

    0.jar:${MODULES_DIR}/com.oracle.jpa2support_1.0.0.0_2-

    1.jar

    export PRE_CLASSPATH

2.2.2 Configuring Data Source

To configure data source, perform the following:

  1. Log in to the Oracle WebLogic server console for the HSnP domain.

  2. Create data source using the schema created in database setup steps.

  3. Enter the jndi name as jdbc/HAFDBDS and assign it to the HSnPManApp server as target.

  4. Restart the server.

2.2.3 Setting Transaction Timeout

To set the transaction timeout for the WebLogic application server, perform the following:

  1. Go to Services > JTA in the WebLogic console.

  2. Update timeout seconds to 600 and save.

2.2.4 Deploying EAR

To deploy EAR, perform the following:

Note:

Ensure that the application name is set to HSnPMan-EAR during deployment.
  1. Extract the HSnPManApp EAR file from the media pack.

  2. Deploy the EAR file to the Oracle WebLogic server, where HSnPManApp need to be installed.

2.2.5 Configuring Logging

To configure logging, perform the following:

  1. Log in to the Enterprise Manager of WebLogic server.

  2. In the pane on the left side of the window, click the HSnPManApp domain in the WebLogic Domain folder and select the target HSnPManApp server.

    For example, provider1.

  3. From the WebLogic Server drop-down list, select Logs and then select Log Configuration.

    Figure 2-1 Log Configuration

    Description of Figure 2-1 follows
    Description of "Figure 2-1 Log Configuration"

  4. Expand Root Logger.

  5. For Oracle, change the log level and select Inherited from Parent.

  6. Select Persist log level state across component restarts and click Apply Changes.

2.2.6 Configuring the Oracle Web Services Manager

To execute the following commands you need to set the JAVA_HOME environment variable to point to JDK referred in the HSnP domain:

  • export JAVA_HOME=<Path to JDK referred with hsnp domain>

  • export PATH=$JAVA_HOME/bin:$PATH

  1. Generate private key to be used in the HSnP ManApp and SOA servers using keytool utility available in the JDK bin directory.

  2. In the following command, replace the <KEY_LOCATION> as required.

    keytool -genkey -alias hsnp-key -keyalg "RSA" -sigalg "SHA1withRSA" -dname "cn=HSNP, ou=HSGBU, o=ORACLE, c=US" -keystore <KEY_LOCATION>/hsnpkey.jks -validity 3650

    1. Enter the keystore password and the key password when prompted.

  3. Copy the generated keystore hsnpkey.jks to the <HSNP_DOMAIN_HOME>/config/fmwconfig folder.

  4. Open the <HSNP_DOMAIN_HOME>/config/fmwconfig/jps-config.xml file.

  5. Search for default-keystore.jks in the file.

    It should be similar to <serviceinstance name="keystore" provider="keystore.provider" location="./default-keystore.jks">.

  6. Replace ./default-keystore.jks with ./hsnpkey.jks and save the file.

  7. Restart the WebLogic server instances for the HSnP domain.

  8. Copy the HSnP_OWSM_Config.py and GrantIdentity_to_HSnP.py files from the media pack to a location to which the operating system user has read and execute permissions.

  9. Execute the following commands on the command prompt:

    • cd <MIDDLEWARE_HOME>/oracle_common/common/bin

    • ./wlst.sh <ABSOLUTE FILE_PATH to HSnP_OWSM_Config.py>

      1. Enter the corresponding values as prompted by the script.

    • ./wlst.sh <ABSOLUTE FILE PATH to GrantIdentity_to_HSnP.py>

      1. Enter the corresponding values as prompted.

    The HSnP_OWSM_Config.py script adds credentials for the hsnpkey.jks file. The GrantIdentity_to_HSnPMan.py file grants identity permission to the HSnPMan-Ear application.

  10. Login to the Enterprise Manager of the HSnP domain.

  11. In the left pane, click the HSnP domain in the WebLogic domain folder.

  12. From the WebLogic Domain drop-down list, select Web Services and then select Platform Policy Configuration.

    Figure 2-4 WebLogic Domain Drop-down List

    Description of Figure 2-4 follows
    Description of "Figure 2-4 WebLogic Domain Drop-down List"

  13. Click the Trusted SAML clients tab in the Platform Policy Configuration page.

  14. Select www.oracle.com issuer in the Trusted Issuers pane.

    Figure 2-5 Platform Policy Configuration

    Description of Figure 2-5 follows
    Description of "Figure 2-5 Platform Policy Configuration"

  15. Click Add in the Trusted SAML clients: www.oracle.com pane.

    The Add New Distinguished Name (DN) window is displayed.

    Figure 2-6 Add New Distinguished Name (DN) Window

    Description of Figure 2-6 follows
    Description of "Figure 2-6 Add New Distinguished Name (DN) Window"

  16. Add text cn=HSN-PVPR, ou=HSGBU, o=ORACLE, c=US and click OK.

  17. Repeat steps 14 and 15 to add cn=HSNP, ou=HSGBU, o=ORACLE, c=US as trusted SAML client.

  18. Click Apply.

  19. Log out of the Enterprise Manager.

  20. Create the WebLogic user hsn_system to be used for the HSnP domain.

  21. Restart the WebLogic server instances for the HSnP domain.

2.3 Configuring HSN-SOA

This chapter contains the following topics:

2.3.1 Increasing PermGen Memory When Using Sun JDK

To increase PermGen memory, perform the following:

  1. Edit the <HSNP-SOA_DOMAIN_HOME>/bin/setSOADomainEnv.sh file to increase the permgen memory allocation.

  2. Increase the following values:

    if [ "${JAVA_VENDOR}" != "Oracle" ] ; then DEFAULT_MEM_ARGS="${DEFAULT_MEM_ARGS} -XX:PermSize=128m -XX:MaxPermSize=256m" PORT_MEM_ARGS="${PORT_MEM_ARGS} -XX:PermSize=256m -XX:MaxPermSize=512m"fi

    to these values:

    if [ "${JAVA_VENDOR}" != "Oracle" ] ; then DEFAULT_MEM_ARGS="${DEFAULT_MEM_ARGS} -XX:PermSize=512m -XX:MaxPermSize=1024m" PORT_MEM_ARGS="${PORT_MEM_ARGS} -XX:PermSize=1024m -XX:MaxPermSize=1024m"fi

2.3.2 Installing SOA Security Patch

To install SOA security patch, perform the following:

  1. Install the SOA Security Patch 16622432 for SOA version 11.1.1.6.0.

  2. Download the patch from the following link and follow the install procedure for the Oracle SOA Platform:

    https://support.oracle.com/epmos/faces/PatchDetail?_afrLoop=446908509299957&patchId=16622432&_afrWindowMode=0&_adf.ctrl-state=1dv0u5xlba_4

2.3.3 Configuring Logging

To configure logging, perform the following:

  1. Log in to the Enterprise Manager.

  2. In the pane on the left side of the window, click the SOA domain in the WebLogic Domain folder and select the target SOA server.

  3. From the WebLogic Server drop-down list, select Logs and then select Log Configuration.

    Figure 2-7 Log Configuration

    Description of Figure 2-7 follows
    Description of "Figure 2-7 Log Configuration"

  4. Expand Root Logger.

  5. For Oracle, change the log level and select Inherited from Parent.

  6. Select Persist log level state across component restarts and click Apply Changes.

2.3.4 Configuring Oracle Web Services Manager

To configure Oracle Web Services Manager, perform the following:

  1. Copy the hsnpkey.jks keystore file generated as part of OWSM configuration in the HSnP domain to the <HSNP-SOA_DOMAIN_HOME>/config/fmwconfig folder.

  2. Open the <HSNP-SOA_DOMAIN_HOME>/config/fmwconfig/jps-config.xml file.

  3. Search for default-keystore.jks in the file.

    It should be like <serviceinstance name="keystore" provider="keystore.provider"location="./default-keystore.jks">

  4. Replace ./default-keystore.jks with ./hsnpkey.jks and save the file.

  5. Restart the WebLogic server instances for the HSnP-SOA domain.

  6. Copy the HSnP_OWSM_Config.py file from the media pack to a location to which the operating system user has read and execute permissions.

  7. Execute the following commands on the command prompt:

    • cd <MIDDLEWARE_HOME>/oracle_common/common/bin

    • ./wlst.sh <ABSOLUTE FILE_PATH to HSnP_OWSM_Config.py>

      1. Enter the corresponding values as prompted by the script.

  8. Log in to the Enterprise Manager of the HSnP-SOA domain.

  9. In the left pane, click the HSnP-SOA domain in the WebLogic Domain folder.

  10. From the WebLogic Domain drop-down list, select Web Services and then select Platform Policy Configuration.

    Figure 2-10 WebLogic Domain Drop-down List

    Description of Figure 2-10 follows
    Description of "Figure 2-10 WebLogic Domain Drop-down List"

  11. Click the Trusted SAML clients tab in the Platform Policy Configuration page.

  12. Select www.oracle.com issuer in the Trusted Issuers pane.

    Figure 2-11 Platform Policy Configuration

    Description of Figure 2-11 follows
    Description of "Figure 2-11 Platform Policy Configuration"

  13. Click Add in the Trusted SAML clients: www.oracle.com pane.

    The Add New Distinguished Name (DN) window is displayed.

    Figure 2-12 Add New Distinguished Name (DN) Window

    Description of Figure 2-12 follows
    Description of "Figure 2-12 Add New Distinguished Name (DN) Window"

  14. Add text cn=HSN-PVPR, ou=HSGBU, o=ORACLE, c=US and click OK.

  15. Repeat steps 12 and 13 to add cn=HSNP, ou=HSGBU, o=ORACLE, c=US as trusted SAML client.

  16. Log out of the Enterprise Manager.

  17. Create the WebLogic user hsn_system to be used for the HSnP-SOA domain.

  18. Restart the WebLogic server instances for the HSnP-SOA domain.

2.4 Configuring SOA MDS

To configure HSN-SOA MDS, perform the following:

  1. Extract the soa_mds_<<buildNumber>>.zip file and soa_mds_endpoint_<<buildNumber>>.zip file for MDS from the media pack.

  2. Create a folder named apps on your local system and extract the JAR file from the soa_mds_<<buildNumber>>.zip file in the folder.

  3. Zip the apps folder.

  4. Log in to the Enterprise Manager of the SOA server.

  5. Expand SOA under Farm_soa_domain and click soa-infra (soa_server1).

    The SOA Infra Home Page screen is displayed.

    Figure 2-13 SOA Infra Home Page

    Description of Figure 2-13 follows
    Description of "Figure 2-13 SOA Infra Home Page"

  6. Click SOA Infrastructure.

  7. Select Administration and then select MDS Configuration.

    The MDS Configuration screen is displayed. This screen lets you import and export MDS archives.

    Figure 2-14 MDS Configuration

    Description of Figure 2-14 follows
    Description of "Figure 2-14 MDS Configuration"

  8. Click Import and select the apps.zip folder.

    Note:

    You cannot cancel the import operation once it is initiated.

    You have successfully imported the archives.

    Figure 2-15 Import Operation Successful

    Description of Figure 2-15 follows
    Description of "Figure 2-15 Import Operation Successful"

  9. Create a folder named apps on your local system and extract the JAR file from the soa_mds_endpoint_<<buildNumber>>.zip file in the folder.

  10. Navigate to the apps\soa_mds\Reference\dvm path within the apps folder.

  11. Edit the SOAServiceEndpoint.dvm file.

    This file contains endpoint URL for the SOA and registry services.

    • For SOA services, update the domain and port as per the SOA server details.

    • For registry services, update the domain and port as per the target server where HSnPManApp is deployed.

  12. Update the URLs of SOA services as per the target SOA server and registry services as per the ManApp deployment server.

  13. Repeat steps 3 through 8 to import the new apps.zip file.

2.5 Configuring HSN Tracking for SOA Composites

This section contains the following topics:

2.5.1 Configuring Data Source

To configure data source, perform the following:

  1. Log in to the WebLogic console of the SOA server.

  2. Create a data source using the ManApp schema credentials.

  3. Enter jdbc/HAFDBDS as jndi name and assign it to the SOA server as target server.

  4. Restart the SOA server.

2.5.2 Configuring the SOA Server

To configure SOA server, perform the following:

  1. Extract the HsnSensor JAR from the media pack.

  2. Shut down the server.

  3. Copy the HsnSensor-<<buildNumber>>.jar file to <MIDDLEWARE_HOME>/Oracle_SOA1/soa/modules/oracle.soa.ext_11.1.1 on target server.

  4. Navigate to <MIDDLEWARE_HOME>/Oracle_SOA1/soa/modules/oracle.soa.ext_11.1.1.

  5. Execute the following commands:

    1. /bin/sh

    2. source <MIDDLEWARE_HOME>/wlserver_10.3/server/bin/setWLSEnv.sh

    3. ant

  6. Wait for the build successful message.

  7. Start the server.

2.6 Setting Transaction Timeout for Service-Oriented Architecture

To set transaction timeout for SOA, the administrator need to set the SyncMaxWaitTime property value in seconds using the following steps:

  1. To set timeout for BPEL:

    1. Log in to the Enterprise Manager.

    2. On the left of the navigation menu, expand the SOA folder and select soa-infra (soa_server1).

    3. On the right top of the Details screen, expand the SOA Infrastructure drop-down menu and select SOA Administration, BPEL Properties.

      The BPEL Service Engine Properties screen is displayed.

    4. Click More BPEL Configuration Properties.

      The Application Defined MBeans: BPELConfig:bpel screen is displayed.

    5. Edit the SyncMaxWaitTime setting in the list to set timeout to 720 seconds.

  2. To set timeout in the SOA EJBs:

    1. Log in to the WebLogic console.

    2. On the left of the navigation menu, click Deployments.

    3. Click soa-infra in the list of deployments.

      The Settings for soa-infra screen is displayed.

    4. In the Modules and Components list, click each of the following EJBs to increase the transaction timeout value in the corresponding Configuration tab.

      BPELEngineBean

      BPELDeliveryBean

      BPELActivityManagerBean

      BPELServerManagerBean

      BPELProcessManagerBean

      BPELInstanceManagerBean

      BPELFinderBean

    5. Set the timeout to 960 seconds.

  3. To set timeout for JTA:

    1. On the left side of the navigation menu, select soa_domain and increase the JTA timeout.

    2. Select JTA in the Configuration tab.

    3. Set the timeout to 1200 seconds.

2.7 Deploying SOA Composite

You can deploy the following SOA services from their respective JAR files:

  • GetNetworkCountService

  • PlantedQuerySerrvice

  • RecruitmentService

  • GetPatientCountService

  • GetCriteriaAnalysisCountService

To deploy SOA services, perform the following:

  1. Extract the following files from the media pack:

    • sca_NetworkCountService_rev<<buildNumber>>.jar

    • sca_PlantedQueryService_rev<<buildNumber>>.jar

    • sca_RecruitmentService_rev<<buildNumber>>.jar

    • sca_GetPatientCountService_rev<<buildNumber>>.jar

    • sca_CriteriaSetAnalysisService_rev<<buildNumber>>.jar

  2. Log in to the Enterprise Manager of the SOA server.

  3. Expand SOA and select default.

    The Enterprise Manager - SOA Default Node screen is displayed.

    Figure 2-16 Enterprise Manager - SOA Default Node

    Description of Figure 2-16 follows
    Description of "Figure 2-16 Enterprise Manager - SOA Default Node"

  4. From SOA Partition, select Deployment and then select Undeploy All From This Partition.

    Figure 2-17 Undeploying Composites from a Partition

    Description of Figure 2-17 follows
    Description of "Figure 2-17 Undeploying Composites from a Partition"

    All the available composites are undeployed from the server.

    Figure 2-18 Undeploying Composites

    Surrounding text describes Figure 2-18 .

    Note:

    You cannot stop the undeploying operation once it is initiated.
  5. From SOA Partition, select Deployment and then select Deploy To This Partition.

  6. Select the deployable composite JAR from your system and keep clicking Next.

    Figure 2-19 Selecting an Archive

    Description of Figure 2-19 follows
    Description of "Figure 2-19 Selecting an Archive"

    The selected JAR file is deployed on the SOA server.

  7. Repeat step 6 to deploy all the required services.