Text Box: HOW TOHow To:


This installation requires that the computer have a web server (IAS), Perl and Oracle installed. The first three sections explain how to install and configure these items

before PARPs-DB is installed. If these items are installed already, there will be some configuration to do, so make sure you read all sections before installing PARPs-DB.

Text Box: PerlThere are a couple of other things that are done differently for PARPs-DB and will be noted as we go along.


       I.            Windows

  1. Download and install ActiveState Perl.
  2. It is recommended to install at c:\perl if possible as the perl scripts expect to find the perl executable there. If installed somewhere else, the first line of each perl script will need to be changed to point to the correct location of perl.
  3. Install the dbi and dbd perl modules needed for database communication. See here for pointers or enter the commands below at the command prompt.


  c:\> cd perl\bin

  c:\perl\bin> ppm

  ppm> install DBI

  ppm> install http://theoryx5.uwinnipeg.ca/ppms/DBD-mysql.ppd


    II.            Unix/Linux

  1. In general, Perl is installed in the most Linux / Unix distribution.

Text Box: Oracle· Install the dbi and dbd perl modules needed for database communication.


Installation of Oracle database is not easy. We suggest installing this database with database administrator.

We have prepared guidelines to install Oracle (see How to install Oracle for windows or Unix systems).

If you want more information, we suggest consulting Oracle documentation.


Text Box: Database creation 


Once Perl and Oracle and IAS have been installed and configured, the database can be created.

PARPS scripts are available on SourceForge.net CVS repository. This can be checked out through anonymous (pserver) CVS with the following instruction set.

The module you wish to check out must be specified as the modulename. When prompted for a password for anonymous, simply press the Enter key.


       I.            We suggest downloading tortoise cvs software at the following address for Windows operating systems:  (http://www.tortoisecvs.org/).

a.    Install tortoise software

b.     Create a folder on your local disk to download files (eg. PARPS_DB)

c.      Click right on PARPS_DB folder

d.     Select CVS checkout

e.      A new windows appears and fill like figure 2

f.      Press ok
























All CVS contents are downloaded in PARPD_DB folder.


    II.            With Unix or Linux operating systems, use this following command.


cvs -d:pserver:anonymous@parpdb.cvs.sourceforge.net:/cvsroot/parpdb login


1.      So, we have downloaded all scripts for PARPS-DB systems. All scripts are open source and if you need help, contact me.

2.    Open a command prompt and navigate to 'scripts_DB' folder in PARPS_DB_scripts directory.

3.    Open a SQL prompt

4.    Open create_PARPsDB.sql file.  

5.    Copy each tables in SQL prompt (e.g.

create table project (


nom_project varchar2(10) );


6.      You should see :

Query OK, 0 rows affected (0.48 sec)


7.      An empty PARPs_DB has been created.

8.     The next step is to install PL scripts. Each scripts must be loaded on sql prompt.         

      Query OK

9.      Open the script called: parp_admin.txt and copy each lines on sql prompt to grand privileges.


Text Box: USE PARPs-DB 


PARPs-Db is now ready to use. Point your browser to http://servername/index.html. You should see PARPs-DB start page.

If you get the error:

Check IAS configuration.


Text Box: Getting Help 


This set of instructions is not a rigid formula: you may have to adjust the way it is installed based on existing web servers on your computer,

or just to make it more convenient for you. If you have any problems or questions email us at arnaud.droit@crchul.ulaval.ca.

Return to the main page

Download documentation How to install Oracle on windows XP How to install Oracle on Linux