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 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):

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

* Change to the administration tab

* Select the tablespace administration

• Click Create to begin creation of a new tablespace:

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

• 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.

• Click OK to conclude the tablespace creation

In the same manner create now the tablespace for indexes.

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

Continue now with the Create datasore wizard.