Browse Prior Art Database

Method and System for Automatically Cloning Oracle Application Instances Running on Real Application Clusters (RAC) Architecture

IP.com Disclosure Number: IPCOM000203500D
Publication Date: 2011-Jan-27
Document File: 4 page(s) / 110K

Publishing Venue

The IP.com Prior Art Database

Abstract

A method and system is provided for automatically cloning Oracle* application instances running on a Real Application Clusters (RAC) architecture. An automation tool is used for automatically cloning the Oracle application instances.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 47% of the total text.

Page 01 of 4

Method and System for Automatically Cloning Oracle Application Instances Running on Real Application Clusters (RAC) Architecture

Disclosed is a method and system for automatically cloning Oracle* application instances, running on Real Application Clusters (RAC) architecture using an automation tool such as the Kintana** automation tool.

The Kintana automation tool is based on Oracle Apps architecture and provides features that enable automation. For example, the Kintana automation tool includes features such as "Workflow" for automating repetitive tasks and eliminating error prone processes, environment definitions, GUI for creating automation packages, and a modular approach to script execution. "Workflow" controls process flow in the Kintana automation tool and the environment definitions contain OS user credentials for a client/server, which may be used during execution. The Workflow is attached with backend scripts using entities called object types.

Fig. 1 exemplarily illustrates execution steps involved in automatically cloning an Oracle application instance running on RAC architecture. The RAC architecture is a four node architecture consisting of two database nodes and two application nodes. The RAC architecture performs load balancing across the two application nodes. The database nodes include an RAC "Primary" node and an RAC "Secondary" node. The application nodes include an APP "Primary" node and an APP "Secondary" node. The RAC "Primary" node and the APP "Primary" node are grouped in the client/server architecture and are termed as primary object types. Similarly, the RAC "Secondary" node and the APP "Secondary" node are grouped in the client/server architecture and are termed as secondary object types. The primary object types and the secondary object types are together termed as "Environment".

1


Page 02 of 4

(This page contains 00 pictures or other non-text object)

Figure 1

The execution steps that may be processed in parallel to reduce total time taken for clone are indicated in Fig. 1. The symbol, "=" depicts serial execution on multiple nodes, whereas the symbol, "||" depicts parallel execution on the multiple nodes. A Kintana package is built using the Kintana automation tool for automating the cloning of the Oracle application instances. The Kintana automation tool is used to create environment definitions for the primary object types and the secondary object types. Thereafter, the Workflow for cloning the Oracle application instances is developed and backend scripts are written to work in synergy with the Kintana process flow. The primary object types and the secondary object types attach scripts to the Workflow.

Subsequent to developing the Workflow, the object types and the scripts, a Kintana clone package is created using the Kintana automation tool. A screenshot of an exemplary user interface of the Kintana automation tool used for creating the Kintana

2


Page 03 of 4

clone package is illustrated in Fig. 2...