ITS will apply the quarterly Oracle security patch to all production Oracle servers. All Oracle instances will be down approximately 10 minutes per host. Below is an approximate schedule for each host.

S​​​​​​erver           Time
fprod-db         3:30am
hprod-db        3:50am
popo               4:10am
garlic              4:20am
bagel              4:30am
scone             4:40am
hoagie            4:50am
zwieback        5:10am
crepe              5:20am
toast               5:30am
banana           5:40am

ITS will be applying an OS patch for the production Oracle servers Hoagie, Toast, Scone and Garlic. All instances on the server be will be unavailable and will take approximately 30 minutes per host.

Server            Time            Datebases
Hoagie            5:30am        HOSPHRP, cdtaprod, filesprd, itconnp, vaultprd, wrkflowp
Toast               6:00am        dwprod
Scone             6:30am         acdbprod, awprod, cfdev, nm01prod, nolij6p, pcrdprod, radarprd, saprod, writctrp
Garlic              7:00am         unipcrdp

ITS will be replacing hardware for production Oracle server Popo. All instances on the server will be unavailable.

Impacted instances include: commprod, mauiprod, soapprod, uachprod, unitimep

ITS will be replacing hardware for production Oracle server Bagel. All instances on the server will be unavailable. 

Impacted instances include: ecoiprod, facprod, hawkirb, isisprod, preqprod, smacprod, webmiscp

ITS will apply Oracle Native Network Encryption to all production Oracle servers.  Oracle services will remain available during the maintenance window.

Contact the ITS Oracle Database Administration Team at ITS-DPA-Oracle-Notify@uiowa.edu if you have questions or concerns.

ITS will be applying the quarterly Oracle security patch to all production Oracle servers. The security patch install requires that all instances on the server be brought down, the install will take approximately 10 minutes per host. Below is an approximate schedule for each host.
 
Server           Time
fprod-db         3:30am
hprod-db        3:50am
scone             4:10am
garlic              4:20am
bagel              4:30am
popo               4:40am
hoagie            4:50am
toast               5:10am
crepe              5:20am

ITS will be applying the quarterly Oracle security patch to all production Oracle servers. The security patch install requires that all instances on the server be brought down, the install will take approximately 10 minutes per host. Below is an approximate schedule for each host.

Server            Time
fprod-db         3:30am
hprod-db        3:50am
scone             4:10am
garlic              4:20am
bagel              4:30am
popo               4:40am
hoagie            4:50am
zwieback        5:10am
crepe              5:20am
toast               5:30am
banana           5:40am
 

ITS will be replacing hardware for the production Oracle server Toast.  The University Data Warehouse, DWPROD, will be unavailable during this time.

ITS will be replacing hardware for the production Oracle server Hoagie. All instances on the server will be unavailable. 

Impacted instances include: HOSPHRP, cdtaprod, filesprd, vaultprd, wrkflowp.

ITS will be applying the quarterly Oracle security patch to all production Oracle servers.  The security patch install requires that all instances on the server be brought down, the install will take approximately 10 minutes per host. Below is an approximate schedule for each host.

Server            Time
fprod-db         3:30am
hprod-db        3:50am
scone             4:10am
garlic              4:20am​​​​​​​
bagel              4:30am
popo               4:40am​​​​​​​
hoagie            4:50am​​​​​​​
ginger             5:00am​​​​​​​
zwieback        5:10am​​​​​​​
crepe              5:20am​​​​​​​​​​​​​​
toast               5:30am​​​​​​​
banana           5:40am

ITS will apply OS patches to production Oracle servers Popo and Toast. The patch requires that all instances on the server be brought down. The install will take up to one hour per host.  

Impacted instances: dwprod, mauiprod, commprod, uachprod, soapprod, and unitimep

ITS will be applying the quarterly Oracle security patch to all production Oracle servers. The security patch install requires that all instances on the server be brought down, the install will take approximately 10 minutes per host. Below is an approximate schedule for each host.

Note: server popo will be getting an OS patch applied, down time will be up to 60 minutes for popo only.

Server             Time
fprod-db         3:30am
hprod-db        3:50am
scone             4:10am
garlic              4:20am
bagel              4:30am
popo               4:40am
hoagie            4:50am
ginger             5:00am
zwieback        5:10am
toast               5:20am
banana           5:30am

ITS will be applying the quarterly Oracle security patch to all production Oracle servers. The security patch install requires that all instances on the server be brought down, the install will take approximately 10 minutes per host.

ITS will be applying the quarterly Oracle security patch to all production Oracle servers. The security patch install requires that all instances on the server be brought down, the install will take approximately 10 minutes per host. Below is an approximate schedule for each host.
 
Server            Time
fprod-db         3:30am
hprod-db        3:50am
scone             4:10am
garlic              4:20am
bagel              4:30am
popo               4:40am
crepe              4:50am
hoagie            5:00am
ginger             5:10am
zwieback        5:20am
toast               5:30am
banana           5:40am

ITS will be applying OS patches to the following production Oracle servers.  The patch install requires that all instances on the server be brought down, the install will take up to one hour per host. Below is an approximate schedule for each host.

Server            Time

hprod-db        3:30am

bagel              4:10am

popo               4:40am

ginger             5:10am

banana           5:30am

ITS will be applying OS patches to the following production Oracle servers.  The patch install requires that all instances on the server be brought down, the install will take up to one hour per host. Below is an approximate schedule for each host.

Server            Time

fprod-db         3:30am

scone             4:15am

hoagie            4:50am

zwieback        5:20am

ITS will be applying the quarterly Oracle security patch to all production Oracle servers.  The security patch install requires that all instances on the server be brought down, the install will take approximately 10 minutes per host. Below is an approximate schedule for each host.
 

Server                   Time

fprod-db              3:30am

hprod-db             3:50am

scone                    4:10am

garlic                     4:20am

bagel                     4:30am

popo                     4:40am

crepe                    4:50am

hoagie                  5:00am

ginger                   5:10am

zwieback             5:20am

toast                      5:30am

Note: The test Oracle servers will be patched this Friday April 20 starting at 7pm.

ITS will be applying the quarterly oracle security patch to the server Bagel along with the majority of the production oracle servers.  The security patch install requires that all instances on the server be brought down, the install will take approximately 10 minutes. 

The oracle test servers will be getting patched this Sunday, July 31^st starting at 8am, this will not impact prod instances just test.

Oracle instances on the server that will be unavailable during the 10 minute downtime are as follows:

bagel.its.uiowa.edu
ecoiprod
facprod
hawkirb
isisprod
preqprod
smacprod
webmiscp

fprod-db        3:30am
hprod-db       3:50am
scone            4:10am
garlic             4:20am
bagel            4:30am
popo             4:40am
crepe            4:50am
hoagie           5:00am
ginger             5:10am
flat                   5:20am
s-lib003           5:30am
ihprod              5:40am
zwieback          5:50am
toast                 6:00am