Suggested Technique for Manually Installing and Configuring a Windchill Database.

Introduction
Instructions on Manually Installing and Configuring a Windchill Database.

Procedure

1. Assuming that the Oracle Software has been Installed.


2. Make Sure that [WT_HOME]/db/sql is in your SQLPATH environment variable.

3. Create the database by running the Oracle Database Configuration Assistant

    • To start Database Configuration Assistant: Start#Programs#Oracle-OraHome81#Database Administration#Database Configuration Assistant
    • Create a Typical Database

4. Create the BLOBS Tablespace:
  • Login to sqlplus as system/manager (manager is the password, unless changed)
  • execute: create tablespace blobs datafile '<ORACLE_HOME>\database\blobs.ora' size 1000m;

5.   Create the Windchill User:
  • Login to sqlplus as system/manager (manager is the password, unless changed)
  • execute @create_user (if SQLPATH Environment Variable does not contain [WT_HOME]/db/sql then execute @[WT_HOME]/db/sql/create_user)
  • when prompted for username enter a desired name (this entry shall be used in db.properties for wt.pom.dbUser)
  • wt.pom.dbPassword shall be set to the same as the username.
  • when prompted for Temporary Tablespace use : TEMP
  • when prompted for USER tablespace use : USERS

6. Creating the Windchill schema for the new Windchill user:
  • login into sqlplus as the Windchill user created in Step 5 (as stated password = username)
  • execute @create_ddl_wt (if SQLPATH Environment Variable does not contain [WT_HOME]/db/sql then execute @[WT_HOME]/db/sql/create_ddl_wt)

 


7. Chane the following entried in the db.properties file:
  • wt.pom.serviceName=<hostname>:1521(or the port number used duirng the database creation):sid (sid is the servicename used during creating the database)
  • wt.pom.dbUser= Windchill user created
  •  wt.pom.dbPassword= password of Windchill username (same as username)

8. Restart your Windchill Servers to save the changes.