HOW TO CLEAR CACHE IN R12 / 11i

R12

ORACLE R12 : SIMPLE STEPS HOW TO CLEAR CACHE 

First we have to check no user connected to application then follow

select count(distinct d.user_name) from apps.fnd_logins a,
v$session b, v$process c, apps.fnd_user d
where b.paddr = c.addr
and a.pid=c.pid
and a.spid = b.process
and d.user_id = a.user_id
and (d.user_name = 'USER_NAME' OR 1=1);

login sysadmin >
         then goto system navigation >
            logging functional administrator responsibility >
         core services  >
                 caching core service >
global services >
clear all caches



Suppose you don't have permission to logging functional administrator , then

HOW TO CLEAR CACHE IN R12 WITHOUT FUNCTIONAL RESPONSIBILITY  

1.Method

1.            ./adopmnctl.sh stopall

2.            wait for command to complete

3.            ./adopmnctl.sh status -l

4.            cd $COMMON_TOP/_pages

5.            ls -l|wc -l (note it down)

6.            rm -rf * (to remove all files)
Note:- For step 4 to 6, better to take backup of _pages by renaming it, and create a new directory as _pages at the same place.

7.            ls -l|wc -l (it should be 0 now)

8.            cd $FND_TOP/patch/115/bin

9.            which perl (should come from $IAS_ORACLE_HOME/perl/bin)

10.          ojspCompile.pl --compile --flush -p 10 (to compile all JSPs,-p is for parallel and value (i.e. 10 here) can be varied according to your server)

11.          wait for successful completion

12.          cd $COMMON_TOP/_pages

13.          ls -l| wc -l (check whether count is same or more than before (pre-remove) - sometimes a little difference may be there)

14.          Go to $ADMIN_SCRIPTS_HOME again

15.          ./adopmnctl.sh startall

16.          wait for proper services startup

17.          ./adopmnctl.sh status -l

18.          check front-end and JSPs and FORMs should open up fine

NOTE: If you cleared/delete the _pages method as used in 11i accidentally,

.run ojspcompile.pl.

The ojspcompile.pl perl script to perform a manual pre-compilation of the JSP pages. The following command will compile all the JSP pages and build up the JSP cache again.

cd $FND_TOP/patch/115/bin

perl ojspCompile.pl --compile --flush -p 2

 or


2. Best way to clear cache modify context file parameter file
    s_jsp_main_mode default value is justrun , simple change to recompile
   "s_jsp_main_mode" value to recompile

    jsp pages automatic recompile after modify s_jsp_main_mode


11i

HOW TO CLEAR CACHE IN ORACLE 11i

previously it done by $COMMON_TOP/_pages and delete all files 

1. stop Apache - adapcctl.sh stop apps/***

2. goto $comman_top/_pages 

3. delete - $rm -rf *.*       # else rename the directory _pages_bak and create new directory as same name

4. start apache - adapcctl.sh start apps/***

In 11i Jps pages automatic compile , here jserv handle jsp pages but in R12 it taken care by OC4J , if directly clear _pages you will get blank screen issue , so it recommended when ever clear cache always complie jsp manually

$FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 2 

COMMON ISSUE : BLANK LOGGING PAGES  

Error:

javax.servlet.ServletException: oracle.classloader.util.AnnotatedClassNotFoundException: Missing class: _AppsLocalLogin

Solution:

1. shut down application services

2. compile jsp manually

3. Restart application services

4. clear browser cache

5. Try to logging pages