MST Database Patching/Upgrade Schedule
The following table outlines the patching and upgrade schedule for all MST databases.
MST Database Patching/Upgrade schedule for 2018
|Date and Time||Description||Databases|
|05/01 4:00 AM - 6:00 AM||Apply April PSU to dev databases|| gamsdvdb|
|05/08 4:00 AM - 6:00 AM||Apply quarterly Oracle patches to test databases|| msttst
|05/15 4:00 AM - 6:00 AM||Apply April PSU patches to first set of production databases|| iamdb
|05/29 4:00 AM - 6:00 AM||Apply April PSU patches to second set of production databases|| gamsdb
|06/25 4:00 AM - 6:00 AM||Upgrade dev databases to 12.2||
|07/05 4:00 AM - 6:00 AM||Upgrade test databases to version 12.2||
|07/17 4:00 AM - 6:00 AM||Upgrade first set of production databases to 12.2||
|07/31 4:00 AM - 6:00 AM||Upgrade 2nd set of production databases to 12.2||
At no point during maintenance will NetID Login Service or Wisconsin Federation be unavailable. SAML2 Login and attribute delivery for UW Madison and UW System will not be impacted.
IMPORTANT: A precise procedure must be followed by users of the redundant PHEXPP environment to avoid unexpected interruptions during planned maintenance to PHEXPP1 and PHEXPP2. Instructions for this procedure may be found at the following address: https://kb.wisc.edu/page.php?id=60684.
Please contact your appropriate Middleware representative or email@example.com if you have any concerns or questions about this maintenance.
If you would like to avoid unplanned database outages, your applications should be configured to use the PHEXPP database. The PHEXPP database is a fully redundant system comprised of separate servers and databases with failover protection, such that users will be able to reconnect immediately to the secondary PHEXPP database should the primary database go down unexpectedly. PHEXPP will not have to endure an outage should either one of the database servers become unavailable. If you would like to discuss migrating your applications to PHEXPP, please contact your normal Middleware contact or email firstname.lastname@example.org.
Impacts in ITE:
MSTTST, PHEXPT1, and PHEXPT2 - Data access to schemas on MSTTST, PHEXPT1, and PHEXPT2 will be inaccessible.
GAMSTSDB - ITE Manifest will be unavailable.
IAMTSDB - ITE Oracle Identity Manager will be unavailable.
Impacts in Production:
UWPDR - Any data access to schemas on UWPDR (IAA) (e.g. UDSVIEWS, IAAVIEWS, PASEVIEWS, IDM, PASE and IAAREG) will be inaccessible.
- Many MST Web Services will not be able to deliver data.
- New Data will not flow through Person Hub to downstream IAA and UDS customers.
- NetID and Service activation will not be available.
PHEXPP1 and PHEXPP2 - Customers of PHEXPP who have properly configured their client should see no impact.
GAMSDB - Manifest services will be unavailable.
IAMDB - Oracle Identity Manager will be unavailable.