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:
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) |
Make sure that the ORACLE_HOME and PATH environment variables are setup in your session. For example:
|
|
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:
|
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:
|
|
Navigate to the Disk1/install folder. | |
Change the protection on files as follows:
|
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:
Click Next. |
|
Healthcare Common Data Mart Configuration | Enter values for the following fields:
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:
Click Next. |
|
Temporary Tablespace | Specify the temporary tablespace details for the Common datamart schema. Enter values for the following fields:
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,
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.
Microsoft Windows (64-bit) OS | |
Oracle Database 12.1.0.2.0 Enterprise Edition | |
Python 2.6.6 |
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:
|
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. |
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:
Click Next. |
|
Healthcare Common Data Mart Configuration | Enter values for the following fields:
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:
Click Next. |
|
Temporary Tablespace | Specify the temporary tablespace details for the Common datamart schema. Enter values for the following fields:
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,
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.
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 |
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. |
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:
|
|
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. |
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.
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.
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
.
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.