adautocfg.sh managed files (3) web, forms and mwa tier

1. environment files (4)

$APPL_TOP/APPSORA.env
$APPL_TOP/APPS$CONTEXT_NAME.env
$APPL_TOP/PROD.env
$APPL_TOP/$CONTEXT_NAME.env

2. files used for ad tools, java, and java related environment files (8)

$APPL_TOP/admin/adconfig.txt
$APPL_TOP/admin/adgetlnxver.sh
$APPL_TOP/admin/adjareas.txt
$APPL_TOP/admin/adjborg.txt
$APPL_TOP/admin/adjborg2.txt
$APPL_TOP/admin/adovars.env
$APPL_TOP/admin/PROD_806_BALANCE/adalldefaults.txt
$APPL_TOP/admin/$CONTEXT_NAME/out/adcert.txt

3. other tools for application: WEB ADI, Workflow, XML etc. (15)

$APPL_TOP/bne/11.5.0/conf/webadi.properties
$APPL_TOP/cct/11.5.0/admin/install/$CONTEXT_NAME/cctclean.sh
$APPL_TOP/cct/11.5.0/admin/install/$CONTEXT_NAME/cctclean.sql
$APPL_TOP/fnd/11.5.0/patch/115/import/US/wfautocfg.msg
$APPL_TOP/fnd/11.5.0/resource/appsweb.cfg
$APPL_TOP/fnd/11.5.0/resource/appsweb_$CONTEXT_NAME.cfg
$APPL_TOP/fnd/11.5.0/xml/oamextensions.xml
$APPL_TOP/icx/11.5.0/html/US/ICXINDEX.htm
$APPL_TOP/icx/11.5.0/html/US/ICXINDEX_$CONTEXT_NAME.htm
$APPL_TOP/ieo/11.5.0/admin/install/$CONTEXT_NAME/ieosvicsm.sh
$APPL_TOP/ieo/11.5.0/admin/scripts/$CONTEXT_NAME/ieoenv.sh
$APPL_TOP/ieo/11.5.0/admin/scripts/$CONTEXT_NAME/ieoicsm.sh
$APPL_TOP/ieo/11.5.0/admin/scripts/$CONTEXT_NAME/ieozip.sh
$APPL_TOP/ieo/11.5.0/admin/scripts/$CONTEXT_NAME/ieozipall.sh
$APPL_TOP/ies/11.5.0/admin/install/$CONTEXT_NAME/cooper.sh

4. MWA related files (7)

$APPL_TOP/mwa/11.5.0/bin/mwactl.sh
$APPL_TOP/mwa/11.5.0/secure/device.cfg
$APPL_TOP/mwa/11.5.0/secure/deviceIP.ini
$APPL_TOP/mwa/11.5.0/secure/mwa.cfg
$APPL_TOP/mwa/11.5.0/secure/$CONTEXT_NAME/device.cfg
$APPL_TOP/mwa/11.5.0/secure/$CONTEXT_NAME/deviceIP.ini
$APPL_TOP/mwa/11.5.0/secure/$CONTEXT_NAME/mwa.cfg

5. cloning support files (62)

$COMMON_TOP/admin/install/$CONTEXT_NAME/abmwebprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/abmwebprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/adadmat.pl
$COMMON_TOP/admin/install/$CONTEXT_NAME/adadmrat.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/adatccnv.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/adgendbc.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/adgenjky.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/admkenv.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/admkliblist.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/admkpltfrm.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/admkxdir.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/adsupmult.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/adsvalsn.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/adsvapc.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/adsvfmc.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/adsvfms.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/adsvfrm.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/adsvtcf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/adunzip.pl
$COMMON_TOP/admin/install/$CONTEXT_NAME/adupdbid.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/afadmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/afadmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/afcpclean.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/afcpctx.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/afcpgsm.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/afcpgsm.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/afcpnode.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/afcpnode.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/affrmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/affrmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/afgcsreg.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/afgcsreg.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/afwebprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/afwebprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/amswebprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/amswebprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/csfwebprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/csfwebprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/ibywebprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/ibywebprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/icxwebprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/icxwebprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/jtfictx.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/jtfirip.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/jtfsvfm.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/mwamscasvc.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/mwamscasvc.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/oksfrmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/oksfrmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/ssodatan.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/ssodatan.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/txkFrmUTF8.pl
$COMMON_TOP/admin/install/$CONTEXT_NAME/txkFrmUTF8.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/txkFrmUTF8.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/txkGenExtSecConf.pl
$COMMON_TOP/admin/install/$CONTEXT_NAME/txkGenFormServletIni.pl
$COMMON_TOP/admin/install/$CONTEXT_NAME/txkGetWebNodes.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/txkJdkCfg.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/txkMultinode.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/txkOprocmgrConf.pl
$COMMON_TOP/admin/install/$CONTEXT_NAME/txkWfClone.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/wdbsvr.sh

6. maintenance scripts at web, forms, mwa and discoverer tier (16)

$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adalnctl.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adapcctl.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adaprstctl.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adautocfg.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/addisctl.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adexecsql.pl
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adfmcctl.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adfmsctl.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adfrmctl.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adpreclone.pl
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adstpall.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adstrtal.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adtcfctl.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/gsmstart.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/jtffmctl.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/mwactlwrpr.sh

7. HTML related scripts (7)

$COMMON_TOP/html/bin/appsweb.cfg
$COMMON_TOP/html/bin/appsweb_$CONTEXT_NAME.cfg
$COMMON_TOP/html/bin/txkcsa_$CONTEXT_NAME.cfg
$COMMON_TOP/html/txkcsa/txkLoadXMLInDB.sh
$COMMON_TOP/html/txkObjectTag.js
$COMMON_TOP/html/US/ICXINDEX.htm
$COMMON_TOP/html/US/ICXINDEX_$CONTEXT_NAME.htm

8. Portal related files (22)

$COMMON_TOP/portal/$CONTEXT_NAME/apccmsvc.html
$COMMON_TOP/portal/$CONTEXT_NAME/aplogon.html
$COMMON_TOP/portal/$CONTEXT_NAME/appcfg.html
$COMMON_TOP/portal/$CONTEXT_NAME/appdet.html
$COMMON_TOP/portal/$CONTEXT_NAME/appdoc.html
$COMMON_TOP/portal/$CONTEXT_NAME/appfso.html
$COMMON_TOP/portal/$CONTEXT_NAME/appgloss.html
$COMMON_TOP/portal/$CONTEXT_NAME/applist.html
$COMMON_TOP/portal/$CONTEXT_NAME/applog.html
$COMMON_TOP/portal/$CONTEXT_NAME/applogh.html
$COMMON_TOP/portal/$CONTEXT_NAME/appnefso.html
$COMMON_TOP/portal/$CONTEXT_NAME/appnetst.html
$COMMON_TOP/portal/$CONTEXT_NAME/appnevis.html
$COMMON_TOP/portal/$CONTEXT_NAME/apptitle.html
$COMMON_TOP/portal/$CONTEXT_NAME/apscript.html
$COMMON_TOP/portal/$CONTEXT_NAME/index.html
$COMMON_TOP/portal/$CONTEXT_NAME/inst_log.html
$COMMON_TOP/portal/$CONTEXT_NAME/logon.html
$COMMON_TOP/portal/$CONTEXT_NAME/machine.html
$COMMON_TOP/portal/$CONTEXT_NAME/nav.html
$COMMON_TOP/portal/$CONTEXT_NAME/robots.txt
$COMMON_TOP/portal/$CONTEXT_NAME/script.html

9. environment files in 8.0.6 Oracle Home (2)

$ORA_TOP/8.0.6/PROD.env
$ORA_TOP/8.0.6/$CONTEXT_NAME.env

10. adlnk806.sh for relink 8.0.6 Oracle Home

$ORA_TOP/8.0.6/bin/adlnk806.sh

11. discoverer related files (26)

$ORA_TOP/8.0.6/discwb4/discwb.sh
$ORA_TOP/8.0.6/discwb4/util/applypreferences.sh
$ORA_TOP/8.0.6/discwb4/util/checkdiscoverer.sh
$ORA_TOP/8.0.6/discwb4/util/registerall.sh
$ORA_TOP/8.0.6/discwb4/util/registercollector.sh
$ORA_TOP/8.0.6/discwb4/util/registerpreference.sh
$ORA_TOP/8.0.6/discwb4/util/registersession.sh
$ORA_TOP/8.0.6/discwb4/util/registersessionwithlog.sh
$ORA_TOP/8.0.6/discwb4/util/runcol.sh
$ORA_TOP/8.0.6/discwb4/util/runpref.sh
$ORA_TOP/8.0.6/discwb4/util/runses.sh
$ORA_TOP/8.0.6/discwb4/util/startall.sh
$ORA_TOP/8.0.6/discwb4/util/startgatekeeper.sh
$ORA_TOP/8.0.6/discwb4/util/startgkconfig.sh
$ORA_TOP/8.0.6/discwb4/util/startlocator.sh
$ORA_TOP/8.0.6/discwb4/util/startoad.sh
$ORA_TOP/8.0.6/discwb4/util/startosagent.sh
$ORA_TOP/8.0.6/discwb4/util/stopall.sh
$ORA_TOP/8.0.6/discwb4/util/stopdisprocess.sh
$ORA_TOP/8.0.6/discwb4/util/stopgatekeeper.sh
$ORA_TOP/8.0.6/discwb4/util/stoplocator.sh
$ORA_TOP/8.0.6/discwb4/util/stopoad.sh
$ORA_TOP/8.0.6/discwb4/util/stoposagent.sh
$ORA_TOP/8.0.6/discwb4/util/unregistercollector.sh
$ORA_TOP/8.0.6/discwb4/util/unregisterpreference.sh
$ORA_TOP/8.0.6/discwb4/util/unregistersession.sh

12. reports and forms related files (4)

$ORA_TOP/8.0.6/reports60/server/CGIcmd.dat
$ORA_TOP/8.0.6/reports60/server/REP60_PROD.ora
$ORA_TOP/8.0.6/tools/web60/html/runform.htm
$ORA_TOP/8.0.6/tools/web60/html/runrep.htm

13. environment files for iAS Oracle Home (2)

$ORA_TOP/iAS/PROD.env
$ORA_TOP/iAS/$CONTEXT_NAME.env

14. configuration files for Apache (38)

$ORA_TOP/iAS/Apache/Apache/bin/apachectl
$ORA_TOP/iAS/Apache/Apache/bin/java.sh
$ORA_TOP/iAS/Apache/Apache/bin/startJserv.sh
$ORA_TOP/iAS/Apache/Apache/bin/stopJserv.sh
$ORA_TOP/iAS/Apache/Apache/cgi-bin/printenv
$ORA_TOP/iAS/Apache/Apache/cgi-bin/test-cgi
$ORA_TOP/iAS/Apache/Apache/conf/apps.conf
$ORA_TOP/iAS/Apache/Apache/conf/custom_apache.conf
$ORA_TOP/iAS/Apache/Apache/conf/httpd.conf
$ORA_TOP/iAS/Apache/Apache/conf/httpd_pls.conf
$ORA_TOP/iAS/Apache/Apache/conf/httpds.conf
$ORA_TOP/iAS/Apache/Apache/conf/imeeting.conf
$ORA_TOP/iAS/Apache/Apache/conf/oprocmgr.conf
$ORA_TOP/iAS/Apache/Apache/conf/oracle_apache.conf
$ORA_TOP/iAS/Apache/Apache/conf/security.conf
$ORA_TOP/iAS/Apache/Apache/conf/trusted.conf
$ORA_TOP/iAS/Apache/Apache/conf/url_fw.conf
$ORA_TOP/iAS/Apache/Apache/htdocs/disco4iv/html/disco4iv.xml
$ORA_TOP/iAS/Apache/Apache/htdocs/discwb4/scripts/htmlvars.js
$ORA_TOP/iAS/Apache/Apache/htdocs/discwb4/scripts/htmlvars_apps.js
$ORA_TOP/iAS/Apache/Jserv/etc/disco4iviewer.properties
$ORA_TOP/iAS/Apache/Jserv/etc/emailcenter.properties
$ORA_TOP/iAS/Apache/Jserv/etc/forms.properties
$ORA_TOP/iAS/Apache/Jserv/etc/formservlet.properties
$ORA_TOP/iAS/Apache/Jserv/etc/jserv.conf
$ORA_TOP/iAS/Apache/Jserv/etc/jserv.properties
$ORA_TOP/iAS/Apache/Jserv/etc/jserv_restrict.properties
$ORA_TOP/iAS/Apache/Jserv/etc/mobile.properties
$ORA_TOP/iAS/Apache/Jserv/etc/ssp_init.txt
$ORA_TOP/iAS/Apache/Jserv/etc/viewer4i.properties
$ORA_TOP/iAS/Apache/Jserv/etc/xmlsvcs.properties
$ORA_TOP/iAS/Apache/Jserv/etc/zone.properties
$ORA_TOP/iAS/Apache/Jserv/etc/zone_restrict.properties
$ORA_TOP/iAS/Apache/mapviewer/conf/mapViewerConfig.xml
$ORA_TOP/iAS/Apache/modplsql/cfg/cache.cfg
$ORA_TOP/iAS/Apache/modplsql/cfg/plsql.conf
$ORA_TOP/iAS/Apache/modplsql/cfg/plsql_pls.conf
$ORA_TOP/iAS/Apache/modplsql/cfg/wdbsvr.app

