Skip Headers
Oracle® Healthcare Data Warehouse Foundation Secure Installation and Configuration Guide
Release 6.1

E27595-06
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

5 Installing Oracle Healthcare Data Warehouse Foundation

This section describes how to install HDWF securely.

Oracle recommends that you capture the following information required to install HDWF before starting the installation. It proves useful for cross-verification during the installation process.

Table 5-1 HDWF Configuration

HDWF Configuration Value

Type of Install: Fresh or Upgrade (from HDWF 6.0 to HDWF 6.1)

 

ORACLE_HOME name and location

 

HDWF home (HDWF installation location)

 

Database server host name and port number

 

HDWF database service name

 

System user credentials

 

Tablespace encryption

 

HDWF tablespace name

 

HDWF tablespace initial size (in MB)

 

HDWF temporary tablespace name

 

HDWF schema user credentials

 

HDWF data file location name

 

HDWF interface tablespace name

 

HDWF interface tablespace initial size (in MB)

 

HDWF interface temporary tablespace name

 

HDWF interface schema user credentials

 

HDWF interface data file location name

 

Would you like to overwrite the HDWF Oracle seed data?

 

Would you like to overwrite the HDWF interface Oracle seed data?

 

Are you installing on Exadata database system?

 

Compression Method: HCC or OLTP

 

5.1 HDWF Installation Overview

Oracle HDWF installer uses OUI, a user-interface driven installation tool to install HDWF data warehouse.

The media pack from eDelivery contains the HDWF installer for Linux 64-bit OS. Following is the media pack folder structure:

MEDIA_PACK_LOCATION

/hdwf61

/software

/install

/stage1

where MEDIA_PACK_LOCATION refers to the location of the HDWF media pack.

The installer acts in two phases:

5.1.1 Installation Options

Select one of the following options based on your installation needs:

  • Server installation - Select this option if you are running the HDWF installer directly on a database server. See Section 5.3.

  • Remote installation - Select this option if you are installing HDWF remotely on a database server by running the installer from a different machine. See Section 5.4.

5.1.2 Installation Types

The installer provides the following installation types:

  • Complete - This option performs a new installation of HDWF 6.1. It does not create a new database instance. Instead, it creates a new tablespace and a new schema in this newly created tablespace. While an existing database instance can be used for a new installation of HDWF 6.1, an existing tablespace cannot be used.

  • Upgrade - This option upgrades an existing HDWF version 6.0 to 6.1. The upgrade installation uses an existing schema. No new schema is created. The existing data files for interface tables and HDWF tables are used.

5.1.3 Installing from Unix or Linux 64-bit Operating System

  1. Extract the contents of the HDWF media pack to your system.

  2. Ensure that ORACLE_HOME, ORACLE_SID, and PATH environment variables are setup in your session.

  3. Set the X Window display output to the IP address of your local computer. Use the standard format for IP addresses and append :0 at the end. For example (based on your shell):

    setenv DISPLAY 198.51.100.89:0

    or export DISPLAY 198.51.100.89:0

  4. For Linux 64-bit OS, navigate to the <media_pack_location>/ hdwf61/software/install/ folder.

  5. Change protections on files to 755:

    chmod 755 *

  6. Start the following OUI:

    ./runInstaller -invPtrLoc < HDWF_HOME >/oraInst.loc

5.2 Installation Log Files

While installing HDWF, the OUI generates the following log files:

The log files are time stamped and each installation session creates a new log file.

On a Linux machine, the log files are located at $ORACLE_BASE/oraInventory/logs.

For example:

/u01/app/oraInventory/logs

In addition to the OUI generated log files, HDWF install log files are generated at:

/<HDWF_HOME>/oracle.hsgbu.hdwf/oracle/hdwf61/install/logs

While reporting any problems that occur during HDWF installation, ensure that you include all the above log files.

5.3 HDWF Server Installation

The installer creates the following directory structure on the server it is run:

hdwf_home

/oracle.hsgbu.hdwf

/oracle

/hdwf61

/install

/scripts (HDWF SQL scripts)

/logs (Installation log files)

/rpt (Installation report files)

hdwf_home refers to the root installation directory of the Oracle HDWF product. Create an empty directory for this purpose.

