Website Design, Website Development, Shopping Carts, Content Management Systems, Custom Programming, Custom Applications Appsdba: April 2009

Oracle Applications, Middleware, Database, DB RAC & HA

It is place where anyone grab more knowledge about Oracle Applications, middleware etc.

 
APPS R12
  • File System
  • Tech Stack
  • Admin Scripts
  • Forms Mode
  • APPS 11i
  • Know more
  • Maintenance Mode
  • Maintenance Mode(New)
  • Patching
  • APPS Scripts
  • Database Scripts
  • Protect APPS Password
  • Concurrent Manager
  • Database Refersh
  • Patchset Utility
  • Forms Data Loader
  • Web Server
  • Space Required
  • Responsibilities Of APPSDBA
  • OAS 9i/10gR2
  • Software Load Balancer
  • OAS 10gR3
  • Components
  • HTTP Server as Port 80
  • Database
  • Enable Archive
  • Clear Temp Tablespace
  • Drop DB (New in 10g)
  • Database Performance
  • Oracle Process
  • Advanced Topic
  • Database RAC

  • Do you know
  • Clusterware
  • Manage RAC Environment
  • High Availability
  • Certifications
  • EBS R12 Beta Exam
  • APPS 11i - 1z0-233
  • RAC 10gR2 - 1z0-048
  • Oracle Certifications
  • DBA Tools
  • TOAD
  • KEEP TOOL
  • ORACLE's SQL DEVELOPER
  • Spotlight on Oracle E-Business
  • DBDiff For Oracle

  • Single Node Cloning !!!!!
    Friday, April 24, 2009
    After installing the Rapid Clone and AutoConfig patches, you are ready to clone an instance. There are tenbasic steps involved:

    1. Run system configuration on the Application tier:
    $ $COMMON_TOP/admin/scripts//adautocfg.sh
    Use the APPS password when prompted.

    2. Run system configuration on the database tier:
    $ $ORACLE_HOME/appsutil//scripts/adautocfg.sh
    Use the APPS password when prompted.

    3. Copy AutoConfig to the RDBMS ORACLE_HOME:
    Apply patch 2952369 to acquire adchkcfg utility.
    Create appsutil.zip file by: $ perl $AD_TOP/bin/admkappsutil.pl.
    Output is located in $APPL_TOP/admin/out/appsutil.zip; copy appsutil.zip file to the
    $ORACLE_HOME
    unzip -o appsutil.zip

    4. Generate the database context file:
    $ cd $ORACLE_HOME/appsutil/bin
    adbldxml.sh tier=database appsuser= appspasswd=
    Output log is written to: $ORACLE_HOME/appsuti/out//cfgcheck.txt

    5. Generate and apply AutoConfig configuration file:
    cd $ORACLE_HOME/appsutil/bin
    adconfig.sh contextfile= appspass=

    6. Prepare for source database clone:
    cd $ORACLE_HOME/appsutil/scrips/
    ./perl adpreclone.pl dbTier

    7. Prepare for source application clone:
    cd $COMMON_TOP/admin/scripts/
    ./perl adpreclone.pl appsTier

    8. Copy the application tier file system:
    Logon to the source system as APPLMGR and shut down the server processes.
    Copy the following application directories from the source to the target node/file system:

    $APPL_TOP
    $OA_HTML
    $OA_JAVA
    $COMMON_TOP/util
    $COMMON_TOP/clone
    $806 ORACLE_HOME
    $iAS ORACLE_HOME
    Shut down the source database and copy it to the target node/file system.
    Restart the source database and source application server processes.

    9. Configure the target system database sever:
    cd $ORACLE_HOME/appsutil/clon/bin
    ./perl adcfgclone.pl dbTier

    10. Configure the target system application tier:
    cd $COMMON_TOP/clone/bin
    ./perl adcfgclone.pl appsTier

    Note: These steps are for a single node install. If you are using Oracle Workflow, you must update
    wf_notification_attributes and wf_item_attribute_values.
    posted by Jaswinder Singh @ 2:18 AM   1 comments
    About Me

    Name: Jaswinder Singh
    Home: Bangalore, Karnataka, India
    Certifications: RAC Certified Expert, OCP 9i, 10g & 11i
    About Me: I am working as APPSDBA, have hands on experience on DB RAC, HA on OAS 10g and Oracle Applications.
    See my complete profile
    Previous Post
    Archives
    Links
    Powered by

    Free Blogger Templates

    BLOGGER

    ADVERTISEMENT
    click here
    © 2006 Appsdba .