CHG0000009
Summary | |||
---|---|---|---|
Number: | CHG0000009 | Approval: | Approved |
Type: | Normal | State: | New |
Category: | Software | Configuration item: | SAP ORA01 |
Impact: | 3 - Low | Phase: | Requested |
Urgency: | 3 - Low | Risk: | High |
Priority: | 1 - Critical | Closed at: | |
Short description: | Apply patches 10.2.0.1 to 10.2.0.3\n | ||
Reason: | |||
Parties & Schedule | |||
Assigned to: | Bow Ruggeri | ||
Start date: | 2019-11-14 10:00:00 | ||
End date: | 2019-11-14 15:00:15 |
Description
Need to apply the follow security patches from oracle -
10.2.0.1 to 10.2.0.3.
Change Plans
Backout Plan
* Shut down the database
* Change Oracle Home to the old
one
* Start the database
Test Plan
Read through the README file included with the patch and
test applying the patch or patchset in a non-production environment
prior to applying it in production.
Implementation Plan
- parent
- reason
- watch_list
- upon_reject
- cancel
- sys_updated_on
- 2019-11-17 21:58:35
- type
- normal
- approval_history
- number
- CHG0000009
- test_plan
- Read through the README file included with the patch and\n test applying the patch or patchset in a non-production environment\n prior to applying it in production.\n
- cab_delegate
- requested_by_date
- 2019-11-17 07:12:27
- state
- -5
- sys_created_by
- itil
- knowledge
- false
- order
- phase
- requested
- cmdb_ci
- SAP ORA01
- my_cmdb_ci
- SAP ORA01
- my_cmdb_ci_link
- Cmdb.3a72d947c0a8ce0100a7a64397fdcd53
- delivery_plan
- contract
- impact
- 3
- active
- true
- work_notes_list
- priority
- 1
- sys_domain_path
- /
- cab_recommendation
- production_system
- false
- review_date
- business_duration
- group_list
- requested_by
- Fred Luddy
- my_requested_by
- Fred Luddy
- my_requested_by_link
- SysUser.5137153cc611227c000bbd1bd8cd2005
- change_plan
- * Download the patch from Metalink.\n * Unzip it on the\n database server.\n * Shut down all databases using the Oracle9i home.\n *\n Apply the patchset to the Oracle binaries.\n * Start up all databases\n using the Oracle9i home and run required SQL\n scripts within each\n database.\n
- approval_set
- 2019-11-17 05:20:03
- implementation_plan
- end_date
- 2019-11-14 15:00:15
- short_description
- Apply patches 10.2.0.1 to 10.2.0.3\n
- correlation_display
- delivery_task
- work_start
- 2019-11-16 16:17:01
- additional_assignee_list
- outside_maintenance_schedule
- false
- std_change_producer_version
- service_offering
- sys_class_name
- change_request
- closed_by
- follow_up
- reassignment_count
- review_status
- assigned_to
- Bow Ruggeri
- my_assigned_to
- Bow Ruggeri
- my_assigned_to_link
- SysUser.F298d2d2c611227b0106c6be7f154bc8
- start_date
- 2019-11-14 10:00:00
- sla_due
- comments_and_work_notes
- escalation
- 0
- upon_approval
- proceed
- correlation_id
- made_sla
- true
- backout_plan
- * Shut down the database\n * Change Oracle Home to the old\n one\n * Start the database\n
- conflict_status
- sys_updated_by
- pat.casey
- opened_by
- ITIL User
- my_opened_by
- ITIL User
- my_opened_by_link
- SysUser.681b365ec0a80164000fb0b05854a0cd
- user_input
- sys_created_on
- 2019-11-17 05:16:25
- on_hold_task
- closed_at
- review_comments
- business_service
- time_worked
- expected_start
- opened_at
- 2019-11-17 05:07:53
- work_end
- 2019-11-16 20:17:04
- phase_state
- open
- cab_date
- work_notes
- close_code
- assignment_group
- description
- Need to apply the follow security patches from oracle -\n 10.2.0.1 to 10.2.0.3.\n
- on_hold_reason
- calendar_duration
- close_notes
- sys_id
- d7323e9dc0a8016700538974c2efb7f1
- contact_type
- phone
- cab_required
- false
- urgency
- 3
- scope
- 3
- company
- justification
- activity_due
- comments
- approval
- approved
- due_date
- sys_mod_count
- 16
- on_hold
- false
- sys_tags
- conflict_last_run
- unauthorized
- false
- location
- risk
- 2
- category
- Software
- risk_impact_analysis
- my_sys_class_name_link
- ChangeRequest.D7323e9dc0a8016700538974c2efb7f1
Change Tasks
Number | Opened At | Opened By | Assigned To | State | Closed At | Closed By | Summary |
---|---|---|---|---|---|---|---|
CTASK0010007 | 2016-11-10 05:21:13 | Bow Ruggeri | 3 | Download and unzip patch | |||
CTASK0010008 | 2016-11-10 05:23:45 | Don Goodliffe | 3 | Shut down all databases using the Oracle home | |||
CTASK0010009 | 2016-11-10 05:24:53 | David Loo | 3 | Apply the patchset Oracle binaries | |||
CTASK0010010 | 2016-11-10 05:26:34 | Fred Luddy | 3 | Startup all databases |