Case study – pharmaceutical

In the case of this large pharmaceutical company, they have an installation of 2000 Oracle databases of different versions, on 500 hosts having multiple platforms. The company decided to apply quarterly CPUs (Critical Patch Updates) recommended by Oracle, as soon as they were released by Oracle Support.

Applying patches manually to databases is a labor-intensive task, and takes up a lot of the DBA time, especially when there are so many databases, and a limited number of DBAs. Even if counting only around one hour per patch application, applying the patch quarterly to 2000 databases adds up to a lot of man-hours per year, and becomes prohibitively expensive.

The company decided to use the Patch Automation facility of ...

Get Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.