FAQ
Our environment:
95% RHEL5
5% Windows
Approximately 120 Oracle EE 11.2.0.2 databases.
3 DBAs
We're looking for a method to help automate the application of the quarterly CPUs. We've looked into the Database Lifecycle Management Pack to help provide automation for the process but that is very costly. We can manually apply the CPU to each database but as the number of databases increase and our head count does not, that approach does not scale well. We've thought about somehow building our own automation but that can become a maintenance issue over time.

I would be interested in hearing about the tools and processes that others use to manage the application of CPUs across many database installations.

Thanks,
Stan

Search Discussions

  • Wayne Smith at Apr 30, 2012 at 3:11 pm
    That's a great question, Stan.
    I've been thinking about the same area. This doesn't have to be an
    all-or-none solution ... you (I) could build it over time and each part
    could be useful as it is available to be deployed.

    - script to connect to a/each machine and verify/determine
    - Op/sys
    - homes
    - patchset
    - CPU/PSU
    - running services
    - script to download/explode appropriate CPU/PSU patch(es)
    - script to run/return/analyze "opatch prereq
    CheckConflictAgainstOHWithDetail"
    - (actually applying CPU/PSU with total automation is beyond what I want
    to do, but I might build a script to take Oracle down, a script to
    run/record/analyze patch application and another to bring things up as they
    were?)


    Have others addressed this area with code they can share or see issues
    deserving warning?

    Cheers, Wayne

    - "Never argue with an idiot. They drag you down to their level and then
    beat you with experience." - Unknown

    On Mon, Apr 30, 2012 at 10:07 AM, Kroll, Stanley R.
    <krolls@umsystem.edu>wrote, in part:
    Our environment:
    95% RHEL5
    5% Windows
    Approximately 120 Oracle EE 11.2.0.2 databases.
    3 DBAs
    We're looking for a method to help automate the application of the
    quarterly CPUs. We've looked into the Database Lifecycle Management Pack
    to help provide automation for the process but that is very costly. We
    can manually apply the CPU to each database but as the number of databases
    increase and our head count does not, that approach does not scale well.
    We've thought about somehow building our own automation but that can
    become a maintenance issue over time.

    I would be interested in hearing about the tools and processes that others
    use to manage the application of CPUs across many database installations.

    --
    http://www.freelists.org/webpage/oracle-l
  • Joel Patterson at Apr 30, 2012 at 10:12 pm
    I understand that there is a way using Enterprise Manager.

    Joel Patterson
    Database Administrator
    904 727-2546

    -----Original Message-----
    From: oracle-l-bounce@freelists.org On Behalf Of Kroll, Stanley R.
    Sent: Monday, April 30, 2012 10:08 AM
    To: oracle-l@freelists.org
    Subject: Process and tools for managing Critical Patch Updates

    Our environment:
    95% RHEL5
    5% Windows
    Approximately 120 Oracle EE 11.2.0.2 databases.
    3 DBAs
    We're looking for a method to help automate the application of the quarterly CPUs. We've looked into the Database Lifecycle Management Pack to help provide automation for the process but that is very costly. We can manually apply the CPU to each database but as the number of databases increase and our head count does not, that approach does not scale well. We've thought about somehow building our own automation but that can become a maintenance issue over time.

    I would be interested in hearing about the tools and processes that others use to manage the application of CPUs across many database installations.

    Thanks,
    Stan

    --
    http://www.freelists.org/webpage/oracle-l


    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedApr 30, '12 at 2:08p
activeApr 30, '12 at 10:12p
posts3
users3
websiteoracle.com

People

Translate

site design / logo © 2021 Grokbase