| Oracle® Clinical Installation Guide Release 4.6 Part Number A83779-08 |
|
|
View PDF |
| Oracle® Clinical Installation Guide Release 4.6 Part Number A83779-08 |
|
|
View PDF |
This chapter describes how to set up a new Oracle Clinical Database Server on a Windows computer.
Installing the Oracle Clinical Database Server on a Windows computer requires you to complete the following tasks:
If you are installing the Oracle Clinical Database Server on a UNIX computer, see Chapter 2 for the installation instructions.
If you are upgrading to Oracle Clinical 4.6, see Chapter 9.
To support Oracle Clinical Database Server, a Windows computer requires the following version of Oracle Database software:
Oracle Database 11gRelease 11.1.0.6.0 plus Patch Set 1 (11.1.0.7.0), plus individual patchesEnterprise Edition
However, this requirement might change during the life of this document. Before you begin, check My Oracle Support for the latest requirement.
This section describes the following tasks:
Section 3.1.1, "Install Oracle Database 11g Release 11.1.0.6.0"
Section 3.1.2, "Install Oracle Database Examples 11g Release 1"
Section 3.1.4, "Apply Oracle Database 11g Patch Bundle 8451592"
To install Oracle Database 11g Release 11.1.0.6.0:
Insert Disk V14231-01 of the Oracle Clinical 4.6 and Oracle Thesaurus Management System 4.6.1 Media Pack.
Locate the Oracle Database 11g software for Microsoft Windows (32-bit).
Follow the included instructions for installing Oracle Database 11g.
Choose to install the Enterprise Edition option.
Oracle Database Examples, which is required for Oracle Clinical 4.6, includes the following items:
Oracle JDBC Development Drivers
Oracle Database Examples
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 Thesaurus Management System. You can add them later if you change your mind.To install Oracle Database Examples:
Locate the Oracle Database 11g Examples software for Windows on the media pack:
Disk: V18332-01 Path: \patches File: win32_11gR1_examples.zip
Install the software according to the Oracle Database Examples Installation Guide, which is also included on the media pack.
Accept all the default values during the installation.
To apply Patch Set 1 (Patch Set 11.1.0.7.0) to the Oracle Database 11g installation:
Locate the Oracle Database 11g Patch Set 1 software for Windows on the media pack:
Disk: V18332-01 Path: \patches File: p6890831_111070_Win32.zip
Extract the patch zip file to a location that is accessible to the Database Server.
Follow the instructions in the ReadMe file to apply Patch Set 1 to the Oracle Database 11g installation. The ReadMe file is located at the top level of the patch set extraction location.
To apply Patch Bundle 8451592 to the Oracle Database 11g installation:
Locate the Oracle Database 11g Patch Bundle 8451592 software for Windows on the media pack:
Disk: V18332-01 Path: \patches File: p8451592_111070_Win32.zip
Extract the patch zip file to a location that is accessible to the Database Server.
Follow the instructions in the ReadMe file to apply the patch bundle to the Oracle Database 11g installation. The ReadMe file is located at the top level of the patch set extraction location.
Before you install the Oracle Clinical Database Server on a Windows computer, you must create the following user accounts and user groups:
The RXCPROD user account, which is the dedicated PSUB account
The oclsascr user group, which controls access to the files Oracle Clinical generates on the database server
Oracle Clinical processes most batch requests from clients on the server with the Parameterized Submission (PSUB) process. The RXCPROD user account starts the PSUB service for Oracle Clinical databases on this server.
To create and configure the RXCPROD account:
Use Windows Administrative Tools to create a local user account named RXCPROD.
Add RXCPROD to the Power Users local group.
Navigate to the Windows Control Panel.
Double-click Administrative Tools, and then double-click Local Security Policy.
Expand the Local Policies folder, and then select User Rights Assignment.
Give RXCPROD these user rights:
Act as part of the operating system
Adjust memory quotas for a process
Log in as a service
Replace a process level token
The oclsascr user group controls access to the files Oracle Clinical generates on the database server, including data extract files, which contain patient data.
To create and configure the oclsascr user group:
Use Windows Administrative Tools to create a new Global Group in your Domain with the name oclsascr.
Add to the oclsascr user group each account to which you grant access to the server files generated by Oracle Clinical, including the SAS programs and SAS Pass Through Views.
Define a method to control access to the server files generated by Oracle Clinical, including the SAS programs and SAS Pass Through Views.
This section describes how to install and set up the Oracle Clinical 4.6 Database Server on one computer. Perform this task once for each Oracle Clinical Database Server computer.
Note:
Read this section completely before you begin. The Installer prompts you for information you should know before you start.The Oracle Universal Installer performs the following operations:
Creates the Oracle Clinical directory structure (see Section 3.3.1 for details)
Installs the Oracle Clinical Database Server application
Sets permissions on the directories
Creates the environment setup files
Modifies the environment setup files
Creates the directory for storing the SAS files
The Installer creates the following directory structure:
OPA_HOME \bin \xmltemp \oc \46 \bin (Symbolic links to the 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.
You can install the Oracle Clinical 4.6 Database Server component for Windows directly from the Oracle Clinical 4.6 and Oracle Thesaurus Management System 4.6.1 Media Pack.
To begin the installation:
Log in to the server computer using an account with system administrator privileges.
Insert Disk V17174-01 of the Oracle Clinical 4.6 and Oracle Thesaurus Management System 4.6.1 Media Pack.
Locate and execute the setup.exe file:
oc\server_code\win\install\setup.exe
The Installer opens to the Welcome screen.
Proceed with the installation steps in Section 3.3.3, "Attend to the Oracle Clinical 4.6 Database Server Installation Screens."
The Installer acts in two phases. In the first phase, the Installer collects information about your system. During this phase, you can move backward and forward through the screens, revising your entries. During the second phase, the Installer runs the scripts to set up the Oracle Clinical 4.6 software according to the information you provided in the first phase. Attend to the installer's screens as described below.
Click Next to continue the installation. Alternatively, you can click Installed Products to review a list of installed Oracle products.
Enter the ORACLE_HOME location, which is where you installed Oracle Database 11g, in the Destination field.
Note that the value you enter here does not indicate the destination of the Oracle Clinical Database Server software that you are currently installing. You define the location of the installation directory in the "Choose Directory" screen that follows.
Click Next.
Select OC Server for Windows 4.6 and then click Next.
Specify the directory that is the root installation directory of the Oracle Health Sciences products. Typically, you respond with the path to the opapps login directory. For example:
drive:\opapps
where drive is the disk's letter designation and opapps is the directory name.
The Oracle Clinical documentation uses the variable OPA_HOME to refer to this location. The Oracle Health Sciences products were formerly known as Oracle Pharmaceutical Applications (OPA).
Click Next.
Select a location for storing SAS files. The default value is OPA_HOME\sas_view. (For more information, see Chapter 8, "Setting Up SAS.")
Review the destination settings before proceeding. To make changes to the settings, click Back. Otherwise, click Next to continue.
This screen lists the target directories. Note that the Installer only displays ORACLE_HOME in the Destination field. It might differ from your actual directory path.
Click Install.
The Installer copies the files onto the server computer.
This screen displays the location of the OPA_HOME\bin directory. Make note of this location because you need it to complete the installation.
In addition, this screen displays the location of the log file, which records the results of the installation activities. Note the location of this log file so that you can review it when the installation finishes. If there are any errors in the log file, contact Oracle Support.
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.
Click Share this folder 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 Properties dialog box.
The PSUB root directory is the common directory for all Oracle Clinical users' PSUB log directories. For example, if user vsmith's log directory is:
d:\users\vsmith\log then d:\users is the PSUB root directory.
Create a PSUB root directory on the database server or create a new directory to hold user log directories, and make it shareable. (For more information, see the chapter titled "File Viewing" in the Oracle Clinical Administrator's Guide.)
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 process.
During installation of the server code, the Installer creates the opa_settings.bat file in the following directory:
opapps\bin
Edit this file, and change the following assignments, if necessary.
set NLS_DATE_FORMAT=DD-MON-RRRR
NLS_DATE_FORMAT determines the format in which client applications running on the Windows server transfer date information to and from the database. The format must specify the year as RRRR to be Year 2000 compliant.
set NLS_LANG=american_america.utf8
NLS_LANG determines which language setting Oracle uses when it reads and writes values into the database. The NLS_LANG entry for your Oracle AS10gR2 home must be consistent with the NLS_LANG entry for the Oracle Database 11g home and your databases.
In addition, for PSUB to work correctly for a UTF8 character set database, the opa_settings.bat file must have the following setting:
set NLS_LANG=american_america.utf8
If you do not have a UTF8 character set database, you can use these character sets:
american_america.us7ascii
american_america.we8iso8859p1
If you install more than one Oracle Health Sciences product, review Section 1.2, "Choosing a Character Set" for valid character sets with combined products.
Note:
Do not create new databases with the default character set (AL32UTF8) by the Assistant.Oracle publishes a CPU Security Update patch quarterly. Apply the latest CPU Security Update patch approved for the Oracle Health Sciences applications to this computer. Check My Oracle Support to determine the latest version.
In addition, check My Oracle Support to determine if Oracle has released any new patch sets or any individual patches since the publication of this guide.
|
 Copyright © 1996, 2010, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
