Steven S Lim

US Patent:

20140068584, Mar 6, 2014

Filed:

Aug 31, 2012

Appl. No.:

13/600786

Inventors:

Steven S.H. Lim - Amherst NH, US
Joydip Kundu - Derry NH, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 9/44
G06F 17/30

US Classification:

717168

Abstract:

A method, system, and computer program product for upgrading high-availability database systems. The method commences by specifying a subject database configuration state (e.g., an initial state) as well as an upgraded database configuration state (e.g., an upgraded state). Then, the method performs operations for compiling the specifications and validating the upgraded database configuration state with respect to the specified subject database configuration state. Compile errors are reported and a user can change the specifications. Once the compiler determines that the upgraded configuration state can be reached from the subject database configuration state, then the method generates an upgrade plan. The upgrade plan is executed by a computer-implemented controller. During execution of the plan, the controller pauses for accepting user intervention at key execution points. The controller monitors state changes to establish checkpoints. In the event of execution errors detected during execution of the plan, corrective action reports are output.