Upgrade the Oracle Clinical Database Server
This section describes how to install and set up the Oracle Clinical database server.
The Oracle Universal Installer performs the following operations:
- Creates the Oracle Clinical directory structure
- Installs the Oracle Clinical database server
- Sets permissions on the directories
- Creates the environment setup files
- Modifies the environment setup files
- Creates the Oracle Wallet to store credentials for OCPSUB and RXC_DISC_REP
- Creates the directory for storing the SAS files
For more information, see:
- Gather Required Information on Oracle Clinical Database Server for Windows
- Upgrade the Oracle Clinical Database Server Software
- Review the Log Files
- Oracle Clinical Database Server Directory Structure for Windows
- Perform Post-Upgrade Tasks
Parent topic: Upgrade the Oracle Clinical Database Server on Windows
Gather Required Information on Oracle Clinical Database Server for Windows
You must have the following information ready to enter in the Installer screens:
Parent topic: Upgrade the Oracle Clinical Database Server
Upgrade the Oracle Clinical Database Server Software
Parent topic: Upgrade the Oracle Clinical Database Server
Oracle Clinical Database Server Directory Structure for Windows
The Installer creates the following directory structure:
OPA_HOME \bin \xmltemp \oc \54 \bin (Executables) \dcd (Data Collection Definition) \des (Design) \dm (Data Management) \dx (Data Extract) \glib (Global Library) \install (Install and upgrade scripts) \log (PSUB log files) \lr (Lab Ranges) \patch (Patches to Oracle Clinical) \pd (Procedure Definition) \psub (Parameterized Submission process) \release (Server code release marker) \tools (Miscellaneous tools)
Note that OPA_HOME refers to the root installation directory of the Oracle Health Sciences products, which were formerly known as Oracle Pharmaceutical Applications (OPA). You specify the root installation directory when you install the Oracle Clinical database server. Typically, you specify the path to the opapps login directory, for example, drive
:\opapps.
Parent topic: Upgrade the Oracle Clinical Database Server
Perform Post-Upgrade Tasks
To complete the upgrade of Oracle Clinical database server on a Windows computer, perform the following tasks:
Parent topic: Upgrade the Oracle Clinical Database Server
Limit Permissions on the XMLTEMP Folder
By default, a Windows installation grants read and write privileges to the XMLTEMP database folder to everyone. To reduce security risks, limit permissions on the XMLTEMP folder for all Windows database server installations.
- Use Windows Explorer to locate the XMLTEMP folder in the OPA_HOME directory.
- Right-click on the XMLTEMP folder, and then select Properties from the menu.
- Click the Sharing tab, then click Advanced Sharing.
- Select the Share this folder check box to enable sharing with other users on your network.
- Click Permissions.
- Give Read and Write (Change) permissions to user
oracle
. - Click OK to save your changes and close the Permissions dialog box.
- Click OK to save your changes and close the Advanced Sharing dialog box.
- Click Close to close the Properties dialog box.
Parent topic: Perform Post-Upgrade Tasks
Review the opa_settings.bat File
On Windows systems, configurations are defined in the opa_settings.bat file. This file contains the commands to set environment variables at startup and execution of the PSUB service.
Parent topic: Perform Post-Upgrade Tasks