Oracle® Healthcare Foundation

Application Toolkit Installation Guide

Release 7.1.1

E79467-03

April 2017

Oracle Healthcare Foundation provides a standalone Application Toolkit that enables you to build downstream applications for Oracle Healthcare Foundation without the need to install the complete product. The Application Toolkit includes the Healthcare Common Data Mart (HCD) data model and the Oracle Business Intelligence Enterprise Edition (OBIEE) RPD file for HCD, which is used for Self-Service Analytics.

This manual contains the following topics:

- Installing the Application Toolkit HCD on Linux

- Installing the Application Toolkit HCD on Windows

- Installing the RPD File for Self-Service Analytics

- Troubleshooting

1 Installing the Application Toolkit HCD on Linux

1. Check Software Requirements

2. Check Prerequisites

3. Prepare the Installer

4. Run the Installer

1.1 Check Software Requirements

Oracle Linux 6.5 or above (64-bit)

Oracle Database 12.1.0.2.0 Enterprise Edition

Python 2.6.6

Linux X-windows (Linux Graphical User Interface)

1.2 Check Prerequisites

Make sure that the ORACLE_HOME and PATH environment variables are setup in your session. For example:
export ORACLE_HOME=/u01/app/oracle/product/121020 export PATH=$PATH:$ORACLE_HOME/bin

Make sure that the password expiry notification message does not display for the Sys and system schemas.

Set the NLS_LENGTH_SEMANTICS parameter to either CHAR or BYTE, based on your requirements.
For Oracle Healthcare Foundation Globalization Support information, see Oracle Database Globalization Support Guide and set your database character set accordingly.

Make sure the database connection through SERVICE_NAME is enabled. You can verify the database connectivity using the following command:
SQL>connect <username>@<hostname>:<port number>/<service name>

1.3 Prepare the Installer

Extract the contents of the Oracle Healthcare Foundation media pack to your system.

Navigate to the <media_pack_location>/ folder.

Unzip the OHF_V711_AT_Linux-x64.zip file where you want to launch the installer using the following command:
unzip -a OHF_V711_AT_Linux-x64.zip

Navigate to the Disk1/install folder.

Change the protection on files as follows:
chmod 755 *

1.4 Run the Installer

Start the Oracle Universal Installer (OUI) using the following command:

- If the database server is on the machine where the installer is running:
sh runInstaller.sh -local

- If the database server is on a different machine:
sh runInstaller.sh -local remote_installation=true

where, the -local option is to install on the local node irrespective of the cluster nodes specified on the installer machine.

Screen

Action

Welcome

Click Next.

Specify Home Details

Enter the installation home name and location.
Click Next.

Oracle Client Home Configuration

Specify the Oracle client home path. The installer validates this path.
Click Next.

Database Configuration

Enter values for the following fields:

- Host name - By default, the system host name appears.

- Port - By default, the port number is 1521. You can edit this field if required.

- Service name

- System user password

- Sys user password

Click Next.

Healthcare Common Data Mart Configuration

Enter values for the following fields:

- Common data mart schema name

- Common data mart schema password

Note: If you are upgrading from a previous Application Toolkit version, provide the values for the existing Common data mart schema.

Click Next.

Tablespace Details

Specify the default tablespace details for the HCD schema. Enter values for the following fields:

- Tablespace name

- Initial size

- Maximum size - By default, this is set to UNLIMITED.

Click Next.

Temporary Tablespace

Specify the temporary tablespace details for the Common datamart schema. Enter values for the following fields:

- Tablespace name

- Initial size

- Maximum size - By default, this is set to UNLIMITED.

Click Next.

Tablespace Data File Location

Specify the location of the Tablespace data files. This is the directory on the database server where the data files are created during the installation.
For example,

/u01/oradata/dbname/

The installer does not validate the tablespace location entered. Ensure that the tablespace location physically exists if the database server is on the remote server. Otherwise, the installer will fail during the installation.

Click Next.

Verify Configuration Parameters

Click Next.

Summary

Click Install.

End of Installation

After reviewing the installation information, click Exit.

If the installation fails, see Troubleshooting.

2 Installing the Application Toolkit HCD on Windows

1. Check Software Requirements

2. Check Prerequisites

3. Prepare the Installer

4. Run the Installer

2.1 Check Software Requirements

Microsoft Windows (64-bit) OS

Oracle Database 12.1.0.2.0 Enterprise Edition

Python 2.6.6

2.2 Check Prerequisites

Make sure that the ORACLE_HOME and PATH environment variables are setup in your session.

Make sure that the password expiry notification message does not display for the Sys and system schemas.

Set the NLS_LENGTH_SEMANTICS parameter to either CHAR or BYTE, based on your requirements.
For Oracle Healthcare Foundation Globalization Support information, see Oracle Database Globalization Support Guide and set your database character set accordingly.

Make sure the database connection through SERVICE_NAME is enabled. You can verify the database connectivity using the following command:
SQL>connect <username>@<hostname>:<port number>/<service name>

2.3 Prepare the Installer

Extract the contents of the Oracle Healthcare Foundation media pack to your system.

Navigate to the <media_pack_location>/ folder.

Unzip the OHF_V711_AT_Windows-x64.zip file where you want to launch the installer.

Navigate to the Disk1/install folder.

2.4 Run the Installer

Start the Oracle Universal Installer (OUI) using the following command:

- If the database server is on the machine where the installer is running:
setup.exe

- If the database server is on a different machine:
setup.exe remote_installation=true

Screen

Action

Welcome

