Oracle Apps Cloning
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