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 | 
