Oracle® Healthcare Foundation Application Toolkit

Installation Guide

Release 7.0.1

E71048-02

May 2016

Oracle Healthcare Foundation provides a standalone Application Toolkit installer that supports the installation of Healthcare Common Data Mart (HCD) data model and packages Self-Service Analytics HCD RPD. This enables you to build downstream applications for Oracle Healthcare Foundation without the need to install the complete product.

The components in the Application Toolkit installer are intended to be used for downstream applications development purpose only. Oracle does not recommend you to use this in the production environment.

This document explains the installation of Oracle Healthcare Foundation Application Toolkit. The user installing this component should have knowledge of Oracle, Linux or Windows operating system (OS). This installer lets you install the Healthcare Common Data mart (HCD) Data Model.

This chapter contains the following topics:

- Section 1, "Software Requirements"

- Section 2, "Media Pack Content"

- Section 3, "General Guidelines for Installation"

- Section 4, "Prerequisites"

- Section 5, "Installation Log Files"

- Section 6, "Installing the Oracle Healthcare Foundation Application Toolkit from Linux Operating System"

- Section 7, "Installing the Oracle Healthcare Foundation Application Toolkit from Windows Operating System"

- Section 8, "Installing the Oracle Healthcare Foundation Self-Service Analytics"

- Section 9, "Troubleshooting"

- Section 10, "Documentation Accessibility"

1 Software Requirements

The following is a list of software requirements:

Application Toolkit HCD

- Oracle Linux 6.5 or 6.6 (64-bit) or Window (64 -bit) OS

- Oracle Database 12.1.0.2.0 Enterprise Edition

- Python 2.6.6

Self-Service Analytics

- Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.9

- Oracle Business Intelligence Developer Client Tools 11.1.1.9.0

- Java Development Kit (JDK) 1.8

2 Media Pack Content

The media pack from the Oracle Software Delivery Cloud (OSDC) contains the installer for:

- Oracle Healthcare Foundation Application Toolkit Linux (OHF_V701_AT_Linux-x64.zip)

- Oracle Healthcare Foundation Application Toolkit Windows (OHF_V701_AT_Windows-x64.zip)

3 General Guidelines for Installation

- Use Linux X-windows for the Linux Oracle Universal Installer (OUI) installation (Linux Graphical User Interface).

- Before running the installer, make sure that the ORACLE_HOME and PATH environment variables are setup in your session.
For example,

Linux:

export ORACLE_HOME=/u01/app/oracle/product/121020 export PATH=$PATH:$ORACLE_HOME/bin

- 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.

- Convert the installer execution shell to SH shell as the installer script executes in the SH shell of Linux OS.

4 Prerequisites

The following are the prerequisites to install the HCD data model:

- Oracle Database 12.1.0.2 Enterprise Edition.

- Python 2.6.6 environment variable is set.

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

- NLS_LENGTH_SEMANTICS parameter set 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.

- Database connection through SERVICE_NAME enabled.
You can verify the database connectivity using the following command:

SQL>connect <username>@"(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=<hostname>)(PORT=<port number>))(CONNECT_DATA=(SERVICE_NAME=<service_ name>)))"

5 Installation Log Files

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

- installActions<timestamp>.log - Records the action 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.
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

- <INSTALL_HOME>/at/install.err - This file gets 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.
While reporting any problems that occur during installation, make sure that you include all the above log files.

6 Installing the Oracle Healthcare Foundation Application Toolkit from Linux Operating System

To install the Oracle Healthcare Foundation Application Toolkit from the Linux OS, perform the following steps:

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

2. Navigate to the <media_pack_location>/ folder.

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

4. Navigate to the Disk1/install folder.

5. Change the protection on files as follows:
chmod 755 *

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

- Database server is on the machine where the installer is running, execute:
sh runInstaller.sh -local

- Database server is on a different machine, execute:
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.

The Welcome screen appears.

7. Click Next. The Specify Home Details screen appears.

8. Enter the installation home name and location.

9. Click Next. The Oracle Client Home Configuration screen appears.

10. Specify the Oracle client home path. The installer validates this path.

11. Click Next. The Database Configuration screen appears.

12. 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

13. Click Next. The Healthcare Common Data Mart Configuration screen appears.

14. Enter values for the following fields:

- Common data mart schema name

- Common data mart schema password

15. Click Next. The Tablespace details screen appears.

16. 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.

