12.17 Configuring an Oracle Database for OpenClinica (Deprecated)
If you use OpenClinica with the Oracle database, follow these instructions to set up the database. The instructions differ depending on the version of OpenClniica you are using.
12.17.1 Set Up Oracle for OpenClinica 3.1.2 or Above
Follow these instructions to configure an Oracle 10g database to run with OpenClinica versions 3.1.2 or above.
- Open a shell/command prompt window and change the current directory to the location of the OpenClinica database files.
- Ensure there is at least 512MB of disk space available at that location.
- Start sqlplus:
- Run
sqlplus sys as sysdba - When prompted for the password, enter the sys password.
- Run
- At the SQL prompt, run the script to create the tablespace:
- Run
@create_ts.sql - When the following prompts display (shown below in bold), provide these values (shown below in code font):
- Specify Tablespace name for Clinica Data:
openclinica - Specify Tablespace type for Clinica Data (S/M/L):
L
(This specifies a tablespace size of Large, 512MB.) - DataFile Name (with exact path):
/usr/lib/oracle/xe/oradata/XE/OPENCLINICA01.DBF
(This is the default oradata directory for Linux; specify the full path to the oradata directory on your system.)
- Specify Tablespace name for Clinica Data:
- Run
- At the SQL prompt, run the script to create the database user "clinica":
- Run
@oracle_setup_db.sql - When the following prompts display (shown below in bold), provide these values (shown below in code font):
- Specify the Tablespace name you provided when you executed the create_ts.sql script:
openclinica - Specify the wanted username for the OpenClinica oracle account:
clinica
- Specify the Tablespace name you provided when you executed the create_ts.sql script:
- Check spool_oracle_setup_db.txt for any errors.
- Run
- Change the default password "clinica" to a secure password:
- As the sysdba user, connect to your instance via sqlplus by running
sqlplus sys as sysdba - Run the following command, where PASSWORD is the new, secure password you are sepcifying for the clinica database user:
alter user clinica identified by PASSWORD;
- As the sysdba user, connect to your instance via sqlplus by running
- Start Tomcat, which will build the OpenClinica database within the tablespace.
- After the tablespace is built, create indexes to help performance by running the following:
- Connect to sqlplus as the clinica user by running
sqlplus clinica/clinica - Run this script:
@performance.sql
- Connect to sqlplus as the clinica user by running
12.17.2 Set Up Oracle for OpenClinica Versions Pre-3.1.2
Follow these instructions to configure an Oracle 10g database to run with OpenClinica versions 3.1 and 3.1.1.
- Open a shell/command prompt window and change the current directory to the location of the OpenClinica database files.
- Ensure there is at least 512MB of disk space available at that location.
- Start sqlplus:
- Run
sqlplus sys as sysdba - When prompted for the password, enter the sys password.
- Run
- At the SQL prompt, run the script to set up the database tablespace and database user "clinica":
- Run
@oracle_setup_db.sql - When the following prompts are display (shown below in bold), provide these values (shown below in code font):
- Specify Tablespace name for Clinica Data:
openclinica - Specify Tablespace type for Clinica Data (S/M/L):
L
(This specifies a tablespace size of Large, 512MB.) - DataFile Name (with exact path):
/usr/lib/oracle/xe/oradata/XE/OPENCLINICA01.DBF
(This is the default oradata directory for Linux; specify the full path to the oradata directory on your system.) - Specify the wanted username for the OpenClinica oracle account:
clinica
- Specify Tablespace name for Clinica Data:
- Check spool_oracle_setup_db.txt for any errors.
- Run
- Change the default password "clinica" to a secure password:
- As the sysdba user, connect to your instance via sqlplus by running
sqlplus sys as sysdba - Run the following command, where PASSWORD is the new, secure password you are sepcifying for the clinica database user:
alter user clinica identified by PASSWORD;
- As the sysdba user, connect to your instance via sqlplus by running
- Start Tomcat, which will build the OpenClinica database within the tablespace.
- After the tablespace is built, create indexes to help performance by running the following:
- Connect to sqlplus as the clinica user by running:
sqlplus clinica/clinica - Run this script:
@performance.sql
- Connect to sqlplus as the clinica user by running:
Approved for publication by Benjamin Baumann (bbaumann), Principal. Signed on 2014-04-16 3:38PM
Not valid unless obtained from the OpenClinica document management system on the day of use.
Search
- OpenClinica 3 User Documentation
- Overview of OpenClinica 1 Overview of OpenClinica
- Submit Data2 Submit Data
- Monitor and Manage Data3 Monitor and Manage Data
- Extract Data4 Extract Data
- Study Setup5 Study Setup
- Rules6 Rules
- Users and Roles7 Users and Roles
- Administration8 Administration
- Printing CRFs9 Printing CRFs
- OpenClinica Participate10 OpenClinica Participate
- OpenClinica Randomize11 OpenClinica Randomize
- OpenClinica Installation and Upgrade Guides12 OpenClinica Installation and Upgrade Guides
- System Requirements12.1 System Requirements
- Install OpenClinica12.2 Install OpenClinica
- Install OpenClinica 3.412.3 Install OpenClinica 3.4
- Install OpenClinica 3.3 on Linux12.4 Install OpenClinica 3.3 on Linux
- Install OpenClinica 3.3 on Windows12.5 Install OpenClinica 3.3 on Windows
- Upgrade to OpenClinica 3.3 on Linux12.6 Upgrade to OpenClinica 3.3 on Linux
- Upgrade to OpenClinica 3.3 on Windows12.7 Upgrade to OpenClinica 3.3 on Windows
- Install OpenClinica 3.2 on Linux12.8 Install OpenClinica 3.2 on Linux
- Install OpenClinica 3.2 on Windows12.9 Install OpenClinica 3.2 on Windows
- Upgrade to OpenClinica 3.2 on Linux12.10 Upgrade to OpenClinica 3.2 on Linux
- Upgrade to OpenClinica 3.2 on Windows12.11 Upgrade to OpenClinica 3.2 on Windows
- Install OpenClinica 3.1.x on Linux12.12 Install OpenClinica 3.1.x on Linux
- Install OpenClinica 3.1.x on Windows12.13 Install OpenClinica 3.1.x on Windows
- Upgrade to OpenClinica 3.1.x on Linux12.14 Upgrade to OpenClinica 3.1.x on Linux
- Upgrade to OpenClinica 3.1.x on Windows12.15 Upgrade to OpenClinica 3.1.x on Windows
- OpenClinica VM Image12.16 OpenClinica VM Image
- Configuring an Oracle Database for OpenClinica (Deprecated)12.17 Configuring an Oracle Database for OpenClinica (Deprecated)
- Operating System Installation12.18 Operating System Installation
- Glossary13 Glossary
- Knowledge Articles14 Knowledge Articles
- OpenClinica Community Tools and Tips15 OpenClinica Community Tools and Tips
- OpenClinica Conference Presentations16 OpenClinica Conference Presentations