Click Next.

Specify Home Details

Enter the installation home name and location.
Click Next.

Oracle Client Home Configuration

Specify the Oracle client home path. The installer validates this path.
Click Next.

Database Configuration

Enter values for the following fields:

- Host name - By default, the system host name appears.

- Port - By default, the port number is 1521. You can edit this field if required.

- Service name

- System user password

- Sys user password

Click Next.

Healthcare Common Data Mart Configuration

Enter values for the following fields:

- Common data mart schema name

- Common data mart schema password

Note: If you are upgrading from a previous Application Toolkit version, provide the values for the existing Common data mart schema.

Click Next.

Tablespace Details

Specify the default tablespace details for the HCD schema. Enter values for the following fields:

- Tablespace name

- Initial size

- Maximum size - By default, this is set to UNLIMITED.

Click Next.

Temporary Tablespace

Specify the temporary tablespace details for the Common datamart schema. Enter values for the following fields:

- Tablespace name

- Initial size

- Maximum size - By default, this is set to UNLIMITED.

Click Next.

Tablespace Data File Location

Specify the location of the Tablespace data files. This is the directory on the database server where the data files are created during the installation.
For example,

C:/app/oracle/product/oradata/dbname/

The installer does not validate the tablespace location entered. Ensure that the tablespace location physically exists if the database server is on the remote server. Otherwise, the installer will fail during the installation.

Click Next.

Verify Configuration Parameters

Click Next.

Summary

Click Install.

End of Installation

After reviewing the installation information, click Exit.

If the installation fails, see Troubleshooting.

3 Installing the RPD File for Self-Service Analytics

1. Check Software Requirements

2. Prepare the RPD File

3. Install the RPD File

3.1 Check Software Requirements

Oracle Business Intelligence Enterprise Edition (OBIEE) 12.2.1.2.0

Oracle Business Intelligence Developer Client Tools 12.2.1.2.0

Java Runtime Environment (JRE) 1.8 Update 91 (JRE 1.8 u91) or above

Oracle Healthcare Foundation Application Toolkit Healthcare Common Data Mart

3.2 Prepare the RPD File

Extract the contents of the Oracle Healthcare Foundation media pack to your system.

Navigate to the <media_pack_location>/ folder.

Depending on your operating system, unzip the OHF_V711_Linux-x64.zip or the OHF_V711_AT_Windows_x64.zip file.

3.3 Install the RPD File

Navigate to the selfserviceanalytics folder in the media pack.

Open the RPD file, ohf_ssa_hcd.rpd, available in the selfserviceanalytics\hcd_rpd folder using the Oracle BI Administration Tool, and perform the following steps:

1. Navigate to Manage > Variables, update the default value of the puser variable to point to the HCD schema name, and click OK.

2. In the Physical layer, navigate to localhost > Properties > Connection Pools, and double-click Relation Connection.
- Update the Data source name with the database host name, port number, and service name.

- Update the HCD schema password.

3. In the Physical layer, rename the physical schema hcd with the HCD schema name.

Save the ohf_ssa_hcd.rpd file and deploy it on the OBIEE server for analytics and reporting.
For details on deploying the RPD file, see Oracle Business Intelligence Enterprise Edition 12.2.1.2.0 documentation.

4 Troubleshooting

If the installation fails, check the log files for errors (see Installation Log Files).

You must fix the issues and rerun the installer from the installation home location.

When re-executing the installer due to a failure, enter the same details in the question prompting phase at all times. Do not delete any objects in the installation folder.

Contact Oracle support, if necessary, to resolve any persisting errors.

4.1 Installation Log Files

While installing the HCD Data Model, the installer generates the following log files:

Log File

Description

installActions<timestamp>.log

Records the actions of the installer and can be used to diagnose issues with the installer.

oraInstall<timestamp>.out

Records the output of the SQL scripts run by the installer. Database objects are installed using the Python framework.

oraInstall<timestamp>.err

Records the errors from the SQL scripts run by the installer.

<INSTALL_HOME>/at/install.err

This file is generated only when there are any SQL errors. Database objects are installed using the Python framework and the error logging is redirected to this location.

The log files are time stamped and each installation session creates a new log file. The log files are located at <ORACLE_BASE>/oraInventory/logs.

For example:

- Linux - /u01/app/oraInventory/logs

- Windows - C:\Program Files\Oracle\Inventory\logs

When reporting any problems that occur during installation to Oracle support, make sure that you include all the above log files.

5 Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Oracle Healthcare Foundation Application Toolkit Installation Guide, Release 7.1.1

E79467-03

Copyright © 2016, 2017, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Oracle Legal Notices

Copyright Notice

Copyright © 1994-2017, Oracle and/or its affiliates. All rights reserved.

License Restrictions Warranty/Consequential Damages Disclaimer

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

Warranty Disclaimer

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

Restricted Rights Notice

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

Hazardous Applications Notice

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Trademark Notice

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

Third-Party Content, Products, and Services Disclaimer

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Pre-General Availability Draft Documentation Notice

If this document is in public or private pre-General Availability status:

This documentation is in pre-General Availability status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.

Private Pre-General Availability Draft Documentation Notice

If this document is in private pre-General Availability status:

The information contained in this document is for informational sharing purposes only and should be considered in your capacity as a customer advisory board member or pursuant to your pre-General Availability trial agreement only. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.

This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Master Agreement, Oracle License and Services Agreement, Oracle PartnerNetwork Agreement, Oracle distribution agreement, or other license agreement which has been executed by you and Oracle and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.