ITS-AIS Data, Platforms, and Architecture team provides Oracle Hosting and Administration Services. These services include the physical design, implementation and maintenance of the database as well as data security, data integrity, backup/recovery, performance monitoring, and tuning.
Advanced Technical Information
General Support Information
Troubleshooting
Current Status
Maintenance
Past 90 Days
Alert History
The University Data Warehouse - DWPROD will be down for maintenance to upgrade hardware for Oracle production server Toast. During this time the following production databases will not be available: dwprod.
The issue has been resolved.
We are experiencing degraded performance with Peoplesoft Financials, Oracle, and SQL that is causing slowness and timeouts. Support staff are investigating the issue.
ITS will apply security updates to the Oracle servers. Each instance on the server will be down for approximately 20-30 minutes per host. Below is an approximate schedule:
Server Time
fprod-db 3:30am
hprod-db 3:50am
bagel 4:15am
garlic 4:15am
scone 4:15am
zwieback 4:15am
hoagie 4:40am
popo 4:40am
toast 4:40am
The Oracle production server Scone will be down for maintenance to upgrade hardware. During this time the following production databases will not be available: acdbprod, awprod, cfdev, nm01prod, nolij6p, pcrdprod, radarprd.
ITS will apply security updates to the Oracle servers. Each instance on the server will be down for approximately 20-30 minutes per host. Below is an approximate schedule:
Server Time
fprod-db 3:30am
hprod-db 3:50am
bagel 4:15am
garlic 4:15am
scone 4:15am
zwieback 4:15am
hoagie 4:40am
popo 4:40am
toast 4:40am
ITS will apply security updates to the Oracle servers. Each instance on the server will be down for approximately 20-30 minutes per host. Below is an approximate schedule:
Server Time
fprod-db 3:30am
hprod-db 3:50am
bagel 4:15am
garlic 4:15am
scone 4:15am
zwieback 4:15am
hoagie 4:40am
toast 4:40am
These issues are resolved.
The restoration of the data warehouse onto good SAN storage is complete and is available for use. MAUI daily, HRIS, and Financials reloads have completed. Additional data loads will continue through the day today and into Monday. Please let us know of any issues or questions, and thanks for your patience during this process.
There will be a brief 30-minute outage on Monday evening, 7/18 at 7:00pm to perform a snapshot of the warehouse as a recovery point. We expect that to be the last outage associated with the recovery.
A disk failure has caused an outage for many University hosted services and databases. ITS is working to restore services.
ITS will apply security updates to the Oracle servers. Each instance on the server will be down for approximately 20-30 minutes per host. Below is an approximate schedule:
Server Time
fprod-db 3:30am
hprod-db 3:50am
bagel 4:15am
garlic 4:15am
scone 4:15am
zwieback 4:15am
hoagie 4:40am
popo 4:40am
toast 4:40am
ITS will apply security updates to the Oracle servers. Each instance on the server will be down for approximately 20-30 minutes per host. Below is an approximate schedule:
Server Time
fprod-db 3:30am
hprod-db 3:50am
bagel 4:15am
garlic 4:15am
scone 4:15am
zwieback 4:15am
hoagie 4:40am
popo 4:40am
toast 4:40am
ITS will apply security updates to the Oracle servers. Each instance on the server will be down for approximately 20-30 minutes per host besides hoagie and zwieback being up to 2 hours. Below is an approximate schedule:
Server Time
fprod-db 3:30am
hprod-db 3:50am
hoagie 4:20am
zwieback 4:40am
bagel 5:00am
garlic 5:00am
popo 5:00am
scone 5:00am
toast 5:00am
The University Data Warehouse, dwprod, will be unavailable so ITS can perform maintenance on the database server toast.
ITS will apply security updates to the Oracle servers. Each instance on the server will be down for approximately 10-20 minutes per host. Below is an approximate schedule:
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
toast 5:20am
ITS will apply security updates to the Oracle servers. Each instance on the server will be down for approximately 10-20 minutes per host. Below is an approximate schedule:
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
toast 5:20am
ITS will apply security updates to the Oracle servers. Each instance on the server will be down for approximately 10-20 minutes per host. Below is an approximate schedule:
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
toast 5:20am
ITS will apply security updates to the Oracle servers. Each instance on the server will be down for approximately 10-20 minutes per host. Below is an approximate schedule:
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
toast 5:20am
DWPROD will be down for maintenance and upgraded to 19c.
ITS will apply security updates to the Oracle servers. The schedule for each host is as follows:
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
toast 5:20am
ITS will apply OS patches to three production Oracle servers (Hoagie, Toast, Zwieback). All instances will be down for approximately 20 minutes per host. Below is an approximate schedule for each host.
Server Time
hoagie 5:40am
toast 6:00am
zwieback 6: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-20 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
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.
Server 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 31st 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
Oracle Hosting and Administration Contact Information
Contact Sriram Chari, AIS Director, sriram-chari@uiowa.edu