Sunday, December 6, 2009

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.