Configuring an Existing Windchill Oracle Database for use with Oracle Data Guard
Complete the following steps to configure an existing Windchill Oracle database for use with Oracle Data Guard.
1. Stop Windchill.
2. Back up the existing Windchill database, and verify that the backup is valid.
|
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.
|
5. From a Windchill shell, run the following command to set the needed properties, replacing the variables with values appropriate for your system:
xconfmanager -s wt.pom.dbConnectionRetryCount=60 -t "db/db.properties"
xconfmanager -s
wt.pom.jdbc.host="(DESCRIPTION=(ADDRESS_LIST=(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))))" -t "db/db.properties"
xconfmanager -s wt.pom.jdbc.port="" -t "db/db.properties"
xconfmanager -s wt.pom.jdbc.service="" -t "db/db.properties"
xconfmanager -p
6. Start Windchill.
7. Verify that all Windchill functionality works as expected.