4 Installing Oracle Healthcare Data Repository

4.2.1 Create oraInventory directory and file (optional)

If the HDR Installer cannot reuse the default oraInventory location or if you prefer to have a custom oraInventory location, you can:

1. Create an oraInventory directory in your preferred location.

2. Create a file named oraInst.loc and put it in the oraInventory directory.

   The contents of the oraInst.loc file must be:

   inventory_loc=<full_path_of_the_new_oraInventory_location> 
   inst_group=<OS_user_group_name_that_owns_the_new_oraInventory_location>
   

3. When you run the HDR Installer, use the following command instead of the one specified in Section 4.2.2, "Run the HDR database tier Installer".

   Disk1$  ./install/runInstaller -invPtrLoc <full_path_to_the_new_ oraInst.loc file>
   

4.2.2 Run the HDR database tier Installer

The Installer creates the HDR, ETS and HDR_CONFIG schemas and database objects in the HDR, ETS and HDR_CONFIG schemas.

1. Copy HDR_Installer_Linux64.zip folders to the database server machine.

2. Extract the files from HDR_Installer_Linux64.zip to a directory such as /home/hdrinstaller. This location name is not required but it is used in the following step.

3. Navigate to the /hdrinstaller/Disk1 directory using the following command:

   cd /hdrinstaller/Disk1

4. Execute the following script:

   ./runInstaller.sh

   Enter values in the Installer screens. See the following table for details.

   Table 4-1 HDR Oracle Universal Installer screens for the database tier

   Screen	Details
   Welcome	Click Next.
   Select a Product to Install	Select the database tier and click Next.
   Specify Home Details	Name: Enter the name of the HDR Home. Path: Browse to the HDR home. This is the location where the HDR product artifacts are copied. For example: /u01/hdr/product. By default, the Oracle Database home directory path is displayed. Be sure to change the values to the HDR home and its path.
   Database Details	Enter values as follows: Database Host Name: Enter the host name of the database server. Port: Enter the Oracle database port number. Database Service Name: Enter the Oracle database service name. DBA user name: Enter the Oracle system user name. Password: Enter the system user password.
   Choose if want to configure per domain tablespaces	Select an option for the number of tablepaces to configure: Yes. This setting is recommended. It creates different tablespaces for different clinical domains so that storage management becomes easier as the system accumulates large volumes of data over time. No. This option is suitable for HDR installations where the data volume is expecte to be small to medium (a few terabytes). Fewer tablespaces are created.
   HDR Current Data Tablespace	If you are upgrading from an earlier version of HTB/HDR, enter the names of the tablespaces where the latest versions of records are stored for the following types of data. The default tablespace names are displayed. Change them if you use different names: Clinical data tablespace: hdr_cln_tbs Administrative data tablespace: hdr_admin_tbs Financial data tablespace: hdr_fin_tbs Infrastructure data tablespace: hdr_infra_tbs Identification data tablespace: hdr_ident_tbs
   HDR Current Index Tablespace	If you are upgrading from an earlier version of HTB/HDR, enter the names of the tablespaces where indexes for the latest versions of records are stored. The default tablespace names are displayed. Change them if you use different names: Clinical index tablespace: hdr_cln_idx_tbs Administrative index tablespace: hdr_admin_idx_tbs Financial index tablespace: hdr_fin_idx_tbs Infrastructure index tablespace: hdr_infra_idx_tbs Identification index tablespace: hdr_ident_idx_tbs
   HDR Historical Data Tablespace	If you are upgrading from an earlier version of HTB/HDR, enter the names of the tablespaces where indexes for the historical versions of records are stored. The default tablespace names are displayed. Change them if you use different names: Clinical index tablespace: hdr_cln_hist_idx_tbs Administrative index tablespace: hdr_admin_hist_idx_tbs Financial index tablespace: hdr_fin_hist_idx_tbs Infrastructure index tablespace: hdr_infra_hist_idx_tbs Identification index tablespace: hdr_ident_hist_idx_tbs
   Enter Password for HDR schema	Enter and confirm the password for the HDR database user account.
   Choose Password for config schema	Enter and confirm the password for the HDR_CONFIG user account. All static configuration data and seed data of the HDR product are stored in this schema.
   ETS Schema Details	Enter Enterprise Terminology Services details. Default values are displayed for some fields. ETS user password. Enter a password. Confirm password. Reenter the password. ETS default tablespace: ets_data_tbs. Enter the tablespace name where terminology data is stored. ETS context tablespace: ets_ctx_tbs ETS index tablespace: ets_idx_tbs. Enter the tablespace name where terminology indexes are stored. ETS Language: ENUS. Enter the ETS base language code in the form of <Languagecode><CountryCode>.
   Choose Directory for Java Home	Enter or browse to the Java Home location for the ETS Java Scheduler Job programs to run in.
   Summary	Review the settings, then click Install. Any errors during the installation are logged in the files under oraInventory/logs folder. Absolute path of the file will be displayed on the OUI screen.
   End of Installation	Read the message and click Exit.

   
   

