REDUCING DOWNTIME DURING UPGRADES OF INTERRELATED COMPONENTS IN A DATABASE SYSTEM

• US 20140101646A1
• Filed: 03/14/2013
• Published: 04/10/2014
• Est. Priority Date: 09/28/2012
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: BUZASKI, George, HUDSON, Kevin, BASTIDAS, Santiago Xavier, DUJMOVIC, Ivo, ARDERIUS, Maximiliano
• Granted Patent: US 9,448,784 B2
• Time in Patent Office: Days
• US Class Current: 717/168
• CPC Class Codes: G06F 11/2056 by mirroring
• CPC Class Codes: G06F 11/2058 using more than 2 mirrored copies
• CPC Class Codes: G06F 16/178 Techniques for file synchronisation in file systems
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/2372 Updates performed during offline database operations
• CPC Class Codes: G06F 16/2393 Updating materialised views
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 8/65 Updates security arrangements therefor G06F21/57
• CPC Class Codes: G06F 8/656 while running
• CPC Class Codes: G06F 8/658 Incremental updates; Differential updates
• CPC Class Codes: G06F 8/71 Version control security arrangements therefor G06F21/57; Configuration management

Abstract

A method, system, and computer program product for reducing downtime during upgrades of interrelated components in a computing environment. The method commences while at least one running software application is executing within the computing environment by loading a plurality of database objects from an initial run edition into a patch edition. The database objects comprise at least one software application code module, at least one relational database table, and at least one file system. The method continues by applying at least one patch to the software application code module(s) corresponding to the running software application(s) to create patched software application(s), then applying patches to the relational database table to create a patched relational database table, and further applying a patch to the file system to create a patched file system. When the subject patches have been applied, the method stops the running software application(s) and starts the patched software application(s).

Claims

1. A computer implemented method for reducing downtime during upgrades of interrelated components in a computing environment, the method comprising:

loading, while at least one running software application is executing within the computing environment, a plurality of database objects from an initial run edition into a patch edition, the database objects comprising at least one software application code module, at least one relational database table, and at least one file system;

applying at least one first patch to the at least one software application code module corresponding to the at least one running software application to create a patched software application;

applying at least one second patch to the at least one relational database table to create a patched relational database table;

stopping the at least one running software application; and

starting the patched software application.

2. The method of claim 1, further comprising modifying a synonym to refer to a logical schema of the patch edition.

3. The method of claim 1, further comprising applying at least one file system patch to the at least one file system to create a patch file system.

4. The method of claim 3, further comprising configuring the patch file system as a new run file system.

5. The method of claim 1, further comprising deleting the at least one software application code module that was used to create the patched software application.

6. The method of claim 1, further comprising executing one or more enablement steps, the enablement steps comprising at least one of, calculating free space requirements, granting edition management permissions, or enabling editioning for users.

7. The method of claim 1, further comprising executing one or more finalizing steps, the finalizing steps comprising at least one of, computing cutover actions, recompiling selected objects, or reporting processing errors.

8. The method of claim 1, further comprising accessing the patched relational database table using the patched software application.

9. A computer system for reducing downtime during upgrades of interrelated components in a computing environment, comprising:

a computer processor to execute a set of program code instructions; and

a memory to hold the program code instructions, in which the program code instructions comprises program code to perform,

loading, while at least one running software application is executing within the computing environment, a plurality of database objects from an initial run edition into a patch edition, the database objects comprising at least one software application code module, at least one relational database table, and at least one file system;

applying at least one first patch to the at least one software application code module corresponding to the at least one running software application to create a patched software application;

applying at least one second patch to the at least one relational database table to create a patched relational database table;

stopping the at least one running software application; and

starting the patched software application.

10. The computer system of claim 9, further comprising program code for modifying a synonym to refer to a logical schema of the patch edition.

11. The computer system of claim 9, further comprising program code for applying at least one file system patch to the at least one file system to create a patch file system.

12. The computer system of claim 11, further comprising program code for configuring the patch file system as a new run file system.

13. The computer system of claim 9, further comprising deleting the at least one software application code module that was used to create the patched software application.

14. The computer system of claim 9, further comprising program code for accessing the patched relational database table using the patched software application.

15. A computer program product embodied in a non-transitory computer readable medium, the computer readable medium having stored thereon a sequence of instructions which, when executed by a processor causes the processor to execute a process to implement reducing downtime during upgrades of interrelated components in a computing environment, the process comprising:

loading, while at least one running software application is executing within the computing environment, a plurality of database objects from an initial run edition into a patch edition, the database objects comprising at least one software application code module, at least one relational database table, and at least one file system;

applying at least one first patch to the at least one software application code module corresponding to the at least one running software application to create a patched software application;

applying at least one second patch to the at least one relational database table to create a patched relational database table;

stopping the at least one running software application; and

starting the patched software application.

16. The computer program product of claim 15, further comprising instructions for modifying a synonym to refer to a logical schema of the patch edition.

17. The computer program product of claim 15, further comprising instructions for applying at least one file system patch to the at least one file system to create a patch file system.

18. The computer program product of claim 17, further comprising instructions for configuring the patch file system as a new run file system.

19. The computer program product of claim 15, further comprising instructions for deleting the at least one software application code module that was used to create the patched software application.

20. The computer program product of claim 15, further comprising instructions for accessing the patched relational database table using the patched software application.