Database shutdown with session migration

• US 20060200454A1
• Filed: 05/01/2006
• Published: 09/07/2006
• Est. Priority Date: 08/12/2004
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Gollapudi, Sreenivas, Krishnaswamy, Srinath, Kaluskar, Sanjay, Frumkin, Dmitry
• Granted Patent: US 7,502,824 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases

Abstract

When a request for a shutdown of a server (e.g. database server) is requested, existing sessions established for the clients are migrated to another server. Some sessions may not be migrated for various reasons; these sessions may be terminated without migrating them.

Claims

1. A method, comprising:

receiving a command requesting that a certain server hosted on a multi-node computer system be shutdown;

wherein said multi-node computer system includes a plurality of nodes that host a plurality of servers, said plurality of servers including said certain server, each node of said plurality of nodes hosting a server of said plurality of servers; and

in response to receiving said command;

attempting to migrate a plurality of sessions from said certain server;

after attempting to migrate said plurality of said sessions, determining to terminate one or more certain sessions of said plurality of sessions in lieu of migrating said one or more certain sessions; and

shutting down said server after all of said plurality of said sessions have either been terminated or migrated.

2. The method of claim 1, wherein:

a plurality of services are hosted on said multi-node computer system;

a particular session of said plurality of sessions is associated with a particular service of said plurality of services; and

the steps further include selecting a server to which to migrate said particular session based on one or more factors that include whether a destination server to which to migrate said particular session hosts said particular service.

3. The method of claim 1, wherein:

a plurality of services are hosted on said multi-node computer system;

a particular session of said plurality of sessions is associated with a particular service of said plurality of services; and

determining to terminate one or more certain sessions is based on determining that no other server hosts said particular session.

4. The method of claim 1, wherein said command is a single statement conforming to a computer language.

5. The method of claim 1, wherein said command is an invocation of a function or routine of an API.

6. The method of claim 1, wherein the steps performed in response to receiving said command further include directing connection requests for sessions to servers other than said certain server.

7. The method of claim 1, wherein said plurality of nodes hosts a plurality of database servers that include said certain server.

8. The method of claim 7, wherein said plurality of database servers manage access to a database.

9. The method of claim 1, wherein the steps performed in response to receiving said command further include migrating a subset of said plurality of sessions, wherein said migrating said subset includes balancing load on said subset of plurality of sessions.

10. The method of claim 1,

wherein termination of said one or more certain sessions includes waiting for said one or more certain sessions to be user terminated;

and

while said waiting, further attempting to migrate said one or more certain sessions.

11. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 1.

12. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 2.

13. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 3.

14. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 4.

15. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 5.

16. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 6.

17. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 7.

18. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 8.

19. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 9.

20. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 10.