Configuring a New Windchill Installation for use with Oracle Data Guard

Complete the following steps to configure a new Windchill installation for use with Oracle Data Guard.

1. Configure and verify Oracle Data Guard following the information provided by Oracle: https://docs.oracle.com/database/121/SBYDB/create_ps.htm

PTC strongly recommends selecting MaxProtection as the Data Guard Protection mode to avoid any data inconsistencies immediately after a database failover. While assuring data consistency, this protection mode can negatively affect overall system performance.

2. Configure the client failover service for Oracle Data Guard using the “Client Failover Best Practices for Highly Available Oracle Databases: Oracle Database 11g Release 2” white paper provided by Oracle (http://www.oracle.com/technetwork/database/features/availability/maa-wp-11gr2-client-failover-173305.pdf) or Oracle support documents 461874.1 or 1429223.1.

3. Create the Windchill Oracle database user schema by executing the following statements as a database administrative user, using SQL*Plus. Replace the variables with values appropriate for your system.

create user <Windchill_DB_Username> identified by <Windchill_DB_User_password>
default tablespace <Default_Tablespace_Name>
temporary tablespace <Temporary_Tablespace_Name>
/
grant connect, resource to <Windchill_DB_Username>
/
grant create sequence, create view, query rewrite, select any dictionary,
unlimited tablespace to <Windchill_DB_Username>

4. Launch the PTC Solution Installer (PSI) and install Windchill by selecting the Oracle Advanced option for the Database Software field in the platform components window.

5. In the database information window of the PSI, enter the following information:

◦ The full Oracle Data Guard connection string in the Oracle Database Connection String field as follows, replacing the variables with values appropriate for your system:

(DESCRIPTION=(ADDRESS_LIST=(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)
(HOST=<Primary_DB_HOST>)(PORT=<Listener_Port>))(ADDRESS=(PROTOCOL=TCP)
(HOST=<StandBy_DB_HOST>)(PORT=<Listener_Port>)))
(CONNECT_DATA=(SERVICE_NAME=<Client_Failover_Service_Name>)
(SERVER=DEDICATED)(FAILOVER_MODE=(TYPE=session)(METHOD=BASIC)(RETRIES=180)
(DELAY=5))))

◦ The user name and password of the existing Windchill database user in the User Name and Password fields.