Oracle® Clinical Installation Guide Release 5.1 E53553-02 |
|
|
PDF · Mobi · ePub |
This chapter describes how to create a new Oracle database for use with Oracle Clinical. You must install Oracle Database first; see Chapter 2, "Installing Oracle Clinical Database Server on UNIX" or Chapter 3, "Installing the Oracle Clinical Database Server on Windows."
This chapter includes:
Before you install an Oracle database, review the requirements and recommendations — such as tablespace sizes, memory management, and initialization parameters — listed in this section.
Note:
Follow these requirements for each database you create.Oracle recommends that you set up a new database instance so that neither Oracle Clinical nor its installation process interferes with other applications. However, you can install Oracle Clinical on an existing database instance.
Table 4-1 lists the tablespaces, along with their minimum size, required for Oracle Clinical. Make sure the database contains these tablespaces. The best practice is to create them with the Autoextend On option, to avoid running out of space.
In addition, you may need to increase the minimum sizes for your installation.
To create a new database, use the Database Configuration Assistant (DBCA). For instructions about the Database Configuration Assistant, see the Oracle Database 12c Release 1 (12.1.0.1) 2 Day DBA guide at http://docs.oracle.com/database/121/ADMQS/install.htm#ADMQS0232
.
Note:
Use the Custom Database installation option. This option allows access to the Database Storage screen, where you can expand the Tablespaces folder in the tree on the left side of the screen and edit the following tablespaces as required; see Section 4.1.2, "Check Required Tablespaces"
The following parameters are not listed under All Initialization Parameters. Click Show Advanced Parameters to set the following parameters as described in Section 4.1.8, "Set Initialization Parameters":
Db_cache_size
Db_files
Java_pool_size
Job_queue_process
Large_pool_size
You can install an Oracle Clinical database on either a pluggable database (PDB) in a container database (CDB) or on a non-CDB (pre-12c-style) database.
To create a PDB, enable CDB and immediately create the PDB as well by entering its name in the Pluggable database name field.
To create a non-CDB database, do not enable the option to create a CDB.
For more information see the Oracle Database 12c Release 1 (12.1.0.1) 2 Day DBA guide at http://docs.oracle.com/database/121/ADMQS/install.htm#ADMQS0232
.
Select the following database options that are required for Oracle Clinical:
Oracle JVM
Oracle XML DB
Note:
If you are creating a CDB and PDB, these are already selected by default.Oracle recommends that you use Oracle Database 12c Release 1 (12.1.0.1)'s Automatic Memory Management feature for a new or an upgraded Oracle Clinical database.
Choose to configure the database to accept connections as a service instead of a SID. Service name requirements for Oracle Clinical include:
The service name must be less than 15 characters long.
It must not include the domain.
It must be all lowercase.
Note:
If you are installing the Oracle Clinical database on a pluggable Oracle 12.1.0.1 database (PDB), see My Oracle Support article ID 1910177.1, How To Configure TNS / SQLNET using the local_listener parameter for Pluggable Database In Oracle 12c, Allowing a SQLNET Connection to the PDB. See "Finding Information on My Oracle Support."Table 4-2 lists the required and recommended initialization parameters in the init.ora file for Oracle Clinical. For those parameters that accept a value from within a range, the values in the table are the minimum values.
Tip:
Table 4-2 arranges the parameters in alphabetical order. In the Database Configuration Assistant, you can select the Parameter column to sequence the parameters in the same order.Note:
If you make any changes to the initialization parameters, be sure to stop and restart the database for the new settings to take effect.Table 4-2 Required and Recommended Initialization Values in the init.ora File
Parameter | Value | Comments |
---|---|---|
COMPATIBLE |
11.2.0.4 |
Specifies the release with which the Oracle server must maintain compatibility. |
DB_BLOCK_SIZE |
16384 bytes |
You cannot change this value after you create the database. |
DB_CACHE_SIZE |
150 MB |
Recommended value for 50 to 60 concurrent users. Adjust this value according to your organization's needs. |
DB_DOMAIN |
null |
DO NOT set this value. In Release 5.1 onward setting this value causes problems. |
DB_FILES |
200 |
Oracle adds needed space to the control files up to the number specified in the DB_FILES parameter. |
EVENT |
31151 trace name context forever, level 0x100 |
Required for HTML generation. NOTE: Do not include the EVENT parameter when you create the database. Once the database is created, you can add the EVENT parameter to the init.ora file. |
JAVA_POOL_SIZE |
50 MB |
Recommended value for 50 to 60 concurrent users. You can change the value of this parameter after installation. (Set greater than 150 MB with Oracle AERS, minimum.) |
JOB_QUEUE_PROCESSES |
10 |
Developer-specific parameter. You can change the value of this parameter after installation. |
LARGE_POOL_SIZE |
50 MB |
Recommended value for 50 to 60 concurrent users. |
MEMORY_MAX_TARGET |
1000 MB (minimum) |
Adjust this value according to your organization's needs. |
MEMORY_TARGET |
1000 MB (minimum) |
Adjust this value according to your organization's needs. |
NLS_DATE_FORMAT |
DD-MON-RRRR (default value) |
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. |
NLS_LENGTH_SEMANTICS |
BYTE |
The CHAR value for this parameter is not supported. |
OPEN_CURSORS |
800 or greater |
You can change the value of this parameter after installation. |
OPTIMIZER_DYNAMIC_SAMPLING |
2 or greater |
The default setting is 2. Oracle recommends using dynamic sampling for Batch Data Load temporary tables; see the Oracle Clinical Administrator's Guide. |
OPTIMIZER_FEATURES_ENABLE |
11.2.0.4 |
Acts as an umbrella for enabling a series of optimizer features based on an Oracle release number. NOTE: Oracle Clinical 5.1 is certified on the Oracle Database 11g optimizer features; see Section 11.4.6.6.4, "Run Scripts to Gather Schema Statistics for the Oracle Database Optimizer." |
OPTIMIZER_MODE |
CHOOSE |
If you run Oracle Clinical's statistics gathering scripts, the CHOOSE value sets Oracle Optimizer to apply the execution plan that best minimizes response time. See the Oracle Database documentation for more information. (CHOOSE is the default value when you specify 11.2.0.4 as the value of OPTIMIZER_FEATURES_ENABLE.) |
PGA_AGGREGATE_TARGET |
200 MB |
Recommended value for 50 to 60 concurrent users. You can change the value of this parameter after installation. |
REMOTE_LOGIN_PASSWORDFILE |
EXCLUSIVE |
The database must be set up to use password file authentication. |
SEC_CASE_SENSITIVE_LOGON |
FALSE |
Lets you enter passwords without case sensitivity. |
SESSIONS |
500 or greater |
You can change the value of this parameter after installation. |
SGA_MAX_SIZE |
600 MB (minimum) |
Recommended value for 50 to 60 concurrent users. Adjust this value according to your organization's needs. |
SGA_TARGET |
600 MB (minimum) |
Recommended value for 50 to 60 concurrent users. Adjust this value according to your organization's needs. |
SHARED_POOL_SIZE |
150 MB (minimum) |
Recommended value for 50 to 60 concurrent users. You can change the value of this parameter after installation. |
UNDO_MANAGEMENT |
AUTO |
Specifies which undo space management mode the system uses. When set to AUTO, the instance starts in Automatic Undo Management (AUM) mode. |
opa_home\xmltemp |
Specifies each directory you access. Required to support Oracle Clinical PDF layout generation and Oracle AERS. For Windows environments, samples of the valid syntax are as follows:
In a UNIX environment, UTL_FILE_DIR requires an entry with two specified paths: one with and one without a trailing slash. Add these lines before any other UTL_FILE_DIR entries:
|
The tnsnames.ora file must have a connect string entry for each database that matches the database's service name. There is a tnsnames.ora file in at least two locations in the installation. Oracle recommends maintaining a master file and copying it to each location whenever you add a database. See Section 5.8, "Modify the tnsnames.ora File on the Application Server" for the application server locations.
The tnsnames.ora file is on each database server at: oracle_home/network/admin.
If the database server has multiple Oracle Homes, the tns entries for all databases should be maintained in a central location; for example: /etc/tnsnames.ora.
For the requirements for disconnected replication, see Section 4.4.3.2, "Create a Wallet Credential for the RXC_DISC_REP Database User."
Follow the instructions in this section to add Oracle Clinical database objects to this database.
Before you install database objects, you may want to modify some of the default SQL scripts used by the Installer; see Section 4.2.1, "Customize the Installation".
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.
UNIX To create larger databases in UNIX, edit the following scripts:
OPA_HOME
/oc/51/install/opadba2.sql
OPA_HOME
/oc/51/install/rxcdba2.sql
Windows To create larger databases in Windows, edit the following scripts:
OPA_HOME
\oc\51\install\opadba2.sql
OPA_HOME
\oc\51\install\rxcdba2.sql
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:
UNIX OPA_HOME
/oc/51/install/rxcdba4.sql
Windows OPA_HOME
\oc\51\install\rxcdba4.sql
See the Oracle Clinical Administrator's Guide for more information about enrolling users.
Create a directory that is accessible to the opapps user and different from the Oracle Wallet location. The Installer fails if this directory is not created before running the Installer.
Example location: /pharm/home/opapps/sec_store/db_name
Make sure you have the information below, which is arranged in the order it is prompted for by the Installer during a fresh installation. The order for upgrades is somewhat different.
Note:
You must install the Oracle Clinical database server before you install or upgrade the Oracle Clinical database.The ORACLE_HOME location, which is where you installed Oracle Database 12.1.0.1; for example:
root:app/oracle/product/12.1.0.1/dbhome
OPA Home: the directory where Oracle Clinical will be installed; Oracle recommends:
/pharm/home/opapps
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.Service name for the database to be installed
Know if you plan to use either Automatic Storage Management (ASM) or Real Application Clusters (RAC). This affects the Installer behavior for validating tablespaces.
Location for tablespace datafiles. You can change the default sizes by editing the script before running the Installer; see Section 4.2.1, "Customize the Installation".
Location and password for the Wallet created during Oracle Clinical database server installation to store credentials for OCPSUB and RXC_DISC_REP.
You will need to enter passwords for the following:
Oracle Wallet
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.BC4J_INTERNAL
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.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.
Database host name and port number
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.
Location of the secret store folder you created in Section 4.2.1.3, "Create a Secret Store Directory".
Follow the instructions appropriate for your operating system:
Section 4.2.3.2, "Start the Installer on a Windows Server"
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.To start installing the Oracle Clinical database:
Log in to the server computer 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 12c Release 1 (12.1.0.1) installation. Typically, this user group is oinstall.
This temporary change is necessary so that the Installer can update the Oracle Inventory.
Set the X Window display output to the IP address of your local computer. Use the standard format for IP addresses. For example:
setenv DISPLAY 123.45.67.89
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 files to 755
.
chmod 755 *
Start the Installer:
Non-RAC Installation:
./runInstaller
Or, if the database server has multiple Oracle Homes, then enter:
./runInstaller -invPtrLoc ORACLE_HOME/oraInst.loc
For example:
./runInstaller -invPtrLoc /u01/app/oracle/product/121010_qa/oraInst.loc
RAC Installation:
./runInstaller -local
Or, if the database server has multiple Oracle Homes, then enter:
./runInstaller -local -invPtrLoc ORACLE_HOME/oraInst.loc
For example:
./runInstaller -invPtrLoc /u01/app/oracle/product/121010_qa/oraInst.loc
In the Select a Product to Install page, select OC Database Install 5.1.0.0.x.
Follow the instructions on the installation screens, providing the information you assembled in Section 4.2.2, "Gather Required Information".
To start installing the Oracle Clinical database:
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 as an administrator:
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 Database Install 5.1.0.0.x.
Follow the instructions on the installation screens, providing the information you assembled in Section 4.2.2, "Gather Required Information".
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 4.2.3, "Start Installing the Oracle Clinical Database"). 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.
The Installer generates numerous log files and saves the files to the following location:
Windows OPA_HOME
\oc\51\install
Check the following 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
This section describes the following tasks for completing the installation of your Oracle Clinical database:
See also Section 8.1, "Set Up PSUB" for additional required tasks.
The Oracle Clinical Remote Data Capture Onsite (RDC Onsite) application uses the dbtimezone value for internal calculations when the Display timestamps in local timezone preference is set.
Oracle recommends setting time zone to a named location rather than a numeric offset so that standard and daylight time adjustments are made automatically.
You can find valid named location strings in the V$TIMEZONE_NAMES view. For example, to find a time zone in the United States, enter the following query:
SELECT distinct tzname FROM V$TIMEZONE_NAMES WHERE tzname like 'US/%'
To set the time zone in the database:
Connect to the database as any user that has ALTER DATABASE privileges.
Enter the following command:
alter database set time_zone='
tzname_value
';
For example:
alter database set time_zone='US/Eastern';
To improve performance, some of Oracle Clinical's packages are pin-able packages. Pinning allocates a stable memory location so that a package cannot be subjected to being swapped out of memory. Oracle Clinical provides the rxcdbinit.sql script to pin the database packages.
To pin the database packages located on a UNIX server:
Log in to the UNIX server computer as the opapps
user.
Set the UNIX environment:
opa_setup
database_name code_environment
Change to the RXC_INSTALL directory:
cd $RXC_INSTALL
Connect to SQL*Plus as the rxc
user:
sqlplus rxc/
password
Run the rxcdbinit.sql script:
start rxcdbinit.sql
The script pins the database packages and exits upon completion.
Note:
You must rerun this script each time you restart the database. Consider creating an entry in the database startup script that runsrxcdbinit.sql
automatically.To pin the database packages located on a Windows server:
Set the Windows environment:
set p1=
database
set p2=51
opa_setup
where database
is the name of this database instance, and 51
is the alias for the version of Oracle Clinical.
Change to the drive where Oracle Clincal is installed. For example:
X
:
Start an SQL*Plus session, and connect to the database in the RXC account:
sqlplus rxc/
password
Run the rxcdbinit.sql script to pin the database packages:
start %RXC_INSTALL%\rxcdbinit.sql
If you are continuing the installation, note that you perform the next task in this environment.
Do the following only if you plan to use disconnected replication.
If you use disconnected replication, you might need to increase the size of the DISC_REP_DATA tablespace to fit the amount of replicated data. Installing Oracle Clinical creates the RXC_DISC_REP user account to manage disconnected replication. DISC_REP_DATA is the default tablespace for RXC_DISC_REP. For more information about disconnected replication, see the Oracle Clinical Administrator's Guide.
The system stores these credentials in the same Wallet as the one created for OCPSUB.
Log in as opapps.
Set environment variables.
In UNIX:
opa_setup database_name 51
In Windows:
set p1=database_connect_string
set p2=51
opa_setup
Create an alias for the disconnected replication wallet alias in tnsnames.ora. The disconnected replication wallet alias is the name of the database appended with:
_disc
.
For example, if the database name is ny123x
, the tnsnames entry would look something like:
ny123x, ny123x_disc, ny123x.world, ny123x.us.oracle.com = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=example.us.company.com)(PORT=1124)) (CONNECT_DATA=(service=ny123x))
See Section 4.1.9, "Modify the tnsnames.ora File on the Database Server.".
For the disconnected replication wallet alias enter tnsping
wallet_alias
to test that it returns success. For example:
tnsping ny123x_disc
Create the credentials for the disconnected replication wallet alias and account.
In UNIX:
mkstore -wrl /pharm/home/opapps/wallet51 -createCredential wallet_alias rxc_disc_rep rxc_disc_rep_password
In Windows:
mkstore -wrl %walletpath% -createCredential wallet_alias rxc_disc_rep rxc_disc_rep_password
Set tns_admin:
In UNIX:
setenv TNS_ADMIN path_of_sqlnet.ora
In Windows:
set TNS_ADMIN=%walletpath%
For the disconnected replication wallet alias run sqlplus /@
wallet_alias
. for example:
sqlplus /@ny123x_disc
The connection should be a success.
Run show user
This should display the rxc_disc_rep user.
The Oracle Clinical RESPONSES table contains all patient data entered for all studies in an Oracle Clinical installation. You can partition this table. See the Oracle Clinical Administrator's Guide for more information.