12.2

12.2 An Introduction.

Oracle 12.2 has some major changes in terms file system and technology stack .usability improvements and new versions of technology stack components (Oracle Database 11g R2 and Oracle Fusion Middleware 11g R1 as the application server), but the most important and impressive new feature of course will be online patching. Online patching is supposed to change the game changer as Oracle says it.

Oracle plans for moving the application to next level of high availability, although not completely yet. With introduction to 2 file systems, online patching option, it has already started in that direction and with Weblogic in Tech Stack, it has scope for fail-over and clustering of application services.

Now with introduction of WebLogic in 12.2, Oracle is back to integration lines. Integration of fusion product with EBS now would be easier. We are going to see something in terms of ERP consolidation with this release, which means use of 12.2 EBS with fusion Middleware and Fusion Apps Products is going to have a good scope.

With introduction of “Edition Based Redefinition” in 11gr2, it is now possible to upgrade the database component of an application while it is in use, thereby minimizing or eliminating down time. Upgrade an application while it is in use, you copy the database objects that comprise the application and redefine the copied objects in isolation. Your changes do not affect users of the application—they continue to run the unchanged application. When you are sure that your changes are correct, you make the upgraded application available to all users.

Just to add more on online patching, although it can be reduced with various techniques (e.g. staged APPL_TOP), some downtime is still required to apply a number of changes. Online patching will not eliminate downtime completely, but will reduce it significantly by using “Edition Based Redefinition” (EBR) at the database level and using a secondary applications file system for online patching. In fact, all patching activity will be an online operation; downtime will be required only to switch from one version to another. Online Patching means that patches that change EBS database objects can be applied while the E-Business Suite production instance is fully operational.  Only a short downtime will be required to complete the patching process.  This wills make patching downtime's more predictable.

AutoConfig Search Utility

Sometime if we want to find out a variable to be changed in context file, but we dont know the exact name and the meaning of the variable then we can use autoconfig search utility. Search utility will ask for the keyword to be searched for and will generate the report based on the available variables contaning that search keyword. It will also give the description about the autoconfig variables, which is very useful.
Following is the way to use search utility
-bash-3.00$ perl $FND_TOP/bin/txkrun.pl -script=GenCtxInfRep -keyword=mwa -outfile=$OA_HTML/txkContext_Apps.html
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** Log File = /u01/apps/appmgr/inst/apps/az1mq206_rws60043rems/logs/appl/rgf/TXK/txkGenCtxInfRep_Wed_Jun_17_00_04_30_2009.log
Program : /u01/apps/appmgr/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkGenCtxInfRep.pl started @ Wed Jun 17 00:04:30 2009
*** Log File = /u01/apps/appmgr/inst/apps/az1mq206_rws60043rems/logs/appl/rgf/TXK/txkGenCtxInfRep_Wed_Jun_17_00_04_30_2009.log
The HTML report is generated in /u01/apps/appmgr/apps/apps_st/comn/webapps/oacore/html/txkContext_Apps.html
Program : /u01/apps/appmgr/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkGenCtxInfRep.pl completed @ Wed Jun 17 00:04:59 2009
End of /u01/apps/appmgr/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkGenCtxInfRep.pl : No Errors encountered
-bash-3.00$

Here I used the keyword as mwa and the report will give all variables having mwa as sub-string.And the Report would be some thing like this:


Technology Stack (TXK) AutoConfig Context Variable Report

Entered Keywords mwa
Matched Context Variables s_mwaPortNo, s_mwaTelnetPortNo, s_mwaDispatcherPort, s_mwaLogLevel, s_mwaLogRotate, s_mwaLogFileSize, s_mwaDropConnectionTimeout, s_mwaStaleSessionTimeout, s_mwaDispatcherThreadCount, s_mwaDispatcherClientsPerWorker, s_mwaJVMb, s_mwaActivateLOVByEnter, s_mwaSubmenuChangeOrgResp, s_mwatop, s_mwaname, s_mwastatus, s_mwalog, s_mwatimeout, s_mwactrl
Context Variable : s_mwaPortNo
Description MSCA Server Port Number
Current Value 10290-10295
Default Value 10200
The context variable is not found in any template under FND_TOP
The context variable is not found in any template under AD_TOP


Context Variable : s_mwaTelnetPortNo
Description MSCA Telnet Server Port Number
Current Value 10290,10292,10294
Default Value 10200
The context variable is not found in any template under FND_TOP
The context variable is not found in any template under AD_TOP


Context Variable : s_mwaDispatcherPort
Description MSCA Dispatcher Port Number
Current Value 10845
Default Value 10800
The context variable is not found in any template under FND_TOP
The context variable is not found in any template under AD_TOP


