Prepare The Source System (Pre-Clone)

Prepare The Source System (Pre-Clone Procedure)

1. Stop and Backup both database and application server

2. Startup database server only
    su - oraprd
    /home/oraprd/scripts/prod/startdb.sh

3. Shutdown both database and application server
    Login Application server (i.e. app_server)
    su - applprd
    /home/applprd/scripts/prod/stopappl.sh

4. Run Auto-Config in app_server
    $COMMON_TOP/admin/scripts/ebsprd_app_server/adautocfg.sh

5. Prepare appsutil.zip contains the DB Node Autoconfig files in app_server
    cd $AD_TOP/bin (e.g. /app/ebsprd/appl/ad/11.5.0/bin)
    perl admkappsutil.pl

    Remarks :
    make sure /usr/local/bin is added to PATH

6. Copy appsutil.zip to db server $ORACLE_HOME
    Login as root in app_server
    rcp /app/ebsprd/appl/admin/out/appsutil.zip db_server:/home/oraprd/.

    login as root in db_server
    chown oraprd:dba /home/oraprd/appsutil.zip

7. Uncompress appsutil.zip in db_server
    cd $ORACLE_HOME
    mkdir appsutil_20091106
    cp -r -p ./appsutil/* ./appsutil_20091106/.
    mv /home/oraprd/appsutil.zip .
    unzip appsutil.zip <- Replace all existing file in appsutil

8. Make sure the perl related variables are correct in the following file :

    /oracle/ebsprd/product/10.2.0/ebsprd_db_server.env :

    #
    # Add perl to the PATH and set PERL5LIB
    #

    PERLBIN=`dirname /oracle/ebsprd/product/10.2.0/perl/bin/perl`
    PATH=${PERLBIN}:${PATH}
    PERL5LIB=/oracle/ebsprd/product/10.2.0/perl/lib/5.8.3/aix-thread-multi:/oracle/ebsprd/product/10.2.0/perl/lib/5.8.3:
    /oracle/ebsprd/product/10.2.0/perl/lib/site_perl/5.8.3/aix-thread-multi:/oracle/ebsprd/product/10.2.0/perl/lib/site_perl/5.8.3:
    /oracle/ebsprd/product/10.2.0/perl/lib/site_perl:.:/oracle/ebsprd/product/10.2.0/appsutil/perl:/oracle/ebsprd/product/10.2.0/appsutil/perl:
    /oracle/ebsprd/product/10.2.0/appsutil/perl
    ADPERLPRG=/oracle/ebsprd/product/10.2.0/perl/bin/perl

    export PATH
    export PERL5LIB
    export ADPERLPRG
    ------------------------------------------------------------------------------------
    /oracle/ebsprd/product/10.2.0/appsutil/ebsprd_db_server.xml :

    <ADPERLPRG oa_var="s_adperlprg" osd="unix">/oracle/ebsprd/product/10.2.0/perl/bin/perl</ADPERLPRG>
    <PERL5LIB oa_var="s_perl5lib" osd="unix">/oracle/ebsprd/product/10.2.0/perl/lib/5.8.3/aix-thread-multi:
    /oracle/ebsprd/product/10.2.0/perl/lib/5.8.3:/oracle/ebsprd/product/10.2.0/perl/lib/site_perl/5.8.3/aix-thread-multi:
    /oracle/ebsprd/product/10.2.0/perl/lib/site_perl/5.8.3:/oracle/ebsprd/product/10.2.0/perl/lib/site_perl:.
    :/oracle/ebsprd/product/10.2.0/appsutil/perl:/oracle/ebsprd/product/10.2.0/appsutil/perl:/oracle/ebsprd/product/10.2.0/appsutil/perl</PERL5LIB>
    ------------------------------------------------------------------------------------

9. Run Auto-Config in db_server (it may issue core dump error)
    su - oraprd
    cd /oracle/ebsprd/product/10.2.0/appsutil/scripts/ebsprd_db_server
    ./adautocfg.sh

    Remarks :
    If it cause core dump error [/oracle/ebsprd/product/10.2.0/appsutil/bin/adconfig.sh[274]: 1126468 Illegal instruction(coredump)],
    please run the following script to rollback :

    /oracle/ebsprd/product/10.2.0/appsutil/out/ebsprd_db_server/11101613/restore.sh

10. Check adconfig.log
      egrep -i "ORA-|fail|error" /oracle/ebsprd/product/10.2.0/appsutil/log/ebsprd_db_server/11101612/adconfig.log

11. Start Preclone of database tier (DB need to be on)
      cd /oracle/ebsprd/product/10.2.0/appsutil/scripts/ebsprd_db_server
      perl adpreclone.pl dbTier

12. Check DB preclone result :
      egrep -i "ORA-|fail|error" /oracle/ebsuat/product/10.2.0/appsutil/log/ebsuat_db_server/StageDBTier_11241431.log

13. Start Preclone of application tier
      cd $COMMON_TOP/admin/scripts/ebsprd_db_server/
      perl adpreclone.pl appsTier

14. Check Apps preclone result :
      egrep -i "ORA-|fail|error" /app/ebsuat/appl/admin/ebsuat_app_server/log/StageAppsTier_11241448.log

15. Shutdown Database Server
      Login Database server (i.e. db_server)
      Shutdown Database Server
      su - oraprd
      /home/oraprd/scripts/prod/stopdb.sh

16. Copy Source System(Both DB, Apps and Discoverer) to target server

      Remarks :

      We better use Tape instead of rsync.

      Include Data file, oracle base , apps base and discoverer(actually no need)