Rolling Back an AutoConfig Session.

Rolling Back an AutoConfig Session

1)The database server and the database listener must be up and running  during the AutoConfig run.
 Only the application tier services should be down.

2)Each AutoConfig run  creates a rollback script you can use to revert to the previous configuration settings if necessary.
The script and all backup configuration files from each AutoConfig session are stored in below location.
 i)Database Tier $RDBMS_ORACLE_HOME/appsutil/out/MMDDhhmm
 ii)Application Tier $INST_TOP/admin/out/MMDDhhmm

3)To roll back an AutoConfig session, execute---

restore.sh


Scenario: in previous example i have change the $APPLCSF/$APPLLOG file location and now i am reverting the previous setting.

1)Current concurret manager logfile location
[applmgr@apps 03081544]$ cd $APPLCSF/$APPLLOG
[applmgr@apps log]$ pwd
/u02/inst/log
[applmgr@apps log]$

2)last time i have ran autoconfig on 8 march and today is 13 march.

[applmgr@apps log]$ cd $INST_TOP/admin/out
[applmgr@apps out]$ pwd
/u02/inst/apps/PROD_apps/admin/out
[applmgr@apps out]$ ls -tlrh
total 36K
drwxr-xr-x  2 applmgr dba 4.0K Mar  1 18:19 03011819
drwxr-xr-x  2 applmgr dba 4.0K Mar  1 18:31 03011831
drwxr-xr-x  2 applmgr dba 4.0K Mar  1 19:17 03011908
drwxr-xr-x  2 applmgr dba  12K Mar  1 19:40 03011917
drwxr-xr-x  2 applmgr dba  12K Mar  8 15:49 03081544
[applmgr@apps out]$

[applmgr@apps 03081544]$ ls -tlrh /u02/inst/apps/PROD_apps/admin/out/03081544/restore.sh
-rwxr-xr-x  1 applmgr dba 25K Mar  8 15:49 /u02/inst/apps/PROD_apps/admin/out/03081544/restore.sh
[applmgr@apps 03081544]$

3)Make sure application services must be down.use below command to check whether any process is running or not.

[applmgr@apps 03081544]$ ps -fu applmgr
UID        PID  PPID  C STIME TTY          TIME CMD
applmgr  26737 26736  0 18:03 pts/1    00:00:00 -bash
applmgr  26968 26737  0 18:18 pts/1    00:00:00 ps -fu applmgr
[applmgr@apps 03081544]$

4)when you run restore.sh script it will prompt for apps password.

[applmgr@apps 03081544]$ sh restore.sh

SQL*Plus: Release 10.1.0.5.0 - Production on Wed Mar 13 18:27:27 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter apps password

