ProVation MD Manual Database Install Instructions 5.0.X Installation

User Manual:

Open the PDF directly: View PDF PDF.
Page Count: 3

DownloadProVation MD Manual Database Install Instructions 5.0.X Installation
Open PDF In BrowserView PDF
Manual ProVation MD Database
Installation Instructions
v5.0.X

This document provides the steps necessary to manually install the ProVation MD/MultiCaregiver
database.

Install Prerequisites:
1. The person running this install has read the documents containing the ProVation MD
Hardware Requirements (5.0 TechSpecv50-09.pdf).and the ProVation Database
Requirements (Database Requirementsv5x-01.pdf).
2. The person running this install has complete control of the Oracle install and knows the
system password.
3. A generic database with a unique service name has been created prior to running the steps
provided in this document. There should also be a TNSNAMES.ORA alias called GIHUB
pointing to the existing, generic database. Once this is done, following the instructions in
this document will create the required data files, tablespaces, and users for the ProVation
MD/MultiCaregiver programs.
Step 1: Copy files from install CD to a temporary location
1. Launch the ProVation MD Installer (setup.exe) on a computer running 2003 Server or
Server 2008 SP2 (Server 2008 R2 is not yet supported).
2. Obtain installation program password from ProVation Customer Support @ 877-454-2994,
option 1.
3. Select Database and Unpack Manual Database Install Files, then select Next.
4. Select a directory where you would like the manual database setup files unpacked, then
select Next.
5. Retrieve the unpacked database files and move them to the appropriate location. The
following are example locations:
Temporary location example for Windows: D:\Provation\Manual
Temporary location example for UNIX: /usr/home/oracle/Provation/Manual/

50DBMANUALINSTALL-01

1

Step 2: Create Tablespaces
1. Edit the file tablespaces.sql to make sure that the paths are correct. The paths should
point to the directory location of the ProVation MD database, as in the following examples:
Path example for Windows: D:\ORACLE\ORADATA\CMORE\CMORELCD1.DBF
Path example for UNIX: /U01/oracle/oradata/cmore/cmorlcd1.dbf
2. Change directory to the temporary location created in Step 1 of this document. For
example, if the files were copied to the location D:\Provation\Manual, change
directory to that folder. At this point your command prompt should look like this:
In Windows: D:\Provation\Manual>
In Unix: /usr/home/oracle/Provation/Manual/
3. From the preceding command prompt, run the following file using SQL*Plus:
sqlplus system/@GIHUB @tablespaces.sql
Step 3: Create the Redo Logs
1. Edit the file redologs.sql to make sure that the paths are correct. Run the following file
using SQL *Plus:
sqlplus system/@GIHUB @redologs.sql
Step 4: Create the Users
This step creates the user schemas required by the ProVation MD program. You must log on as
SYS. There is no need to edit the following file run in this step, simply run it from SQL*Plus:
sqlplus sys/@GIHUB @users.sql
Step 5: Prepare to import of ProVation MD data
1. Shutdown the database using SQLPLUS /NOLOG
2. Required—the following setting must be made in the file init.ora/initcmore.ora:
compatible = 10.2.0
3. If the compatibility level is less than 10.2.0, some objects may not import correctly.
4. Optional—the following changes are helpful in speeding up the import. Edit the parameters
in the file INIT.ORA/INITCMORE.ORA as shown here:
sort_area_size = 20000000
sort_area_retained_size=0
log_checkpoint_interval = 10000000
log_checkpoint_timeout = 0
log_buffer = 327680
5. Start the database again using SQLPLUS /NOLOG
6. At the command line, make sure to switch directory to the temporary location configured in
Step 1 of this document.; then, import the export file (for example, data.dmp), using the
following imp statement. (The import should be run with a log file specified, as shown in the
example.) Note—the following is one command:
imp system/@GIHUB file=data.dmp log=imp.log
fromuser=(cmore,cm_nurse2,pvusr) touser=(cmore,
cm_nurse2,pvusr) grants=y analyze=n
7. Once the import is complete, analyze all tables.

50DBMANUALINSTALL-01

2

Step 6: Optional: Database Cleanup
Running the following script is optional, it merely removes some of the well-known tablespaces that
are created as part of a database created by the Oracle Database Assistant utility. You may choose
to leave these well-known tablespaces, but ProVation will never use them.
This step also makes sure that all small rollback segments are brought online and also performs
any necessary cleanup tasks.
This step must be run as user SYS, not SYSTEM.
1. There is no need to edit the following file, simply run it in SQL*Plus:
sqlplus sys/@GIHUB @cleanup.sql
Once these steps are completed, the manual database installation is complete.

50DBMANUALINSTALL-01

3
Source Exif Data: 
File Type                       : PDF
File Type Extension             : pdf
MIME Type                       : application/pdf
PDF Version                     : 1.5
Linearized                      : No
Page Count                      : 3
Language                        : en-US
Tagged PDF                      : Yes
Title                           : ProVation MD Manual Database Install Instructions
Author                          : Provation Medical, Inc.
Creator                         : Microsoft® Office Word 2007
Create Date                     : 2011:06:30 08:51:34
Modify Date                     : 2011:06:30 08:51:34
Producer                        : Microsoft® Office Word 2007
EXIF Metadata provided by EXIF.tools

Navigation menu