Oracle® Clinical Installation Guide Release 5.0.1 E36499-02 |
|
|
PDF · Mobi · ePub |
This chapter describes how to install Oracle Database and the Oracle Clinical Database Server on a Windows computer.
Note:
Installing Oracle Clinical with Oracle Real Application Clusters (RAC) is not supported on Windows.Section 3.1, "Setting Up the opapps User Account and the oclsascr User Group"
Section 3.4, "Installing the Oracle Clinical Database Server"
If you are upgrading to Oracle Clinical, see Chapter 11.
For database tier system requirements, see the Oracle Database 11g Release 2 (11.2) Installation Guide for your operating system.
Note:
If you install the Oracle Clinical database on Windows and use SAS, you must also install SAS on Windows; see Chapter 9, "Setting Up SAS".Critical Patch Updates See Section 1.9, "Applying Oracle Critical Patch Updates."
Before you install Oracle Clinical Database Server, create the following user group and account:
oclsascr — The group that controls access to the files Oracle Clinical generates for SAS. This user group is required if you use SAS integrated with Oracle Clinical.
opapps — The operating system account that owns Oracle Clinical and that runs the Parameterized Submission (PSUB) process. This account is required.
The oclsascr user group controls access to the files Oracle Clinical generates on the database server for SAS, including data extract files, which contain patient data.
Use Windows Administrative Tools to create a new Global Group in your Domain with the name oclsascr.
You must create the operating system account that owns Oracle Clinical. This account also has the privileges to run the parameterized submission (PSUB) service RXCPSDPS and the PSUB Launcher (PSLAUNCH).
The user name for the account is opapps
, with a home directory named opapps
. For example:
/home/opapps
The Oracle Clinical documentation uses the variable OPA_HOME to refer to this location on an Oracle Clinical Database Server.
Using Windows administrative tools, assign opapps to the following user groups:
administrator
oclsascr
Note:
In Oracle Clinical 5.0, unlike previous releases, no other accounts need to be added to the oclsascr user group.In the Start menu, navigate to Administrative Tools.
Open Administrative Tools, and then Local Security Policy.
Expand the Local Policies folder and then select Security Options.
Set the following values:
Set Network security: Restrict NTLM: Outgoing NTLM traffic to remote servers to Allow All.
Set Network security: Restrict NTLM: Incoming NTLM traffic to Allow All.
Set Network Security:Allow Local System to use Computer identity for NTLM to Enabled.
Set Network Security:Allow Local System NULL session fallback to Enabled.
Enforce the policy by opening a command prompt and entering: gpupdate/force
This section describes the following tasks:
Section 3.3.1, "Install Oracle Database 11.2.0.4 Enterprise Edition"
Section 3.3.2, "Install Oracle Database 11g Release 2 Examples"
To install Oracle Database 11.2.0.4:
Locate the Oracle Database software in the staging area on the database server where you downloaded it; see Section 1.5, "Downloading and Extracting the Software."
It is shipped as patch 13390677. This patch contains the entire Oracle Database product.
Install Oracle Database 11.2.0.4. For instructions see the patch readme file and Oracle Database 11g Release 2 (11.2) Installation Guide for your operating system at http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame=
Choose to install the Enterprise Edition.
Oracle Database Examples includes the following items:
Oracle JDBC Development Drivers (required)
Oracle Database Examples (required)
Oracle Product Demonstrations (optional)
Note:
You do not need to install any of the sample schemas. They are not required for either Oracle Clinical or Oracle Thesaurus Management System. You can add them later if you change your mind.To install Oracle Database Examples:
Extract p13390677_112040_platform_6of7.zip in the examples
directory.
Start Oracle Universal Installer from the examples
directory and install Oracle Database Examples.
Accept all the default values during the installation.
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 (see Section 3.4.5 for details)
Installs the Oracle Clinical Database Server
Sets permissions on the directories
Creates the environment setup files
Modifies the environment setup files
Creates the database Oracle Wallet
Creates the directory for storing the SAS files
You must have the following information ready to enter in the Installer screens:
Home Details: The ORACLE_HOME location, which is where you installed Oracle Database 11.2.0.4; for example:
drive:\app\oracle\product\11.2.0.4\dbhome
OPA Home: The directory where Oracle Clinical will be installed; Oracle recommends:
drive:\opapps
SAS View: The directory where Oracle Clinical will generate SAS views; Oracle recommends:
drive:\opapps\sas_view
Oracle Wallet location and password. The Installer uses these to create the database Wallet in the location you specify. The database Wallet stores the password for two accounts: .
the OCPSUB proxy account, which is used for database access for parameterized submission (PSUB) jobs
the RXC_DISC_REP account used only in disconnected replication—however you must insert this one manually (if needed); see Section 4.4.3, "Set Up Disconnected Replication."
If you have already created a Wallet through a previous installation of Oracle Clinical 5.0 or higher, you do not need to do this again.
Location for the secret store. It must be accessible to the opapps user and it must be different from the Oracle Wallet location.
Log in to the server computer using the opapps account.
In the staging area, locate the directory where you downloaded and extracted Oracle Clinical (see Section 1.5, "Downloading and Extracting the Software").
Run the following file:
Disk1\install\setup.exe
The Installer opens to the Welcome screen.
Note:
See "Using the Silent Installer" 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.In the Select a Product to Install page, select OC Server for Windows.
Follow the instructions on the installation screens, providing the information you assembled in Section 3.4.1, "Gather Required Information".
At the end of the installation, the installer screen displays the:
Location of the OPA_HOME directory
Name of the code environment
Make note of this information because you need it for several post-installation tasks.
The log files are located at:
\Oracle\Inventory\logs
For example:
C:\Program Files\Oracle\Inventory\logs
The Installer creates the following directory structure:
OPA_HOME \bin \xmltemp \oc \501 \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.
This section describes the tasks you perform to complete the installation of Oracle Clinical Database Server on a Windows computer.
By default, a Windows installation grants read and write privileges to the XMLTEMP database folder to everyone. To reduce security risks, you should limit permissions on the XMLTEMP folder for all Windows Database Server installations.
To limit permissions on the XMLTEMP folder:
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.
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.
During installation of the server code, the Installer creates the opa_settings.bat file in the following directory:
opapps\bin
See Section 1.8, "Choosing a Character Set" for important information, and see the Oracle Clinical Administrator's Guide for a list of the settings and for information about changing, adding, and verifying values.
Note:
NLS_DATE_FORMAT must be set to DD-MON-RRRR. It is possible to override this setting for display in RDC Onsite, the Patient Data Report, and Oracle Clinical data entry, but the setting in opasettings.bat must be DD-MON-RRRR.