ProVation MD Manual Database Install Instructions 5.0.X Installation

User Manual:

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

50DBMANUALINSTALL-01

1

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

2

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/<password>@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/<password>@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/<password>@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/<password>@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

3

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/<password>@GIHUB @cleanup.sql

Once these steps are completed, the manual database installation is complete.