Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

obiee 12c cache purge

Received Response
11
Views
3
Comments
Rank 5 - Community Champion

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • 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.

  • Rank 5 - Community Champion

    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

  • Rank 10 - Analytics Guru

    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" >>

Welcome!

It looks like you're new here. Sign in or register to get started.