Oracle® Healthcare Foundation Application Toolkit Installation Guide Release 7.1 E79467-01 |
|
PDF · Mobi · ePub |
Application Toolkit Installation Guide
Release 7.1
E79467-01
September 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:
The following is a list of software requirements:
Application Toolkit HCD
Oracle Linux 6.5 or above (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) 12.2.1.0
Oracle Business Intelligence Developer Client Tools 12.2.1.0
Java Runtime Environment (JRE) 1.8 Update 91 (JRE 1.8 u91) or above
The following is the supported upgrade path:
Application Toolkit 7.0.1 to 7.1
The media pack from the Oracle Software Delivery Cloud (OSDC) contains the installer for:
Oracle Healthcare Foundation Application Toolkit Linux (OHF_V71_AT_Linux-x64.zip)
Oracle Healthcare Foundation Application Toolkit Windows (OHF_V71_AT_Windows-x64.zip)
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.
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>@<hostname>:<port number>/<service name>
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.
To install the Oracle Healthcare Foundation Application Toolkit from the Linux OS, perform the following steps:
Extract the contents of the Oracle Healthcare Foundation media pack to your system.
Navigate to the <media_pack_location>/ folder.
Unzip the OHF_V71_AT_Linux-x64.zip file where you want to launch the installer using the following command:
unzip -a OHF_V71_Linux-x64.zip
Navigate to the Disk1/install folder.
Change the protection on files as follows:
chmod 755 *
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.
Click Next. The Specify Home Details screen appears.
Enter the installation home name and location.
Click Next. The Oracle Client Home Configuration screen appears.
Specify the Oracle client home path. The installer validates this path.
Click Next. The Database Configuration screen appears.
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. The Healthcare Common Data Mart Configuration screen appears.
Enter values for the following fields:
Common data mart schema name
Common data mart schema password
Click Next. The Tablespace details screen appears.
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. The Temporary Tablespace details screen appears.
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.
Click Next. The Tablespace Data File Location screen appears.
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.Click Next. The Verify Configuration Parameters screen appears.
Click Next. The Summary screen appears.
Click Install.
After the installation is complete, the End of Installation screen appears.
Review the generated installation log files for errors. For details on troubleshooting, see Section 10.
Contact Oracle support, if necessary, to resolve any errors.
To install the Oracle Healthcare Foundation Application Toolkit from the Window OS, perform the following steps:
Extract the contents of the Oracle Healthcare Foundation media pack to your system.
Navigate to the <media_pack_location>/ folder.
Unzip the OHF_V71_AT_Windowsx-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:
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.
Click Next. The Specify Home Details screen appears.
Enter the installation home name and location.
Click Next. The Oracle Client Home Configuration screen appears.
Specify the Oracle client home path. The installer validates this path.
Click Next. The Database Configuration screen appears.
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. The Healthcare Common Data Mart Configuration screen appears.
Enter values for the following fields:
Common data mart schema name
Common data mart schema password
Click Next. The Tablespace details screen appears.
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. The Temporary Tablespace details screen appears.
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.
Click Next. The Tablespace Data File Location screen appears.
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.Click Next. The Verify Configuration Parameters screen appears.
Click Next. The Summary screen appears.
Click Install.
After the installation is complete, the End of Installation screen appears.
Review the generated installation log files for errors. For details on troubleshooting, see Section 10.
Contact Oracle support, if necessary, to resolve any errors.
This section describes how to install Oracle Healthcare Foundation Self-Service Analytics. It contains the following topics:
Oracle Healthcare Foundation Self-Service Analytics is available in the OHF_V71_AT_Windows_x64.zip or OHF_V71_Linux-x64.zip file of the media pack.
The following is the structure of the Self-Service Analytics package:
/selfserviceanalytics
/hcd_rpd
obieeIds.csv
ohf_ssa_hcd.rpd
It consists of the Oracle Business Intelligence Enterprise Edition (OBIEE) RPD file for the Healthcare Common Data Mart, which is used for Self-Service Analytics.
For prerequisites, see Section 1. In addition, the following is required:
Oracle Healthcare Foundation Application Toolkit Healthcare Common Data Mart
To install the Oracle Healthcare Foundation Self-Service Analytics, perform the following steps:
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:
Navigate to Manage > Variables, update the default value of puser variable to point to the HCD schema name, and click OK.
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.
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.0 documentation.
If the installation fails, open the log file for errors. For the log file details, see Section 6.
You must fix the issues and rerun the installer from the installation home location.
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
E79467-01
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.