Oracle Apps Cloning

Refreshing single instance Test database with Production Data

What is Oracle Applications/Oracle E-Business Suite?

To facilitate big businesses, Oracle Corporation have created collection of software in the category of ERP (Enterprise Resource Planning) known as modules, that are integrated to talk to each other and known as Oracle Applications or E-Business Suite.

Oracle EBS R12 Architecture

Oracle EBS R12 Applications is a three-tiered architecture.

1. Desktop Tier

2. Application Tier

3. Database Tier

The Oracle Applications Architecture is a framework for multi-tiered, distributed computing that supports Oracle Applications products. In this model, various servers or services are distributed among three levels, or tiers.

First we need to know the important points like SERVER, NODE, MACHINE and TIER.

Server: Server is a process or group of processes that run on a single machine and provide a particular functionality.

Tier: A tier is a logical group of services that spread across more than one physical machine.

Machine or node: A machine is referred to as a node, particularly in the context of a group of computers that work closely together in a cluster.

Desktop Tier:

The Forms client applet must be run within a Java Virtual Machine (JVM) on the desktop client. The Sun J2SE Plug-in component allows use of the Oracle JVM on web clients, instead of the browser’s own JVM. This is implemented as a browser plug-in.

The Application Tier:

In Release 12, the application tier contains Oracle Application Server 10g (OAS10g). Three servers or service groups comprise the basic application tier for Oracle Applications:

Web services

The Web services component of Oracle Application Server processes requests received over the network from the desktop clients.

Forms services

Forms services in Oracle Applications Release 12 are provided by the Forms listener servlet or Form Socket mode, which facilitates the use of firewalls, load balancing, proxies, and other networking options.

Concurrent Processing server

Processes that run on the Concurrent Processing server are called concurrent requests. When you submit such a request, either through HTML-based or Forms-based Applications, a row is inserted into a database table specifying the program to be run. A concurrent manager then reads the applicable requests in the table, and starts the associated concurrent program.

Database Tier :

The database tier contains the Oracle database server, which stores all the data maintained by Oracle Applications.

R12 EBS Directory Structure

Techstack Components:

DB_TIER

11.2.0.1.0 RDBMS ORACLE_HOME

APPL-TIER

10.1.2 C ORACLE_HOME / FORMS ORACLE_HOME

10.1.3 Java ORACLE_HOME/OC4J ORACLE_HOME

INSTANCE_TOP: Each application tier has a unique Instance Home file system associated

Application Directory Structure

Oracle Apps cloning:

Need to refresh the Test database periodically to synchronize it with changes to the production DB.

Step 1:

Copy production backup to test server

Rename and open the database

Add the temp files to new database

Now go to $ORACLE_HOME/appsutil/install/<CONTEXT_NAME> directory:

Now, go to $ORACLE_HOME/appsutil/clone/bin/ and run the following command. Please note that the Database and the Listener should be up when you run this command.

Step 2:

Run autoconfig on Apps Tier

Oracle Apps Cloning

Partager cet article