Efficiently executing commands against a large set of servers with near real time feedback of execution and presentation of the output of the commands

• US 20060212422A1
• Filed: 10/07/2005
• Published: 09/21/2006
• Est. Priority Date: 03/21/2005
• Status: Abandoned Application

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: McKeen, Karen, Khilani, Anil, Rizvi, Hasan, Akali, Harish
• Application Number:
  US11/245,864
• Publication Number:
  US 20060212422A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 9/45512 Command shells

Abstract

According to one embodiment of the invention, a technique is provided for interactive execution of commands on multiple computer targets. As the commands execute on the remote systems, the user receives feedback in real time. The feedback consists of the status of each command on each system and the output from each command executed on each system, among other items. The feedback is formatted in a user-friendly fashion to enable the user to quickly determine the status of the job, such as which systems have succeeded in executing the commands and which have failed. The feedback also indicates which systems are currently being operated on. The feedback may be viewed in real time as well as saved to a file for later viewing. In one embodiment, the user is also provided with a graphical user interface (GUI).

Claims

1. A method for interactive execution of commands on multiple computer targets, the method comprising:

receiving at a host machine from a user through a user interface, at least one command to be executed on a plurality of computer targets;

establishing a connection between the host machine and the plurality of computer targets;

causing the at least one command to be executed on the plurality of computer targets contemporaneously; and

displaying, for each of the plurality of computer targets, information in the user interface about the status of the commands being executed on said each of the plurality of computer targets.

2. The method of claim 1, wherein the computer targets are database systems.

3. The method of claim 1, wherein the at least one command specifies to execute commands in a file.

4. The method of claim 1, wherein the at least one command comprises a database statement.

5. The method of claim 4, wherein the database statements comprise SQL statements.

6. The method of claim 1, further comprising providing authentication information to at least one of the plurality of computer targets.

7. The method of claim 1, wherein the feedback further comprises output generated by the commands being executed.

8. The method of claim 1, wherein the commands being executed on the plurality of targets may be cancelled or suspended via the user interface.

9. The method of claim 1, wherein the commands being executed on the plurality of machines may be cancelled or suspended individually for each target via the user interface.

10. The method of claim 1, wherein the feedback further comprises the amount of time elapsed between the time the at least one command began executing on at least one of the plurality of computer targets and the time the at least one command completed execution on at least one of the plurality of computer targets.

11. The method of claim 1, wherein the feedback may be saved to a file.

12. The method of claim 1, further comprising creating a second plurality of computer targets by interactively adding or removing computer targets to the initial plurality of computer targets during or after the execution of the initial commands on the initial plurality of computer targets, then causing at least one command to be executed contemporaneously on the second plurality of computer targets.

13. The method of claim 1, further comprising causing at least one preliminary command to be executed on a subset of the plurality of computer targets prior to causing the at least one command to be executed on the plurality of computer targets.

14. The method of claim 13, wherein the preliminary command comprises SQL statements.

15. The method of claim 1, further comprising:

during the execution of the commands on the plurality of computer targets,

receiving a second set of commands;

selecting a second set of computer targets comprising at least one computer target on which the first commands have been completed; and

causing the second set of commands to be executed on the second set of computer targets.

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 2.

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 3.

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 4.

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 5.

21. 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.

22. 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.

23. 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.

24. 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.

25. 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.

26. 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 11.

27. 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 12.

28. 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 13.

29. 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 14.

30. 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 15.

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 steps of:

receiving at a host machine from a user through a user interface, at least one command to be executed on a plurality of computer targets;

establishing a connection between the host machine and the plurality of computer targets;

causing the at least one command to be executed on the plurality of computer targets contemporaneously; and

displaying, for each of the plurality of computer targets, information in the user interface about the status of the commands being executed on said each of the plurality of computer targets.