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 19.3 download the Linux installation guide at https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/index.html">>https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/index.html
.
Download from the Oracle Software Delivery Cloud at https://edelivery.oracle.com
.
Oracle Healthcare Data Repository 8.1 requires:
Oracle Database Enterprise Edition
Oracle Database Client
Oracle Database Global Service Manager
Oracle Database Grid Infrastructure (Required for RAC)
To set up HDR 8.1 on a new database machine, you need to do the following:
Perform a backup of your existing HDR 7.x schemas for CTB and HCT. Export the CTB and HCT schemas to a dump.
Copy the dump files to new database machine.
Create the following tablespaces on the HDR 8.1 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).
Create the HCT and CTB schema users on the HDR 8.1 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;
Run CREATE OR REPLACE DIRECTORY HDR_DMP_DIR as '<path>'
to create the HTB_DUMP_DIR directory on the target HDR 8.1 Oracle database where the HDR 7.x dump file is located.
Import the HCT objects from HDR 7.x to the target HCT schema.
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.
Follow instructions in the Oracle Database Installation Guide, making selections appropriate for Oracle Healthcare Data Repository 8.1 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.1 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
or https://docs.oracle.com/en/database/oracle/oracle-data-access-components/19.3/livsc/index.html
.
During installation of the database software (called "binaries" in the installation guide) the following selections are supported or required with Oracle Healthcare Data Repository 8.1:
Oracle Partitioning (Required)
Oracle Real Application Clusters (RAC) (Recommended)
Oracle Advanced Compression (Recommended)
Note:
Refer to the Oracle Database Installation Guide to learn how to configure advanced options that are applicable to the HDR installation process.When you configure the database, select the following options:
Character Set
ALT32UTF8 is recommended.
Automatic Memory Management
Oracle JVM
Oracle Text
Oracle Database Examples
Note:
Oracle Text, Java Virtual Machine (JVM), and Oracle XML DB are configured automatically if you select a general purpose template.