15. adlinkiAS.sh for relink iAS Oracle Home (1)

$ORA_TOP/iAS/bin/adlnkiAS.sh

16. OEM related file (1)

$ORA_TOP/iAS/oem_webstage/oem.conf

17. SOAP related files (3)

$ORA_TOP/iAS/soap/webapps/soap/WEB-INF/config/soap.properties
$ORA_TOP/iAS/soap/webapps/soap/WEB-INF/config/soapConfig.xml
$ORA_TOP/iAS/soap/webapps/soap/WEB-INF/config/wsConfig.xml

18. listener.ora and tnsnames.ora

$ORA_TOP/8.0.6/network/admin//listener.ora and tnsnames.ora
$ORA_TOP/iAS/network/admin//tnsnames.ora


Above files are created using $AD_TOP/bin/adgentns.pl during adautocfg.sh run with information from the database Net Services Topology Data Model.

19. dbc f iles

$FND_SECURE/prod.dbc

Above file is created using $COMMON_TOP/admin/install/$CONTEXT_NAME/adgendbc.sh during adautocfg.sh run with information from contextfile and database.

adautocfg.sh managed files (2) concurrent manager and admin server tier

1. environment files (4)

$APPL_TOP/APPSORA.env
$APPL_TOP/APPS$CONTEXT_NAME.env
$APPL_TOP/PROD.env
$APPL_TOP/$CONTEXT_NAME.env

2. files used for ad tools, java, and java related environment file (7)

$APPL_TOP/admin/adconfig.txt
$APPL_TOP/admin/adgetlnxver.sh
$APPL_TOP/admin/adjareas.txt
$APPL_TOP/admin/adjborg.txt
$APPL_TOP/admin/adjborg2.txt
$APPL_TOP/admin/adovars.env
$APPL_TOP/admin/PROD_806_BALANCE/adalldefaults.txt

3. other tools for application: WEB ADI, Workflow, XML etc. (4)

$APPL_TOP/bne/11.5.0/conf/webadi.properties
$APPL_TOP/fnd/11.5.0/patch/115/import/US/wfautocfg.msg
$APPL_TOP/fnd/11.5.0/xml/oamextensions.xml
$APPL_TOP/ies/11.5.0/admin/install/$CONTEXT_NAME/cooper.sh

4. MWA related files (7)

$APPL_TOP/mwa/11.5.0/bin/mwactl.sh
$APPL_TOP/mwa/11.5.0/secure/device.cfg
$APPL_TOP/mwa/11.5.0/secure/deviceIP.ini
$APPL_TOP/mwa/11.5.0/secure/mwa.cfg
$APPL_TOP/mwa/11.5.0/secure/$CONTEXT_NAME/device.cfg
$APPL_TOP/mwa/11.5.0/secure/$CONTEXT_NAME/deviceIP.ini
$APPL_TOP/mwa/11.5.0/secure/$CONTEXT_NAME/mwa.cfg

5. cloning support files (90)

$COMMON_TOP/admin/install/$CONTEXT_NAME/adadmat.pl
$COMMON_TOP/admin/install/$CONTEXT_NAME/adadmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/adadmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/adadmrat.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/adatccnv.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/adgendbc.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/admkenv.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/admkliblist.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/admkpltfrm.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/admkxdir.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/adsupmult.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/adsvalsn.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/adsvcm.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/adsvrep.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/adunzip.pl
$COMMON_TOP/admin/install/$CONTEXT_NAME/adupdbid.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/adupdlobs.pl
$COMMON_TOP/admin/install/$CONTEXT_NAME/adupdlobs.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/afadmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/afadmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/afchgpwd.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/afcmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/afcmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/afcpclean.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/afcpctx.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/afcpgsm.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/afcpgsm.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/afcpnode.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/afcpnode.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/afgcsreg.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/afgcsreg.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/ahladmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/ahladmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/amscmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/amscmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/aradmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/aradmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/bisadmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/bisadmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/bisdblrp.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/bisdblrp.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/clnadmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/clnadmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/cnadmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/cnadmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/cncmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/cncmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/csdadmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/csdadmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/cseadmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/cseadmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/csfagprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/csfagprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/csiadmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/csiadmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/eamadmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/eamadmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/ecxadmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/ecxadmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/fteadmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/fteadmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/gladmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/gladmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/igccmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/igccmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/jtfadmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/jtfadmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/mwamscasvc.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/mwamscasvc.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/okeadmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/okeadmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/okladmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/okladmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/ontadmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/ontadmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/paadmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/paadmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/txkGenExtSecConf.pl
$COMMON_TOP/admin/install/$CONTEXT_NAME/txkJavaMailerCfg.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/txkJavaMailerCfg.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/txkJdkCfg.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/txkWebServicescfg.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/txkWebServicesCfg.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/txkWfClone.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/wipadmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/wipadmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/wshadmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/wshadmprf.sql
$COMMON_TOP/admin/install/$CONTEXT_NAME/xnccmprf.sh
$COMMON_TOP/admin/install/$CONTEXT_NAME/xnccmprf.sql

6. maintenance scripts at concurrent manager and admin server tier (10)

$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adalnctl.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adautocfg.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adcmctl.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adexecsql.pl
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adpreclone.pl
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adrepctl.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adstpall.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adstrtal.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/gsmstart.sh
$COMMON_TOP/admin/scripts/$CONTEXT_NAME/mwactlwrpr.sh

7. HTML related scripts (2)

$COMMON_TOP/html/bin/txkcsa_$CONTEXT_NAME.cfg
$COMMON_TOP/html/txkcsa/txkLoadXMLInDB.sh

8. environment files in 8.0.6 Oracle Home (2)

$ORA_TOP/8.0.6/PROD.env
$ORA_TOP/8.0.6/$CONTEXT_NAME.env

9. adlnk806.sh for relink 8.0.6 Oracle Home

$ORA_TOP/8.0.6/bin/adlnk806.sh

10. reports and forms related files (4)

$ORA_TOP/8.0.6/reports60/server/CGIcmd.dat
$ORA_TOP/8.0.6/reports60/server/REP60_PROD.ora
$ORA_TOP/8.0.6/tools/web60/html/runform.htm
$ORA_TOP/8.0.6/tools/web60/html/runrep.htm

11. environment files for iAS Oracle Home (2)

$ORA_TOP/iAS/PROD.env
$ORA_TOP/iAS/$CONTEXT_NAME.env

12. configuration files for Apache (33)

$ORA_TOP/iAS/Apache/Apache/bin/apachectl
$ORA_TOP/iAS/Apache/Apache/cgi-bin/printenv
$ORA_TOP/iAS/Apache/Apache/cgi-bin/test-cgi
$ORA_TOP/iAS/Apache/Apache/conf/apps.conf
$ORA_TOP/iAS/Apache/Apache/conf/custom_apache.conf
$ORA_TOP/iAS/Apache/Apache/conf/httpd.conf
$ORA_TOP/iAS/Apache/Apache/conf/httpd_pls.conf
$ORA_TOP/iAS/Apache/Apache/conf/httpds.conf
$ORA_TOP/iAS/Apache/Apache/conf/imeeting.conf
$ORA_TOP/iAS/Apache/Apache/conf/oracle_apache.conf
$ORA_TOP/iAS/Apache/Apache/conf/security.conf
$ORA_TOP/iAS/Apache/Apache/conf/trusted.conf
$ORA_TOP/iAS/Apache/Apache/conf/url_fw.conf
$ORA_TOP/iAS/Apache/Apache/htdocs/discwb4/scripts/htmlvars.js
$ORA_TOP/iAS/Apache/Apache/htdocs/discwb4/scripts/htmlvars_apps.js
$ORA_TOP/iAS/Apache/Jserv/etc/disco4iviewer.properties
$ORA_TOP/iAS/Apache/Jserv/etc/emailcenter.properties
$ORA_TOP/iAS/Apache/Jserv/etc/forms.properties
$ORA_TOP/iAS/Apache/Jserv/etc/formservlet.properties
$ORA_TOP/iAS/Apache/Jserv/etc/jserv.conf
$ORA_TOP/iAS/Apache/Jserv/etc/jserv.properties
$ORA_TOP/iAS/Apache/Jserv/etc/jserv_restrict.properties
$ORA_TOP/iAS/Apache/Jserv/etc/mobile.properties
$ORA_TOP/iAS/Apache/Jserv/etc/ssp_init.txt
$ORA_TOP/iAS/Apache/Jserv/etc/viewer4i.properties
$ORA_TOP/iAS/Apache/Jserv/etc/xmlsvcs.properties
$ORA_TOP/iAS/Apache/Jserv/etc/zone.properties
$ORA_TOP/iAS/Apache/Jserv/etc/zone_restrict.properties
$ORA_TOP/iAS/Apache/mapviewer/conf/mapViewerConfig.xml
$ORA_TOP/iAS/Apache/modplsql/cfg/cache.cfg
$ORA_TOP/iAS/Apache/modplsql/cfg/plsql.conf
$ORA_TOP/iAS/Apache/modplsql/cfg/plsql_pls.conf
$ORA_TOP/iAS/Apache/modplsql/cfg/wdbsvr.app

13. adlnkiAS.sh for relink iAS Oracle Home (1)

$ORA_TOP/iAS/bin/adlnkiAS.sh

14. OEM related file (1)

$ORA_TOP/iAS/oem_webstage/oem.conf

15. SOAP related files (2)

$ORA_TOP/iAS/soap/webapps/soap/WEB-INF/config/soap.properties
$ORA_TOP/iAS/soap/webapps/soap/WEB-INF/config/soapConfig.xml

16. listener.ora and tnsnames.ora

$ORA_TOP/8.0.6/network/admin//listener.ora and tnsnames.ora
$ORA_TOP/iAS/network/admin//tnsnames.ora

Above files are created using $AD_TOP/bin/adgentns.pl during adautocfg.sh run with information from the database Net Services Topology Data Model.

17. dbc f iles

$FND_SECURE/prod.dbc

Above file is created using $COMMON_TOP/admin/install/$CONTEXT_NAME/adgendbc.sh during adautocfg.sh run with information from contextfile and database.

adautocfg.sh managed files (1) db tier

1. environment file (1)

$ORACLE_HOME/$CONTEXT_NAME.env

2. config.c for Oracle RDBMS binary relink (1)

$ORACLE_HOME/rdbms/lib/config.c

3. adlnkoh.sh for relink Oracle RDBMS binary (1)

$ORACLE_HOME/appsutil/install/adlnkoh.sh

4. cloning support files (20)

$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/adcctclean.sql
$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/adclobconv.sql
$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/adclobtmp.sql
$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/adcmclean.sql
$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/adcrdb.sh
$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/adcrdbrdlg.sh
$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/adcrobj.sh
$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/adcrobj.sql
$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/addbccnv.sql
$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/addbprf.sh
$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/addbprf.sql
$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/addbupdgsm.sql
$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/adlicnse.sql
$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/adsvdb.sh
$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/adsvdcnv.sh
$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/adsvdlsn.sh
$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/adupdlib.sql
$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/afdbprf.sh
$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/afdbprf.sql
$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/afmkinit.sh

5. system maintenance scripts at database tier (9)

$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adautocfg.sh
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adchknls.pl
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addbctl.sh
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addlnctl.sh
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adexecsql.pl
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adlsnodes.sh
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adpreclone.pl
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adstopdb.sql
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adstrtdb.sql

5. listener.or, tnsnames.ora and sqlnet.ora

$ORACLE_HOME/network/admin//listener.ora
$ORACLE_HOME/network/admin//tnsnames.ora
$ORACLE_HOME/network/admin//sqlnet.ora

Created using templates: $ORACLE_HOME/appsuitl/template/adlsnr10RAC.ora, ad8itns.ora and ad8isqlnet.ora

adautocfg.sh managed files (0) system architecture

1. Initial implementation (32 bit)

1.1 discoverer runs on separate server with its own infrastructure database.
1.2 Two web/forms/mwa nodes
1.3 Two db/ccm/admin nodes
1.4 database is on 10gR2 RAC 32 bit using ASM for database files
1.5 OCFS2 shared mounting points for archive logs and backup and parallel concurrent computing: /archive, /backup, and /pcp
1.6 NFS shared mounting point for patches and other codes: /share which is mounted onto all servers including production, test and development servers.

2. 64 bit database nodes

2.1 moved the database to two new servers which are 64 bit.
2.2 The /pcp OCFS2 mounting point is mounted onto two ccm/admin and two RAC database nodes.

3. shared application file system

3.1 NFS shared mounting point /mnt/applXXX is mounted onto two web/forms/mwa nodes and two ccm/admin nodes.

4. final architecture

