Monday, 2 July 2012


Clear presentation cache auto script

  • OBIEE 11G has a catalog manager command called “ClearQueryCache” to clear out the PS cache.
  • The syntax of ClearQueryCache command is: 
    runcat.cmd/ -cmd clearQueryCache  -online <OBIPS URL> -credentials <credentials properties file>
  • Create a catalog manager credential properties file. Open a text file and type the following entries.
              Login = <weblogic_admin_Username>
              Pwd = <weblogic_Admin_Userpassword>  
    And save in a directory with the file name as
  • Now open command prompt and navigate to <MW_HOME>instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalogmanager\
  • And Run the following command to clear OBIPS query cache:
    runcat.cmd -cmd clearQueryCache -online http://host:9704/analytics/saw.dll -credentials E:\

About Authors

Shahed Munir

Krishna Udathu

Shahed and Krishna are Oracle / Big Data Experts