Skip Headers
Oracle® Healthcare Operating Room Analytics Installation Guide
Release 1.0.1
E16679-02
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Feedback page
Contact Us
  PDF · Mobi · ePub

Oracle® Healthcare Operating Room Analytics

Installation Guide

Release 1.0.1

E16679-02

November 2012

Oracle Healthcare Operating Room Analytics (ORA) release 1.0.1 is an analytical reporting application. ORA generates both predefined and custom reports of key metrics across the operating room spectrum.

ORA is built on top of Oracle Business Intelligence Enterprise Edition (OBIEE) infrastructure. This document presents instructions for installing ORA. It also describes the tasks that you must complete before you can install the ORA application.

ORA is integrated with several other products including Informatica and Oracle Business Intelligence Enterprise Edition (OBIEE).

1 Intended Audience

This installation guide is intended for users who are responsible for installing Oracle Operating Room Analytics. You should be familiar with:

2 Before You Begin

This section presents an overview of the ORA requirements. It also describes the tasks that you must complete before you can install the ORA application. Specifically, this section includes the following topics:

2.1 Technology Stack and System Requirements

The required technology stack for Oracle Operating Room Analytics consists of the following products:

  • Oracle Database 11.2.0.2

  • Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.6.0

Table 1 System Requirements References

Product Reference

Oracle Database 11.2.0.2

Database Installation Guide for <platform>

Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.6.0

System Requirements and Supported Platforms for Oracle Business Intelligence Suite Enterprise Edition

Oracle Business Intelligence Infrastructure Installation and Configuration Guide

Other Technology Stack Components

My Oracle Support / Certifications

Note:

Download Oracle Database 11.2.0.2 from My Oracle Support Article ID 988222.1

It is important to get the technology stack products from the ORA media pack because newer versions of the technology stack products may have become available but may not be compatible with ORA.

For more information about certifications, refer to Finding Certification Information.

2.1.1 Supported Browsers

ORA supports those Internet browsers supported by OBIEE. For a list of the browsers supported by OBIEE, refer to System Requirements and Supported Platforms for Oracle Business Intelligence Suite Enterprise Edition.

2.1.2 Supported Platforms

ORA supports the following platforms:

2.2 Installing the Prerequisite Software

Before you can install the ORA application, you must complete the following pre-installation tasks:

Note:

Oracle recommends that you enable HTTPS on the middle-tier computer that is hosting the Web services, since the trusted user name and password that are passed can be intercepted.

2.3 Getting the Oracle Healthcare Operating Room Analytics Media Pack

The Oracle Operating Room Analytics media pack is available both as physical media and as a disk image from the Oracle E-Delivery Web site.

The media pack contains the technology stack products and the ORA application.

To receive the physical media, order it from Oracle Store at https://oraclestore.oracle.com.

To download the Oracle Operating Room Analytics media pack from eDelivery, do the following:

  1. Go to http://edelivery.oracle.com and log on.

  2. From the Select a Product Pack drop-down list, select Health Sciences.

  3. From the Platform drop-down list, select the appropriate operating system.

  4. Click Go.

  5. Select Oracle Healthcare Operating Room Analytics 1.0.1 Media Pack for Operating System and click Continue.

  6. Download the software.

3 Oracle Healthcare Operating Room Analytics Installation

This chapter presents an overview of the ORA installation process. It also describes the ORA Installation tasks that you must complete for different environments. This section includes the following topics:

Note:

All references to ${MEDIA_PACK} in this document refer to Media Pack directory respectively.

3.1 Installing Oracle Healthcare Operating Room Analytics Reports

The following steps are involved in installing ORA on Windows and Unix:

  1. Setting Up Database

  2. Role and Policy Set Up

  3. Installing Repository and Catalog

3.1.1 Setting Up Database

Perform the following steps to set up the database:

  1. Create a directory on the server and copy the contents of the software folder on the media to this directory.

  2. Install the Oracle database.

  3. Connect to the database as the SYSTEM user.

  4. Create the tablespace APPS_TS_TX_DATA using the following command:

    CREATE BIGFILE TABLESPACE APPS_TS_TX_DATA DATAFILE '+DATA_xx /my_dbspace/ APPS_TS_TX_DATA_bigfile.dbf' SIZE 4G REUSE