4.1 discoverer runs on separate sever with its own infrastructure database (10g).
4.2 two web/forms/mwa nodes (32bit): OS Oracle Enterprise Linux 5.2, shared mounting points: /mnt/applXXX (NFS) and /share (NFS)
4.3 two ccm/admin nodes (32bit): OS Oracle Enterpise Linux 5.2, shared mounting points: /pcp (OCFS2), /mnt/applXXX (NFS) and /share (NFS)
4.4 two RAC database nodes (64bit): OS Oracle Enterprise Linux 5.2, shared mounting points: /backup (OCFS2), /archive (OCFS2), /pcp (OCFS2) and /share (NFS). Database files are on 10gR2 ASM.
4.5 application versions: EBS11.5.10.2, 11i.ATG_PF.H.6 (5903765), 11i.AD.I.7 (p7429271), 11i Rapidclone consolidated fixes May/2009 (p7164202), TXK Autoconfig and Templates Rollup Patch T (p8327898)

adcfgclone.pl stages

appldev@pind31(DEV_806_BALANCE/CCM:Admin):$ perl adcfgclone.pl
USAGE:
adcfgclone.pl [context file]
WHERE:
: { appsTier | appltop | atTechStack }
: { dbTier | database | dbTechStack }
Depending on the context type.
NOTE:
if no context is specified, adcfgclone.pl will
prompt for cloned system target values to create
the new context file


1. perl adcfgclone.pl atTechStack

Only run cloning procedure on TechStack: that is 8.0.6 and iAS Oracle Home under $ORA_TOP.

2. perl adcfgclone.pl appltop

Only run cloning procedure on $APPL_TOP and $COMMON_TOP.

3. perl adcfgclone.pl appsTier

For all apps tier: $APPL_TOP, $COMMON_TOP and $ORA_TOP.

4. perl adcfglone.pl dbTechStack

Only run cloning procedure on RDBMS: database Oracle Home.

5. perl adcfgclone.pl database

Create control file, start database etc.

6. perl adcfgclone.pl dbTier

For all database tier procedures.

Tracing EBS html pages, forms and concurrent programs

A. Trace HTML pages

Here is how to do the trace for HTML.
For the trace files in the sswa (or HTML) screens you would need to enable the pro
file option FND: Diagnostic = Yes for the user. Then do the following:

1. Click on DIAGNOSTICS which should appear in the upper right side of the screen.

2. This will take you to a window for Diagnostic. In the LOV select SET TRACE LEVEL and click on Go.
3. Then choose TRACE WITH BINDS and Save.
4. Turn of Trace (click on DIAGNOSTICS again and disable trace).
5. Upload the raw and tkprof trace file.



B. Trace Forms

Using Help->Diagnostics->Trace->Trace with Binds in the Forms


C. Trace Concurrent Programs

Sysadmin>concurrent > program > define
Query the concurrent program
Check the trace box to enable trace.

Do you get a fair pay?

1. payscale

www.payscale.com

Payscale site is the best which gives your ability to create personalized report.


2. salary

www.salary.com

it is generic based on job title.


3. salaryexpert

www.salaryexpert.com


4. labor statistics

http://www.bls.gov/oes/current/oes151061.htm

No detail enough. For example, database administrator: SQL SERVER, Oracle, DB2 etc.


5. information week magazine salary survey

http://www.informationweek.com/research/advisor/index.jhtml;jsessionid=MCSQYQPOQPJ1TQE1GHOSKHWATMY32JVN

No detail enough.

Good job searching web sites

Here are the jobs sites that I have used to look for jobs.

www.indeed.com

it is an integrator. This site pools job info from the other sites.

www.monster.com

www.careerbuilder.com

www.hotjobs.com

The better way to look for a job is networking. Let your family members, friends, former co-workers know that you are looking for jobs.

Using adstrtal.sh and adstpall.sh to start and stop MWA

For EBS, there are scripts to start and stop all servers except MWA servers. It would be nice If we can use adstrtal.sh and adstpall.sh in $COMMON_TOP/admin/scripts/$CONTEXT_NAME to start and stop MWA servers. Normally, adstrtal.sh and adstpall.sh control web, forms, concurrent manager, report server, and discoverer servers. For MWA, we have to use mwactl.sh in $MWA_TOP/bin.

mwactl.sh start
mwactl.sh -login sysadmin/sysadminpw stop

Per Note 731320: How to start/stop MWA services using control scripts adstrtal.sh/adstpall.sh, we need to apply TXK patch 5985992 (latest as of 12/2/2009: p7164202: 11i rapidclone consolidated fixes may/2009) and MWA patch 5712178, update s_mwastatus in context file to “enabled”, run autocfg. There is a new script for MWA created in $COMMON_TOP/admin/scripts/$CONTEXT_NAME:

mwactlwrpr.sh

adstrtal.sh can start all services including MWA but adstpall.sh could stop all services except MWA as mwactlwrpr.sh still needs sysadmin password.

mwactlwrpr.sh start|stop userid/password.

Passing apps/appspw for starting MWA is fine. However, for stoping MWA, we have to use sysadmin:

mwactlwrpr.sh stop sysadmin/sysadminpw

Created a SR to ask Oracle Support for help. Oracle asked me to apply patch 8405261: 1OFF:7510101:11.5.10.2:ADSTPALL>MWACTLWRPR.SH>DOES NOT STOP MWA LISTENERS WITH APPS USER. After applying this patch, I still could not shutdown mwa using adstpall.sh.

Per bug note: 7510101, there is a patch p7510101_11i_GENERIC.zip to fix the problem. This patch is not longer available. It appears it got replaced by p8405261_11i_GENERIC.zip which I have applied.

My SR is still open and Oracle is working on this issue.

Our issue is due to the $TWO_TASK setting in dbc file for the RAC environment. After appling patch 9535311: TXK autoconfig and templates rollup patch U and patch 9395815: cannot stop mwa server using mwactlwrpr.sh and mwactl.sh due to two_task, the issue has been resolved.

For shared appltop environment with two web nodes, need to modify the template $MWA_TOP/admin/template/mwactlwrpr.sh and add sub dir $CONTEXT_NAME before mwa.cfg and add –java_config after mwactl.sh to point to context sensitive mwa.cfg. Then running adautocfg to populate the start and stop scripts. See MWA Troubleshooting Tips for Release 11i [ID 269991.1], Section 12 How to use MWA in a Shared APPL_TOP environment:

Do the following for starting a MWA Telnet Server :
---------------
mwactl -java_config "-Dmwa.cfg=[path to config file]" -mwatop [path to mwatop] start [port number]

In case you still could not stop MWA, then modify the template for mwactlwrpr.sh as:
#{ echo $USERPASS; } | nohup $top/$script_path/mwactl.sh stop_force $telnet_port >> /dev/null 2>&1 &
nohup $top/$script_path/mwactl.sh -login $USERPASS stop_force $telnet_port >> /dev/null 2>&1 &

Here is the customized template for mwactlwrpr.sh:

#!/bin/sh
###################################################################
# MWACommand line utility to start and start the telnet server through autoconfig
###################################################################
# Author kkesavar
###################################################################
# Command line utility to start and stop the telnet server
# Usage
# mwactlwrpr.sh start userid/pwd
# mwactlwrpr.sh stop userid/pwd
# $Header: mwactlwrpr.sh 115.0.11510.4 2008/11/24 12:29:02 pbonthu noship $

# %s_dummy%
# This is to override the File.Gen.4 which requires a placeholder variable

