2 Install Oracle Database

2.1 Get the Oracle Database 12.2.1.2.0 and 12.1.0.2.0 installation guide

• For the Oracle Database 12.2.0.1.0 download the Linux installation guide at https://docs.oracle.com/database/122/LADBI/toc.htm.

  For the Oracle Database 12.1.0.2.0 download the Linux installation guide at https://docs.oracle.com/database/121/LADBI/toc.htm">>https://docs.oracle.com/database/121/LADBI/toc.htm.

2.2 Download and extract the Oracle Database software

Download from the Oracle Software Delivery Cloud at https://edelivery.oracle.com.

Oracle Healthcare Data Repository 8.0 requires:

• Oracle Database Enterprise Edition

• Oracle Database Client

• Oracle Database Global Service Manager

• Oracle Database Grid Infrastructure (Required for RAC)

2.3 Set up HDR 8.0 database on a new machine

To set up HDR 8.0 on a new database machine, you need to do the following:

1. Perform a backup of your existing HDR 7.x schemas for CTB and HCT. Export the CTB and HCT schemas to a dump.

   Example 2-1 Schema dump

   expdp system/<password>@<SID> schemas=CTB,HCT exclude=GRANT,USER,STATISTICS,TABLESPACE_QUOTA,DEFAULT_ROLE directory=hdr_dmp_dir dumpfile=<dump file name>.dmp logfile=hdr_dump.log
   

2. Copy the dump files to new database machine.

3. Create the following tablespaces on the HDR 8.0 target database by connecting as the system user:

   • Tablespace for CTB user(CTB_TBS).

   • Tablespace for HCT user(HCT_TBS).

   • Tablespace for Context (CTX_TBS).

   • Tablespace for Indexes (IDX_TBS).

     Example 2-2 Create migration tablespaces

     TABLESPACE <tablespace name>
      
             LOGGING
      
             DATAFILE '<data file path>/hdr_hcttb.dbf'
      
             SIZE <100M>
      
             AUTOEXTEND ON
      
             NEXT <100M> MAXSIZE UNLIMITED
      
             EXTENT MANAGEMENT LOCAL;
     

4. Create the HCT and CTB schema users on the HDR 8.0 target database by connecting as the system user.

   Example 2-3 Create HCT user on HCT_TBS

     ALTER USER HCT QUOTA unlimited ON IDX_TBS;
    
           ALTER USER HCT QUOTA unlimited ON CTX_TBS;
    
           GRANT UNLIMITED TABLESPACE TO HCT;
    
           grant CREATE INDEXTYPE to HCT;  
    
           grant CREATE PROCEDURE to HCT;
    
           grant CREATE SEQUENCE to HCT;
    
           grant CREATE SESSION to HCT;
    
           grant CREATE TABLE to HCT;
    
           grant CREATE TYPE to HCT;
    
           grant CREATE VIEW to HCT;
    
           grant ALTER SESSION to HCT;
    
           grant ANALYZE ANY to HCT;
    
           grant EXECUTE on CTXSYS.ctx_ddl to HCT;
    
           grant Create Any Job to HCT;
    
           grant Create External Job to HCT;
    
           grant Create Job to HCT;
    
           grant Execute Any Class to HCT;
    
           grant Execute Any Program to HCT;
    
           grant Manage Scheduler to HCT;
    
           GRANT CREATE ANY DIRECTORY TO HCT;
   

   Example 2-4 Create CTB user on CTB_TBS

    ALTER USER CTB QUOTA unlimited ON IDX_TBS;        GRANT UNLIMITED TABLESPACE TO CTB;         grant CREATE INDEXTYPE to CTB;          grant CREATE PROCEDURE to CTB;        grant CREATE SEQUENCE to CTB;        grant CREATE SESSION to CTB;        grant CREATE TABLE to CTB;        grant CREATE TYPE to CTB;        grant CREATE VIEW to CTB;        grant CREATE SYNONYM to CTB;        grant ALTER SESSION to CTB;        grant ANALYZE ANY to CTB;        GRANT EXECUTE ON SYS.DBMS_AQIN TO CTB;        GRANT EXECUTE ON SYS.DBMS_AQADM TO CTB;        grant Create Any Job to CTB;        grant Create External Job to CTB;        grant Create Job to CTB;        grant Execute Any Class to CTB;        grant Execute Any Program to CTB;        grant Manage Scheduler to CTB;        grant create any directory to CTB;        GRANT CREATE ANY DIRECTORY TO CTB;
   

5. Run CREATE OR REPLACE DIRECTORY HDR_DMP_DIR as '<path>' to create the HTB_DUMP_DIR directory on the target HDR 8.0 Oracle database where the HDR 7.x dump file is located.

6. Import the HCT objects from HDR 7.x to the target HCT schema.

   Example 2-5 Import HCT objectsto the target schema

   impdp system/<password> exclude=GRANT,USER,STATISTICS,TABLESPACE_QUOTA,DEFAULT_ROLE schemas=hct directory=HDR_DMP_DIR  dumpfile=< HDR7.x dump file name >.dmp logfile=hdr_hct_import.log.
   

7. Import the CTB objects from HDR7.x to the target CTB schema. Run the example script above with HTB replaced by CTB where it applies.

2.4 Install Oracle Database 12.2.1.2.0

Follow instructions in the Oracle Database Installation Guide, making selections appropriate for Oracle Healthcare Data Repository 8.0 as noted in the following sections.

You can configure the database as part of the database software installation or after, using the Database Configuration Assistant (DBCA). Oracle Healthcare Data Repository 8.0 supports installation on either:

• a Container Database (CDB) containing a Pluggable Database (PDB)

• a non-CDB database

For an explanation of which options require an additional license, see the Database Licensing Information User Manual at https://docs.oracle.com/database/122/DBLIC/toc.htm .