In Oracle : Cloning Oracle Apps multi node to single node

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Applications EBS

Oracle Apps 11i DBA (I) Oracle Apps 11i DBA (II) Oracle Apps 11i DBA (III) Oracle Apps 11i Sys Admin UPGRADE 11i Apps to R12 Oracle Apps R12 DBA

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle Applications (apps)  -> 11i

-> Cloning Oracle Apps multi node to single node

 

 Cloning Oracle Apps Multi Node to Single Node

 

 

To see if your environment is ready for the Cloning with Rapid Clone, please check the Metalink Note 230672.1.

 

NOTE: The initial system has ONE APPL_TOP on one node (apps.localdomain) and the DB tier on another node (db.localdomain).

 

 

    These easy to follow steps will allow you to move or clone Oracle applications from one location to another. This can be essential when moving from a multi-node system to single-node system. It may seem complex, but by approaching such a task one stage at a time it will become much easier under understand this technical process.

 

    Cloning Oracle Applications 11i with Rapid Clone is extremely useful for anyone wishing to convert from one system to another. You could even use SSH in conjunction with the latest Mobile Broadband to access this database information when you're not at your computer. Simply follow the stages described in order to clone your database information and convert information stored from one system to another.

1. Maintain Snapshot information (on the APPS node)

    adadmin -> 2. Maintain Applications Files menu -> 5. Maintain snapshot information -> 2. Update current view snapshot

 

2. Prepare the source system database tier for cloning

    cd <RDBMS ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>

    perl adpreclone.pl dbTier 

 

    cd $ORACLE_HOME/appsutil/scripts/VIS_apps
    perl adpreclone.pl dbTier 

 

 

3. Prepare the source system application tier for cloning

    cd <COMMON_TOP>/admin/scripts/<CONTEXT_NAME>
    perl adpreclone.pl appsTier

 

    cd $COMMON_TOP/admin/scripts/VIS_apps
    perl adpreclone.pl appsTier

 

 

4. Stop the Apps services if is not already done

    $COMMON_TOP/admin/scripts/<CONTEXT_NAME>/adstpall.sh apps/apps

 

    $COMMON_TOP/admin/scripts/VIS_apps/adstpall.sh apps/apps

 

5. Shutdown the Database and stop the listener

    $ORACLE_HOME/appsutil/scripts/<CONTEXT_NAME>/addlnctl.sh stop VIS
    $ORACLE_HOME/appsutil/scripts/<CONTEXT_NAME>/addbctl.sh stop immediate VIS

 

    $ORACLE_HOME/appsutil/scripts/VIS_db/addlnctl.sh stop VIS
    $ORACLE_HOME/appsutil/scripts/VIS_db/addbctl.sh stop immediate VIS

 

 

6. On the target system, create the directory where the Applications will be cloned

    [oracle@linux1 ~]$ su - root
    Password:
    [root@linux1 ~]# mkdir /APPS_11i
    [root@linux1 ~]# chown oracle:dba /APPS_11i

 

7. Copy the following application tier directories from the source node to the target application tier node: 

<APPL_TOP> 
<OA_HTML> 
<OA_JAVA> 
<OA_JRE_TOP> 
<COMMON_TOP>/util 
<COMMON_TOP>/clone 
<COMMON_TOP>/_pages (when this directory exists) 
<806 ORACLE_HOME> 
<iAS ORACLE_HOME> 

 

Source Node = apps.localdomain Destination Node = linux1.localdomain
/APPS_MI/visappl /APPS/visappl
/APPS_MI/viscomn/html /APPS/viscomn/html
/APPS_MI/viscomn/java /APPS/viscomn/java
/APPS_MI/viscomn/util /APPS/viscomn/util
/APPS_MI/viscomn/clone /APPS/viscomn/clone
/APPS_MI/viscomn/_pages /APPS/viscomn/_pages
/APPS_MI/visora/8.0.6 /APPS/visora/8.0.6
/APPS_MI/visora/iAS /APPS/visora/iAS

The files are copied from the apps node (apps.localdomain) and db node (db.localdomain) to the new node ( linux1.localdomain). This type of cloning is very similar with a single node system to single node system.

 

8. Copy the DBF files and ORACLE_HOME to the target system

 

Source Node = db.localdomain Destination Node = linux1.localdomain
/APPS_DB/visdata /APPS/visdata
/APPS_DB/visdb /APPS/visdb

 

9.  Start up the source Applications system database and application tier processes (optional)

 

10. Configure the target system database server
      

      Connected as ORACLE:

      cd <RDBMS ORACLE_HOME>/appsutil/clone/bin
      perl adcfgclone.pl dbTier

 

   cd /APPS/visdb/9.2.0/appsutil/clone/bin
      perl adcfgclone.pl dbTier

 

11. Configure the target system application tier server nodes
      

      Connected as APPLMGR:

      cd <COMMON_TOP>/clone/bin
      perl adcfgclone.pl appsTier

 

      cd /APPS/viscomn/clone/bin
      perl adcfgclone.pl appsTier

      

      Attention: 

  • Windows user only: add <806 ORACLE_HOME>\bin to the system path before running this step

  • When you run adcfgclone.pl on appsTier as APPLMGR, APPLMGR must have write permission to the oraInventory

12. Finishing Tasks

 

 

In-Oracle.com  -> Oracle Applications (apps)  -> 11i 

-> Cloning Oracle Apps multi node to single node

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.