if [ $# -ne 2 ];
then
printf "\nmwactlwrpr: Program has wrong number of arguments\n"
printf "Usage: mwactlwrpr start userid/pwd\n"
printf "Usage: mwactlwrpr stop userid/pwd\n"
printf "Usage: mwactlwrpr start -nopromptmsg\n"
printf "Usage: mwactlwrpr stop -nopromptmsg\n"
exit 1
fi

if [ -z "${MWA_TOP}" ]
then
printf "mwactlwrpr: Unable to determine MWA_TOP"
printf "mwactlwrpr: Please make sure that MWA_TOP is defined"
exit 1
fi

control_code=$1

if test "$2" = "-nopromptmsg";
then
read USERNAME
read PASSWORD
USERPASS=${USERNAME}/${PASSWORD}
else
userid_pwd=$2
fi

if test "$control_code" != "start" -a "$control_code" != "stop" ;
then
printf "\nFirst argument must be start or stop\n"
exit 1
fi

if [ -f $MWA_TOP/bin/mwactl.sh ]
then
top="$MWA_TOP"
script_path="bin"
config_path="secure"
else
if [ -z "${INST_TOP}" ]
then
printf "mwactlwrpr: Unable to determine INST_TOP"
printf "mwactlwrpr: Please make sure that INST_TOP is defined"
exit 1
else
top="$INST_TOP"
script_path="admin/scripts"
config_path="admin/install"
fi
fi

# Userid/pwd parameter in case of starting the service is not used anywhere
# It is here because it was requested by the ATG team for consistency purposes

if test "$control_code" = "start" ;
then

###### MWA Server - Start ######
# Check all the ports where the servers are going to be started
# If the ports are free i.e., no process is holding these ports, no issues
# Otherwise kill the processes which are holding these ports

printf "\nStarting MWA Wrapper script. Checking if all ports are free to start the servers and dispatcher...\n"
telnet_ports=`cat $top/$config_path/$CONTEXT_NAME/mwa.cfg | grep -i '^mwa.TelnetPortNumber=' | awk -F= '{ print $2}' | awk -F, '{
n = 1;
while ( $n != "") {
print $n; n=n+1; }
}'`

while [ ! -z "$telnet_ports" ]
do
telnet_port=`echo $telnet_ports | awk ' { FS = " " }; { print $1 }'`
lsof -i | grep $telnet_port > devnull
# Start the server on this port, only if it not used by any other process
if [ $? -eq 0 ]
then
echo "PortNumber:" $telnet_port " is not free to start the server. Please specify a different port in the configuration file (or) end the process using this port"
else
echo "Starting MWA Server on Port number:" $telnet_port
nohup $top/$script_path/mwactl.sh -java_config "-Dmwa.cfg=$top/$config_path/$CONTEXT_NAME/mwa.cfg" -mwatop $top start $telnet_port >> /dev/null 2>&1 &
exit_code=$?
fi

telnet_ports=`echo $telnet_ports | awk '{ FS = " "}; {
n = 2;
while ( $n != "") {
print $n; n=n+1; }
}'`
done

###### MWA Dispatcher - Start ######
# Check the ports where the dispatcher is going to be started
# If the ports are free i.e., no process is holding these ports, no issues
# Otherwise kill the processes which are holding these ports

dispatcher_port=`cat $top/$config_path/$CONTEXT_NAME/mwa.cfg | grep -i '^mwa.Dispatcher=' | awk -F: '{ print $2}' | awk -F- '{ print $1}'`

lsof -i | grep $dispatcher_port > devnull
# Start the dispatcher on this port, only if it not used by any other process
if [ $? -eq 0 ]
then
echo "PortNumber:" $dispatcher_port " is not free to start the dispatcher. Please specify a different port in the configuration file (or) end the process using this port"
else
echo "Starting MWA Dispatcher on Port number:" $dispatcher_port
$top/$script_path/mwactl.sh -java_config "-Dmwa.cfg=$top/$config_path/$CONTEXT_NAME/mwa.cfg" -mwatop $top start_dispatcher >> /dev/null 2>&1 &
exit_code=$?
fi
fi

if test "$control_code" = "stop" ;
then
printf "\nStopping MWA Servers and the dispatcher ....\n"

###### MWA Servers - Stop ######
#Stopping the servers on the ports in which they are started

telnet_ports=`cat $top/$config_path/$CONTEXT_NAME/mwa.cfg | grep -i '^mwa.TelnetPortNumber=' | awk -F= '{ print $2}' | awk -F, '{
n = 1;
while ( $n != "") {
print $n; n=n+1; }
}'`

while [ ! -z "$telnet_ports" ]
do
telnet_port=`echo $telnet_ports | awk ' { FS = " " }; { print $1 }'`

ps -ef | grep $telnet_port | grep Listener > devnull
# Execute the stop server command only if MWA Server is running on the specified port
if [ $? -eq 0 ]
then

if [ -z "$userid_pwd" ] ;
then
echo "Stopping MWA Server on Port number:" $telnet_port
#{ echo $USERPASS; } | nohup $top/$script_path/mwactl.sh stop_force $telnet_port >> /dev/null 2>&1 &
nohup $top/$script_path/mwactl.sh -login $USERPASS stop_force $telnet_port >> /dev/null 2>&1 &
else
echo "Stopping MWA Server on Port number:" $telnet_port
nohup $top/$script_path/mwactl.sh -login $userid_pwd stop_force $telnet_port >> /dev/null 2>&1 &
fi
fi
telnet_ports=`echo $telnet_ports | awk '{ FS = " "}; {
n = 2;
while ( $n != "") {
print $n; n=n+1; }
}'`

done

exit_code=$?

###### MWA Dispatcher - Stop ######

dispatcher_port=`cat $top/$config_path/$CONTEXT_NAME/mwa.cfg | grep -i '^mwa.Dispatcher=' | awk -F: '{ print $2}' | awk -F- '{ print $1}'`

ps -ef | grep MWADIS | grep -v grep > devnull
# Execute the stop dispatcher command only if MWA Dispatcher is running on the specified port
if [ $? -eq 0 ]
then
echo "Stopping MWA Dispatcher on Port number:" $dispatcher_port
$top/$script_path/mwactl.sh -java_config "-Dmwa.cfg=$top/$config_path/$CONTEXT_NAME/mwa.cfg" stop_dispatcher >> /dev/null 2>&1 &
exit_code=$?
fi
fi
exit $exit_code

What is the purpose of applsyspub/pub and guest/oracle?

1. APPLSYSPUB/PUB

APPLSYSPUB is a public schema that grants access to the Oracle applications initial sign-on forms. The default password is PUB. The OS environment variable GWYUID in .env is for this. There is no need to change it.

APPLYSYPUB has no data objects, only synonyms to APPS.

SYNONYM_NAME OWNER OBJECT_NAME OBJECT_OWNER
BSC_SECURITY_PKG APPLSYSPUB BSC_SECURITY_PKG APPS
FND_APPLICATION APPLSYSPUB FND_APPLICATION APPS
FND_APPLICATION_TL APPLSYSPUB FND_APPLICATION_TL APPS
FND_APPLICATION_VL APPLSYSPUB FND_APPLICATION_VL APPS
FND_DISCONNECTED APPLSYSPUB FND_DISCONNECTED APPS
FND_LANGUAGES_TL APPLSYSPUB FND_LANGUAGES_TL APPS
FND_LANGUAGES_VL APPLSYSPUB FND_LANGUAGES_VL APPS
FND_LOOKUPS APPLSYSPUB FND_LOOKUPS APPS
FND_MESSAGE APPLSYSPUB FND_MESSAGE APPS
FND_PRODUCT_GROUPS APPLSYSPUB FND_PRODUCT_GROUPS APPS
FND_PRODUCT_INSTALLATIONS
APPLSYSPUB FND_PRODUCT_INSTALLATIONS APPS
FND_PUB_MESSAGE APPLSYSPUB FND_PUB_MESSAGE APPS
FND_SECURITY_PKG APPLSYSPUB FND_SECURITY_PKG APPS
FND_SESSIONS APPLSYSPUB FND_SESSIONS APPS
FND_SIGNON APPLSYSPUB FND_SIGNON APPS
FND_UNSUCCESSFUL_LOGINS APPLSYSPUB FND_UNSUCCESSFUL_LOGINS APPS
FND_WEBFILEPUB APPLSYSPUB FND_WEBFILEPUB APPS
CSF_MD_ADM_BOUNDS APPLSYSPUB CSF_MD_ADM_BOUNDS CSF
CSF_MD_HYDROS APPLSYSPUB CSF_MD_HYDROS CSF
CSF_MD_LAND_USES APPLSYSPUB CSF_MD_LAND_USES CSF
CSF_MD_POIS APPLSYSPUB CSF_MD_POIS CSF
CSF_MD_RAIL_SEGS APPLSYSPUB CSF_MD_RAIL_SEGS CSF
CSF_MD_RD_SEGS APPLSYSPUB CSF_MD_RD_SEGS CSF

Above is from my PROD. Need to check some synonyms from CSF schema.

APPLSYSPUB is a gateway user and used for connection purposes. When you sign on to Oracle Applications, you initially connect to the public schema, APPLSYSPUB. Once your user name and password are verified, Oracle Applications connects your to the APPS schema and allows you to choose a responsibility. You can then use the professional interface or the HTML interface to access data that resides in a product schema.

APPLSYSPUB/PUB appears in contextfile, dbc file and env file. Dbc file and env file are populated with the value in contextfile.



2. GUEST/ORACLE

The application account GUEST is used by the foundation layers in order to establish user sessions where the user identity is not yet known. End users should not actually be logging into this account directly.

Some additional points:
2.A. GUEST User is used to connect to RDBMS to render the login page.
The name/password can be anything for GUEST user but it should be same in the .dbc file and Profile Option (Guest User Password).
Check the GUEST user information (name can be different according to your Instance)
a. Run following SQL:

SQL>select user_name, start_date, end_date from fnd_user where user_name = 'GUEST';

This should return one row, end_date should be NULL or in advance of today's date, and start_date should be before today's date.

b. Validate the GUEST username/password combinations from the DBC file.
Using the GUEST_USER_PWD value in the DBC file run the following sql:

SQL>select fnd_web_sec.validate_login('GUEST',' ') from dual ;

This should return Yes.

2.B. To set it permanently across the Applications, change the following parameters in _.xml and run autoconfig on the middle
tier:



GUEST
ORACLE


2.C. Use Note 443353.1 How To Successfully Change The Guest Password In E-Business Suite 11.5.10 and R12 to rectify the GUEST password change issue in an Oracle Supported way

How to disable jinitiator automatic download after upgrading to SUN JRE?

After upgrading the jinitiator from SUN JRE 1.6.0_05, we did not remove the oajinit.exe from the system. Thus for new Window’s desktop/laptop or Window’s OS reinstall, first access for the Forms always prompts for installing jinitiator. Here are ways to get around of this problem.

1. install SUN JRE on client side which will prevent from jinitiator downloading.
2. follow Oracle Note: 384261.1: how to disable jinitiator automatic download.
a. Rename $OA_HTML/oajinit.exe or
b. Edit $OA_HTML/bin/appwweb.cfg and change jnit_name to oajinit.exe.old (might update template $FND_TOP/admin/template/appsweb.cfg and run autocfg)

The Haunted DBA (1) -- none empty tnsnames.ora ifile in iAS Oracle Home

Dr. Z once worked for a manufacturing company with total of two DBAs and one Linux system administrator. The Oracle E-Business Suite 11.5.10.2 ran on six Oracle Enterprise Linux nodes: two nodes for web/forms/MWA, two nodes for concurrent managers and report server, and admin server; database is on the two node 10gR2 RAC with ASM. Initially the system was on 32bit database nodes and the performance sucks, especially during monthly close.

The existing cloning method does not follow Oracle’s rapid clone approach. No adpreclone steps from the source system. No adcfgclone step on the destination system. They simply copy the application code over, modify the context file and then run adconfig.sh. after sourcing the environment, run adautocfg.sh again. They had problems from time to time by following this approach. During the server migration from 32bit database node to 64bit database node, they had six new servers for the PROD. One weekend, Dr. Z’s fellow DBA conducted the server migration while he watched. They could not get it done due to configuration issues for some of the concurrent managers.

After some trouble shooting, eventually, they got 64 bit migration completed without load balancing etc. Thus, Dr. Z proposed to fix the cloning method and conducted an in-place clone for the PROD to fix context file, load balancing for web, forms, MWA and concurrent managers.

About one week from the Halloween, they decided to go through the in-place clone procedure for PROD. They got a slow start in the morning due to the nightly security guard forgot to leave office building door keys to the daily security guard. They intended to start at 7:00am and had to wait for about 40 min to get into office. The in-place clone went smoothly and they left the office at about 10:30am. Normally, for the scheduled maintenance, they did not need to go to office. However, Dr. Z’s fellow DBA would like to watch what Dr.Z did.

Dr.Z checked system. Everything was fine. However, on the following Monday, some users had connection problems for the Forms server. Initially, they thought it was due to IE 6, or SUN JRE etc. As more users got problems, they began to check the backend. They found that on web-forms node 2, there were more than 200 forms connections and on web-forms node 1, there were only 4 connections. Trying to connect to web-forms node 1 forms directly, they got errors for connection. Checking Apache logs: error_log_pls, we found: ORA-12541 error which started at 3:47pm on Sunday afternoon.

[Sun Oct 25 10:21:10 2009] [notice] FastCGI: process manager initialized (pid 912)
[Sun Oct 25 10:21:11 2009] [notice] Oracle HTTP Server Powered by Apache/1.3.19 configured -- resuming normal operations
[Sun Oct 25 15:47:03 2009] [error] mod_plsql: /pls/PROD/fnd_icx_launch.launch HTTP-503 ORA-12541
[Sun Oct 25 15:47:19 2009] [error] mod_plsql: /pls/PROD/fnd_icx_launch.launch HTTP-503 ORA-12541

Dr.Z checked all entries in $IAS_ORACLE_HOME/network/admin/tnsnames.ora and none gave him trouble. As the PROD_pind23_ifile.ora is supposed to be empty, so he ran ls –lart *.ora and found that it was not empty. He talked to his fellow DBA and his fellow DBA went to empty it. Thus, Dr.Z lost the file and the timestamp of the file. After bouncing the web/forms tier, their system was back to normal.

Due to above Oracle errors in error_log_pls which started at 3:47pm on Sunday, then the ifile.ora must not be empty since then. Dr.Z wanted to investigate further to find out who might put a none empty file PROD_pind23_ifile.ora there. Before Dr.Z conducted the in-place, he took a backup. Following was from backup that he took in the morning of Sunday. It clearly shows that PROD_pind23_ifile.ora is empty.

wfmprod@pind23(PROD_806_BALANCE/Web:Forms:MWA):$ ls -lR *
-rw-r--r-- 1 wfmprod oinstall 0 Mar 25 2009 PROD_pind23_ifile.ora
-rw-r--r-- 1 wfmprod oinstall 7935 Sep 20 07:50 tnsnames.ora

old:
total 24
-rw-r--r-- 1 wfmprod oinstall 0 Oct 23 08:56 PROD_pind23_ifile.ora
-rw-r--r-- 1 wfmprod oinstall 7731 Oct 23 08:56 PROD_pind23_ifile.ora.old
-rw-r--r-- 1 wfmprod oinstall 7935 Oct 23 08:56 tnsnames.ora
-rw-r--r-- 1 wfmprod oinstall 7889 Oct 23 08:56 tnsnames.ora.cya
[/share/oracle/pind23/product/iAS/network/admin/PROD_pind23]

He also asked his backup administrator to restore PROD_pind23_ifile.ora from tape. The tape backup was taken on Friday. PROD_pind23_ifile.ora is empty and with same timestamp as above.

wfmprod@pind23(PROD_806_BALANCE/Web:Forms:MWA):$ ls -l
total 12
drwxr-xr-x 2 wfmprod oinstall 4096 Sep 8 09:39 old
-rw-r--r-- 1 wfmprod oinstall 0 Mar 25 2009 PROD_pind23_ifile.ora
-rw-r--r-- 1 wfmprod oinstall 0 Oct 26 15:43 PROD_pind23_ifile.ora.bak
-rw-r--r-- 1 wfmprod oinstall 7926 Oct 25 10:16 tnsnames.ora
[/data/wfmprod/product/iAS/network/admin/PROD_pind23]

Thus, when they began to work on the system, the ifile.ora was empty. As the cloning procedure does not touch PROD_pind23_ifile.ora, he suspected that somebody put a none empty file there.

Here were connections to the box from last command: On Sunday, only two DBAs were on the pind23.

wfmprod pts/4 172.18.33.73 Sun Oct 25 08:01 - 08:06 (1+00:04)
wfmprod pts/1 172.18.31.85 Sun Oct 25 07:40 - 16:16 (1+08:36)
wfmprod pts/3 172.18.31.85 Sat Oct 24 00:12 - 16:16 (2+16:04)
root pts/3 172.18.33.53 Fri Oct 23 15:24 - 15:25 (00:00)
root pts/3 172.18.33.53 Fri Oct 23 13:09 - 13:32 (00:23)

172.18.33.73 is Dr.Z’s desktop IP address. 172.18.31.85 is his fellow DBA’s desktop IP address. 172.18.33.53 is Linux system administrator’s desktop IP address. Dr.Z talked to his fellow DBA about this and his fellow DBA denied he put the file there. The command history for bash did not show any activities for PROD_pind23_ifile.ora.

As there were only three people had access to the system, his fellow DBA or Linux system administrator might intentionally put the none empty ifile.ora with tnsnames.ora alias for none existing systems. Here were some suspecting activities:

1. Dr.Z asked his Linux system admin to give him /var/log/secure and message files, the Linux Admin refused to give him the files or let him read them. The Linux admin checked the files and reported that only two DBAs were on the system.
2. Dr.Z’s fellow DBA emptied the file before he could save it.
3. Dr.Z’s fellow DBA was on the system on Sunday.
4. Somebody could use scp to put a copy of file there to avoid directly login to the system.
5. Somebody did not use bash, thus command history shows no activity about the file.

Talked to his manager about this issue and asked for the file level audit. It appears that they are not going to have it. Dr.Z had created shell script to check the file changes for the pass 24 hours. Hopefully, Dr.Z will not have this kind surprise in the future.

How to remove the source node name from cloned RAC Oracle Home inventory

Problem: when running opatch lsinventory for the cloned RAC Oracle Home, the source node name was in the inventory:

Rac system comprising of multiple nodes
Local node = it-pwl-ods01
Remote node = it-pwl-ods02
Remote node = pind42

The remote node pind42 prevents patching and upgrading the Oracle Home except using -local switch for opatch apply -local and runInstaller -local.

Update following file in central inventory:
/opt/oracle/oraInventory/ContentsXML/inventory.xml

Remove the node name pind42 entry.

For local inventory in each cloned Oracle Home:
/opt/oracle/product/10.2.0/GOLD/inventory/ContentsXML/oraclehomeproperties.xml

Update above file and remove node name of pind42.

Check again by running opatch lsinventory.

Hot Clone EBS 11i on 10gR2 RAC and ASM

Rapid Clone Prerequisites

Software Minimum Version Current Version Location
Oracle Universal Installer 2.2.0.19 2.2.0.19 All source system nodes
Perl 5.0.0.5 5.8.8 Source and target database nodes
JRE 1.1.8 1.4.2 Source database node
JDK 1.3.1 1.5.0_10 Target middle-tier applications nodes
Zip 2.3 2.31 All source nodes
OS utilities: make, ld, cc, ar Db tier: ld is in version of 217.
Apps tier: link ld to ld215 Need to be in the PATH when running adcfgclone.pl
AD Minipack 11i.AD.I.6 (6502082) All source nodes
Autoconfig Template Patch 11i.TXK.S (6372396) All source nodes
Raplid Clone Patches 11i Rapidclone Consolidated Fix (6718351) All source nodes

10gR2 (10.2.0.4) CRS and ASM were installed.


On the Source System: PROD

1. run adpreclone.pl on all six production nodes

1.1 database tier: pind41 and pind42
$ORACLE_HOME/appsutil/scripts/

cd /opt/oracle/product/10.2.0/PROD/appsutil/scripts/PROD1_pind41
perl adpreclone.pl dbTier

cd /opt/oracle/product/10.2.0/PROD/appsutil/scripts/PROD2_pind42
perl adpreclone.pl dbTier

1.2 concurrent manager and admin server tier: pind43 and pind44

$COMMON_TOP/admin/scripts/

cd /data/applprod/common/admin/scripts/PROD_pind43
perl adpreclone.pl appsTier

cd /data/applprod/common/admin/scripts/PROD_pind44
perl adpreclone.pl appsTier

1.3 web, forms and mwa server tier: pind23 and pind24

$COMMON_TOP/admin/scripts/

cd /data/wfmprod/common/admin/scripts/PROD_pind23
perl adpreclone.pl appsTier

cd /data/wfmprod/common/admin/scripts/PROD_pind24
perl adpreclone.pl appsTier

2. create backups on the application tier

Run backup scripts on pind23 and pind43:

pind23: /home/wfmprod/scripts/backup and put backups to /data/wfmprod/backup
pind43:/home/applprod/scripts/backup and put backups to /data/applprod/backup

3. create tar file for the Oracle database binary on just one database node (pind41).

cd $ORACLE_HOME/..
tar -cpvzf /backup/PROD/racdb_techstack.tgz PROD

4. run rman backup

Use each morning’s daily rman backup. Need to run backup archivelogs to get archive logs generated after daily rman backup run. Rman backup code is on pind42

Backup files in /backup/PROD/archivelogs and datafiles.

5. move above backups to destination nodes:


on pind41:
cd /backup/PROD
scp racdb_techstack.tgz it-pwl-ods01:/backup/PROD

[/backup/PROD/datafiles] (only need today’s backup)
oracle@pind41(PROD1/DBTier):$ scp PROD_LVL0_20090505_gnke7tbk_s535_p1 PROD_LVL0_20090505_gmke7tbk_s534_p1 PROD_LVL0_20090505_gpke7tbl_s537_p1 PROD_LVL0_20090505_goke7tbk_s536_p1 it-pwl-ods01:/backup/PROD/datafiles


cd /backup/PROD/archivelogs (only need today’s backup)
oracle@pind41(PROD1/DBTier):$
scp * it-pwl-ods01:/backup/PROD/archivelogs

[/backup/PROD/controlfiles]
oracle@pind41(PROD1/DBTier):$ scp * it-pwl-ods01:/backup/PROD/controlfiles


[/pcp/applprod/backup]
applprod@pind43(PROD_806_BALANCE/CCM:Admin):$ scp -r * applmgr@it-pwl-oas01:/pcp/applmgr/backup

[/data/applprod/backup]
wfmprod@pind23(PROD_806_BALANCE/Web:Forms:MWA):$ scp –r * applmgr@it-pwl-ows01:/data/applmgr/backup

wfmprod@pind23(PROD_806_BALANCE/Web:Forms:MWA):$ scp –r * applmgr@it-pwl-ows02:/data/applmgr/backup


On the Destination System: GOLD

6. destination system preparation
6.0 destination should have crs and asm installed on db nodes, /pcp ocfs2 shared disks among ccm and database tier nodes.
6.1 clean the previous old instance on all tiers in refreshing old instance

6.2 for new system, check following OS level requirements
6.2.1 check hugepage
./home/oracle/scripts/hugepages_settings.sh
Recommended setting: vm.nr_hugepages = 2115 (when SGA size is 4GB).

To do for setting hugepage:

Vi /etc/sysctl.conf

Add following at the bottom:

#Custom Setting
#Huge pages for database
Vm.nr_hugepages=2115

Run following command to make the change in effect:
sysctl –p

oracle@it-pwl-ods02(GOLD2/DBTier):$ grep Huge /proc/meminfo
HugePages_Total: 2115
HugePages_Free: 17
HugePages_Rsvd: 14
Hugepagesize: 2048 kB

Run grep, if total is not 2115, then reboot servers.

6.2.2 update /etc/hosts on all servers to include database tiers’ public, private, and virtual ip address, cocurrent manager tier and web tiers. Or use DNS.

6.2.3 central inventory
Create /etc/oratab and /etc/oraInst.loc for new installation on all nodes. Make them chmod 666 oratab oraInst.loc and chown oracle:oinstall oratab oraInst.loc

On apps tiers
applmgr.it-pwl-oas01>cat oraInst.loc
inventory_loc=/opt/oracle/oraInventory
inst_group=oinstall

on database tier
GOLD1.oracle.it-pwl-ods01>cat /etc/oraInst.loc
inventory_loc=/opt/oracle/oraInventory
inst_group=oinstall

6.2.4 ownership of following directories
On database tier:
chown oracle:oinstall /opt/oracle /pcp /backup
On apps tier:
chown applmgr:oinstall /opt/oracle /data
6.2.5 create sub directories
On apps tier
mkdir –p /pcp/applmgr/common/temp
mkdir –p /opt/oracle/oraInventory
mkdir –p /data/applmgr/11i
mkdir –p /data/applmgr/common
mkdir –p /data/applmgr/product
on database tier
mkdir –p /backup/GOLD
mkdir –p /backup/PROD
mkdir –p /opt/oracle/product/10.2.0/GOLD

7. Clone the RAC database
7.1 make sure the ASM listener name is not in the format of LISTENER_. Make sure +ASM and listener are up on it-pwl-ods01 and ods02.

7.2 untar database binary backup on it-pwl-ods01

cd /opt/oracle/product/10.2.0
tar -xvzf /backup/PROD/racdb_techstack.tgz

mv PROD GOLD

7.3 create a pairsfile.txt for new primary target system node (it-pwl-ods01) and put the file in /appsutils/clone

cat pairsfile.txt

s_undo_tablespace=APPS_UNDOTS1
s_dbClusterInst=2
s_db_oh=/opt/oracle/product/10.2.0/GOLD


7.4 create context file for primary target system node: it-pwl-ods01

cd /opt/oracle/product/10.2.0/GOLD/appsutil/clone/bin
run_adclonectx.sh
perl adclonectx.pl \
contextfile=/opt/oracle/product/10.2.0/GOLD/appsutil/PROD1_pind41.xml \
template=/opt/oracle/product/10.2.0/GOLD/appsutil/template/adxdbctx.tmp \
pairsfile=/opt/oracle/product/10.2.0/GOLD/appsutil/clone/pairsfile.txt


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 hostname [pind41]:it-pwl-ods01

It is recommended that your inputs are validated by the program.
However you might choose not to validate your inputs under following \
circumstances:

-If cloning a context on source system for a remote system.
-If cloning a context on a machine where the ports are taken and you do not \
want to shutdown the services at this point.
-If cloning a context but the database it needs to connect is not available.

Do you want the inputs to be validated (y/n) [n] ?:n

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

Current node is the first node in an N Node RAC Cluster (y/n)[n]:y

Target System database name [prod]:GOLD

Do you want to preserve the port values from the source system on the target \
system (y/n) [y] ?:n

Clone Context uses the same port pool mechanism as the Rapid Install

Enter the port pool number [0-99]: 80 (avoid 80 as tomcat uses 8080).

Database port is 1601

Provide information for the Node 1 (current node):

Host name [pind41]:it-pwl-ods01

Virtual Host name [null]:it-pwl-ods01-vip

Instance number [1]: 1

Private interconnect name [pind41-priv]:it-pwl-ods01-priv

Provide information for the Node 2:

Host name [pind42]:it-pwl-ods02

Virtual Host name [null]:it-pwl-ods02-vip

Instance number [2]: 2

Private interconnect name [pind42]:it-pwl-ods02-priv

Target system quorum disk location required for cluster manager and node monitor \
[/dev/raw/raw2]:/dev/raw/raw2

Target system cluster manager service port [9998]:

Oracle OS User [oracle]:

Oracle OS Group [oinstall]:

Target system utl_file accessible directories list [/usr/tmp]: /pcp/applmgr/common/temp, /usr/tmp

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

Target system DATA_TOP 1:+DSKGRP1

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

Target system Display [it-pwl-oas01:0.0]:it-pwl-oas01.visioncorp.com:1.0


Perl executable location is set to:
/usr/bin/perl

New context path and file name [/opt/oracle/product/10.2.0/GOLD/appsutil/GOLD1_it-pwl-ods01.xml]:

Creating the new Database Context file from :
/opt/oracle/product/10.2.0/GOLD/appsutil/template/adxdbctx.tmp


7.5 Run the adclone.pl utility as follows:
Check KSH_VERSION is set and ld, ar, cc, make are set. Make sure ld link to ld215 (install a package on dbtier?, ld217). After rapidclone patchset, do not need to set KSH_VERION.
cd /opt/oracle/product/10.2.0/GOLD/appsutil/clone/bin.
Run_adclone.sh
export KSH_VERSION='@(#)PD KSH v5.2.14 99/07/13.2'
perl adclone.pl
java=/opt/oracle/product/10.2.0/GOLD/appsutil/clone/jre
component=dbTechStack
mode=apply
stage=/opt/oracle/product/10.2.0/GOLD/appsutil/clone
method=CUSTOM
dbctxtg=/opt/oracle/product/10.2.0/GOLD/appsutil/GOLD1_it-pwl-ods01.xml
showProgress contextValidated=true

Note: Asks for apps password even though the database hasn’t been created yet.

7.6 rman duplicate to create cloned database

7.6.1 create password files

GOLD1.oracle.it-pwl-ods01>orapwd file=orapwGOLD1 password=syspasswd entries=10
(run on two nodes).

7.6.2 create initGOLD1.ora.dup

Cp initPROD1.ora to initGOLD1.ora

Make changes in initGOLD1.ora
Replace PROD with GOLD
Replace applprod with applmgr
Replace pind41 with it-pwl-ods01,pind42 with it-pwl-ods02
Comment out cluster_database,control_files,
Change sga_target from 24G to 4G
Change log_archive_dest_1 to ‘LOCATION=/backup/GOLD/arch’
Change the arch log format backup from GOLD to PROD.
Update temporary tnsnames.ora with local and remote listeners name in initGOLD1.ora, create entry for PROD1.

7.6.3 create temporary tnsnames.ora

set $TNS_ADMIN=/opt/oracle/product/10.2.0/GOLD/network/admin
Tnsnames.ora:

[/opt/oracle/product/10.2.0/GOLD/network/admin]
oracle@it-pwl-ods01(GOLD1/DBTier):$ cat tnsnames.ora
#
# $Header: ad8itns.ora 115.4 2004/04/01 12:57:26 rsanders ship $
#
# ###############################################################
#
# This file is automatically generated by AutoConfig. It will be read and
# overwritten. If you were instructed to edit this file, or if you are not
# able to use the settings created by AutoConfig, refer to Metalink document
# 165195.1 for assistance.
#
# ###############################################################

#

#
# Net8 definition for the database
#
PROD1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=pind41-vip.visioncorp.com)(PORT=1531))
(CONNECT_DATA=
(SERVICE_NAME=PROD)
(INSTANCE_NAME=PROD1)
)
)


