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

No comments:

Post a Comment

Loading xml file data to oracle table using python

Sample xml file (test.xml): <?xml version="1.0"?> <data>     <customer name="Ravi" >     ...