4.2.3 Run the HDR middle tier Installer

To install the HDR middle tier, perform the following:

1. Copy HDR_Installer_Linux64.zip to the WebLogic server machine.

2. Extract the files from HDR_Installer_Linux64.zip to a directory such as /home/hdrinstaller. This location name is not required but it is used in the following step.

3. Navigate to the hdrinstaller directory using the following command:

   cd hdrinstaller/Disk1

4. Execute the following script:

   ./runInstaller.sh

   Enter values as required in the Installer screens.

4.4.1 Uninstall database objects

To uninstall the database objects (HDR, ETS and HDR_CONFIG user schemas), execute the following SQL scripts from sqlplus/sqldeveloper as the sys user:

alter session set "_oracle_script"=true; set serveroutput on; declare
     type tbs_name_type is table of varchar2(100);
     tbs_names tbs_name_type;
begin
     begin
         dbms_scheduler.drop_job('HDR_ETS_MAINTENANCE', TRUE);
     exception when others then
         dbms_output.put_line(SQLERRM);
     end;
 
     begin
         dbms_scheduler.drop_job('HDR_ETS_LOADER', TRUE);
     exception when others then
         dbms_output.put_line(SQLERRM);
     end;
 
     begin
         dbms_scheduler.drop_job('HDR_ETS_IMPORTER', TRUE);
     exception when others then
         dbms_output.put_line(SQLERRM);
     end;
 
     begin
dbms_scheduler.drop_program('hdr_ets_maintenance_program');
     exception when others then
         dbms_output.put_line(SQLERRM);
     end;
 
     begin
         dbms_scheduler.drop_program('hdr_ets_loader_program');
     exception when others then
         dbms_output.put_line(SQLERRM);
     end;
 
     begin
         dbms_scheduler.drop_program('hdr_ets_importer_program');
     exception when others then
         dbms_output.put_line(SQLERRM);
     end;
 
     select tablespace_name bulk collect into tbs_names from DBA_TS_QUOTAS where username in ('HDR', 'ETS', 'HDR_CONFIG');
 
     begin
         execute immediate 'drop user HDR cascade';
     exception when others then
         dbms_output.put_line(SQLERRM);
     end;
 
     begin
         execute immediate 'drop user ETS cascade';
     exception when others then
         dbms_output.put_line(SQLERRM);
     end;
 
     begin
         execute immediate 'drop user HDR_CONFIG cascade';
     exception when others then
         dbms_output.put_line(SQLERRM);
     end;
 
     for i in 1..tbs_names.count loop
         begin
             execute immediate 'drop tablespace '||tbs_names(i)||' 
including contents and datafiles';
         exception when others then
             dbms_output.put_line(SQLERRM);
         end;
     end loop;
end;
/

4.4.2 Uninstall the HDR middle tier

To uninstall the HDR middle tier:

1. Stop the hdr_domain and hdr_server node mangers.

2. Delete the hdr_domain folder completely.

3. Edit WebLogic Oracle_Home/domain-registry.xml and remove the entry for hdr_domain.

4. Delete the HDR home directory (that you provided during installation) completely.