Schedule meeting with the OIT Oracle team.
Re-scheduled for Monday 2/27
Agenda:
Confirming work next week (read-only mode) - confirming our work on Monday and OIT's work on Tuesday
Estimate less than 2 hours
Why read only - if we don't do that (users would continue to add data) and then need to do a re-index of data (this would mitigate loss of data). we will look at enabling read-only on the app side.
we want to have prod data copied over well in advance of next week.
Monday 2/27 -Tuesday 2/28
LTDS - servicenow ticket to Naiqi
Thursday 3/2
Beth will email let Naiqi know we are ready
Naiqi copy up to 19c (estimate of between 1hour and 2 hours)
Thursday 2/2 to Monday 3/6
App will be read-only
Monday 3/6 to Wednesday 3/8
LTDS will update connection string for 19c
LTDS will get results from testing
Collin will let Naiqi know when to lock down the application account in the 12c db
Acceptance / Backout Criteria
If testing goes well LTDS will send Naiqi the all-clear to delete the databases.
If testing does not go well with the copied db then we will need to delete things in the copied database and reindex from the application (could take up to 5 days)
If the second bullet does not go well then we need to unlock the 12c db and revert back and reschedule work after commencement.
Confirm list of dbs
COMPLETED: fedcopd and fedcoqa. Oracle has a 8-character limit on names. pd for prod, qa for test.
Cost Item
The database team is currently running both prod and qa on one server, and would like to move to two. This will cost ~$250 per month, but a better estimate is coming.
KBS has cost estimates (add info or steps to the cost ticket on the board)
Naming Conventions
COMPLETED/ DECISION: fedcoprd > fedcopd (so both can run simultaneously)
Connection Conventions
COMPLETED/DECISION continue using what we have
Confirm Change Request approach
Naiqi will put in a change record for this work as a risk level 5
LTDS can send Naiqi our CI's affected for that change record
Doug will update senior leadership for their feedback as this change results in a risk level 2 for students and faculty uptime access to the content and material provided by the applications via the databases that are upgrading from 12c to 19c.
Parking Lot: ESD QA
note: the esdqa upgrade is also a dependency used by our fedora app.
Schedule meeting with the OIT Oracle team. Re-scheduled for Monday 2/27
Agenda:
Confirming work next week (read-only mode) - confirming our work on Monday and OIT's work on Tuesday
Monday 2/27 -Tuesday 2/28
Thursday 2/2 to Monday 3/6
Monday 3/6 to Wednesday 3/8
Acceptance / Backout Criteria
Confirm list of dbs
Cost Item
Naming Conventions
Connection Conventions
Confirm Change Request approach
Parking Lot: ESD QA