Letting go a dba s guide to autoconfig and rapid clone
Download
1 / 35

Letting Go: A DBA's Guide to AutoConfig and Rapid Clone - PowerPoint PPT Presentation


  • 75 Views
  • Uploaded on

Letting Go: A DBA's Guide to AutoConfig and Rapid Clone. Mark Morgan siMMian systems, inc. 415-585-4242 morgan@simmian.com. AutoConfig and Rapid Clone. Overview Implementation and Operation Troubleshooting, Tips, and Tricks. AutoConfig Overview. 10.7 --> 2 config files APPSORA.env

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Letting Go: A DBA's Guide to AutoConfig and Rapid Clone' - lester


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Letting go a dba s guide to autoconfig and rapid clone

Letting Go: A DBA's Guide to AutoConfig and Rapid Clone

Mark Morgan

siMMian systems, inc.

415-585-4242

morgan@simmian.com


Autoconfig and rapid clone
AutoConfig and Rapid Clone

  • Overview

  • Implementation and Operation

  • Troubleshooting, Tips, and Tricks

Mark Morgan siMMian systems, inc.


Autoconfig overview
AutoConfig Overview

  • 10.7 --> 2 config files

    • APPSORA.env

    • FNDENV

  • 11.5.9 --> 100? config files

    • Database

    • DB Networking

    • Apache

    • Framework (jsp, AOL.J,pls,servlets, TCF)

    • Applications environment

    • Discoverer server

    • Portal

Mark Morgan siMMian systems, inc.


