Create the Tridion Database Schemas

In this step, we will create the two database schemas required by the Tridion Content Manager.

Tutorial Sections

• Part 1: Preparing the Database
• Part 2: Preparing Windows
• Part 3: Installing the Oracle Clients
• Part 4: Create Tridion Databases
• Part 5: Install Tridion Content Manager
• Part 6: Test and Validate

Run the Tridion Database Manager (TDM) tool

Download and install MSXML 4 SP3
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7f6c0cb4-7a5e-4790-a7cf-9e139e6819c0&displaylang=en

Locate the Tridion Database Manager (under [Tridion_Install]\Database) and launch this tool.

Click on New Database

Select the default options of "Content Manager" and click Next

Select Oracle from the Database Type drop-down and enter the SQL*NET service name, then click Next

Enter the tridion_sys account name and password and click Next. This is the account you created on step 3.1 of this document

Enter a name for the Content Manager schema (default: TCMDBUser) and select a password to use for this schema. Click Next

Enter a name for the Content Manager Log schema (default: TCMLogDBUser) and select a password to use for this schema. Click Next

Enter the MTSUser accound information. If this account does not yet exist or the information is incorrect you will receive a warning message. Click Next.

Enter the SYSTEM account to use. Typically you will NOT change this value.

Enter the details of the "Tridion Administrator" account. This will default to the user currently executing the installation.

Select the tablespaces to use for each type of data. Your Oracle DBA may provide you with a different set of Tablespaces than the default ones.

Select the Tablespaces to use for the Logging database.

Select the location of the log file generated by this tool.

Wait for the completion of the database creation.

Select File -> Exit, and close the Database Manager

You have now created the Tridion Content Manager database schemas. The next step will guide you through the installation of the Content Manager software.

Next: Install Tridion

Next we will install the Tridion Content Manager