17. Click Next. The Temporary Tablespace details screen appears.

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

- Tablespace name

- Initial size

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

19. Click Next. The Tablespace Data File Location screen appears.

20. 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/

Note:
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. Else, the installer will fail during installation.

21. Click Next. The Verify Configuration Parameters screen appears.

22. Click Next. The Summary screen appears.

23. Click Install.

24. After the installation is complete, the End of Installation screen appears.

25. Review the generated installation log files for errors. For details on troubleshooting, see Section 9.

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

7 Installing the Oracle Healthcare Foundation Application Toolkit from Windows Operating System

To install the Oracle Healthcare Foundation Application Toolkit from the Window OS, perform the following steps:

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

2. Navigate to the <media_pack_location>/ folder.

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

4. Navigate to the Disk1/install folder.

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

- Database server is on the machine where the installer is running, execute:
setup.exe

- Database server is on a different machine, execute:
setup.exe remote_installation=true

The Welcome screen appears.

6. Click Next. The Specify Home Details screen appears.

7. Enter the installation home name and location.

8. Click Next. The Oracle Client Home Configuration screen appears.

9. Specify the Oracle client home path. The installer validates this path.

10. Click Next. The Database Configuration screen appears.

11. 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

12. Click Next. The Healthcare Common Data Mart Configuration screen appears.

13. Enter values for the following fields:

- Common data mart schema name

- Common data mart schema password

14. Click Next. The Tablespace details screen appears.

15. 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.

16. Click Next. The Temporary Tablespace details screen appears.

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

- Tablespace name

- Initial size

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

18. Click Next. The Tablespace Data File Location screen appears.

19. 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/

Note:
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. Else, the installer will fail during installation.

20. Click Next. The Verify Configuration Parameters screen appears.

21. Click Next. The Summary screen appears.

22. Click Install.

23. After the installation is complete, the End of Installation screen appears.

24. Review the generated installation log files for errors. For details on troubleshooting, see Section 9.

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

8 Installing the Oracle Healthcare Foundation Self-Service Analytics

This section describes how to install Oracle Healthcare Foundation Self-Service Analytics. It contains the following topics:

- Section 8.1, "Overview"

- Section 8.2, "Prerequisites"

- Section 8.3, "Installing the Oracle Healthcare Foundation Self-Service Analytics"

8.1 Overview

Oracle Healthcare Foundation Self-Service Analytics is available in the OHF_V701_AT_Windows_x64.zip or OHF_V701_Linux-x64.zip file of the media pack.

The following is the structure of the Self-Service Analytics package:

/selfserviceanalytics

/hcd_rpd

obieeIds.csv

oh7.0_ssa_hcd.rpd

It consists of the Self-Service Analytics Oracle Business Intelligence Enterprise Edition (OBIEE) RPD file for the Healthcare Common Data Mart, which is used for Self-Service Business Intelligence.

8.2 Prerequisites

The following are the prerequisites for Self-Service Analytics:

- Oracle Business Intelligence 11.1.1.9.0

- Oracle Business Intelligence Developer Client Tools 11.1.1.9.0

- Oracle Healthcare Foundation Application Toolkit Healthcare Common Data Mart

8.3 Installing the Oracle Healthcare Foundation Self-Service Analytics

To install the Oracle Healthcare Foundation Self-Service Analytics, perform the following steps:

1. Navigate to the selfserviceanalytics folder in the media pack.

2. Open the RPD file, oh7.0_ssa_hcd.rpd, available in the selfserviceanalytics\hcd_rpd folder using the Oracle Business Intelligence Developer Client Tools 11.1.1.9.0, and update the connection pool to point to HCD.

3. Save the oh7.0_ssa_hcd.rpd file and deploy it on the OBIEE server for analytics and reporting.

For details on deploying the oh7.0_ssa_hcd RPD file, see Oracle Business Intelligence Enterprise Edition 11g Release 1 (11.1.1.9) documentation.

For details about Self-Service Analytics tool, see Oracle Healthcare Foundation Programmer's Guide.

9 Troubleshooting

If the installation fails, open the log file for errors. For the log file details, see Section 5.

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

10 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.0.1

E71048-02

Copyright © 2016, 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-2016, 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.

Alpha and Beta Draft Documentation Notice

If this document is in preproduction status:

This documentation is in preproduction 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 Alpha and Beta Draft Documentation Notice

If this document is in private preproduction 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 beta 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.