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 UNIX computer.
This chapter includes the following topics:
Section 2.2, "Performing Prerequisite Tasks for Installing Oracle Database"
Section 2.5, "Installing the Oracle Clinical Database Server"
If you are upgrading to Oracle Clinical 5.0.1, see Chapter 11. If you are using Oracle Real Application Clusters (RAC), see Section 1.4, "Supported Configurations with Oracle Data Guard and RAC".
For database tier system requirements, see the Oracle Database 11g Release 2 (11.2) Installation Guide for your operating system.
Critical Patch Updates See Section 1.9, "Applying Oracle Critical Patch Updates."
Oracle Clinical Release 5.0.1 is supported with an Oracle Real Applications Cluster (RAC) distributed database installation on UNIX. Oracle recommends:
Configuring a Maximum Availability Architecture (MAA) in which you use Oracle RAC for both your primary and standby database, synchronized using Oracle Data Guard.
Using the Single Client Access Name (SCAN) option. This RAC feature provides a single name for clients to access Oracle databases running in a cluster. The benefit is that the client's connect information does not need to change if you add or remove nodes in the cluster. Having a single name to access the cluster allows clients to use the EZConnect client and the simple JDBC thin URL to access any database running in the cluster, independent of which server(s) in the cluster the database is active. SCAN provides load balancing and failover for client connections to the database. The SCAN works as a cluster alias for databases in the cluster.
SCAN is configured during the installation of Oracle Grid Infrastructure that is distributed with Oracle Database 11g Release2. Oracle Grid Infrastructure is a single Oracle Home that contains Oracle Clusterware and Oracle Automatic Storage Management (ASM). You must install Oracle Grid Infrastructure first in order to use Oracle RAC 11g Release 2.
Oracle Data Guard is included in Oracle Database 11.2.0.4 Enterprise Edition.
See Section 1.4, "Supported Configurations with Oracle Data Guard and RAC".
For more information see:
Grid Infrastructure Installation Guide and the Real Application Clusters Installation Guide, both found at http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame=
Oracle® Database 2 Day + Real Application Clusters Guide 11g Release 2 (11.2) at http://docs.oracle.com/cd/E11882_01/rac.112/e17264/intro_tdprc.htm#TDPRC109
.
Master Note for Real Application Clusters (RAC) Oracle Clusterware and Oracle Grid Infrastructure (My Oracle Support Article ID 1096952.1); see "Finding Information on My Oracle Support".
11gR2 Grid Infrastructure Single Client Access Name (SCAN) Explained (My Oracle Support Article ID 887522.1)
11gR2 Clusterware and Grid Home - What You Need to Know (My Oracle Support Article ID 1053147.1)
Oracle® Data Guard Broker 11g Release 2 (11.2) at http://docs.oracle.com/cd/E11882_01/server.112/e17023/install.htm#DGBKR1300
Search for the list of Oracle Data Guard guides at http://www.oracle.com/pls/db112/search?remark=quick_search&word=data+guard
Oracle® Database High Availability Best Practices 11g Release 2 (11.2) at http://docs.oracle.com/cd/E11882_01/server.112/e10803/toc.htm
To ensure that your platform meets the minimum requirements for installing Oracle Database 11g Release 2 (11.2.0.4) and Oracle Clinical Database Server products, you must perform the following preparatory tasks:
In case you are using Real Application Clusters (RAC) you need to perform these tasks on every machine.
To create the software owner, required groups, and mount points:
Create the software owner and groups:
Create a UNIX user to own the Oracle software. Typically, the user name is oracle.
Create two groups: one is the Oracle Inventory group; the other is the operating system DBA group. Typically, the group names are oinstall and dba, respectively.
Create mount points owned by the oracle user:
Create a software mount point of at least 10 GB.
Create mount points to hold the database files, control files, and log files, respectively.
Test permissions. Ensure that the oracle user can write to the new mount points and all subdirectories.
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
opapps — The operating system account that owns Oracle Clinical and that runs the Parameterized Submission (PSUB) process.
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.
Create a user group named oclsascr
by adding it to the /etc/group
file.
The preferred method for group authentication is that all groups assigned to a user should become the user's default group at login. If this method is acceptable, link the /etc/logingroup
file to the /etc/group
file.
If the /etc/logingroup
file does not exist, create it as a symbolic link to the /etc/group
file; changes in the /etc/group
file automatically reflect in the /etc/logingroup
file.
To create the symbolic link, enter these commands:
% su root
# cd /etc
# ln -s /etc/group /etc/logingroup
If the /etc/logingroup
file already exists with entries, or if it is unacceptable to link it to the /etc/group
file, you must change both the contents of /etc/logingroup
and /etc/group
each time you add a user to the oclsascr
group.
You must create the operating system account that owns Oracle Clinical. This account also has the priviledges to run PSUB jobs. 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.
Assign the following attributes to the opapps account:
Make a shell for this user. For example, make the default shell:
/bin/csh
Make the opapps account a member of two user groups:
oclsascr
The user group that owns the Oracle Inventory. You specified the name of this group during the Oracle Database 11g Release 2 (11.2.0.4) installation. Typically, this user group is oinstall; see Section 2.2.1, "Create Owners, Groups, and Mount Points".
If you do not know the name of this user group, log in as user oracle
and enter the following command:
more /var/opt/oracle/oraInst.loc
The inst_group
parameter defines the name of the user group that owns the Oracle Inventory (oraInventory). The inventory_loc
parameter defines the path to the oraInventory directory.
Neither the oclsascr group nor the inst_group
group has to be the primary group for the opapps account.
The opapps account also runs the PSUB service RXCPSDPS and the PSUB Launcher PSLAUNCH.
The performance of Oracle Database relies on proper tuning of operating system parameters. In addition, if you are creating several Oracle instances, you might have to increase the amount of shared memory and semaphores on the system by setting kernel parameters.
For details, see the "Configure Kernel Parameters" section of the Oracle Database 11g Release 3 Installation Guide for your operating system.
To test that the correct C compiler is installed and that it is accessible:
Log in to the database server as the opapps
user.
Test for the C compiler type:
ls -l `which cc`
where the `
symbols that wrap the command are single back quotes.
Compare your results to the correct responses listed in Table 2-1.
Test that the make
command is accessible:
ls -l `which make`
where the `
symbols that wrap the command are single back quotes.
Compare your results to the correct responses listed in Table 2-2.
Table 2-2 Responses to the 'which make' Command
Operating System | Response | Symbolically Links To |
---|---|---|
Oracle Linux x86-64 |
/usr/bin/make |
|
Oracle Solaris SPARC |
|
|
If you do not get the correct response, you can either add the path to the cc executable or add the make command to the path in the .cshrc file for the opapps user; see Section 2.2.2.2, "Create the opapps Account".
Download and install the latest operating system patches required for Oracle, if necessary. Review the latest platform-specific install bulletins for Oracle Database 11.2.0.4.
This section includes the following topics:
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.
For Windows users: double-click the setup.exe.
For Unix users:
./runInstaller
Accept all the default values during the installation.
For more information about installing software and various Oracle product demonstrations from the Oracle Database Examples media, see the Oracle Database Examples Installation Guide at http://docs.oracle.com/cd/E11882_01/install.112/e24501.pdf
.
After you install Oracle Database 11.2.0.4 and before you install the Oracle Clinical component, you must:
Note:
You might have to perform these instructions whenever you apply an HSGBU-approved Critical Patch Update, or any Oracle software that uses the Oracle Database 11g Release 2 (11.2.0.4) ORACLE_HOME directory.With the Bourne shell, you use the Oracle environment-setting script (oraenv) when granting write access to the ORACLE_HOME directory.
However, the oraenv script gives an error if run by a non-Oracle user. To avoid this error, set the following directory and file permissions:
drwxrwxr-x 18 oracle oinstall 1024 Apr 11 19:11 inventory drwxrwxr-x 3 oracle oinstall 1024 Apr 11 18:29 ContentsXML -rwxrwxrwx 1 oracle oinstall 492 Apr 11 13:15 oraclehomeproperties.xml
Because the Installer checks if the ORACLE_HOME directory exists and if it has write access, you must change the access settings for this directory before you install the Oracle Clinical component.
To grant write access to the Oracle Database 11g Release 2 (11.2.0.4) ORACLE_HOME directory and its contents:
Log in to the server as the oracle
user.
Source the Oracle environment-setting script to define ORACLE_HOME:
For C shell, use coraenv.
For Bourne shell, use oraenv.
These shells are located under your Oracle Database 11g Release 2 (11.2.0.4) installation.
Note that the oraenv script gives an error if run by a non-Oracle user. To avoid this error, see Section 2.4.1, "Change Permissions for Running oraenv Script" for setup instructions.
Grant group users modification access to all files in the ORACLE_HOME directory:
If you receive any warning messages, you can ignore them.
To set the permissions for the Oracle Inventory (oraInventory) directory:
Log in to the server as the oracle
user.
Locate the path for the oraInventory directory. The location is defined in the inventory_loc parameter in the /var/opt/oracle/oraInst.loc file.
For example, suppose you enter:
more /var/opt/oracle/oraInst.loc
The system might return the oraInventory location as:
inventory_loc=/u01/app/oraInventory
Give recursive read and write permission for the oraInventory directory to the group:
chmod -R g+rw /
oraInventory_location
For example:
chmod -R g+rw /u01/app/oraInventory
If you receive any warning messages, you can ignore them.
Modify protections on the oraInventory directory to ensure that the group you set up as the oinstall group has write access:
chmod -R g+w oraInventory
Use oinstall instead of dba because the dba group membership gives you access to databases, which is a security issue. The oinstall group gives you access to the Oracle Inventory.
This section describes how to install and set up the Oracle Clinical Database Server.
The Installer performs the following operations:
Creates the Oracle Clinical directory structure (see Section 2.5.6 for details)
Installs the Oracle Clinical Database Server
Builds the executables
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:
root:app/oracle/product/11.2.0/dbhome
If you are installing in a RAC installation, the names of all RAC nodes where the same product(s) should be installed.
OPA Home: the directory where Oracle Clinical will be installed; Oracle recommends:
/home/opapps
Owner of Oracle Clinical Server Code must be opapps
Location for files oratab, tnsnames; for example: /etc
RXC_USER: the directory where Oracle Clinical will generate SAS views; Oracle recommends:
/home/opapps
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.
To start installing the Database Server software:
Log in to the database server as the opapps
user.
Change the primary group of the opapps account to the group that owns the Oracle Inventory:
Note:
Make a note of the current group so that you can set it back after the installation.newgrp
inst_group
where inst_group
is the name of the group that owns the Oracle Inventory. You specified the name during the Oracle Database installation. Typically, this user group is oinstall.
(See Section 2.2.2.2, "Create the opapps Account.")
This temporary change is necessary so that the Installer can update the Oracle Home.
Set the X Window display output to the IP address of your local computer. Use the standard format for IP addresses, and add ":0"
to the end of the address.
For example:
setenv DISPLAY 123.45.67.89:0
Locate the Oracle Clinical software in the Oracle Clinical and Oracle Thesaurus Management System 5.0.1 directory in the staging area on the database server where you downloaded it; see Section 1.5, "Downloading and Extracting the Software."
Open the ldflags file at root: app/oracle/product/11.2.0.4.0/lib and add the following flag:
-lnnz11
To start the Installer:
Log in to the server computer using the opapps account.
In the staging area, locate the directory where you downloaded Oracle Clinical (see Section 1.5, "Downloading and Extracting the Software") and extract the .zip file if you have not already done so.
Navigate to this location:
server_code_platform
\Disk1\install
Change protections on all files to 755
.
chmod 755 *
Run one of the following commands, depending on whether you are using Oracle Real Application Cluster (RAC):
For a non-RAC installation:
./runInstaller
For a RAC installation:
./runInstaller -local
This ensures that the installation is performed only on the local node.
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 Oracle Clinical Server for UNIX 5.0.X.
Follow the instructions on the installation screens, providing the information you assembled in Section 2.5.1, "Gather Required Information".
You can review the progress of the installation:
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.
Review the generated installation log files for errors:
$ORACLE_BASE/oraInventory/logs/installActions.log
The current log file is installActions.log. All previous log generations have a timestamp appended to the name.
OPA_HOME/oc/50/relink_rxc.log—information on the relinking activities
OPA_HOME/oc/50/config_wallet_timestamp.log—information on Oracle Wallet configuration
OPA_HOME/oc/50/config_wallet_err_timestamp.log—this file is created only if there are errors in the Oracle Wallet configuration
Work with Oracle Support, if necessary, to resolve any errors.
The Installer creates the following directory structure for an Oracle Clinical Database Server on UNIX:
OPA_HOME /bin /xmltemp /oc /501 /bin (Symbolic links to the executables) /common (Common files) /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) /sec (Security tools) /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, /home/opapps.
Recall that before you started this installation on UNIX, you changed the primary group of the opapps account to the group that owns the Oracle Inventory (see Section 2.5.2, "Preparing to Install the Oracle Clinical Database Server Software"). This temporary change was necessary so that the Installer could update the Oracle Inventory.
To reset the privileges for the opapps account, enter the following command:
newgrp
group
where group
is the name of your original primary group for the opapps account.
This section describes the following tasks that you perform to complete the installation of Oracle Clinical Database Server on a UNIX computer:
To complete the setup of the opapps account:
Create the log directory for opapps in the following location:
OPA_HOME/log
Define the environment variables for the opapps user:
Open the .cshrc file. This file is located in the home directory after you log in as the opapps
user. You can use the following command to view the hidden .cshrc file:
ls -arlt
Add the following lines to the .cshrc file:
set path=( $path
ORACLE_HOME
/bin
ORACLE_HOME
/lib )
setenv RXC_LOG
OPA_HOME
/log
source
OPA_HOME
/bin/copa_setup_alias
where:
ORACLE_HOME is the directory where you installed Oracle Database 11g Release 2 (11.2.0.4) .
OPA_HOME is the directory where you installed Oracle Clinical Database Server.
Source the .cshrc file when you finish editing it:
On UNIX systems, configurations are defined in the opa_settings file, which the Installer creates in the following directory:
OPA_HOME/bin
The Installer enters all necessary entries and default values for the Oracle Clinical environment into the opa_settings file.
See the Oracle Clinical Administrator's Guide for a list of the environment variables and for information about changing, adding, and verifying values.
Review the opa_settings file and adjust the default values, if necessary. Note:
The db_env_setting
records in the opa_settings file define a default value for particular environment variables that are set when the application calls opa_setup. You can override the default values for all databases or for a particular database.
See Section 1.8, "Choosing a Character Set" for important information.
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 must be DD-MON-RRRR.