Autoconfig overview1
AutoConfig Overview

  • Context file (XML)

  • Template files

  • File drivers

    • lists of template files

  • AD scripts

    • shell scripts, perl, SQL, java

  • Mark Morgan siMMian systems, inc.


    Autoconfig implementation
    AutoConfig Implementation

    • Doc 165195.1

    • Oracle Applications Maintenance Procedures

    Mark Morgan siMMian systems, inc.


    Autoconfig implementation1
    AutoConfig Implementation

    • Patch Current

      • ADX E

      • TXK H

      • AD F+

      • 2873456 (Context Editor)

      • 2674529 (Apache pre 11.5.8)

      • OAM G (optional)

      • zip 2.3

      • JDK 1.3.1

    Mark Morgan siMMian systems, inc.


    Migrate to autoconfig
    Migrate to AutoConfig

    • Will need to migrate if

      • pre 11.5.7 installation

      • applied templates patch

    Mark Morgan siMMian systems, inc.


    Migrate to autoconfig1
    Migrate to AutoConfig

    • Apps Tier

      • adbldxml.sh

      • adconfig.sh

    • DB Tier

      • admkappsutil.sh

      • adbldxml.sh

      • adconfig.sh

    • Always check logs after running scripts!

    Mark Morgan siMMian systems, inc.


    Maintaining autoconfig
    Maintaining AutoConfig

    • Apps Tier:

      • $COMMON_TOP/admin/scripts/<CONTEXT>/adautocfg.sh

    • DB Tier:

      • $ORACLE_HOME/appsutil/scripts/<CONTEXT>/adautocfg.sh

    Mark Morgan siMMian systems, inc.


    Context file
    Context File

    • $APPL_TOP/admin/$SID/<CONTEXT>.xml

    • 3 Ways to Change Configuration:

      • editcontext

      • OAM

      • vi

    Mark Morgan siMMian systems, inc.


    Context file1
    Context File

    • XML

      <web_port_pls oa_var="s_webport_pls" oa_type="PORT">8202</web_port_pls>

      <url_protocol oa_var="s_url_protocol">http</url_protocol>

      <local_url_protocol oa_var="s_local_url_protocol">http</local_url_protocol>

      <oprocmgr_port oa_var="s_oprocmgr_port" oa_type="PORT">8102</oprocmgr_port>

    Mark Morgan siMMian systems, inc.


    Restoring an autoconfig configuration
    Restoring an AutoConfig Configuration

    • OAM

    • restore.sh

      • $APPL_TOP/admin/<CONTEXT>/out/MMDDhhmm

      • $ORACLE_HOME/appsutil/out/<CONTEXT>/MMDDhhmm

    Mark Morgan siMMian systems, inc.


    Customizing configurations
    Customizing Configurations

    • Apps Tier:

      # Begin customizations

      ...

      # End customizations

      • $APPL_TOP/custom<CONTEXT>.env

      • Doc 236618.1 Personalizing OA Framework

      • .profile

    Mark Morgan siMMian systems, inc.


    Customizing configurations1
    Customizing Configurations

    • DB Tier:

      • tnsname.ora --> ifile

      • init.ora --> ifile

    Mark Morgan siMMian systems, inc.


    Autoconfig troubleshooting tips and tricks

    oprocmgr_prt

    s_webport_pls

    s_conctimeout

    s_discostatus

    JDK 131 setups

    TCF Port

    CLASSPATH

    AF_CLASSPATH

    LD_LIBRARY_PATH

    Followsymlinks

    DISPLAY

    AutoConfig Troubleshooting, Tipsand Tricks

    Mark Morgan siMMian systems, inc.


    Autoconfig troubleshooting tips and tricks1
    AutoConfig Troubleshooting, Tipsand Tricks

    • Keep accessible backups of context file

    • Don't break out of adautocfg.sh

    • Use aoljtest.jsp to test configs

    • Updates some profile options

    • init.ora db_cache_size does not work (as of ADX D)

    • Use adautocg.sh to change apps password after running FNDCPASS

    • Keep copies of db configs (init.ora, listener.ora, tnsnames.ora)

    Mark Morgan siMMian systems, inc.


    Rapid clone overview
    Rapid Clone Overview

    • Builds DB init.ora

    • Builds DB controlfiles

    • Creates DB networking config files

    • Creates all Apps config files for AutoConfig

    • Updates Apps profile values

    • Updates/builds oraInventory

    Mark Morgan siMMian systems, inc.


    Rapid clone implementation
    Rapid Clone Implementation

    • Doc 230672.1

    • Oracle Applications Maintenance Procedures

    Mark Morgan siMMian systems, inc.


    Rapid clone implementation1
    Rapid Clone Implementation

    • Patch Current

      • ADX

      • OUI

      • Current AutoConfig patches

    Mark Morgan siMMian systems, inc.


    Running rapid clone preclone
    Running Rapid Clone -- preclone

    • Copies current configurations to templates

    • DB Tier:

      • perl adpreclone.pl dbTier

      • outputs to $ORACLE_HOME/appsutil//clone

    • Apps Tier:

      • perl adpreclone.pl appsTier

      • outputs to $COMMON_TOP/clone

    Mark Morgan siMMian systems, inc.


    Running rapid clone copy files
    Running Rapid Clone -- copy files

    • Apps Tier:

      • APPL_TOP

      • OA_HTML

      • OA_JAVA

      • COMMON_TOP/util

      • COMMON_TOP/clone

      • 806 ORACLE_HOME

      • iAS ORACLE_HOME

    Mark Morgan siMMian systems, inc.


    Running rapid clone copy files1
    Running Rapid Clone -- copy files

    • DB tier:

      • Cold copy of database files*

      • ORACLE_HOME (9i/8i)

    Mark Morgan siMMian systems, inc.


    Running rapid clone postclone
    Running Rapid Clone -- postclone

    • DB Tier:

      • perl ./adcfgclone.pl dbTier

        • control files

        • init.ora

        • tnsnames.ora

        • listener.ora

        • starts database and listener

    Mark Morgan siMMian systems, inc.


    Running rapid clone postclone1
    Running Rapid Clone -- postclone

    • Apps Tier:

      • perl ./adcfgclone.pl appsTier

        • applications configurations

        • profile values

        • starts all services

    Mark Morgan siMMian systems, inc.


    Running rapid clone finishing
    Running Rapid Clone -- finishing

    • Verify profile options

    • Verify printers

    • Update workflow

    • Verify APPLCSF

    • Change passwords

    • Update login user responsibilities

    Mark Morgan siMMian systems, inc.


    Rapid clone options
    Rapid Clone -- options

    • ADX E allows all node cloning options

      • multi --> single

      • multi --> multi

      • single --> multi

    Mark Morgan siMMian systems, inc.


    Rapid clone troubleshooting
    Rapid Clone Troubleshooting

    • Always check postclone logfiles for 'ERRORCODE = 1'

    • errors cause rollbacks

    • Verify utl_file entries in init.ora

    • Verify profile values

    • Verify dbc files

    • Verify GLOBAL_NAME

    Mark Morgan siMMian systems, inc.


    Rapid clone troubleshooting1
    Rapid Clone Troubleshooting

    • Verify data:

      • FND_NODES

      • FND_APPLICATION_SERVERS (desupporting)

      • AD_APPL_TOPS

    • Verify context file entries for:

      • CLASSPATH

      • AF_CLASSPATH

      • LD_LIBRARY_PATH

      • hostname

      • DISPLAY

    Mark Morgan siMMian systems, inc.


    Rapid clone tips and tricks
    Rapid Clone Tips and Tricks

    • Set ORACLE_HOME/JRE to relative path

    • If selectively refreshing environment, make sure to copy

      • $COMMON_TOP/clone

      • $ORACLE_HOME/appsutil/clone

    • Before running postclone, verify /var/opt/oracle/oraInst.loc on target machine

    Mark Morgan siMMian systems, inc.


    Rapid clone tips and tricks1
    Rapid Clone Tips and Tricks

    • Create script to display paths that will be entered in postclone

      • APPL_TOP

      • COMMON_TOP

      • 806 ORACLE_HOME

      • iAS_HOME

    Mark Morgan siMMian systems, inc.


    Rapid clone tips and tricks2
    Rapid Clone Tips and Tricks

    • To use online backup, follow Appendix A steps to manually create controlfiles

    • After cloning, re-login to reset environment

    • Truncate FND_CONCURRENT_REQUESTS before Apps Tier postclone

    • Truncate WF_NOTIFICATIONS

    Mark Morgan siMMian systems, inc.


    Rapid clone tips and tricks3
    Rapid Clone Tips and Tricks

    • Modify adcfgclone.pl to verify new context file:

      #

      print "\nsleeping for 10 minutes to allow fixes of context file...\n";

      sleep 600;

      #

      ## run adclone

      #

      print "\nRunning Rapid Clone with command:\n";

      my $syscmd="perl $ADCLONE java=$JAVA_TOP mode=apply stage=$STAGE_DIR component=$

      COMPONENT method=CUSTOM $CTX_ARG $MERGE_APPL showProgress ";

      if ($Config{osname} ne 'MSWin32') {

      $syscmd =~ s#\\#\/#g;

      }

    Mark Morgan siMMian systems, inc.


    Rapid clone tips and tricks4
    Rapid Clone Tips and Tricks

    • Rather than add new record in WF_SYSTEMS:

      UPDATE wf_systems

      SET name =

      (SELECT global_name FROM global_name),

      display_name =

      (SELECT global_name FROM global_name);

    Mark Morgan siMMian systems, inc.


    Rapid clone tips and tricks5
    Rapid Clone Tips and Tricks

    • To update WF_AGENTS

      DECLARE

      v_gname global_name.global_name%TYPE;

      v_old_gname global_name.global_name%TYPE := '&1';

      BEGIN

      SELECT global_name INTO v_gname FROM global_name;

      UPDATE wf_agents

      SET address =

      substr(address,1,instr(address,'@'))||v_gname

      WHERE address LIKE '%@'||v_old_gname;

      END;

      /

    Mark Morgan siMMian systems, inc.


    Letting go a dba s guide to autoconfig and rapid clone

    By letting it go it all gets done. The world is won by those who let it go. But when you try and try. The world is beyond the winning.

    -- Lao Tzu

    Mark Morgan siMMian systems, inc.