Oracle & MySQL Support

InfraStack-Labs Oracle & MySQL DBA Services help you manage, maintain, and optimize your critical Oracle systems. We deliver 24/7, year-round support with flexible monthly contracts that don’t lock you in.

Please contact me :- ajith.narayanan@infrastack-labs.in

Thursday, September 6, 2012

Oracle Apps R12 -Identify the configuration file for a parameter change in CONTEXT_FILE

Note:- This note describes the direct changes done on context_file and its corresponding configuration file, This example should only be tried by experienced APPS dba's.

Scenario:- I had to change the oacore JVM size in context_file and its corresponding config file, I took the backup of context_file and changed the oacore JVM size as required, but how do we identify the actual config file that needs a change.( Autoconfig would do this for you, But another script for checking helps you to directly identify the relevant config file - ;) a short cut)

1) Make a backup of context_file and make the changes of parameter as required(In my case oacore JVM size is increased from 512M to 768M)

2) Now run the script adchkcfg.sh script to identofy the relevant config file that needs to be changed

$ echo $CONTEXT_FILE


/u01/app/gebs/ajithlab.local/inst/AJITHLAB_ajithR12host15/appl/admin/AJITHLAB_ajithR12host15.xml

[applmgr@ajithR12host15.us.dell.com:/u01/app/gebs/ajithlab/apps_st/appl/ad/12.0.0/bin][AJITHLAB_FORMS]

$ cd $AD_TOP/bin
$ ./adchkcfg.sh

Enter the full path to the Applications Context file:

/u01/app/gebs/ajithlab.local/inst/AJITHLAB_ajithR12host15/appl/admin/AJITHLAB_ajithR12host15.xml

Enter the APPS password:



The log file for this session is located at: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/log/09061142/adconfig.log



AutoConfig is running in test mode and building diffs...



AutoConfig will consider the custom templates if present.

Using CONFIG_HOME location : /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15

Classpath : /u01/app/gebs/ajithlab/apps_st/comn/java/lib/appsborg2.zip:/u01/app/gebs/ajithlab/apps_st/comn/java/classes



Using Context file : /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/AJITHLAB_ajithR12host15.xml



Context Value Management will now update the test Context file



Updating test Context file...COMPLETED



[ Test mode ]

No uploading of Context File and its templates to database.



Testing templates from all of the product tops...



Testing templates from all of the product tops...

Testing AD_TOP........COMPLETED

Testing FND_TOP.......COMPLETED

Testing ICX_TOP.......COMPLETED

Testing MSC_TOP.......COMPLETED

Testing IEO_TOP.......COMPLETED

Testing BIS_TOP.......COMPLETED

Testing AMS_TOP.......COMPLETED

Testing CCT_TOP.......COMPLETED

Testing WSH_TOP.......COMPLETED

Testing CLN_TOP.......COMPLETED

Testing OKE_TOP.......COMPLETED

Testing OKL_TOP.......COMPLETED

Testing OKS_TOP.......COMPLETED

Testing CSF_TOP.......COMPLETED

Testing IGS_TOP.......COMPLETED

Testing IBY_TOP.......COMPLETED

Testing JTF_TOP.......COMPLETED

Testing MWA_TOP.......COMPLETED

Testing CN_TOP........COMPLETED

Testing CSI_TOP.......COMPLETED

Testing WIP_TOP.......COMPLETED

Testing CSE_TOP.......COMPLETED

Testing EAM_TOP.......COMPLETED

Testing FTE_TOP.......COMPLETED

Testing ONT_TOP.......COMPLETED

Testing AR_TOP........COMPLETED

Testing AHL_TOP.......COMPLETED

Testing OZF_TOP.......COMPLETED

Testing IES_TOP.......COMPLETED

Testing CSD_TOP.......COMPLETED

Testing IGC_TOP.......COMPLETED



Differences text report is located at: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/cfgcheck.txt



Generating Profile Option differences report...COMPLETED

Differences text report for the Database is located at: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/ProfileReport.txt

Generating File System differences report......COMPLETED

Differences html report is located at: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/cfgcheck.html



Differences Zip report is located at: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/ADXcfgcheck.zip



AutoConfig completed successfully.

[applmgr@ajithR12host15.us.dell.com:/u01/app/gebs/ajithlab/apps_st/appl/ad/12.0.0/bin][AJITHLAB_FORMS]





3) Now check the cfgcheck.txt , to identify the relevant config files that needs to be changed.
One such file identified is (/u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/ora/10.1.3/opmn/conf/opmn.xml)

$ cat /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/cfgcheck.txt



Driver: /u01/app/gebs/ajithlab/apps_st/appl/ad/12.0.0/admin/driver/adtmpl.drv



Configuration File Changes

==========================



[CHANGED]

Existing file: /u01/app/gebs/ajithlab/apps_st/appl/admin/adconfig.txt

New file: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/adconfig.txt

Diff file: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/x_adconfig.txt



Existing file: /u01/app/gebs/ajithlab/apps_st/appl/admin/AJITHLAB/adalldefaults.txt

New file: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/adalldefaults.txt

Diff file: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/x_adalldefaults.txt



Existing file: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/ora/10.1.3/j2ee/oacore/config/server.xml

New file: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/server.xml

Diff file: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/x_server.xml



Existing file: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/ora/10.1.3/j2ee/oacore/application-deployments/oacore/html/oracle-webservices.xml

New file: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/oracle-webservices.xml

Diff file: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/x_oracle-webservices.xml



Existing file: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/ora/10.1.3/opmn/conf/opmn.xml

New file: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/opmn.xml

Diff file: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/x_opmn.xml



