Installation on Solaris 10 with Oracle 10

The VDAB (Public employment and vocational training service of the Dutch-speaking part of Belgium) is currently preparing an implementation of Moodle 1.9 on a large scale for its clients.

As a first step we have installed Moodle on a standard environment for VDAB being a Solaris 10 with Oracle 10g. Since this operation went succefully, problems encountered were solved, the VDAB offers the installation documentation to the Moodle community.

Contact person: Gerd Goetschalckx

Purpose of this document

This document provides an in-depth installation manual for Moodle on Solaris 10 with Oracle 10.2.0.2.

We provide an overview of the different steps involved:

• Preparing Oracle 10g for a large Moodle installation

• Configuring Apache 2.2 for a secure and high-performance webserver

• Preparing all necessary PHP packages for Apache and Oracle

• Preparing PHP settings for Moodle

• An overview of the steps in the Moodle installation wizard.

3 Setting up the Oracle Database We set up 2 parallel Moodle installations on one and a database on a separate server. Both installations share the same Oracle database, but use a different tablespace.

The Oracle 10.2.0.2 database runs on a Solaris 10 and is set up using Oracle's DBCA tool.

l This is testzone1 on the test server testitis00

l Database name = testitis02.vdab.be

l We used the General purpose template for the database set-up;

l And set UTF8 character encoding to NLS_LANG=AMERICAN_AMERICA.AL32UTF8

For each Moodle installation we create a separate Tablespace:

l First Moodle installation on testzone2:

 MOODLE_DATA with initial size of 300MB

 User: MOODLEUSER, password: moodle

 The user only has rights within the specified tablespace

l Second Moodle installation on testzone3:

 MOODLE_DATA2 with initial size of 300MB

 User: MOODLEUSER2, password: moodle

 The user only has rights within the specified tablespace