CHG0000009

Summary
Number:CHG0000009Approval:Approved
Type:NormalState:New
Category:SoftwareConfiguration item:SAP ORA01
Impact:3 - LowPhase:Requested
Urgency:3 - LowRisk:High
Priority:1 - CriticalClosed 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


Click for Variables

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

NumberOpened AtOpened ByAssigned ToStateClosed AtClosed BySummary
CTASK00100072016-11-10 05:21:13Bow Ruggeri3  Download and unzip patch
CTASK00100082016-11-10 05:23:45Don Goodliffe3  Shut down all databases using the Oracle home
CTASK00100092016-11-10 05:24:53David Loo3  Apply the patchset Oracle binaries
CTASK00100102016-11-10 05:26:34Fred Luddy3  Startup all databases