Purge Cache using command prompt in OBIEE 11g

This post explains you how to purge cache in OBIEE 11g from the command prompt. Please follow the steps.

1. Create a purgecache.txt file with with the following line and save it in the “BI_Home\Oracle_BI1\bifoundation\server\bin” path.

call SAPurgeAllCache()

2. Open a command prompt window and then navigate to “BI_Home\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup” and then execute bi-init.cmd. it will launch a command prompt window that is initialized to Oracle instance.

 

3. Then navigate to ”BI_Home\Oracle_BI1\bifoundation\server\bin” and then execute the following command. After execution, you should see the similar results as the below screen.

syntax: 

nqcmd –d my_dsn –u my_username [-p my_password] –s sql_input_file

Example:  OBIEE 11g

nqcmd -d coreapplication_OH417411576 -u weblogic -p Admin123 -s purgecache.txt

Example:  OBIEE 10g

nqcmd -d AnalyticsWeb -u weblogic -p Admin123 -s purgecache.txt