Skip to main content

Posts

Showing posts from October, 2017

Clear Cache in OBIEE 11g and OBIEE 12C

Step 1 :  Create a .txt file as  purgecache.txt  and placed into loc : /ebsapp/BIDEV/apps/admin/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup In the file, enter the code  call SAPurgeAllCache() , this is special BI command for clearing the cache. Step 2 :  Create a shell script as  purgecache.sh In .sh file, entered two commands /ebsapp/BIDEV/apps/admin/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/bi-init.sh /ebsapp/BIDEV/apps/product/Oracle_BI1/bifoundation/server/bin/nqcmd -d AnalyticsWeb -u username -p pswd –s /ebsapp/BIDEV/apps/admin/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/purgecache.txt Step 3:   Open the putty software and run the purgecache.sh script

Step by Step on Oracle Data Integrator 12C Installation

Below the screenshot of Oracle Data Integator 12C Installation. This artcile is dedicated to my friend Kaka. Please follow the the below mentionded steps to install Oracle Data integrator 12C (ODI 12C) Download Oracle Data Integator 12C from below link.  http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html Change Jdk/bin path and enter below command >java -jar odi12.2.1 3.jar file including location.  Once you hit enter Oracle Data Integator Pre-check will happen Oracle Data Integator 12c setup lanches for installation Click on Next Click Next  Click on Enterprise Installation It will check Operation system certification and click for Next Click on Next Click on Yes and Hit on next Click on Next Installation will start as below mention screen Click on Next   Click on Finish  You can...

obiee 12c nqsserver.exe has stopped working

obiee 12c nqsserver.exe has stopped working I am Installation OBIEE 12c in Windows 7 and my installation was successful but I am unable to start presentation service. While checking my BI Service I can See OBIS and OBIPS Services are SHUTDOWN and when I try starting it again I keep getting different errors “nqsserver.exe has stopped working” “oracle business intelligence has stopped working” “sawserver.exe crashes” Below are the screenshots of nqsserver.exe has stopped working obiee 12c nqsserver.exe has stopped working obiee 12c nqsserver.exe has stopped working Solution: I doubt this issue is because I had multiple version of Weblogic and BI installed in the same machine and OBIEE 12c unable to locate to Wbem files. I just added one line in start.cmd ( E:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi_foundation\bitools\bin\start.cmd) Line which you need to add for Wbem: set PATH=C:\ProgramData\Oracle\Java\javapath;%SystemRoot%\system32;%SystemRoot%;...