Connected.
[ GWYUID ]
Application Id : 0
Profile Value  : APPLSYSPUB/PUB
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ APPS_DATABASE_ID ]
Application Id : 0
Profile Value  : PROD
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ ICX_DEFAULT_EUL ]
Application Id : 178
Profile Value  : EUL
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ TWO_TASK ]
Application Id : 0
Profile Value  : PRDXBLD9
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ PRINTER ]
Application Id : 0
Profile Value  : noprint
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ ICX_LANGUAGE ]
Application Id : 178
Profile Value  : AMERICAN
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ ICX_TERRITORY ]
Application Id : 178
Profile Value  : AMERICA
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ CONC_GSM_ENABLED ]
Application Id : 0
Profile Value  : Y
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ APPS_WEB_AGENT ]
Application Id : 0
Profile Value  : http://ap6006ebo.us.oracle.com:3010/pls/PRDXBLD9
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ APPS_SERVLET_AGENT ]
Application Id : 0
Profile Value  : http://ap6006ebo.us.oracle.com:3010/OA_HTML
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ APPS_JSP_AGENT ]
Application Id : 0
Profile Value  : http://ap6006ebo.us.oracle.com:3010
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ APPS_FRAMEWORK_AGENT ]
Application Id : 0
Profile Value  : http://ap6006ebo.us.oracle.com:3010
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ HELP_WEB_AGENT ]
Application Id : 0
Profile Value  : null
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ HELP_WEB_BASE_URL ]
Application Id : 0
Profile Value  : http://ap6006ebo.us.oracle.com:3010/OA_HTML/
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ ICX_FORMS_LAUNCHER ]
Application Id : 178
Profile Value  : http://ap6006ebo.us.oracle.com:3010/forms/frmservlet
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ ICX_DISCOVERER_LAUNCHER ]
Application Id : 178
Profile Value  : /discoverer/plus?Connect=[APPS_SECURE]
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ ICX_DISCOVERER_VIEWER_LAUNCHER ]
Application Id : 178
Profile Value  : /discoverer/viewer?Connect=[APPS_SECURE]
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ IES_SCRIPTING_SID ]
Application Id : 519
Profile Value  : PRDXBLD9
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ APPS_PORTAL ]
Application Id : 0
Profile Value  : null
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ CZ_UIMGR_URL ]
Application Id : 702
Profile Value  :
http://ap6006ebo.us.oracle.com:3010/OA_HTML/configurator/UiServlet
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ ICX_CLIENT_IANA_ENCODING ]
Application Id : 178
Profile Value  : US-ASCII
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ WEB_PROXY_HOST ]
Application Id : 0
Profile Value  : null
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ WEB_PROXY_PORT ]
Application Id : 0
Profile Value  : null
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ WEB_PROXY_BYPASS_DOMAINS ]
Application Id : 0
Profile Value  : us.oracle.com
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ TCF:PORT ]
Application Id : 0
Profile Value  : -1
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ TCF:HOST ]
Application Id : 0
Profile Value  : http://ap6006ebo.us.oracle.com:3010/OA_HTML
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ QP_PRICING_ENGINE_URL ]
Application Id : 661
Profile Value  : http://ap6006ebo.us.oracle.com:3010/OA_HTML/pricing
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ JTF_DIST_CACHE_PORT ]
Application Id : 690
Profile Value  : 12456
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ FND_CACHE_PORT_RANGE ]
Application Id : 0
Profile Value  : null
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ ICX_SESSION_TIMEOUT ]
Application Id : 178
Profile Value  : 30
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ POR_CACERT_FILE_NAME ]
Application Id : 178
Profile Value  :
/nfs/bld/d26/PRDXBLD9/apps/tech_st/10.1.2/sysman/config/b64InternetCertificate.t
xt
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ POR_PROXY_SERVER_NAME ]
Application Id : 178
Profile Value  : null
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ POR_PROXY_SERVER_PORT ]
Application Id : 178
Profile Value  : null
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ EDW_LOGFILE_DIR ]
Application Id : 191
Profile Value  : /usr/tmp
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ AMS_IMP_CTL_PATH ]
Application Id : 530
Profile Value  : /nfs/bld/d26/PRDXBLD9/apps/apps_st/appl/ams/12.0.0/bin/
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ AMS_IMP_DATA_PATH ]
Application Id : 530
Profile Value  :
/nfs/bld/d26/PRDXBLD9/inst/apps/PRDXBLD9_ap6006ebo/logs/appl/conc/inbound/PRDXBL
D9_ap6006ebo/
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ AMS_SERVER_URL ]
Application Id : 530
Profile Value  : http://ap6006ebo.us.oracle.com:3010
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ WSH_DEBUG_LOG_DIRECTORY ]
Application Id : 665
Profile Value  : /usr/tmp
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ CLN_DEBUG_LOG_DIRECTORY ]
Application Id : 701
Profile Value  : /usr/tmp
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ OKS_SMTP_DOMAIN ]
Application Id : 515
Profile Value  : us.oracle.com
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ OKS_SMTP_HOST ]
Application Id : 515
Profile Value  : ap6006ebo
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ CSF_EMAP_RMI_HOST ]
Application Id : 513
Profile Value  : http://ap6006ebo.us.oracle.com:3010/mapviewer/omserver
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ IBY_ECAPP_URL ]
Application Id : 673
Profile Value  : http://ap6006ebo.us.oracle.com:3010/OA_HTML/ibyecapp
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ ICX_PAY_SERVER ]
Application Id : 673
Profile Value  : null
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ IBY_XML_TEMP ]
Application Id : 673
Profile Value  : /nfs/bld/d22/AB/temp
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ IBY_HTTP_PROXY ]
Application Id : 673
Profile Value  : http://:
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ IBY_NOPROXY_DOMAIN ]
Application Id : 673
Profile Value  : us.oracle.com
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ IBY_XML_BASE ]
Application Id : 673
Profile Value  : /nfs/bld/d26/PRDXBLD9/apps/apps_st/appl/iby/12.0.0/xml
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ CN_IMP_SERVER_PATH ]
Application Id : 283
Profile Value  :
/nfs/bld/d26/PRDXBLD9/inst/apps/PRDXBLD9_ap6006ebo/logs/appl/conc/inbound/PRDXBL
D9_ap6006ebo/
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ CN_IMP_CONTROL_PATH ]
Application Id : 283
Profile Value  : /nfs/bld/d26/PRDXBLD9/apps/apps_st/appl/cn/12.0.0/bin/
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ CSI_LOGFILE_PATH ]
Application Id : 542
Profile Value  : /usr/tmp
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ CSE_DEBUG_LOG_DIRECTORY ]
Application Id : 873
Profile Value  : /usr/tmp
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ EAM_PM_DEBUG_FILE ]
Application Id : 426
Profile Value  : /usr/tmp\eampmeng.log
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ EAM_ABO_DEBUG_DIR_FILE ]
Application Id : 426
Profile Value  : /usr/tmp/eam_abo.log
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ EAM_MOI_LOG_DIR_FILE ]
Application Id : 426
Profile Value  : /usr/tmp/eam_moi.log
Level Name: SITE
INFO           : Updated/created profile option value.
.
[ FTE_PRC_DEBUG_LOG_DIR ]
Application Id : 716
Profile Value  : /usr/tmp
Level Name: SITE
INFO           : Updated/created profile option value.
.

PL/SQL procedure successfully completed.


56 rows deleted.


Commit complete.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


source env
==========

[applmgr@apps appl]$ ls -tlrh APPS*.env
-rw-r--r--  1 applmgr dba 999 Mar 13 18:27 APPSPROD_apps.env
[applmgr@apps appl]$ . ./APPSPROD_apps.env

[applmgr@apps appl]$ echo $APPLCSF/$APPLLOG
/u02/inst/apps/PROD_apps/logs/appl/conc/log
[applmgr@apps appl]$

autconfig rollback session completes sucessfully.