GOLD1 = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=it-pwl-ods01)(PORT=1601))
(CONNECT_DATA=(SID=GOLD1))
)

GOLD1_LOCAL =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=it-pwl-ods01)(PORT=1601))
)

GOLD_REMOTE =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=it-pwl-ods01)(PORT=1601))
)

#
# Intermedia
#
extproc_connection_data =
(DESCRIPTION=
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCGOLD1))
)
(CONNECT_DATA=
(SID=PLSExtProc)
(PRESENTATION = RO)
) )

IFILE=/opt/oracle/product/10.2.0/GOLD/network/admin/GOLD1_it-pwl-ods01/GOLD1_it-pwl-ods01_ifile.ora


[/opt/oracle/product/10.2.0/GOLD/network/admin]

7.6.4 check ASM and listener

Start asm if it is not up.
crs.oracle.it-pwl-ods01>srvctl start asm -n it-pwl-ods01
crs.oracle.it-pwl-ods01>srvctl start asm -n it-pwl-ods02

change asm listener name.

7.6.5 check backups

cd /home/oracle/scripts/clone/GOLD

make sure rman backups (datafile and archive logs) in right location.
It-pwl-ods01:/backup/PROD/archivelogs and datafiles


Check connection to PROD1. set until time in the rman run block accordingly. Make sure archive logs are backed up to this point of time and the archive log backup pieces are moved over.

