Autoconfig steps in ecsprod

BEFORE AUTOCONFIG

Internal and External Nodes

· Save context files
· cp $TNS_ADMIN/tnsnames.ora $TNS_ADMIN/tnsnames.ora.preauto
· cp $FND_SECURE/ecsprod.dbc $FND_SECURE/ecsprod.dbc.preauto
· Save jserv.properties and zone.properties
· Add xml entry for smtp host if it is not done already.
· Commentout cron jobs on rh132 and rh133

Internal Nodes

· cp $OA_HTML/bin/appsweb_$CONTEXT_NAME.cfg $OA_HTML/bin/appsweb_$CONTEXT_NAME.cfg.preauto
· cp $COMMON_TOP/admin/scripts/$CONTEXT_NAME/adfrmctl.sh $COMMON_TOP/admin/scripts/$CONTEXT_NAME/adfrmctl.sh.preauto
(this is needed because the DIRTMP environment variable is customized and cannot be set in the context file)


External Nodes

· cp $IAS_CONFIG_HOME/Apache/Apache/conf/url_fw.conf $IAS_CONFIG_HOME/Apache/Apache/conf/url_fw.conf.preauto


Database

· Rename workflow tables and create temporary workflow tables from the original workflow tables.



AFTER AUTOCONFIG

Internal and External Nodes

· Take out the entries created for the database services from the tnsnames.ora file – they already exist in the include file


Internal Nodes

· put back the Markview entries in the .cfg files - this step should be eliminated with Begin/End Customization or some other methodology - in all environments we should have .cfg.170 files that include the Markview entries and are not overwritten by autoconfig
· make sure "ICX: Forms Launcher" has "?config=170systems" appended to the end for Site Level and all the internal server level- this step will be eliminated as well - John has the solution
· create new _reporting.dbc DBC file from $FND_SECURE similar to DBC file used for discoverer (check with Matt) - this should use the _reporting service
· send _reporting.dbc to the Discoverer admins (Jason Dimmer) + Discoverer middle tier admins (Krishnan)
· fix CITRIX ADI by putting in the new server ID form the DBC file - once this is done inform Skip and he will propagate the change to all users
· make sure the workflow configurations are were not lost – recreate them if they were
· make sure that in the file $COMMON_TOP/admin/scripts/$CONTEXT_NAME/adfrmctl.sh the environment variable DIRTMP is set to the pre-autoconfig value


External Nodes

· jdbc entry in the .dbc file should use the external service

APPS_JDBC_URL=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=usmliu112-vip.arrow.com)(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=usmliu111-vip.arrow.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ecsprod_external)))
· Copy jserv.properties from backup for double-click fix.
· Replace this section from the $IAS_CONFIG_HOME/Apache/Apache/conf/url_fw.conf

#======================================================================
#Include URLs for product OIR (iReceivables)
#======================================================================

#RewriteRule ^/OA_HTML/AnonymousLogin\.jsp$ - [L]
#RewriteRule ^/OA_HTML/SelfRegistration\.jsp$ - [L]

WITH:

#======================================================================
#Include URLs for product OIR (iReceivables)
#======================================================================

RewriteRule ^/OA_HTML/AnonymousLogin\.jsp$ - [L]
RewriteRule ^/OA_HTML/SelfRegistration\.jsp$ - [L]
RewriteRule ^/OA_CGI/FNDWRR\.exe$ - [L]

· Prepare new DBC file for reporting with the reporting service if needed – follow the above example and use ecsprod_reporting instead of ecsprod_external.
· Fix broken link between GFS and Ascent if we change the apps password.


Database

· Rename backup copy of workflow tables to actual names.