1. Installation Guide
  2. Database Tier
  3. Install Oracle Clinical Database Components on Windows
  4. Install Oracle Clinical Database Objects

Install Oracle Clinical Database Objects

To add Oracle Clinical database objects to this database, follow the instructions as given here:

Parent topic: Install Oracle Clinical Database Components on Windows

Customize the Installation

Before you install database objects, you may want to modify some of the default SQL scripts used by the Installer.

  • Edit the Tablespace Size Scripts: The Installer creates several new tablespaces with default sizes. To create larger databases, you can edit two scripts. The default value is an autoextend of 1MB and an unlimited maximum size.

    To create larger databases in Windows, edit the following scripts:

    OPA_HOME\oc\522\install\opadba2.sql

    OPA_HOME\oc\522\install\rxcdba2.sql

  • Edit the User Account Creation Script: The Installer prompts to create accounts in this database. If you select Yes, the Installer runs a script that creates default guest accounts.

    Before running the Installer, edit the rxcdba4.sql script to customize the accounts that get created and their default settings:

    OPA_HOME/oc/522/install/rxcdba4.sql

    See the Oracle Clinical Administrator's Guide for more information about enrolling users.

  • Create a Secret Store Directory

    Create a directory that is accessible to the opapps user and different from the Oracle Wallet location.

    Example location: /pharm/home/opapps/sec_store/db_name

    The Installer fails if this directory is not created before running the Installer.

Parent topic: Install Oracle Clinical Database Objects

Check for an ORA-29548 Error

  1. Log in to the server computer.
  2. Set environment variables:
    set p1=database_name
set p2=522
opa_setup
  3. Connect to SQL*Plus as the SYS user:

    Doc bug 28549148

    sqlplus sys/password as SYSDBA
  4. Run the following command to check for the ORA-29548 error:
    select dbms_java.get_jdk_version() from dual;

    If no error appears and the command retrieves the JDK version, skip to Gather Required Information.

    If you see the following error, continue with the next step to fix it:

    ERROR at line 1:
ORA-29548: Java system class reported: release of classes.bin in the database
does not match that of the oracle executable
  5. To correct the ORA-29548 error, run the following script:
    start update_javavm_db.sql

Parent topic: Install Oracle Clinical Database Objects

Gather Required Information

Have the following information ready to enter in the Installer.

Note:

You must install the Oracle Clinical database server before you install or upgrade the Oracle Clinical database.

  1. Home Details: The OPA_HOME location where you installed Oracle Database 12c Release R2 (12.1.0.2) or ORACLE_HOME location where you installed Oracle Database 19c (19.3.0.0).

    For example:

    • For Oracle Database 12c: Drive:\app\oracle\product\12102
    • For Oracle Database 19c: app\oracle\product\19.0.0\dbhome_1
  2. OPA Home: the directory where Oracle Clinical will be installed; Oracle recommends:
    /pharm/home/opapps
  3. SAS View: the directory where Oracle Clinical will generate SAS views; Oracle recommends:
    • UNIX: $OPA_HOME/sas_view
    • Windows: %OPA_HOME%\sas_view

    Note:

    The upgrade installer does not prompt for this value.
  4. Service name for the database to be installed
  5. Know if you plan to use either Automatic Storage Management (ASM) or Real Application Clusters (RAC). This affects the Installer behavior for validating tablespaces.
  6. Location for tablespace datafiles. You can change the default sizes by editing the script before running the Installer; see Customize the Installation.
  7. Location and password for the Wallet created during Oracle Clinical database server installation to store credentials for OCPSUB and RXC_DISC_REP.
  8. You will need to enter passwords for the following:
    • SYS
    • SYSTEM
    • RXC_MAA
    • RXC_PD
    • RXC_REP
    • RXC_DISC_REP
    • OPA
    • RXC
    • TMS
    • RXA_DES
    • RXA_LR
    • OCPSUB
    • RXA_WS
    • RDC_MIDTIER_PROXY

      Note:

      When you upgrade a database, the Installer does not prompt for the following passwords. For new installations, it does prompt for the following passwords.
    • RXA_READ
    • RXA_RAND
    • RXA_ACCESS
    • OPS$OPAPPS

      Note:

      For information on changing the passwords for these accounts on a regular basis to avoid expiration, see the Oracle Clinical Administrator's Guide.
  9. A database seed number between 1 and 99. Each database in an Oracle Clinical installation (or group of databases that are replicating with each other) must have a unique seed starting number.
  10. Database host name and port number
  11. Global library code. There can be only one Global Library location. If you have only one database, this value should be the same as the database host name. If you are using Oracle Clinical replication and have multiple databases, enter the host name for the database designated as the Global Library location.
  12. Location of the secret store folder you created in Create a Secret Store Directory.

Parent topic: Install Oracle Clinical Database Objects

Start Installing the Oracle Clinical Database

Note:

See Use the Silent Installer (Optional) for instructions for running the Installer as a file with pre-entered parameter values.

Note:

Although there is a button for deinstalling products on the Welcome screen, Oracle does not support using the Installer to deinstall Oracle Clinical or Oracle Clinical Remote Data Capture (RDC) Onsite.
  1. Log in to the server computer using the opapps account.
  2. In the staging area, locate the directory where you downloaded and extracted Oracle Clinical (see Download the Software).
  3. Run the following file as an administrator:
    Disk1\install\setup.exe

    The Installer opens to the Welcome screen.

    Note:

    See Use the Silent Installer (Optional) for instructions for running the Installer as a file with pre-entered parameter values.

    Note:

    Although there is a button for deinstalling products on the Welcome screen, Oracle does not support using the Installer to deinstall Oracle Clinical or Oracle Clinical Remote Data Capture (RDC) Onsite.
  4. In the Select a Product to Install page, select OC Database Install 5.2.2.0.x.
  5. Follow the instructions on the installation screens, providing the information you assembled in Gather Required Information.

Parent topic: Install Oracle Clinical Database Objects

Review the Installation Log Files

During the installation of an Oracle Health Sciences component, the Oracle Universal Installer generates a log file named installActions.log. Earlier files have a timestamp appended to the name.

  1. Review the generated installation log files located at:
    \Oracle\Inventory\logs

    For example:

    C:\Program Files\Oracle\Inventory\logs

  2. Check the log files for error messages and invalid objects.
    • oclinst_database_service.log
    • reall_database_service.log
    • oclconfig_database_service.log
    • flt_seeddata_database_service_timestamp.log
    • html_dialg_templ_database_service_timestamp.log
    • html_blob_seeddata_database_service_timestamp.log
    • xmlp_clob_seeddata_database_service_timestamp.log
    • xml_clob_seeddata_database_service_timestamp.log
    • compile_all_invalid_database_service.log
    • load_olsardcstatemachine_jar_database_service.log
    • install_database_service_timestamp.log
    • opaconnectcheck_system_database_service.log

Parent topic: Install Oracle Clinical Database Objects