Context Variable : s_mwaLogLevel
Description MSCA Log Level. Different log levels can be set for obtaining more debug information.
Current Value error
Default Value error
The context variable is not found in any template under FND_TOP
The context variable is not found in any template under AD_TOP


Context Variable : s_mwaLogRotate
Description Enable log rotation of files based on size (Yes/No).
Current Value Yes
Default Value Yes
The context variable is not found in any template under FND_TOP
The context variable is not found in any template under AD_TOP


Context Variable : s_mwaLogFileSize
Description MSCA Log File Size. If log rotation is enabled, then rotation occurs when log file exceeds this size.
Current Value 10000000
Default Value 10000000
The context variable is not found in any template under FND_TOP
The context variable is not found in any template under AD_TOP


Context Variable : s_mwaDropConnectionTimeout
Description MSCA Drop Connection Timeout. MSCA Server allows a client that was disconnected to reconnect within the time mentioned below in minutes.
Current Value 5
Default Value 5
The context variable is not found in any template under FND_TOP
The context variable is not found in any template under AD_TOP


Context Variable : s_mwaStaleSessionTimeout
Description MSCA Stale Session Timeout. MSCA Server disconnects a client after the client is idle for mwa.StaleSessionTimeout minutes.
Current Value 60
Default Value 60
The context variable is not found in any template under FND_TOP
The context variable is not found in any template under AD_TOP


Context Variable : s_mwaDispatcherThreadCount
Description Specify number of worker threads to start from the dispatcher process
Current Value 15
Default Value 15
The context variable is not found in any template under FND_TOP
The context variable is not found in any template under AD_TOP


Context Variable : s_mwaDispatcherClientsPerWorker
Description Specify number of clients that each dispatcher worker thread can handle
Current Value 10
Default Value 10
The context variable is not found in any template under FND_TOP
The context variable is not found in any template under AD_TOP


Context Variable : s_mwaJVMb
Description MSCA Compatability Setting for JVM
Current Value FALSE
Default Value FALSE
The context variable is not found in any template under FND_TOP
The context variable is not found in any template under AD_TOP


Context Variable : s_mwaActivateLOVByEnter
Description Used to specify whether user would like to retain old LOV behavior, i.e. LOV will be activated by ENTER or not
Current Value FALSE
Default Value FALSE
The context variable is not found in any template under FND_TOP
The context variable is not found in any template under AD_TOP


Context Variable : s_mwaSubmenuChangeOrgResp
Description Specifies whether Change Responsibility and Change Organization menu items should appear on submenus; if TRUE, then these menu items will appear on the main menu and submenus; if FALSE, then these menu items will only appear on the main menu; the default value is FALSE.
Current Value FALSE
Default Value FALSE
The context variable is not found in any template under FND_TOP
The context variable is not found in any template under AD_TOP


Context Variable : s_mwatop
Description Location of Product Top for MWA
Current Value /u01/apps/appmgr/apps/apps_st/appl/mwa/12.0.0
Default Value %s_at3%%/%mwa%/%12.0.0
The context variable is found in the following templates under FND_TOP
Template Configuration Directive
oc4j_properties_1013.tmp oracle.apps.mwa=%s_mwatop%
The context variable is not found in any template under AD_TOP


Context Variable : s_mwaname
Description Instance Specific Name of the 'Oracle MWA' Service.
Current Value Oracle MWA Service az1mq206_rws60043rems
Default Value Oracle MWA Service %s_contextname%
The context variable is not found in any template under FND_TOP
The context variable is not found in any template under AD_TOP


Context Variable : s_mwastatus
Description Status of the 'Oracle MWA' service. Can be 'enabled' or 'disabled'. The default value is 'disabled'.
Current Value enabled
Default Value disabled
The context variable is not found in any template under FND_TOP
The context variable is not found in any template under AD_TOP


Context Variable : s_mwalog
Description Complete path to the Log File for the 'Oracle MWA' Service.
Current Value /u01/apps/appmgr/inst/apps/az1mq206_rws60043rems/logs/appl/admin/log/mwactl.txt
Default Value %s_logs_dir%%/%appl%/%admin%/%log%/%mwactl.txt
The context variable is not found in any template under FND_TOP
The context variable is not found in any template under AD_TOP


Context Variable : s_mwatimeout
Description Timeout for the 'ORACLE MWA' Service in seconds.
Current Value 100
Default Value 100
The context variable is not found in any template under FND_TOP
The context variable is not found in any template under AD_TOP


Context Variable : s_mwactrl
Description Name of the script that controls the 'Oracle MWA' Service.
Current Value /u01/apps/appmgr/inst/apps/az1mq206_rws60043rems/admin/scripts/mwactlwrpr.sh
Default Value %s_config_home%\admin\scripts\mwactlwrpr.cmd
The context variable is not found in any template under FND_TOP
The context variable is not found in any template under AD_TOP