7.6.6 run rman duplicate

startup new instance in nomount stage.

SQL> startup nomount;

Rman target sys/syspw@PROD1 auxiliary /
RMAN> @dupPRODtoGOLD.rman

(duplicate rman will restore archivelogs from backupsets to /backup/GOLD/arch (set in initGOLD1.ora) and apply the logs, after applying, delete them.)

[~/scripts/clone/GOLD]
oracle@it-pwl-ods01(GOLD1/DBTier):$ cat dupPRODtoGOLD.rman
CONFIGURE CHANNEL DEVICE TYPE disk CLEAR;
CONFIGURE DEFAULT DEVICE TYPE TO disk;
CONFIGURE DEVICE TYPE disk PARALLELISM 2;
run {
set until time "to_date('05-MAY-2009 11:00:00','DD-MON-YYYY HH24:mi:ss')";
set autolocate on;
DUPLICATE TARGET DATABASE TO "GOLD" pfile="/opt/oracle/product/10.2.0/GOLD/dbs/initGOLD1.ora";
}
[~/scripts/clone/GOLD]

7.6.7 post database duplicate steps

7.6.7.1 Update initGOLD1.ora

Update Control_file location, uncommented it.
Uncomment cluster_database.
Update *.log_archive_format from PROD to GOLD

Remember to update local and remote listener to match with previous definition.

7.6.7.2 Bounce database. Might need to turn off archivelog.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 4294967296 bytes
Fixed Size 2089432 bytes
Variable Size 1392512552 bytes
Database Buffers 2885681152 bytes
Redo Buffers 14684160 bytes
Database mounted.
SQL> alter database noarchivelog;

Database altered.


SQL> alter database open;

7.6.7.3 In case need to turn on FRA:
Change init.ora
*.db_flashback_retention_target=1440
*.db_recovery_file_dest='/backup'
*.db_recovery_file_dest_size=500G
*.recovery_parallelism=2
#*.log_archive_dest_1='LOCATION=/backup/GOLD/arch'
#*.log_archive_format = 'GOLD_%r_%t_%s.arc'

SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database flashback on;
SQL> alter database open;

7.6.7.4 Use spfile:

SQL> create spfile='+DSKGRP1' from pfile;

Switch to asm instance to find the location of spfile.

Create initGOLD1.ora and initGOLD2.ora with same a pointer to spfile.
GOLD1.oracle.it-pwl-ods01>cat initGOLD1.ora
spfile='+DSKGRP1/GOLD/PARAMETERFILE/spfile.372.686313427'



7.6.7.5 Clean up source system node topology (fnd_node etc):

SQL> connect apps/apps
Connected.

SQL> exec fnd_conc_clone.setup_clean;

PL/SQL procedure successfully completed.

-- must run autoconfig after this
--
EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;
EXIT;


7.6.8 create temporary listener.ora and start temporary listener.

Cd $TNS_ADMIN
(/opt/oracle/product/10.2.0/GOLD/network/admin)
Config temp listener and start it

Listener.ora

# $Header: adlsnr10RAC.ora 115.3 2006/05/02 14:40:32 sbandla noship $
#
# ###############################################################
#
# This file is automatically generated by AutoConfig. It will be read and
# overwritten. If you were instructed to edit this file, or if you are not
# able to use the settings created by AutoConfig, refer to Metalink document
# 165195.1 for assistance.
#
# ###############################################################

#

#
# Definition for RAC Database listener
#

LISTENER_it-pwl-ods01 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = it-pwl-ods01-vip.visioncorp.com)(PORT = 1601)(IP = FIRST)))
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = it-pwl-ods01)(PORT = 1601)(IP = FIRST)))
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCGOLD1)))
)
)

SID_LIST_LISTENER_it-pwl-ods01 =
(SID_LIST =
(SID_DESC = (ORACLE_HOME = /opt/oracle/product/10.2.0/GOLD)(SID_NAME = GOLD1))
(SID_DESC = (SID_NAME = PLSExtProc)(ORACLE_HOME = /opt/oracle/product/10.2.0/GOLD)(PROGRAM = extproc))
)

STARTUP_WAIT_TIME_LISTENER_it-pwl-ods01 = 0
CONNECT_TIMEOUT_LISTENER_it-pwl-ods01 = 10
TRACE_LEVEL_LISTENER_it-pwl-ods01 = OFF

LOG_DIRECTORY_LISTENER_it-pwl-ods01 = /opt/oracle/product/10.2.0/GOLD/network/admin
LOG_FILE_LISTENER_it-pwl-ods01 = GOLD1
TRACE_DIRECTORY_LISTENER_it-pwl-ods01 = /opt/oracle/product/10.2.0/GOLD/network/admin
TRACE_FILE_LISTENER_it-pwl-ods01 = GOLD1
ADMIN_RESTRICTIONS_LISTENER_it-pwl-ods01 = OFF


IFILE=/opt/oracle/product/10.2.0/GOLD/network/admin/GOLD1_it-pwl-ods01/listener_ifile.ora

7.6.9 run adautocfg

7.6.9.1 modify adlsnr10RAC.ora template in /opt/oracle/product/10.2.0/GOLD/appsutil/template to change s_dbhost in the listener name to s_dbSid: LISTENER_%s_dbhost% to LISTENER_%s_dbSid% in case more than one apps database on the nodes.

7.6.9.2 Run adautocfg.sh in /opt/oracle/product/10.2.0/GOLD/appsutil/scripts/GOLD1_it-pwl-ods01

7.6.9.3 Source environment
Bounce listener and database using scripts in /opt/oracle/product/10.2.0/GOLD/appsutil/scripts/GOLD1_it-pwl-ods01

8. create database instance on secondary node

untar database binary code

On second node: it-pwl-ods02:

cd /opt/oracle/product/10.2.0
tar -xvzf /backup/PROD/racdb_techstack.tgz

mv PROD GOLD

create pairsfile.txt
create a pairsfile.txt for new secondary target system node (it-pwl-ods02) and put the file in /appsutils/clone

s_undo_tablespace=APPS_UNDOTS2
s_dbClusterInst=2
s_db_oh=/opt/oracle/product/10.2.0/GOLD
run adclonectx.pl to create contextfile.
Navigate to /appsutil/clone/bin. Run the adclonectx.pl utility as follows:
perl adclonectx.pl \
contextfile=/opt/oracle/product/10.2.0/GOLD/appsutil/PROD1_pind41.xml \
template=/opt/oracle/product/10.2.0/GOLD/appsutil/template/adxdbctx.tmp \
pairsfile=/opt/oracle/product/10.2.0/GOLD/appsutil/clone/pairsfile.txt

oracle@it-pwl-ods02(GOLD2/DBTier):$ run_adclonectx.sh
../jre/bin/java -classpath ../jlib/classes12.jar:../jlib/xmlparserv2.zip:../jre/lib/rt.jar:../jlib/java: oracle.apps.ad.context.CloneContext -e /opt/oracle/product/10.2.0/GOLD/appsutil/PROD1_pind41.xml -tmpl /opt/oracle/product/10.2.0/GOLD/appsutil/template/adxdbctx.tmp -pairsfile /opt/oracle/product/10.2.0/GOLD/appsutil/clone/pairsfile.txt -perl "/usr/bin/perl" -perl5lib "/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi:/usr/lib64/perl5/site_perl/5.8.7/x86_64-linux-thread-multi:/usr/lib64/perl5/site_perl/5.8.6/x86_64-linux-thread-multi:/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi:/usr/lib/perl5/site_perl/5.8.8:/usr/lib/perl5/site_perl/5.8.7:/usr/lib/perl5/site_perl/5.8.6:/usr/lib/perl5/site_perl/5.8.5:/usr/lib/perl5/site_perl:/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi:/usr/lib64/perl5/vendor_perl/5.8.7/x86_64-linux-thread-multi:/usr/lib64/perl5/vendor_perl/5.8.6/x86_64-linux-thread-multi:/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi:/usr/lib/perl5/vendor_perl/5.8.8:/usr/lib/perl5/vendor_perl/5.8.7:/usr/lib/perl5/vendor_perl/5.8.6:/usr/lib/perl5/vendor_perl/5.8.5:/usr/lib/perl5/vendor_perl:/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi:/usr/lib/perl5/5.8.8:.:/opt/oracle/product/10.2.0/GOLD/appsutil/perl"

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 hostname [pind41]:it-pwl-ods02

It is recommended that your inputs are validated by the program.
However you might choose not to validate your inputs under following circumstances:
-If cloning a context on source system for a remote system.
-If cloning a context on a machine where the ports are taken and you do not want to shutdown the services at this point.
-If cloning a context but the database it needs to connect is not available.

Do you want the inputs to be validated (y/n) [n] ?:n

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

Current node is the first node in an N Node RAC Cluster (y/n)[n]:n

Please provide the details to connect to one of live RAC nodes


Host name of the live RAC node:it-pwl-ods01

Domain name of the live RAC node:visioncorp.com

Database SID of the live RAC node:GOLD1

Listener port number of the live RAC node:1601

APPS password is required to fetch the information of the other nodes from the database
Enter APPS Password [APPS]:timn3h
Current Node:
Host Name : it-pwl-ods02

SID : GOLD2

Instance Name : GOLD2

Instance Number : 2

Instance Thread : 2

Undo Table Space: APPS_UNDOTS2

Listener Port : 1601

Target system quorum disk location required for cluster manager and node monitor [/dev/raw/raw2]:

Target system cluster manager service port [9998]:

Oracle OS User [oracle]:

Oracle OS Group [oinstall]:

Target system utl_file accessible directories list [/usr/tmp]:/pcp/applmgr/common/temp,/usr/tmp

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

Target system DATA_TOP 1:+DSKGRP1

Do you want to preserve the Display set to pind43.visioncorp.com:1.0 (y/n) [y] ?:n

Target system Display [it-pwl-ods02:0.0]:it-pwl-oas02.visioncorp.com:1.0

Perl executable location is set to:
/usr/bin/perl

New context path and file name [/opt/oracle/product/10.2.0/GOLD/appsutil/GOLD2_it-pwl-ods02.xml]:

Creating the new Database Context file from :
/opt/oracle/product/10.2.0/GOLD/appsutil/template/adxdbctx.tmp

The new database context file has been created :
/opt/oracle/product/10.2.0/GOLD/appsutil/GOLD2_it-pwl-ods02.xml

Log file located at /tmp/CloneContext_05110903.log

8.1 Modify adlsnrlORAC.ora
cd $ORACLE_HOME/appsutil/template
vi adlsnrlORAC.ora
Modify dbhost = dbSid (Not all, will provide example)
8.2 run adclone

oracle@it-pwl-ods02(GOLD1/DBTier):$ cat run_adclone.sh

export KSH_VERSION='@(#)PD KSH v5.2.14 99/07/13.2'
perl adclone.pl java=/opt/oracle/product/10.2.0/GOLD/appsutil/clone/jre component=dbTechStack mode=apply stage=/opt/oracle/product/10.2.0/GOLD/appsutil/clone method=CUSTOM dbctxtg=/opt/oracle/product/10.2.0/GOLD/appsutil/GOLD2_it-pwl-ods02.xml showProgress contextValidated=true
[/opt/oracle/product/10.2.0/GOLD/appsutil/clone/bin]

8.3 startup instance on second node

Before running autocfg, cp initGOLD1.ora, rename initGOLD2.ora and startup database on it-pwl-ods02.

8.4 create temporary listener

set $TNS_ADMIN=/opt/oracle/product/10.2.0/network/admin

Config temporary listener.ora and start it.

# $Header: adlsnr10RAC.ora 115.3 2006/05/02 14:40:32 sbandla noship $
#
# ###############################################################
#
# This file is automatically generated by AutoConfig. It will be read and
# overwritten. If you were instructed to edit this file, or if you are not
# able to use the settings created by AutoConfig, refer to Metalink document
# 165195.1 for assistance.
#
# ###############################################################

#

#
# Definition for RAC Database listener
#

LISTENER_it-pwl-ods02 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = it-pwl-ods02.visioncorp.com)(PORT = 1601)(IP = FIRST)))
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = it-pwl-ods02)(PORT = 1601)(IP = FIRST)))
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCGOLD2)))
)
)

