Configuring Oracle Databases

Configure an Oracle database for new Brand Mobiliser installations.

Prerequisites

Install an Oracle database.
Create a new hashed password for the admin user, and save it in the /sql/common/1.3.1/04-BrandMobiliser-Base-Data.sql script.

Task

Consult your DBA for a custom installation using an existing tablespace or user for the Brand Mobiliser schema.

Edit the BRAND_HOME/sql/oracle/1.3.1/02-BrandMobiliser-Users.sql script, and replace XXX with a password for the mwiz2 user:
```
create user mwiz2 identified by XXX;
```
As a user with DBA privileges, log in to the database.

Create a tablespace:

/sql/oracle/1.3.1/01-BrandMobiliser-Tablespaces.sql

Create the mwiz2 user:

/sql/oracle/1.3.1/02-BrandMobiliser-Users.sql

As the mwiz2 user, create a schema:
```
/sql/oracle/1.3.1/03a-BrandMobiliser-Objects.sql
```
Perform all remaining steps as the mwiz2 user.

Create another schema:

oracle/1.3.1/03b-BrandMobiliser-Objects.sql

Insert initial data and create the admin user:

/sql/common/1.3.1/04-BrandMobiliser-Base-Data.sql

Next

Install the Oracle JDBC driver.