AUTOEXTEND ON NEXT 8G MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL

  5. Run the CREATE_ORA_USER.SQL script. This script creates a user EHA_ORA.

  6. The script prompts for the Default_Table_Space name. Enter the default tablespace for the user. You can enter any valid tablespace name for the user. Oracle recommends that you use the applications tablespace APPS_TS_TX_DATA as the default tablespace.

    The script also prompts for the ORA user password. Enter a valid password and continue.

  7. Inspect the log file create_ORA_user_<DB_name>.log located in the working directory for errors. <DB_name> is the database name.

  8. Connect to the database as the new user EHA_ORA with the following credentials:

    Username: EHA_ORA

    Password: Enter the same password entered in the step 5.

  9. Run the DDL script, EHA_ORA_DDL_1.1.sql, to create the database objects such as tables, views, indexes, procedures, functions, constraints, and triggers.

  10. The script prompts for the Index_Table_Space for the EHA_ORA user. Enter the tablespace for the indexes. You can enter any valid tablespace name. Oracle recommends that you use the Apps tablespace APPS_TS_TX_IDX as the index table space.

  11. Inspect the log file ORA_DDL_1_<DB_name>.log located in the working directory for errors. <DB_name> is the database name.

  12. Run the EHA_ORA_INSERT_SEED_DATA.SQL script. The script inserts seed data for ORA application into the database. Inspect this log file after each step to see the output log and check for errors during the setup.

  13. Inspect the log file ORA_insert_seed_data_<DB_name>.log located in the working directory for errors. <DB_name> is the database name.

  14. Create a schema, for example, EHA_READ_ONLY_ORA. Grant this schema connect and create synonym privileges.

    For example,

    grant connect to EHA_READ_ONLY_ORA;
                        grant create synonym to EHA_READ_ONLY_ORA;

  15. Execute the ora_grants.sql script passing the name of the read only schema as a parameter from EHA_ORA user.

  16. Execute the ora_synonyms.sql script from EHA_READ_ONLY_ORA user passing the EHA_ORA user as input parameter.

3.1.2 Role and Policy Set Up

If Oracle Weblogic instance does not have any roles or policies from other applications, perform the following steps to create roles in the Weblogic instance where OBIEE is installed:

  1. Log into WebLogic Enterprise Manager where the rpd and webcat is deployed.

  2. Expand the Weblogic Domain node.

  3. Right-click bifoundation_domain and then navigate to Security > Application Roles.

  4. Select Select Application Stripe to search and then select obi.

  5. Click Search.

  6. Click Create.

  7. Enter the role name and click OK.

  8. The following roles have to be created:

    • Analyst

    • Business Analyst

    • Department Manager

    • Executive - Financial Officer

    • Chief of Anesthesia

    • Chief of Surgery

    • Enterprise User

    • Presentation Server Administrators

If Weblogic instance has policies and roles for other deployed applications, perform the policy migration using the following steps:

  1. Create a folder for the policy store migration.

    • Windows: <DRIVE>:\PolicyStoreMigration

      • <DRIVE>:\PolicyStoreMigration\Prod

    • UNIX: /PolicyStoreMigration/ORA

  2. Create sub-folders for ORA and the current production instances.

    • Windows: <DRIVE>:\PolicyStoreMigration\ORA

      • /PolicyStoreMigration/Prod

    • UNIX: /PolicyStoreMigration

  3. Copy system-jazn-data.xml supplied with ORA to the ORA folder.

  4. Copy the system-jazn-data.xml from:

    • Windows: {Middleware_Home}/ user_projects/domains/bifoundation_domain/config/fmwconfig folder to the Prod folder

    • UNIX: {Middleware_Home}\ user_projects\domains\bifoundation_domain\config\fmwconfig folder to the Prod folder.

    Note:

    Oracle recommends that you take a backup of all the files before merging the policies.
 
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Feedback page
Contact Us