SID_LIST_LISTENER_it-pwl-ods02 =
(SID_LIST =
(SID_DESC = (ORACLE_HOME = /opt/oracle/product/10.2.0/GOLD)(SID_NAME = GOLD2))
(SID_DESC = (SID_NAME = PLSExtProc)(ORACLE_HOME = /opt/oracle/product/10.2.0/GOLD)(PROGRAM = extproc))
)

STARTUP_WAIT_TIME_LISTENER_it-pwl-ods02 = 0
CONNECT_TIMEOUT_LISTENER_it-pwl-ods02 = 10
TRACE_LEVEL_LISTENER_it-pwl-ods02 = OFF

LOG_DIRECTORY_LISTENER_it-pwl-ods02 = /opt/oracle/product/10.2.0/GOLD/network/admin
LOG_FILE_LISTENER_it-pwl-ods02 = GOLD2
TRACE_DIRECTORY_LISTENER_it-pwl-ods02 = /opt/oracle/product/10.2.0/GOLD/network/admin
TRACE_FILE_LISTENER_it-pwl-ods02 = GOLD2
ADMIN_RESTRICTIONS_LISTENER_it-pwl-ods02 = OFF


IFILE=/opt/oracle/product/10.2.0/GOLD/network/admin/GOLD2_it-pwl-ods02/listener_ifile.ora

8.5 run adautocfg


Run adautocfg.sh in /opt/oracle/product/10.2.0/GOLD/appsutil/scripts/GOLD2_it-pwl-ods02

Source environment
Bounce listener and database using scripts in /opt/oracle/product/10.2.0/GOLD/appsutil/scripts/GOLD2_it-pwl-ods02

run adautocfg.sh on primary and bounce listener and database

Run adautocfg.sh again on node1: it-pwl-ods01 and bounce listener and database.

8.6 Database postclone steps:
Clean up system level profile options, WF data and other source system specific data which remain in the newly cloned database:

On it-pwl-ods02: /home/oracle/scripts/clone/GOLD/post_clone1_gold.sql as system
And post_clone2_gold.sql as apps

8.6.1 update libraries

cd $ORACLE_HOME/appsutil/install/
adupdlib.sql is called from adcrdb.sql during the standard clone procedure. For RAC, we use manual clone and adcrdb.sql is not used. Thus, run adupdlib.sql here.

Sqlplus “/ as sysdba” @adupdlib.sql so

(so is the library extention).

Select * from dba_libraries where file_spec is not null;

8.6.2 update directories in database

sqlplus “/ as sysdba”

Select * from dba_directories;

Use following command to update the directory path:

drop directory POWL_OUTBOUND_EDI;
create directory POWL_OUTBOUND_EDI
as '/pcp/applmgr/common/xx_custom/outbound/edi';
Grant ALL on Directory POWL_OUTBOUND_EDI to APPS;
Grant ALL on Directory POWL_OUTBOUND_EDI to XX_CUSTOM;

Some directories only used by sys or system, not need for the grants.

8.6.3 check first before running following commands:

sqlplus “/ as sysdba”

--alter tablespace temp add tempfile size 2000m autoextend on maxsize 6000m;
--alter database rename global_name to PTCH.VISIONCORP.COM;
--alter database add logfile thread 2 group 16;
--alter database add logfile thread 2 group 17;
--alter database enable thread 2;

-- Added to create 1GB online redo logs - default is 1MB.
--alter database drop logfile group 2;
--alter database add logfile thread 2 group 3 ('+DSKGRP1') size 1048576k;
--alter database add logfile thread 2 group 4 ('+DSKGRP1') size 1048576k;
--alter database add logfile thread 2 group 5 ('+DSKGRP1') size 1048576k;
--alter database add logfile thread 2 group 6 ('+DSKGRP1') size 1048576k;
--alter database add logfile thread 2 group 7 ('+DSKGRP1') size 1048576k;
--alter database add logfile thread 2 group 8 ('+DSKGRP1') size 1048576k;

8.6.4 update session_cookie_name due to load balancing

sqlplus apps/apps

update icx_parameters set session_cookie_name=’gold’;

8.6.5 update profile option values

select profile_option_value from fnd_profile_option_values;

8.6.6 update workflow related data

select text_alue from wf_notification_attributes;

update wf_systems set display_name = ‘GOLD.VISIONCORP.COM’;
update wf_agents set address=replace(address,’PRD34,US.ORACLE.COM’,’GOLD.VISIONCORP.COM’);

select web_host_name from fnd_form_functions;

8.6.7 concurrent requests

delete from fnd_concurrent_requests where status_code=’C’;

select logfile_name,logfile_node_name,outfile_node_name from fnd_concurrent_requests;

update fnd_concurrent_requests set phase_code = ‘C’, status_code = ‘X’ where status_code = ‘T’;

update fnd_concurrent_requests set phase_code = ‘C’ where phase_code=’P’;

update fnd_concurrent_requests set status_code = ‘C’ where status_code = ‘P’

update fnd_concurrent_requests set hold_flag=’Y’ where phase_code = ‘P’ and status_code in (‘Q’,’I’);


select node_name from fnd_concurrent_queues;
update fnd_concurrent_queues set running_pocesses = 0, max_processes = 0;
update fnd_concurrent_queues set control_code = ‘X’ where concurrent_queue_name = ‘FNDICM’;


9. On Concurrent manager and administration servers (it-pwl-oas01 and oas02):


9.1 untar application binary backup

on it-pwl-oas01 and oas02

cd /data/applmgr/11i

tar –xzf /pcp/applmgr/backup/APPLTOP/11.5.tar.gz

cd /data/applmgr

unzip /pcp/applmgr/backup/COMMON/common.zip

cd /data/applmgr

tar -xzf /pcp/applmgr/backup/ORATOP/product.tar.gz

9.2 check central inventory
/etc/oraInst.loc
/opt/oracle/oraInventory (ownership: applmgr:oinstall).

check ld linked to ld215

check ulimit –a

stack size and open files

/etc/security/limits.conf

9.3 run adcfgclone in $COMMON_TOP/clone/bin
[applmgr@it-pwl-oas01 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 [PROD]:GOLD

Target system database server node [pind41]:it-pwl-ods01

Target system database domain name [visioncorp.com]:visioncorp.com

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

Does the target system application tier utilize multiple domain names (y/n) [n] ?:n

Target system concurrent processing node [pind43]:it-pwl-oas01

Target system administration node [pind43]:it-pwl-oas01

Target system forms server node [pind23]:it-pwl-ows01

Target system web server node [pind23]:it-pwl-ows01

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

Target system APPL_TOP mount point [/data/applprod/11i]:/data/applmgr/11i

Target system COMMON_TOP directory [/data/applprod/common]:/data/applmgr/common

Target system 8.0.6 ORACLE_HOME directory [/data/applprod/product/8.0.6]:/data/applmgr/product/8.0.6

Target system iAS ORACLE_HOME directory [/data/applprod/product/iAS]:/data/applmgr/product/iAS

Do you want to preserve the Display set to pind43.visioncorp.com:1.0 (y/n) [y] ?:n

Target system Display [it-pwl-oas01:0.0]:it-pwl-oas01.visioncorp.com:1.0

Do you want to preserve the port values from the source system on the target system (y/n) [y] ?:n

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]:
80

Checking the port pool 80
done: Port Pool 80 is free

Complete port information available at /data/applmgr/11i/admin/out/GOLD_it-pwl-oas01/portpool.lst

Verifying Database Connection...

Database Connection on Port 1601: Successful

UTL_FILE_DIR on database tier consists of the following directories.

1. /pcp/applmgr/common/temp
2. /pcp/applmgr/common/xx_custom/outbound/gl
3. /pcp/applmgr/common/xx_custom/inbound/gl
4. /pcp/applmgr/common/EDI/inholding
5. /pcp/applmgr/common/EDI/outholding
6. /pcp/applmgr/common/xx_custom/outbound/acsis
7. /opt/oracle/product/10.2.0/GOLD/appsutil/outbound/GOLD1_it-pwl-ods01
8. /pcp/applmgr/common/xx_custom/outbound/ceridian
9. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1]: 1

9.4 Stop ccm
cd $STOP
adstpall apps/apps

9.5 Source environment
Cd $TNS_ADMIN to create ifile.
8.0.6 and iAS homes.

9.6 run adcfgclone on node2
applmgr.it-pwl-oas02>perl adcfgclone.pl appsTier
Enter the APPS password [APPS]:
timn3h

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 [PROD]:GOLD

Target system database server node [pind41]:it-pwl-ods02

Target system database domain name [visioncorp.com]:visioncorp.com

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

Does the target system application tier utilize multiple domain names (y/n) [n] ?:n

Target system concurrent processing node [pind43]:it-pwl-oas02

Target system administration node [pind43]:it-pwl-oas02

Target system forms server node [pind23]:it-pwl-ows02

Target system web server node [pind23]:it-pwl-ows02

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

Target system APPL_TOP mount point [/data/applprod/11i]:/data/applmgr/11i

Target system COMMON_TOP directory [/data/applprod/common]:/data/applmgr/common

Target system 8.0.6 ORACLE_HOME directory [/data/applprod/product/8.0.6]:/data/applmgr/product/8.0.6

Target system iAS ORACLE_HOME directory [/data/applprod/product/iAS]:/data/applmgr/product/iAS

Do you want to preserve the Display set to pind43.visioncorp.com:1.0 (y/n) [y] ?:n

Target system Display [it-pwl-oas02:0.0]:it-pwl-oas02.visioncorp.com:1.0

Do you want to preserve the port values from the source system on the target system (y/n) [y] ?:n

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]:
80

Checking the port pool 80
done: Port Pool 80 is free

Complete port information available at /data/applmgr/11i/admin/out/GOLD_it-pwl-oas02/portpool.lst

Verifying Database Connection...

Database Connection on Port 1601: Successful

UTL_FILE_DIR on database tier consists of the following directories.

1. /pcp/applmgr/common/temp
2. /pcp/applmgr/common/xx_custom/outbound/gl
3. /pcp/applmgr/common/xx_custom/inbound/gl
4. /pcp/applmgr/common/EDI/inholding
5. /pcp/applmgr/common/EDI/outholding
6. /pcp/applmgr/common/xx_custom/outbound/acsis
7. /opt/oracle/product/10.2.0/GOLD/appsutil/outbound/GOLD2_it-pwl-ods02
8. /pcp/applmgr/common/xx_custom/outbound/ceridian
9. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1]:1

10. On Web and Forms servers (it-pwl-ows01 and ows02):


10.1 untar application binary backup

on it-pwl-ows01 and ows02
on it-pwl-ows01:

mkdir –p /data/applmgr/backup

on pind23
cd /data/applprod/backup
scp -r * applmgr@it-pwl-ows01:/data/applmgr/backup


cd /data/applmgr/11i

tar –xzf /data/applmgr/backup/APPLTOP/11.5.tar.gz

cd /data/applmgr

unzip /data/applmgr/backup/COMMON_TOP/common.zip

cd /data/applmgr/

tar -xzf /data/applmgr/backup/ORATOP/product.tar.gz


10.2 check central inventory
/etc/oraInst.loc
/etc/oratab
/opt/oracle/oraInventory (ownership: applmgr:oinstall).

check ld linked to ld215 (On web/forms tier)

check ulimit –a

stack size and open files

/etc/security/limits.conf

Ping database tier’s vip and public ip address and hostname from web and ccm tiers. (/etc/hosts or DNS)
Otherwise, database connection check error when running adcfgclone.pl

Chown applmgr:oinstall /opt/oracle
Mkdir /opt/oracle/oraInventory
Cp /etc/oraInst.loc and /etc/oratab and chown applmgr:oinstall


cd /data/applmgr/common/clone/bin
10.3 run adcfgclone
[applmgr@it-pwl-ows01 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 [PROD]:GOLD

Target system database server node [pind41]:it-pwl-ods01

Target system database domain name [visioncorp.com]:visioncorp.com

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

Does the target system application tier utilize multiple domain names (y/n) [n] ?:n

Target system concurrent processing node [pind43]:it-pwl-oas01

Target system administration node [pind43]:it-pwl-oas01

Target system forms server node [pind23]:it-pwl-ows01

Target system web server node [pind23]:it-pwl-ows01

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

Target system APPL_TOP mount point [/data/wfmprod/11i]:/data/applmgr/11i

Target system COMMON_TOP directory [/data/wfmprod/common]:/data/applmgr/common

Target system 8.0.6 ORACLE_HOME directory [/data/wfmprod/product/8.0.6]:/data/applmgr/product/8.0.6

Target system iAS ORACLE_HOME directory [/data/wfmprod/product/iAS]:/data/applmgr/product/iAS

Do you want to preserve the Display set to pind43.visioncorp.com:1.0 (y/n) [y] ?:n

Target system Display [it-pwl-ows01:0.0]:it-pwl-oas01.visioncorp.com:1.0

Do you want to preserve the port values from the source system on the target system (y/n) [y] ?:n

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]:
80

Checking the port pool 80
done: Port Pool 80 is free

Complete port information available at /data/applmgr/11i/admin/out/GOLD_it-pwl-ows01/portpool.lst

Verifying Database Connection...

