Categories
Blog

Automate the purging of the repository cache (Exalytics Linux)

So we have created a ram disk and you are now storing the repository cache, how can we automate the purging.
1.  First we will create a file that we can run that will 1st load the BI environment, then we will clear the cache :
–          Create a file called purge.txt with the following contents:
Call SAPurgeAllCache();
–          Create a file called purge.sh with the following contents
cd /u01/app/oracle/product/fmw/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup
. ./bi-init.sh
cd /u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin
./nqcmd -d “AnalyticsWeb” -uweblogic –p<place the password here> -s/home/oracle/TT_INSTALLERS/purge.txt
 
2. Update crontab to execute the file everyday:
00 23 * * * /home/oracle/TT_INSTALLERS/purge.sh > /home/oracle/TT_INSTALLERS/purged.log 2>&1
You now have automated purging of your cache.