5.3.1 Fresh Installation of HDWF 6.1

For a fresh installation, perform the following steps:

  1. The Welcome screen appears on running the installer. Click Next to continue the installation.

    Figure 5-1 Welcome Screen

    Description of Figure 5-1 follows
    Description of "Figure 5-1 Welcome Screen"

  2. In the Select Installation Type screen:

    Figure 5-2 Select Installation Type

    Description of Figure 5-2 follows
    Description of "Figure 5-2 Select Installation Type "

    1. Select Complete to perform a fresh installation of HDWF 6.1.

    2. Click Next.

  3. In the Specify Home Details screen:

    Figure 5-3 Specify Home Details

    Description of Figure 5-3 follows
    Description of "Figure 5-3 Specify Home Details"

    1. Specify the root installation directory of HDWF 6.1.

      Note:

      Use lowercase for directory names, for all platforms, to be created and used by the installer.
    2. Click Next.

  4. In the Verify Installation Prerequisites screen, verify the prerequisites mentioned before installation, and click Next.

    Figure 5-4 Verify Installation Prerequisites

    Description of Figure 5-4 follows
    Description of "Figure 5-4 Verify Installation Prerequisites"

  5. In the Oracle Home Configuration screen:

    Figure 5-5 Oracle Home Configuration

    Description of Figure 5-5 follows
    Description of "Figure 5-5 Oracle Home Configuration"

    1. Enter the ORACLE_HOME location. This refers to the location of the Oracle database installation on the machine where the installer is run.

    2. Click Next.

  6. In the HDWF Database Configuration screen:

    Figure 5-6 HDWF Database Configuration

    Description of Figure 5-6 follows
    Description of "Figure 5-6 HDWF Database Configuration"

    1. Enter the database server host name where the HDWF schema is created.

    2. Enter the database server port number.

    3. Enter database system user password.

    4. Enter the HDWF database service name.

    5. Click Next.

  7. In the HDWF Tablespace Encryption Configuration screen:

    Figure 5-7 HDWF Tablespace Encryption Configuration

    Description of Figure 5-7 follows
    Description of "Figure 5-7 HDWF Tablespace Encryption Configuration"

    1. Encrypting the tablespace requires prerequisites to be set.

      If the prerequisites are set for tablespace encryption, click Yes, else click No.

    2. Click Next.

  8. In the HDWF HDM Tablespace and Schema Configuration screen:

    Figure 5-8 HDWF HDM Tablespace and Schema Configuration

    Description of Figure 5-8 follows
    Description of "Figure 5-8 HDWF HDM Tablespace and Schema Configuration"

    1. Enter the HDWF HDM tablespace name.

    2. Enter the HDWF HDM tablespace initial size in MB.

    3. Enter the HDWF HDM temporary tablespace name created as part of the prerequisites.

      Note:

      The installer does not create the temporary tablespace. It should be created as part of the prerequisite steps or the default temp tablespace can be used.
    4. Enter the HDWF HDM schema user name.

    5. Enter the HDWF HDM schema user password.

    6. Click Next.

  9. In the HDWF HDM Tablespace and Schema Configuration screen:

    Figure 5-9 HDWF HDM Tablespace and Schema Configuration

    Description of Figure 5-9 follows
    Description of "Figure 5-9 HDWF HDM Tablespace and Schema Configuration"

    1. Enter the location of the HDWF data file in the machine or ASM specific syntax including the trailing slash.

      This is the directory on the database server where the data files for the application are created during the installation.

      This value is not validated and must be entered in the machine or ASM specific syntax including the trailing slash.

      For example,

      Unix: /u01/oradata/dbname/

      ASM: +DATA_EX02/hashas01/datafile/

      Note:

      • ASM location must always start with + and should be entered with + as shown above.

      • Failure to enter the trailing slash will not stop the installation. However, the data file name will be prefixed with the folder name.

      • The HDWF data file name will be the name of tablespace entered. For example, if the HDWF tablespace name is hdwf_ts, the data file created by the installer is hdwf_ts.dbf.

    2. Click Next.

  10. In the HDWF Interface HDI Tablespace and Schema Configuration screen:

    Figure 5-10 HDWF Interface HDI Tablespace and Schema Configuration

    Description of Figure 5-10 follows
    Description of "Figure 5-10 HDWF Interface HDI Tablespace and Schema Configuration"

    1. Enter the HDWF interface HDI tablespace name.

    2. Enter the initial size of the HDWF interface HDI tablespace in MB.

    3. Enter the HDWF temporary HDI tablespace name created as part of the prerequisites.

      Note:

      The installer does not create the temporary tablespace. It should be created as part of the prerequisites.
    4. Enter the HDWF interface HDI schema user.

    5. Enter the HDWF interface HDI user password.

    6. Click Next.

  11. In the HDWF Interface HDI Tablespace and Schema Configuration screen:

    Figure 5-11 HDWF Interface Tablespace and Schema Configuration

    Description of Figure 5-11 follows
    Description of "Figure 5-11 HDWF Interface Tablespace and Schema Configuration"

    1. Enter the location of the HDWF interface data file in the machine or ASM specific syntax including the trailing slash.

      This is the directory on the database server where the data files for the application are created during the installation.

      This value is not validated and must be entered in the machine or ASM specific syntax including the trailing slash.

      For example,

      Unix: /u01/oradata/dbname/

      ASM: +DATA_EX02/hashas01/datafile/

      Note:

      • ASM location must always start with + and should be entered with + as shown above.

      • Failure to enter the trailing slash will not stop the installation. However, the data file name will be prefixed with the folder name.

      • The HDWF data file name is the name of the tablespace entered. For example, if the HDWF tablespace name is hdwf_ts, the data file created by the installer is hdwf_ts.dbf.

    2. Click Next.

  12. In the HDWF Exadata Configuration screen:

    Figure 5-12 HDWF Exadata Configuration

    Description of Figure 5-12 follows
    Description of "Figure 5-12 HDWF Exadata Configuration "

    1. Select Yes if HDWF is installed on Exadata database machine.

      Click Next and go to step 13.

    2. Select No if HDWF is not installed on Exadata database machine.

      Click Next and go to step 14.

  13. In the Table Compression Configuration screen:

    Figure 5-13 Table Compression Configuration

    Description of Figure 5-13 follows
    Description of "Figure 5-13 Table Compression Configuration"

    1. Select a table compression mode: Hybrid Columnar Compression (HCC - Query High) or Online Transaction Processing (OLTP).

    2. Click Next.

  14. In the Verify Configuration Parameters screen:

    1. Verify all the configuration parameters listed on this screen before proceeding.

    2. If required, click Back to make changes to your installation settings else click Next.

  15. Review the information on the Pre-installation Summary screen, which displays the global settings, the space requirements, and the product to install.

    1. If required, click Back to make changes to your installation settings.

    2. Click Install to continue.

  16. The HDWF installation begins and the Install screen is displayed. OUI copies the files to the HDWF home location and runs the HDWF SQL scripts to create the database.

    The install screen displays the location of the log file that records the results of the installation activities for this session. Note the location of the log file.

    Note:

    The progress bar does not display the installation progress when the database is created using SQLPlus.

    To review the installation progress or monitor the current installation activity, view the log file created at the location displayed on the Install screen.

  17. After the installation is complete, the End of Installation screen is displayed.

    This screen displays:

    • Successfully installed HDWF 6.1, if the installation is successful.

    • Location of the HDWF installer log file: <HDWF_Home>\oracle.hsgbu.hdwf\oracle\hdwf61\install\logs\ folder.

    • Location of the installation report: <HDWF_ Home>\oracle.hsgbu.hdwf\oracle\hdwf61\install\rpt\ folder.

      Note:

      Review the installation report and save it in a secure location for future use.
  18. Click Exit after reviewing the installation information. At the confirmation prompt, click Yes to exit the HDWF installer.

  19. Review the generated installation log files for errors. For details, see Section 5.2.

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

