INSTALLATION DOCUMENTS BY RAVI

Tuesday, June 13, 2017

Batch file for clearing OracleBIServer cache OBIEE 11g on windows

1. Open a text file and paste the below code

call sapurgeallCache();

2. Save the file as purgecache.txt and place it into the location  %ORACLE_INSTANCE%\bifoundation\OracleBIApplication\coreapplication\setup\

3. Now open another text file and paste the below code

@echo off
set ORACLE_HOME=C:\oracle\middlewarehome\Oracle_BI1
set ORACLE_INSTANCE=C:\oracle\middlewarehome\instances\instance1
set ORACLE_BI_APPLICATION=coreapplication
set JAVA_HOME=C:\oracle\middlewarehome\instances\instance1
set ESSBASEPATH=%ORACLE_HOME%\clients\epm\Essbase\EssbaseRTC
call %ORACLE_INSTANCE%\bifoundation\OracleBIApplication\coreapplication\setup\bi-init.cmd
call %ORACLE_HOME%\bifoundation\server\bin\nqcmd -d coreapplication_OH829890363 -u weblogic -p welcome1 -s %ORACLE_INSTANCE%\bifoundation\OracleBIApplication\coreapplication\setup\purgecache.txt

pause

Here 
coreapplication_OH829890363 : DSN name 

4. Save the file as purgecache.bat

5. Double click the bat file and it will clear the cache

2 comments:


  1. In today's digital age, having a strong online presence is essential for any business or individual. Many people rely on various platforms to showcase their skills and services, making it important to choose the right tools. For those interested in creating unique and custom designs, exploring options like website can be incredibly beneficial. It offers a range of features tailored to meet diverse needs and enhance user experience. Ultimately, selecting the right platform can significantly impact your success online.

    ReplyDelete

  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...