Database Connection on Port 1601: Successful

UTL_FILE_DIR on database tier consists of the following directories.

1. /pcp/applmgr/common/temp
2. /pcp/applmgr/common/xx_custom/outbound/gl
3. /pcp/applmgr/common/xx_custom/inbound/gl
4. /pcp/applmgr/common/EDI/inholding
5. /pcp/applmgr/common/EDI/outholding
6. /pcp/applmgr/common/xx_custom/outbound/acsis
7. /opt/oracle/product/10.2.0/GOLD/appsutil/outbound/GOLD1_it-pwl-ods01
8. /pcp/applmgr/common/xx_custom/outbound/ceridian
9. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1]:9

Creating the new APPL_TOP Context file from :
/data/applmgr/11i/ad/11.5.0/admin/template/adxmlctx.tmp

The new APPL_TOP context file has been created :
/data/applmgr/11i/admin/GOLD_it-pwl-ows01.xml

Log file located at /tmp/CloneContext_05130112.log

Running Rapid Clone with command:
perl /data/applmgr/common/clone/bin/adclone.pl java=/data/applmgr/common /clone/bin/../jre mode=apply stage=/data/applmgr/common/clone/bin/.. component=a ppsTier method=CUSTOM appctxtg=/data/applmgr/11i/admin/GOLD_it-pwl-ows01.xml sh owProgress contextValidated=true


/etc/oraInst.loc points to an Inventory that does not exist: /opt/oracle/oraInve ntory
Inventory Directory created...
Beginning application tier Apply - Wed May 13 13:15:57 2009
Log file located at /data/applmgr/11i/admin/GOLD_it-pwl-ows01/log/ApplyAppsTier_ 05131315.log


Completed Apply...
Wed May 13 13:25:09 2009

Beginning APPSIAS_GOLD registration to central inventory...

ORACLE_HOME NAME : APPSIAS_GOLD
ORACLE_HOME PATH : /data/applmgr/product/iAS
Using Inventory location in /etc/oraInst.loc
Log file located at /opt/oracle/oraInventory/logs/OracleHomeCloner_05130125.log
ORACLE_HOME /data/applmgr/product/iAS was registered successfully.

Starting application Services for GOLD:
Running:
/data/applmgr/common/admin/scripts/GOLD_it-pwl-ows01/adstrtal.sh APPS/

You are running adstrtal.sh version 115.19

Executing service control script:
/data/applmgr/common/admin/scripts/GOLD_it-pwl-ows01/adapcctl.sh start
script returned:
****************************************************

adapcctl.sh version 115.55

Apache Web Server Listener is not running.
Starting Apache Web Server Listener (dedicated HTTP) ...

05/13/09-13:25:16 :: Removing gantt cache directory

05/13/09-13:25:17 :: Successfully removed the gantt cache directory:/data/applmgr/common/html/cabo/images/cache/gantt
Apache Web Server Listener (PLSQL) is not running.
Starting Apache Web Server Listener (dedicated PLSQL) ...

adapcctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/data/applmgr/common/admin/scripts/GOLD_it-pwl-ows01/adalnctl.sh start
script returned:
****************************************************

adalnctl.sh version 115.17

Checking for FNDFS executable.
Starting listener process APPS_GOLD.

adalnctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/data/applmgr/common/admin/scripts/GOLD_it-pwl-ows01/adfrmctl.sh start
script returned:
****************************************************

You are running adfrmctl.sh version 115.38

Starting forms server for GOLD on port 9080.

adfrmctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/data/applmgr/common/admin/scripts/GOLD_it-pwl-ows01/adfmcctl.sh start
script returned:
****************************************************

You are running adfmcctl.sh version 115.20

Starting forms load balancing client for GOLD.

adfmcctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/data/applmgr/common/admin/scripts/GOLD_it-pwl-ows01/adfmsctl.sh start
script returned:
****************************************************

You are running adfmsctl.sh version 115.16

starting forms metrics server for GOLD.

adfmsctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/data/applmgr/common/admin/scripts/GOLD_it-pwl-ows01/jtffmctl.sh start
script returned:
****************************************************

You are running jtffmctl.sh version 115.16

Validating Fulfillment patch level via /data/applmgr/common/java
Fulfillment patch level validated.
Starting Fulfillment Server for GOLD on port 9380 ...

jtffmctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


All enabled services for this node are started.
Check logfile /data/applmgr/common/admin/log/GOLD_it-pwl-ows01/05131325.log for details

Exiting with status 0
[/data/applmgr/common/clone/bin]
applmgr@it-pwl-ows01(web/forms):$

10.4 Shutdown web/forms
cd
. ./.profile
cd $STOP
adstpall apps/apps

10.5 run adcfgclone web node 2: it-pwl-ows02.
Check it-pwl-ows02 using step 10.2
cd /data/applmgr/common/clone/bin

applmgr@it-pwl-ows02(/CCM:Admin):$ 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 [PROD]:GOLD

Target system database server node [pind41]:it-pwl-ods01

Target system database domain name [visioncorp.com]:visioncorp.com

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

Does the target system application tier utilize multiple domain names (y/n) [n] ?:n

Target system concurrent processing node [pind43]:it-pwl-oas02

Target system administration node [pind43]:it-pwl-oas02

Target system forms server node [pind23]:it-pwl-ows02

Target system web server node [pind23]:it-pwl-ows02

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

Target system APPL_TOP mount point [/data/wfmprod/11i]:/data/applmgr/11i

Target system COMMON_TOP directory [/data/wfmprod/common]:/data/applmgr/common

Target system 8.0.6 ORACLE_HOME directory [/data/wfmprod/product/8.0.6]:/data/applmgr/product/8.0.6

Target system iAS ORACLE_HOME directory [/data/wfmprod/product/iAS]:/data/applmgr/product/iAS

Do you want to preserve the Display set to pind43.visioncorp.com:1.0 (y/n) [y] ?:n

Target system Display [it-pwl-ows02:0.0]:it-pwl-oas02.visioncorp.com:1.0

Do you want to preserve the port values from the source system on the target system (y/n) [y] ?:n

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]:
80

Checking the port pool 80
done: Port Pool 80 is free

Complete port information available at /data/applmgr/11i/admin/out/GOLD_it-pwl-ows02/portpool.lst

Verifying Database Connection...

Database Connection on Port 1601: Successful

UTL_FILE_DIR on database tier consists of the following directories.

1. /pcp/applmgr/common/temp
2. /pcp/applmgr/common/xx_custom/outbound/gl
3. /pcp/applmgr/common/xx_custom/inbound/gl
4. /pcp/applmgr/common/EDI/inholding
5. /pcp/applmgr/common/EDI/outholding
6. /pcp/applmgr/common/xx_custom/outbound/acsis
7. /opt/oracle/product/10.2.0/GOLD/appsutil/outbound/GOLD2_it-pwl-ods02
8. /pcp/applmgr/common/xx_custom/outbound/ceridian
9. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1]:1

10.6 Shutdown web/forms
cd
. ./.profile
cd $STOP
adapstpall apps/apps

10.7 update contextfile

10.7.1 web tier JDBC and listener load balancing
Update contextfile: s_tools_two_task from GOLD to GOLD_806_BALANCE
And s_weboh_twotask from GOLD to GOLD_BALANCE.

10.7.2 workflow

s_javamailer_reply_to from workflow.prod@visioncorp.com to workflow.gold@visioncorp.com
s_javamailer_imap_user from visioncorp\oraclework to visioncorp\oraclegold
s_smtphost from it-pwl-ows01 to pemco21


Need to create account on exchange server: PEMCO21 with account name: oraclegold and password: powelloracle (for all instances) with email address of workflow.gold@visioncorp.com

use webmail to check the account:

http://email.visioncorp.com
username: oraclegold
password:powelloracle

then OAM->workflow manager->service components->workflow notification mailer->edit->update password

then restart the workflow mailer.

10.7.3 Discoverer (10g, on separate node)
s_disco_machine from it-pwl-ows01.visioncorp.com to pind30.visioncorp.com
s_disco_port from 8080 to 7778

Need to create tnsnames.ora entry on pind30.

10.7.4 web tier load balancing

s_webentryhost=it-pwl-ows01
s_webentrydomain=visioncorp.com
s_webentryurlprotocol=http
s_active_webport=8080
s_login_page=http://it-pwl-ows01.visioncorp.com:8080/OA_HTML/US/ICXINDEX_GOLD_it-pwl-oas01.htm

10.7.5 update context_name_ifile.ora for concurrent processing tiers

GOLD_806_BALANCE=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=it-pwl-ods01-vip.visioncorp.com)(PORT=1601))
(CONNECT_DATA=
(SERVICE_NAME=GOLD)
(INSTANCE_NAME=GOLD1)
)
)
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=it-pwl-ods02-vip.visioncorp.com)(PORT=1601))
(CONNECT_DATA=
(SERVICE_NAME=GOLD)
(INSTANCE_NAME=GOLD2)
)
)
)

Update concurrent manager tier context file: s_cp_twotask from GOLD to GOLD_806_BALANCE in environment->tools_home

s_cp_twotask=GOLD_806_BALANCE



Environment->applsys: s_applcsf: update data to pcp

s_applcsf=/pcp/applmgr/common/admin
s_applptmp=/pcp/applmgr/common/temp
s_appltmp=/pcp/applmgr/common/temp

On web tier:

s_applcsf=/data/applmgr/common/admin
s_applptmp=usr/tmp
s_appltmp=data/applmgr/common/temp

Need to create directories (EDI etc) under /pcp/applmgr/common for new instance.


10.7.6 Modify template for MWATOP on web tier.
Cd $FND_TOP/admin/template
mkdir custom
Cp jserv_ux_ias1022.properties to custom
Change mwa entry to %s_mwatop%

10.7.7 database tier

Update s_dbService from GOLD to GOLD1 (changed back)

S_instLocalListener from LISTENER_GOLD1 to GOLD1_LOCAL
S_instRemoetListener from LISTENERS_GOLD to GOLD_REMOTE

Change default listener name
Cd /opt/oracle/product/10.2.0/GOLD/appsutil/template
Mkdir custom
Cp adlsnr10RAC.ora custom
Cd custom
Update _%s_dbhost% to _%s_dbSid%

10.8 clean clone setup

[~/scripts/clone]
oracle@it-pwl-ods02(GOLD2/DBTier):$ cat fnd_clone_clean.sql
-- must run autoconfig after this
--
EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;
EXIT;

10.9 Run autoconfig on all nodes
cd $ORACLE_HOME/appsutil/scripts/GOLD1_it-pwl-ods01

Run adautocfg.sh ods01, ods02, ods01, oas01, oas02, ows01, ows02, oas01,oas02,ows01

10.10 checking
Select node_name,server_id from fnd_nodes

Make sure all server_id got populated.

Bounced listener (for using listener_ and database for init.ora parameter _immediate_commit_propagation)

Grant debug connect session to apps;

11 apps post clone steps
11.1 create custom.env on all apps node in $APPL_TOP
11.2 start xvnc on oas01 and oas02. copy startvnc.sh from prod ccm tier and run it.
11.3 tomcat for unitask: port 8080 used. In /data/applmgr/11i/xxlpr/11.5.0/apache-tomcat-4.1.36/conf/server.xml file, update to 8081.
11.4 workflow mailer: need to create email account visioncorp\oraclegold
11.5 unitask license for new implementation. Check with George Burgos.
11.6 PIC UI license: run following query and send dbid info to Michael Kendrick


1 select host_name, global_name, dbid
2* from v$database, v$instance, global_name
SQL> /

HOST_NAME GLOBAL_NAME DBID
-------------------- -------------------- ----------
pind42.visioncorp.com PROD.VISIONCORP.COM 94528928

11.7 Update icx_parameters
Login as system
SQL> update icx_parameter set session_cookie_domain = “.visioncorp.com” where session_cookie_name = ‘gold’
11.8 Update gsmstart.sh for MRP
cd $STOP
vi gsmstart.sh
modify TWO_TASK = ‘GOLD’ – not load balanced.

Or modify template $FND_TOP/admin/template/gsmstart.sh.
Cd $FND_TOP/admin/template
Mkdir custom
Cp gsmstart.sh custom
Cd custom
Cp gsmstart.sh gsmstat.sh.orig
Vi gsmstart.sh, modify s_cp_twotask to s_dbSid.

11.9 change passwords
cd scripts/clone/GOLD

FNDCPASS apps/appsPROD 0 Y system/systemPROD SYSTEM APPLSYS newappspw
FNDCPASS apps/newappspw 0 Y system/systemPROD ALLORACLE newpass
FNDCPASS apps/newappspw 0 Y system/systemPROD ORACLE xx_custom newpass
FNDCPASS apps/newappspw 0 Y system/systemPROD USER SYSADMIN newsysadminpw

modify chg.sh
execute chg.sh
11.10 start mwa
11.11 scramble HR data (script takes awhile) (from ccm tier)
cd $HOME/scripts/scramble
sqlplus apps/apps @powl_scramble_data

due to html tag issue, replace "<" with "leftarrow" and ">" with "rightarrow"