Friday, December 27, 2013

Clearing Cache in R12 instance


1- Stop Apache --- adapcctl.sh stopall

2- Clear cache  cd $COMMON_TOP/-----remove _pages  and create _pages

mkdir _pages
chmod 777 _pages

3-  cd $FND_TOP/patch/115/bin


$ ./ojspCompile.pl --compile --flush -p 2
logfile set: /test/mtlog/test_localhost/logs/appl/rgf/ojsp/ojspc_error.log
starting...(compiling all)
using 10i internal ojsp ver: 10
synchronizing dependency file:
enumerating jsps...8001
parsing jsp...8001
writing deplist...8001
initializing compilation:
eliminating children...5912 (-2089)
translating and compiling:
translating jsps...5912/5912 in 4m39s                
compiling jsps...5912/5912 in 17m30s                
Finished!
$

4- Start Apache -- adapcctl.sh startall

Compiling single jsp

ojspCompile.pl --compile -s 'fnd%' -p 20


How to clear cache for a specific component in R12

As we all know the normal tendency for clearing cache in Oracle Apps is to delete the $COMMON_TOP/_pages directory.In 11i, after deleting we dont have to recompile the jsps but in R12 we have to recompile the pages since s_jsp_main_mode is set to justrun by default which is in turn updated in orion-web.xml

How can i clear cache for a specific component of Oracle Apps R12 viz., iprocurement, istore etc.,
Is this even possible ? Yes it is and this option comes handy when somebody modifies a jsp page which is part of say istore,then it makes sense to clear cache for istore and not for the whole server.

Clearing cache for specific Component/Application in R12

Login as sysadmin
Select Functional Administrator responsibility
Go to Core Services ==> Caching Framework ==> Tuning
Query the application (for example iStore) or by Name or code.
Select the component and clear the cache.

Note: For some specific configuration changes, we need to bounce Apache also.

Clearing Global Cache in R12

a) Go to Functional Administrator Responsibility
b) Go to Core Services ==> Caching Framework
c) Go to Global configuration and clear all the cache from there.(Only If you want to clear all the  cache)


For further reading:
http://applicationsdba.blogspot.in/2008/01/r12-beware-executing-rm-rf.html
http://www.pythian.com/blog/jsp-cache-issues-in-11i-and-r12/