====== Preparing Oracle for BPS2 Installation ======

This tutorial shows the preparation of a fresh Oracle 11g installation on windows for BPS2. Basiclly for other operating systems the procedure is the same, but the directory path namings and file permissions are different; check the oracle documentation in case of questions.

In real life we would not only set up a single BPS database, but 3 distinct databases per application. What I will do in this tutorial is just prepare one production database, the quality and testing databases would be setup similar.

I am going to name the instance //prod//, and therefore have to create the tablespaces //prod_dat// and //prod_inx// with the enterprise manager. Everything else will later be done by the [[createdb|Create datasore wizard]]. 

Start up the Oracle Enterprise Manager graphical administration program (of cause you could as well use the sqlplus command line interpreter to do all following tasks - but in that case it is valid to assume you are an expert and know how the following tasks by manual commands):

===== Login page =====

  * Enter user name and password of the DBA
  * Click on the //Login// button to connect.

{{ bps2:oraprep:img-101.png |Login to Enterprise Manager}}


===== Home page =====

 * Change to the administration tab

{{ bps2:oraprep:img-102.png |Go To Administration}}

===== Database control page =====

 * Select the tablespace administration

{{ bps2:oraprep:img-103.png |Go To Tablespaces}}


===== Creating the data tablespace =====

  * Click //Create// to begin creation of a new tablespace:

{{ bps2:oraprep:img-104.png |Tablespaces Overview}}

==== Enter tablespace name ====

  * Enter the name of the new tablespace
  * Click //Add// to add a datafile for the tablespace:

{{ bps2:oraprep:img-105.png |Enter Name of New Tablespace}}

==== Add a tablespace file ====

  * Enter the name and directory for the new tablespace file. The directory might be allready suggested in case.
  * Select an appropriate initial file size - 100MB seems to be a good starter value if you are starting new.
  * It is recommended to let oracle automaticly increase the file size.
  * Click //Continue// to save the file settings.

{{ bps2:oraprep:img-106.png |Add a Datafile}}

==== Save and create the tablespace ====

  * Click //OK// to conclude the tablespace creation

{{ bps2:oraprep:img-107.png |Confirm Creation}}

===== Repeat tablespace creation for index =====

In the same manner create now the tablespace for indexes.

{{ bps2:oraprep:img-108.png |View Created Tablespaces}}

===== Overview of created tablespaces =====

Finally the overview can be displayed as below. This concludes preparation of the oracle database for BPS2.

{{ bps2:oraprep:img-109.png |View Created Tablespaces}}

Continue now with the [[createdb|Create datasore wizard]].