5.3.2 Upgrading HDWF from Version 6.0 to 6.1

For the upgrade installation, perform the following steps:

  1. The Welcome screen appears on running the installer. Click Next to continue the installation.

    Figure 5-14 Welcome Screen

    Description of Figure 5-14 follows
    Description of "Figure 5-14 Welcome Screen"

  2. In the Select Installation Type screen:

    Figure 5-15 Select Installation Type

    Description of Figure 5-15 follows
    Description of "Figure 5-15 Select Installation Type"

    1. Select Upgrade to upgrade HDWF 6.0 to 6.1.

    2. Click Next.

  3. In the Specify Home Details screen:

    Figure 5-16 Specify Home Details

    Description of Figure 5-16 follows
    Description of "Figure 5-16 Specify Home Details"

    1. Specify the root installation directory of HDWF 6.1.

      Note:

      Use lowercase for directory names, for all platforms, to be created and used by the installer.
    2. Click Next.

  4. In the Verify Installation Prerequisites screen, verify the prerequisites mentioned before installation, and click Next.

    Figure 5-17 Installation Prerequisites

    Description of Figure 5-17 follows
    Description of "Figure 5-17 Installation Prerequisites"

  5. In the Oracle Home Configuration screen:

    Figure 5-18 Oracle Home Configuration

    Description of Figure 5-18 follows
    Description of "Figure 5-18 Oracle Home Configuration"

    1. Enter the ORACLE_HOME location. This refers to the location of the Oracle database installation on the machine where the installer is run.

    2. Click Next.

  6. In the HDWF Database Configuration screen:

    Figure 5-19 HDWF Database Configuration

    Description of Figure 5-19 follows
    Description of "Figure 5-19 HDWF Database Configuration"

    1. Enter the database server host name where the HDWF schema exists.

    2. Enter the database server port number.

    3. Enter the database system user password.

    4. Enter the HDWF database service name.

    5. Click Next.

  7. In the HDWF HDM Schema Configuration screen:

    Figure 5-20 HDWF HDM Schema Configuration

    Description of Figure 5-20 follows
    Description of "Figure 5-20 HDWF HDM Schema Configuration"

    1. Enter the HDWF HDM schema user name.

    2. Enter the HDWF HDM schema user password.

    3. Click Next.

  8. In the HDWF HDM Codes Data Configuration screen:

    Figure 5-21 HDWF HDM Codes Data Configuration

    Description of Figure 5-21 follows
    Description of "Figure 5-21 HDWF HDM Codes Data Configuration"

    1. Overwrite the HDM seed data.

      Select No to preserve your seed data in HDM Code Repository tables (recommended).

      Select Yes if you want to overwrite your seed data with Oracle's seed data in HDM Code Repository tables.

    2. Click Next.

  9. In the HDWF HDI Interface Schema Configuration screen:

    Figure 5-22 HDWF Interface HDI Schema Configuration

    Description of Figure 5-22 follows
    Description of "Figure 5-22 HDWF Interface HDI Schema Configuration"

    1. Enter the HDWF interface HDI schema user name.

    2. Enter the HDWF interface HDI schema user password.

    3. Click Next.

  10. In the HDWF Interface Codes Data Configuration screen:

    Figure 5-23 HDWF Interface Codes Data Configuration

    Description of Figure 5-23 follows
    Description of "Figure 5-23 HDWF Interface Codes Data Configuration"

    1. Overwrite the HDI seed data.

      Select No to preserve your seed data in HDI Code Repository tables (recommended).

      Select Yes if you want to overwrite your seed data with Oracle's seed data in HDI Code Repository tables.

    2. Click Next.

  11. In the HDWF Exadata Configuration screen:

    Figure 5-24 HDWF Exadata Configuration

    Description of Figure 5-24 follows
    Description of "Figure 5-24 HDWF Exadata Configuration"

    1. Select Yes if HDWF is installed on Exadata database machine.

      Click Next and go to step 12.

    2. Select No if HDWF is not installed on Exadata database machine.

      Click Next and go to step 13.

  12. In the Table Compression Configuration screen:

    Figure 5-25 Table Compression Configuration

    Description of Figure 5-25 follows
    Description of "Figure 5-25 Table Compression Configuration"

    1. Select a table compression mode: Hybrid Columnar Compression (HCC - Query High) or Online Transaction Processing (OLTP).

    2. Click Next.

  13. In the Verify Configuration Parameters screen:

    1. Verify all the configuration parameters listed on this screen before proceeding.

    2. If required, click Back to make changes to your installation settings.

    3. Click Next.

  14. Review the information on the Pre-installation Summary screen, which displays the global settings, the space requirements, and the product to install.

    1. If required, click Back to make changes to your installation settings.

    2. Click Install to continue.

  15. The HDWF installation begins and the Install screen is displayed. OUI copies the files to the HDWF home location and runs the HDWF SQL scripts to create the database.

    The install screen displays the location of the log file that records the results of the installation activities for this session. Note the location of the log file.

    Note:

    The progress bar does not display the installation progress when the database is created using SQLPlus.

    To review the installation progress or monitor the current installation activity, view the log file created at the location displayed on the Install screen.

  16. After the installation is complete, the End of Installation screen is displayed.

    This screen displays:

    • Successfully Installed HDWF 6.1, if the installation is successful.

    • Location of the HDWF installer log file: <HDWF_ Home>\oracle.hsgbu.hdwf\oracle\hdwf61\install\logs\ folder.

    • Location of the installation report: <HDWF_ Home>\oracle.hsgbu.hdwf\oracle\hdwf61\install\rpt\ folder.

    Note:

    Review the installation report and save it in a secure location for future use.
  17. Click Exit after reviewing the installation information.

    At the confirmation prompt, click Yes to exit the HDWF Installer.

  18. Review the generated installation log files for errors. For details, see Section 5.2.

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

