Logo Background

Oracle Apps 11i & Database Cloning

  • By on December 5, 2008 | No Comments

    PRECLONE STEPS

    DATABASE TIER:

    [oracle2@apps VISION_apps]$ perl adpreclone.pl dbTier
    Running Rapid Clone with command…
    perl /apps11i2/apps11i/visiondb/9.2.0/appsutil/bin/adclone.pl java=/apps11i2/apps11i/visiondb/9.2.0/appsoui/jre/1.3.1 mode=stage stage=/apps11i2/apps11i/visiondb/9.2.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/apps11i2/apps11i/visiondb/9.2.0/appsutil/VISION_apps.xml showProgress

    Beginning database tier Stage – Fri Aug 25 16:57:34 2006
    APPS Password : apps

    Log file located at /apps11i2/apps11i/visiondb/9.2.0/appsutil/log/VISION_apps/StageDBTier_08250457.log
    Completed Stage…
    Fri Aug 25 17:13:46 2006

    APPS TIER:

    [oracle2@apps VISION_apps]$ perl adpreclone.pl appsTier
    Running Rapid Clone with command…
    perl /apps11i2/apps11i/visionappl/ad/11.5.0/bin/adclone.pl java=/apps11i2/apps11i/visionora/iAS/appsoui/jre/1.3.1 mode=stage stage=/apps11i2/apps11i/visioncomn/clone component=appsTier method=CUSTOM appctx=/apps11i2/apps11i/visionappl/admin/VISION_apps.xml showProgress

    Beginning application tier Stage – Fri Aug 25 17:21:45 2006
    Log file located at /apps11i2/apps11i/visionappl/admin/VISION_apps/log/StageAppsTier_08250521.log
    Completed Stage…
    Fri Aug 25 17:29:48 2006

    Now all the tops need to be manually copied from the source system to the destination system
    And they need to be renamed. Say if we are cloning dev from prod, then prodappl, prodcomn etc need to be renamed as devappl, devcomn etc.
    mv prodappl devappl

    POST CLONE –

    DATABASE TIER:

    [oracle3@apps bin]$ perl adcfgclone.pl dbTier
    Enter the APPS password [APPS]:
    apps

    First Creating a new context file for the cloned system.
    The program is going to ask you for information about the new system:

    Provide the values required for creation of the new Database Context file.

    Do you want to use a virtual hostname for the target node (y/n) [n] ?:n

    Target instance is a Real Application Cluster (RAC) instance (y/n) [n]:n

    Target System database name [VISION]:CLONE

    Target system RDBMS ORACLE_HOME directory [/apps11i2/apps11i/visiondb/9.2.0]:/apps11i3/appsclone/clonedb/9.2.0

    Target system utl_file accessible directories list [/usr/tmp]:

    Number of DATA_TOP’s on the target system [1]:1

    Target system DATA_TOP 1 [/apps11i2/apps11i/visiondata]:/apps11i3/appsclone/clonedata

    Do you want to preserve the Display set to apps:0.0 (y/n) [y] ?:y

    Clone Context uses the same port pool mechanism as the Rapid Install
    Once you choose a port pool, Clone Context will validate the port availability.

    Enter the port pool number [0-99]:
    10

    Checking the port pool 10
    done: Port Pool 10 is free
    Database port is 1531

    Creating the new Database Context file from :
    /apps11i2/apps11i/visiondb/9.2.0/appsutil/template/adxdbctx.tmp

    The new database context file has been created :
    /apps11i3/appsclone/clonedb/9.2.0/appsutil/CLONE_apps.xml

    Log file located at /apps11i3/appsclone/clonedb/9.2.0/appsutil/clone/bin/CloneContext_08271007.log

    Running Rapid Clone with command:
    perl /apps11i3/appsclone/clonedb/9.2.0/appsutil/clone/bin/adclone.pl java=/apps11i3/appsclone/clonedb/9.2.0/appsutil/clone/bin/../jre mode=apply stage=/apps11i3/appsclone/clonedb/9.2.0/appsutil/clone/bin/.. component=dbTier method=CUSTOM dbctxtg=/apps11i3/appsclone/clonedb/9.2.0/appsutil/CLONE_apps.xml showProgress contextValidated=true

    Beginning database tier Apply – Sun Aug 27 10:09:36 2006
    Log file located at /apps11i3/appsclone/clonedb/9.2.0/appsutil/log/CLONE_apps/ApplyDBTier_08271009.log
    Completed Apply…
    Sun Aug 27 10:12:57 2006

    Beginning APPSDB_CLONE registration to central inventory…

    ORACLE_HOME NAME : APPSDB_CLONE
    ORACLE_HOME PATH : /apps11i3/appsclone/clonedb/9.2.0
    Using Inventory location in /etc/oraInst.loc
    Log file located at /etc/oraInventory/logs/OracleHomeCloner_08271012.log
    AC-00002: Error: Unable to create log file – /etc/oraInventory/logs/OracleHomeCloner_08271012.log
    AC-00002: Error: Unable to create log file – /etc/oraInventory/logs/OracleHomeCloner_08271012.log
    Exception in thread “main” java.lang.RuntimeException: AC-00002: Unable to create log file – /etc/oraInventory/logs/OracleHomeCloner_08271012.log
    Raised by oracle.apps.ad.util.LogFile
    at oracle.apps.ad.util.LogFile.appendLogFile(LogFile.java:356)
    at oracle.apps.ad.util.LogFile.log(LogFile.java:233)
    at oracle.apps.ad.util.LogFile.info(LogFile.java:212)
    at oracle.apps.ad.clone.util.OracleHomeCloner.registerOracleHome(OracleHomeCloner.java:307)
    at oracle.apps.ad.clone.util.OracleHomeCloner.registerOracleHome(OracleHomeCloner.java:165)
    at oracle.apps.ad.clone.util.OracleHomeCloner.main(OracleHomeCloner.java:1122)

    ERROR: Registration Failed… Please check log file.

    You can rerun this registration with the following script:
    /apps11i3/appsclone/clonedb/9.2.0/appsutil/out/CLONE_apps/regOUI_APPSDB_CLONE.sh

    Starting database listener for CLONE:
    Running:
    /apps11i3/appsclone/clonedb/9.2.0/appsutil/scripts/CLONE_apps/addlnctl.sh start CLONE

    You are running addlnctl.sh version 115.6

    Logfile: /apps11i3/appsclone/clonedb/9.2.0/appsutil/log/CLONE_apps/addlnctl.txt

    Starting listener process CLONE …

    Listener CLONE has already been started.

    addlnctl.sh: exiting with status 0

    Due to this error, this code was required to be rerun again.

    [oracle3@apps CLONE_apps]$ ./regOUI_APPSDB_CLONE.sh
    Using Inventory location in /etc/oraInst.loc
    Log file located at /etc/oraInventory/logs/OracleHomeCloner_08271148.log
    ORACLE_HOME /apps11i3/appsclone/clonedb/9.2.0 was registered successfully.
    ERRORCODE = 0 ERRORCODE_END

    APPS TIER:

    [oracle3@apps bin]$ perl adcfgclone.pl appsTier
    Enter the APPS password [APPS]:
    apps

    First Creating a new context file for the cloned system.
    The program is going to ask you for information about the new system:

    Provide the values required for creation of the new APPL_TOP Context file.

    Do you want to use a virtual hostname for the target node (y/n) [n] ?:n

    Target system database SID [VISION]:CLONE

    Target system database server node [apps]:

    Target system database domain name [tcs.com]:

    Does the target system have more than one application tier server node (y/n) [n] ?:n

    Is the target system APPL_TOP divided into multiple mount points (y/n) [n] ?:n

    Target system APPL_TOP mount point [/apps11i2/apps11i/visionappl]:/apps11i3/appsclone/cloneappl

    Target system COMMON_TOP directory [/apps11i2/apps11i/visioncomn]:/apps11i3/appsclone/clonecomn

    Target system 8.0.6 ORACLE_HOME directory [/apps11i2/apps11i/visionora/8.0.6]:/apps11i3/appsclone/cloneora/8.0.6

    Target system iAS ORACLE_HOME directory [/apps11i2/apps11i/visionora/iAS]:/apps11i3/appsclone/cloneora/iAS

    Do you want to preserve the Display set to apps:0.0 (y/n) [y] ?:y

    Clone Context uses the same port pool mechanism as the Rapid Install
    Once you choose a port pool, Clone Context will validate the port availability.

    Enter the port pool number [0-99]:
    10

    Checking the port pool 10
    done: Port Pool 10 is free
    Web Listener port is 8010
    Complete port information available at /apps11i3/appsclone/cloneappl/admin/out/CLONE_apps/portpool.lst

    UTL_FILE_DIR on database tier consists of the following directories.

    1. /usr/tmp
    2. /usr/tmp
    3. /apps11i3/appsclone/clonedb/9.2.0/appsutil/outbound/CLONE_apps
    4. /usr/tmp
    Choose a value which will be set as APPLPTMP value on the target node [1]:1

    Creating the new APPL_TOP Context file from :
    /apps11i2/apps11i/visionappl/ad/11.5.0/admin/template/adxmlctx.tmp

    The new APPL_TOP context file has been created :
    /apps11i3/appsclone/cloneappl/admin/CLONE_apps.xml

    Log file located at /apps11i3/appsclone/clonecomn/clone/bin/CloneContext_08271201.log

    Running Rapid Clone with command:
    perl /apps11i3/appsclone/clonecomn/clone/bin/adclone.pl java=/apps11i3/appsclone/clonecomn/clone/bin/../jre mode=apply stage=/apps11i3/appsclone/clonecomn/clone/bin/.. component=appsTier method=CUSTOM appctxtg=/apps11i3/appsclone/cloneappl/admin/CLONE_apps.xml showProgress contextValidated=true

    Beginning application tier Apply – Sun Aug 27 12:04:22 2006
    Log file located at /apps11i3/appsclone/cloneappl/admin/CLONE_apps/log/ApplyAppsTier_08271204.log
    Completed Apply…
    Sun Aug 27 12:11:45 2006

    Beginning APPSIAS_CLONE registration to central inventory…

    ORACLE_HOME NAME : APPSIAS_CLONE
    ORACLE_HOME PATH : /apps11i3/appsclone/cloneora/iAS
    Using Inventory location in /etc/oraInst.loc
    Log file located at /etc/oraInventory/logs/OracleHomeCloner_08271211.log
    ORACLE_HOME /apps11i3/appsclone/cloneora/iAS was registered successfully.

    Starting application Services for CLONE:
    Running:
    /apps11i3/appsclone/clonecomn/admin/scripts/CLONE_apps/adstrtal.sh APPS/

    Previous
    Next
    » WEP Security Weakness
Leave a Comment