Configuring Windchill with Oracle or SQL Server

Use the following instructions to set up the cluster configuration with Oracle or an SQL server through the PTC Solution Installer. These instructions are only applicable for a new Windchill installation.

1. Decide on the host name for your Windchill cluster. This name is used in the URL for accessing Windchill.

For more information about deciding on a host name, see Entering the Web Server and Servlet Engine Settings topic in the Windchill Installation and Configuration Guide.

Create an entry in the local hosts file on the machine where you are installing Windchill. The entry resolves the cluster host name to 127.0.0.1. The local hosts file can be found in the following locations:

For example, use the following line if wc-cluster.company.com is the host name of the cluster:

2. Follow the instructions in the Installing Windchill Solutions topic of the Windchill Installation and Configuration Guide to use the PTC Solution Installer to install Windchill solutions.

In addition to the installation instructions, apply the following:

◦ Select Enable Cluster Support when adding optional features for the Windchill solution during the Select Product segment of the installation.

◦ Insert the appropriate information for the requested fields when specifying the cluster information during the Define Settings segment of the installation.

In the Host name and IP address for each node in the cluster(space-separated list) field, also add the IP addresses of the cluster nodes to avoid any Domain Name System (DNS) problems.

This field is used to populate the wt.cache.master.slaveHosts property in the wt.properties file.

◦ Set the following values during the Define Settings segment of the installation for each field:

▪ Web Server DNS Registered Host Name: cluster host name (wc-cluster.company.com)

This field is used to populate the wt.cache.master.slaveHosts property in the wt.properties file.

▪ Oracle Database DNS Registered Host Name: real host name of the Oracle database server; ensure that this is a host name that all cluster nodes can access.

▪ LDAP Server DNS Registered Host Name: real host name of the LDAP server host; ensure that this is a host name that all cluster nodes can access.

3. Follow the instructions in the Configuring Additional Directory Servers topic of the Windchill Installation and Configuration Guide to create a repository in LDAP for the main cache server.

In addition to the instructions, apply the following options for each field:

◦ Repository Name: Use the host name for the main cluster server. For example:

◦ Webject Processor: use the processor created for wc-cluster.company.com. For more information, see the section Configuring Windchill Adapters in a Cluster Configuration (Optional) in Installing and Configuring a Cluster Windchill Environment.

◦ Task Processor: use the task processor created for wc-cluster.company.com. For more information, see the section Configuring Windchill Adapters in a Cluster Configuration (Optional) in Installing and Configuring a Cluster Windchill Environment.

The following instructions should be performed to complete a cluster setup:

1. If you are configuring a dedicated main node in the cluster, use the xconfmanager utility to set the following property:

wt.cache.master.hostname=[hostnames allowed to become a master]

For more information on this configuration, see the Configuring a Cluster with a Dedicated Main Node section in Installing and Configuring a Cluster Windchill Environment.

2. Copy the changes to the files in the Windchill, HTTP Server, and Embedded Servlet Engine directories from the main cache server to the secondary cache server. To do the copy, you can use rsync or any other tool of your choice (such as robocopy).

3. Create an entry in the local hosts file on the machine where you are installing Windchill. The entry resolves the cluster host name to 127.0.0.1. The local hosts file can be found in the following locations:

For example, use the following line if wc-cluster.company.com is the host name of the cluster:

4. Properly tunnel RMI requests over HTTP. For more information about tunneling RMI requests over HTTP, see Configuring RMI for Tunneling over HTTP.