1 / 35

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

Discover how to implement, troubleshoot, and customize AutoConfig and Rapid Clone for efficient database administration. Learn essential tips and tricks to streamline your processes.

orrf
Download Presentation

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

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Letting Go: A DBA's Guide to AutoConfig and Rapid Clone Mark Morgan siMMian systems, inc. 415-585-4242 morgan@simmian.com

  2. AutoConfig and Rapid Clone • Overview • Implementation and Operation • Troubleshooting, Tips, and Tricks Mark Morgan siMMian systems, inc.

  3. 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.

  4. 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.

  5. AutoConfig Implementation • Doc 165195.1 • Oracle Applications Maintenance Procedures Mark Morgan siMMian systems, inc.

  6. 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.

  7. Migrate to AutoConfig • Will need to migrate if • pre 11.5.7 installation • applied templates patch Mark Morgan siMMian systems, inc.

  8. 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.

  9. 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.

  10. Context File • $APPL_TOP/admin/$SID/<CONTEXT>.xml • 3 Ways to Change Configuration: • editcontext • OAM • vi Mark Morgan siMMian systems, inc.

  11. 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.

  12. Restoring an AutoConfig Configuration • OAM • restore.sh • $APPL_TOP/admin/<CONTEXT>/out/MMDDhhmm • $ORACLE_HOME/appsutil/out/<CONTEXT>/MMDDhhmm Mark Morgan siMMian systems, inc.

  13. 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.

  14. Customizing Configurations • DB Tier: • tnsname.ora --> ifile • init.ora --> ifile Mark Morgan siMMian systems, inc.

  15. 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.

  16. 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.

  17. 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.

  18. Rapid Clone Implementation • Doc 230672.1 • Oracle Applications Maintenance Procedures Mark Morgan siMMian systems, inc.

  19. Rapid Clone Implementation • Patch Current • ADX • OUI • Current AutoConfig patches Mark Morgan siMMian systems, inc.

  20. 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.

  21. 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.

  22. Running Rapid Clone -- copy files • DB tier: • Cold copy of database files* • ORACLE_HOME (9i/8i) Mark Morgan siMMian systems, inc.

  23. 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.

  24. Running Rapid Clone -- postclone • Apps Tier: • perl ./adcfgclone.pl appsTier • applications configurations • profile values • starts all services Mark Morgan siMMian systems, inc.

  25. Running Rapid Clone -- finishing • Verify profile options • Verify printers • Update workflow • Verify APPLCSF • Change passwords • Update login user responsibilities Mark Morgan siMMian systems, inc.

  26. Rapid Clone -- options • ADX E allows all node cloning options • multi --> single • multi --> multi • single --> multi Mark Morgan siMMian systems, inc.

  27. 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.

  28. 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.

  29. 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.

  30. 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.

  31. 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.

  32. 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.

  33. 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.

  34. 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.

  35. 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.

More Related