TEMPLATE CUSTOMIZATIONS

=======================



Template: /u01/app/gebs/ajithlab/apps_st/appl/ad/12.0.0/admin/template/iAS_1012_env.tmp

Custom Template: /u01/app/gebs/ajithlab/apps_st/appl/ad/12.0.0/admin/template/custom/iAS_1012_env.tmp

Diff File: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/xt_iAS_1012_env.tmp



Template: /u01/app/gebs/ajithlab/apps_st/appl/ad/12.0.0/admin/template/adovars_ux.env

Custom Template: /u01/app/gebs/ajithlab/apps_st/appl/ad/12.0.0/admin/template/custom/adovars_ux.env

Diff File: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/xt_adovars_ux.env



Template: /u01/app/gebs/ajithlab/apps_st/appl/ad/12.0.0/admin/template/adovars_ux.env

Custom Template: /u01/app/gebs/ajithlab/apps_st/appl/ad/12.0.0/admin/template/custom/adovars_ux.env

Diff File: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/xt_adovars_ux0.env



Template: /u01/app/gebs/ajithlab/apps_st/appl/ad/12.0.0/admin/template/APPLSYS_ux.env

Custom Template: /u01/app/gebs/ajithlab/apps_st/appl/ad/12.0.0/admin/template/custom/APPLSYS_ux.env

Diff File: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/xt_APPLSYS_ux.env



Template: /u01/app/gebs/ajithlab/apps_st/appl/fnd/12.0.0/admin/template/orion_web_xml_1013.tmp

Custom Template: /u01/app/gebs/ajithlab/apps_st/appl/fnd/12.0.0/admin/template/custom/orion_web_xml_1013.tmp

Diff File: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/xt_orion_web_xml_1013.tmp



Template: /u01/app/gebs/ajithlab/apps_st/appl/fnd/12.0.0/admin/template/txkGenDefaultEnv.tmp

Custom Template: /u01/app/gebs/ajithlab/apps_st/appl/fnd/12.0.0/admin/template/custom/txkGenDefaultEnv.tmp

Diff File: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/xt_txkGenDefaultEnv.tmp



Template: /u01/app/gebs/ajithlab/apps_st/appl/fnd/12.0.0/admin/template/oc4j_properties_1013.tmp

Custom Template: /u01/app/gebs/ajithlab/apps_st/appl/fnd/12.0.0/admin/template/custom/oc4j_properties_1013.tmp

Diff File: /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/xt_oc4j_properties_1013.tmp



[applmgr@ajithR12host15.us.dell.com:/u01/app/gebs/ajithlab/apps_st/appl/ad/12.0.0/bin][AJITHLAB_FORMS]


4) Open the diff file and check for the differences

$ cat /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/x_opmn.xml


Checking differences between

Existing file(<) : /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/ora/10.1.3/opmn/conf/opmn.xml

New file(>) : /u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/admin/out/09061142/opmn.xml



===========================================================================

Differences

===========================================================================

114c114

<  data id="java-options" value="-server -verbose:gc -Xmx512M -Xms128M -XX:MaxPermSize=160M -XX:NewRatio=2 -XX:+PrintGCTimeStamps -XX:+UseTLAB -XX:+UseParallelGC -XX:ParallelGCThreads=2 -Dcom.sun.management.jmxremote -Djava.security.policy=$ORACLE_HOME/j2ee/oacore/config/java2.policy -Djava.awt.headless=true -Dhttp.webdir.enable=false -Doracle.security.jazn.config=/u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/ora/10.1.3/j2ee/oacore/config/jazn.xml -Dhttp.cookie.ignoreCommaInCookiesNamed=X_NoMatchingCookies"

-----

> data id="java-options" value="-server -verbose:gc -Xmx768M -Xms512M -XX:MaxPermSize=160M -XX:NewRatio=2 -XX:+PrintGCTimeStamps -XX:+UseTLAB -XX:+UseParallelGC -XX:ParallelGCThreads=2 -Dcom.sun.management.jmxremote -Djava.security.policy=$ORACLE_HOME/j2ee/oacore/config/java2.policy -Djava.awt.headless=true -Dhttp.webdir.enable=false -Doracle.security.jazn.config=/u01/app/gebs/ajithlab.local/apps/AJITHLAB_ajithR12host15/ora/10.1.3/j2ee/oacore/config/jazn.xml -Dhttp.cookie.ignoreCommaInCookiesNamed=X_NoMatchingCookies"

119c119

data id="java-options" value="-server -verbose:gc -Xmx512M -Xms128M -XX:MaxPermSize=160M -XX:NewRatio=2 -XX:+PrintGCTimeStamps -XX:+UseTLAB -XX:+UseParallelGC -XX:ParallelGCThreads=2 -Djava.security.policy=$ORACLE_HOME/j2ee/oacore/config/java2.policy -Djava.awt.headless=true -Dhttp.webdir.enable=false"

-----

data id="java-options" value="-server -verbose:gc -Xmx768M -Xms512M -XX:MaxPermSize=160M -XX:NewRatio=2 -XX:+PrintGCTimeStamps -XX:+UseTLAB -XX:+UseParallelGC -XX:ParallelGCThreads=2 -Djava.security.policy=$ORACLE_HOME/j2ee/oacore/config/java2.policy -Djava.awt.headless=true -Dhttp.webdir.enable=false"

[applmgr@ajithR12host15.us.dell.com:/u01/app/gebs/ajithlab/apps_st/appl/ad/12.0.0/bin][AJITHLAB_FORMS]

$

    HAPPY LEARNING !


No comments:

Post a Comment

Thanks for you valuable comments !