5.4 HDWF Remote Installation

The HDWF installer can also be used to remotely install HDWF 6.1. For example, the installer can be run from a Linux 64-bit OS and installed on a remote system.

The installer creates the following directory structure on the system where it is run.

hdwf_home

/oracle.hsgbu.hdwf

/oracle

/hdwf61

/install

/scripts (HDWF SQL scripts)

/logs (Installation log files)

/rpt (Installation report files)

hdwf_home refers to the root installation directory of the Oracle HDWF product. Create an empty directory for this purpose.

Prerequisites

In addition to the prerequisites mentioned in Chapter 4, the following are also applicable for this installation option.

  1. Make sure the following are available on the client machine:

    • Oracle Unix or Linux 64-bit OS

    • Oracle Database 11.2.0.4 client

  2. Follow the steps in Section 5.1.3 to set up the installer to run on a Linux 64-bit operating system.

5.4.1 Fresh Remote Installation of HDWF 6.1

Perform the following steps:

  1. The Welcome screen appears on running the installer. Click Next to continue the installation.

    Figure 5-26 Welcome Screen

    Description of Figure 5-26 follows
    Description of "Figure 5-26 Welcome Screen"

  2. In the Select Installation Type screen:

    Figure 5-27 Select Installation Type

    Description of Figure 5-27 follows
    Description of "Figure 5-27 Select Installation Type"

    1. Select Complete to perform a fresh installation of HDWF 6.1.

    2. Click Next.

  3. In the Specify Home Details screen:

    Figure 5-28 Specify Home Details

    Description of Figure 5-28 follows
    Description of "Figure 5-28 Specify Home Details"

    1. Specify the root installation directory of HDWF 6.1.

      Note:

      Use lowercase for directory names, for all platforms, to be created and used by the installer.
    2. Click Next.

  4. In the Verify Installation Prerequisites screen, verify the prerequisites mentioned before installation, and click Next.

    Figure 5-29 Verify Installation Prerequisites

    Description of Figure 5-29 follows
    Description of "Figure 5-29 Verify Installation Prerequisites"

  5. In the Oracle Home Configuration screen:

    Figure 5-30 Oracle Home Configuration

    Description of Figure 5-30 follows
    Description of "Figure 5-30 Oracle Home Configuration"

    1. Enter the ORACLE_HOME location. This refers to the location of the Oracle database installation on the machine where the installer is run.

    2. Click Next.

  6. In the HDWF Database Configuration screen:

    Figure 5-31 HDWF Database Configuration

    Description of Figure 5-31 follows
    Description of "Figure 5-31 HDWF Database Configuration"

    The database details mentioned in this step correspond to the details of the database server (remote machine) where HDWF will be installed.

    1. Enter the database server host name where the HDWF schema will be created.

    2. Enter the database server port number.

    3. Enter the database system user password.

    4. Enter the HDWF database service name.

    5. Click Next.

  7. In the HDWF Tablespace Encryption Configuration screen:

    Figure 5-32 HDWF Tablespace Encryption Configuration

    Description of Figure 5-32 follows
    Description of "Figure 5-32 HDWF Tablespace Encryption Configuration"

    1. Encrypting the tablespace requires prerequisites to be set.

      If the pre-requisites are set for tablespace encryption, select Yes, else select No.

    2. Click Next.

  8. In the HDWF HDM Tablespace and Schema Configuration screen:

    Figure 5-33 HDWF HDM Tablespace and Schema Configuration

    Description of Figure 5-33 follows
    Description of "Figure 5-33 HDWF HDM Tablespace and Schema Configuration"

    1. Enter the HDWF HDM tablespace name.

    2. Enter the HDWF HDM tablespace initial size in MB.

    3. Enter the HDWF HDM temporary tablespace name created as part of prerequisites.

      Note:

      The installer does not create the temporary tablespace. It should be created as part of the prerequisite steps or the default temp tablespace can be used.
    4. Enter the HDWF HDM schema user name.

    5. Enter the HDWF HDM schema user password.

    6. Click Next.

  9. In the HDWF HDM Tablespace and Schema Configuration screen:

    Figure 5-34 HDWF HDM Tablespace and Schema Configuration

    Description of Figure 5-34 follows
    Description of "Figure 5-34 HDWF HDM Tablespace and Schema Configuration"

    1. Enter the location of the HDWF data file in the machine or ASM specific syntax including the trailing slash.

      This is the directory on the database server where the data files for the application are created during the installation.

      This value is not validated and must be entered in the machine or ASM specific syntax including the trailing slash.

      For example,

      Unix: /u01/oradata/dbname/

      ASM: +DATA_EX02/hashas01/datafile/

      Note:

      • ASM location must always start with + and should be entered with + as shown above.

      • Failure to enter the trailing slash will not stop the installation. However, the data file name will be prefixed with the folder name.

      • The HDWF data file name will be the name of table space entered. For example, if the HDWF tablespace name is hdwf_ts, the data file created by the installer will be hdwf_ts.dbf.

    2. Click Next.

  10. In the HDWF Interface HDI Tablespace and Schema Configuration screen:

    Figure 5-35 HDWF Interface HDI Tablespace and Schema Configuration

    Description of Figure 5-35 follows
    Description of "Figure 5-35 HDWF Interface HDI Tablespace and Schema Configuration"

    1. Enter the HDWF interface HDI tablespace name.

    2. Enter the initial size of the HDWF interface HDI tablespace in MB.

    3. Enter the HDWF interface HDI temporary tablespace name created as part of the prerequisites.

      Note:

      The installer does not create the temporary tablespace. It should be created as part of the prerequisites.
    4. Enter the HDWF interface HDI schema user.

    5. Enter the HDWF interface HDI user password.

    6. Click Next.

  11. In the HDWF Interface HDI Tablespace and Schema Configuration screen:

    Figure 5-36 HDWF Interface HDI Tablespace and Schema Configuration

    Description of Figure 5-36 follows
    Description of "Figure 5-36 HDWF Interface HDI Tablespace and Schema Configuration"

    1. Enter the location of the HDWF interface data file in the machine or ASM specific syntax including the trailing slash.

      This is the directory on the database server where the data files for the application are created during the installation.

      This value is not validated and must be entered in the machine or ASM specific syntax including the trailing slash.

      For example,

      Unix: /u01/oradata/dbname/

      ASM: +DATA_EX02/hashas01/datafile/

      Note:

      • ASM location must always start with + and should be entered with + as shown above.

      • Failure to enter the trailing slash will not stop the installation. However, the data file name will be prefixed with the folder name.

      • The HDWF data file name will be the name of interface tablespace entered. For example, if the HDWF interface tablespace name is hdwf_int_ts, the data file created by the installer is hdwf_ int_ts.dbf.

    2. Click Next.

  12. In the HDWF Exadata Configuration screen:

    Figure 5-37 HDWF Exadata Configuration

    Description of Figure 5-37 follows
    Description of "Figure 5-37 HDWF Exadata Configuration"

    1. Select Yes if HDWF is installed on an Exadata database machine.

      Click Next and go to step 13.

    2. Select No if HDWF is not installed on an Exadata database machine.

      Click Next and go to step 14.

  13. In the Table Compression Configuration screen:

    Figure 5-38 Table Compression Configuration

    Description of Figure 5-38 follows
    Description of "Figure 5-38 Table Compression Configuration"

    1. Select a table compression mode: Hybrid Columnar Compression (HCC - Query High) or Online Transaction Processing (OLTP).

    2. Click Next.

  14. In the Verify Configuration Parameters screen:

    1. Verify all the configuration parameters listed on this screen before proceeding.

    2. If required, click Back to make changes to your installation settings.

    3. Click Next.

  15. Review the information on the Pre-installation Summary screen, which displays the global settings, the space requirements, and the product to install.

    1. If required, click Back to make changes to your installation settings.

    2. Click Install to continue.

  16. The HDWF installation begins and the Install screen is displayed. OUI copies the files to the HDWF home location and runs the HDWF SQL scripts to create the database.

    The install screen displays the location of the log file that records the results of the installation activities for this session. Note the location of the log file.

    Note:

    The progress bar does not display the installation progress when the database is created using SQLPlus.

    To review the installation progress or monitor the current installation activity, view the log file created at the location displayed on the Install screen.

  17. After the installation is complete, the End of Installation screen is displayed.

    This screen displays:

    • Successfully installed HDWF 6.1, if the installation is successful.

    • Location of the HDWF installer log file - <HDWF_ Home>\oracle.hsgbu.hdwf\oracle\hdwf61\install\logs\ folder.

    • Location of the installation report - <HDWF_ Home>\oracle.hsgbu.hdwf\oracle\hdwf61\install\rpt\ folder.

    Note:

    Review the installation report and save it in a secure location for future use.
  18. Click Exit after reviewing the installation information.

    At the confirmation prompt, click Yes to exit the HDWF Installer.

  19. Review the generated installation log files for errors. For details, see Section 5.2.

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

