obiee 12c cache purge

Question

Hi All, Can you please provide some insight on how to purge cache automatically in OBIEE 12C in Linux environment? ------------ Thanks Raj

[Deleted User] · Answer

nqcmd.sh *IS* on .../user_projects/domains/THISISYOURDOMAINNAME/bi/bitools/bin Have you checked whether it's there and your path is correct? Takes half a second to run << find /YOURFMWHOME -name "nqcmd.sh" >>

7688438 · Answer

Ceresa, Thanks for your inputs.we decided to go with cron tab. It seems in OBIEE 12C the below commands changed.It is not like in 11g. app/oracle/biee/user_projects/domains/bi/bitools/bin/nqcmd.sh -d AnalyticsWeb -u weblogic -p XXXXXXXX Can you provide the correct paths and approaches wit nqcmd.sh method to purge the cache. Thanks R

Gianni Ceresa · Answer

Hi,

https://docs.oracle.com/middleware/1221/biee/BIESG/querycaching.htm#BIESG253

You can use agents, use your ETL process, use crontab.

All these options allow you to schedule the jobs and make it automatically based on your strategy.

So depends on what cache management strategy you decide to adopt.