How to clear Cache in R12/11i Apps


How to bounce Apache, clear HTML cache and have updated Java code class active in R12:-

To clear HTML cache and bounce Apache at R12 level.
First, go to the scripts directory of R12, as shown below:

[oracle@r0469 ~]$ cd /oracle/VIS/apps/apps_st/appl/
[oracle@r0469 appl]$ . APPSVIS_r0469.env
[oracle@r0469 appl]$ cd $ADMIN_SCRIPTS_HOME
[oracle@r0469 scripts]$ pwd
/oracle/VIS/inst/apps/VIS_r0469/admin/scripts

To clear HTML cache:

The pages directory under $COMMON_TOP should not be cleared for E-Biz R12,
which we used to do in 11i applications.
For clearing middle tier cache in R12, Navigate to
Login as sysadmin/sysadmin
Functional Administrator responsibility > Core Services > Caching Framework > Global Configuration > Clear cache
Bouncing apache or Application....

Instead of clearing the _pages, in R12 creates blank login page issue, as in R12 the jsp files does not get compiled automatically.
[oracle@r0469 ~]$ cd /oracle/VIS/inst/apps/VIS_r0469/admin/scripts

[oracle@r0469 scripts]$ ./adapcctl.sh stop


You are running adapcctl.sh version 120.7.12010000.2

Stopping OPMN managed Oracle HTTP Server (OHS) instance ...

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /oracle/VIS/inst/apps/VIS_r0469/logs/appl/admin/log/adapcctl.txt for more information ...

[oracle@r0469 scripts]$ ./adapcctl.sh start


You are running adapcctl.sh version 120.7.12010000.2

Starting OPMN managed Oracle HTTP Server (OHS) instance ...

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /oracle/VIS/inst/apps/VIS_r0469/logs/appl/admin/log/adapcctl.txt for more information ...

At R12 level bouncing apache command is different from the one to bounce oacore, oc4j engine and others.
In 11i the apache start and stop command, also bounce the JVM running on JSERV and clear caches by doings as below :

To clear the jsp & modplsql caches run this command:-

[oracle@r0469 ~]$ rm -rf $OA_HTML/_page/*
[oracle@r0469 ~]$ rm -rf $COMMON_TOP/_page/*
[oracle@r0469 ~]$ rm -rf $IAS_ORACLE_HOME/apache/modplsql/_page/*

But in R12 the command to stop and start apache only takes action on Apache web server and not on the OC4J container that executes the JVM.

To bounce the OC4J container there is a specific script:
$INST_TOP/admin/scripts/adoacorectl.sh
Therefore when making modification to JAVA class in R12 for the web application, in order to have that change recognized, it is needed to bounce OC4J using adoacorectl.sh script.

No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf&#...