5.4.2 Remote HDWF Upgrade from Version 6.0 to 6.1

Perform the following steps:

  1. The Welcome screen appears on running the installer. Click Next to continue the installation.

    Figure 5-39 Welcome Screen

    Description of Figure 5-39 follows
    Description of "Figure 5-39 Welcome Screen"

  2. In the Select Installation Type screen:

    Figure 5-40 Select Installation Type

    Description of Figure 5-40 follows
    Description of "Figure 5-40 Select Installation Type"

    1. Select Upgrade to upgrade from HDWF 6.0 to 6.1.

    2. Click Next.

  3. In the Specify Home Details screen:

    Figure 5-41 Specify Home Details

    Description of Figure 5-41 follows
    Description of "Figure 5-41 Specify Home Details"

    1. Select the root installation directory of HDWF 6.1.

      Note:

      Use lowercase for directory names, for all platforms, to be created and used by the installer.
    2. Click Next.

  4. In the Verify Installation Prerequisites screen, verify the prerequisites mentioned before installation, and click Next.

    Figure 5-42 Verify Installation Prerequisites

    Description of Figure 5-42 follows
    Description of "Figure 5-42 Verify Installation Prerequisites"

  5. In the Oracle Home Configuration screen:

    Figure 5-43 Oracle Home Configuration

    Description of Figure 5-43 follows
    Description of "Figure 5-43 Oracle Home Configuration"

    1. Enter the ORACLE_HOME location. This refers to the location of the Oracle database installation on the machine where the installer is run.

    2. Click Next.

  6. In the HDWF Database Configuration screen:

    Figure 5-44 HDWF Database Configuration

    Description of Figure 5-44 follows
    Description of "Figure 5-44 HDWF Database Configuration"

    1. Enter the database server host name where the HDWF Schema will be created. Click Next.

    2. Enter the database server port number.

    3. Enter database server system user password.

    4. Enter the HDWF database service name.

    5. Click Next.

  7. In the HDWF HDM Schema Configuration screen:

    Figure 5-45 HDWF HDM Schema Configuration

    Description of Figure 5-45 follows
    Description of "Figure 5-45 HDWF HDM Schema Configuration"

    1. Enter the HDWF HDM schema user name.

    2. Enter the HDWF HDM schema user password.

    3. Click Next.

  8. In the HDWF HDM Codes Data Configuration screen:

    Figure 5-46 HDWF HDM Codes Data Configuration

    Description of Figure 5-46 follows
    Description of "Figure 5-46 HDWF HDM Codes Data Configuration"

    1. Overwrite the HDWF HDM seed data.

      Select No to preserve your seed data in HDI Code Repository tables (recommended).

      Select Yes if you want to overwrite your seed data with Oracle's seed data in HDI Code Repository tables.

    2. Click Next.

  9. In the HDWF Interface HDI Schema Configuration screen:

    Figure 5-47 HDWF Interface HDI Schema Configuration

    Description of Figure 5-47 follows
    Description of "Figure 5-47 HDWF Interface HDI Schema Configuration"

    1. Enter the HDWF interface HDI schema user name.

    2. Enter the HDWF interface HDI schema user password.

    3. Click Next.

  10. In the HDWF Interface Codes Data Configuration screen:

    Figure 5-48 HDWF Interface Codes Data Configuration

    Description of Figure 5-48 follows
    Description of "Figure 5-48 HDWF Interface Codes Data Configuration"

    1. Overwrite the HDWF Interface HDI seed data.

      Select No to preserve your seed data in HDI Code Repository tables (recommended).

      Select Yes if you want to overwrite your seed data with Oracle's seed data in HDI Code Repository tables.

    2. Click Next.

  11. In the HDWF Exadata Configuration screen:

    Figure 5-49 HDWF Exadata Configuration

    Description of Figure 5-49 follows
    Description of "Figure 5-49 HDWF Exadata Configuration"

    1. Select Yes if HDWF is installed on Exadata database machine.

      Click Next and go to step 12.

    2. Select No if HDWF is not installed on Exadata database machine.

      Click Next and go to step 13.

  12. In the Table Compression Configuration screen:

    Figure 5-50 Table Compression Configuration

    Description of Figure 5-50 follows
    Description of "Figure 5-50 Table Compression Configuration"

    1. Select a table compression mode: Hybrid Columnar Compression (HCC - Query High) or Online Transaction Processing (OLTP).

    2. Click Next.

  13. In the Verify Configuration Parameters screen:

    1. Verify all the configuration parameters listed on this screen before proceeding.

    2. If required, click Back to make changes to your installation settings.

    3. Click Next.

  14. Review the information on the Pre-installation Summary screen, which displays the global settings, the space requirements, and the product to install.

    1. If required, click Back to make changes to your installation settings.

    2. Click Install to continue.

  15. The HDWF installation begins and the Install progress screen is displayed. OUI copies the files to the HDWF Home location, and runs the HDWF SQL scripts to create the database.

    The install screen displays the location of the log file that records the results of the installation activities for this session. Note the location of the log file.

    Note:

    The progress bar does not display the installation progress when the database is created using SQLPlus.

    To review the installation progress or monitor the current installation activity, view the log file created at the location displayed on the Install screen.

  16. After the installation is complete, the End of Installation screen is displayed.

    This screen displays:

    • Successfully installed HDWF 6.1, if the installation is successful.

    • Location of the HDWF installer log file - <HDWF_ Home>\oracle.hsgbu.hdwf\oracle\hdwf61\install\logs\ folder.

    • Location of the installation report - <HDWF_ Home>\oracle.hsgbu.hdwf\oracle\hdwf61\install\rpt\ folder.

      Note:

      Review the installation report and save it in a secure location for future use.
  17. Click Exit after reviewing the installation information.

    At the confirmation prompt, click Yes to exit the HDWF Installer.

  18. Review the generated installation log files for errors. For details, see Section 5.2.

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

5.5 Post Installation Data Migration when Upgrading from HDWF 6.0 to 6.1

The following data migration scripts are not executed as a part of the upgrade installation by the HDWF 6.1 OUI installer.

You must review these scripts and execute them after the HDWF upgrade installation is complete.

You may select any integration ID pattern for new records that will be populated in HDI_APPT_SVCPRV. To version old records that are migrated to HDI_APPT_SVCPRV from HDI_APPT or HDI_SURGCL_CASE_APPT, use the old integration ID pattern in HDI_APPT_SVCPRV.