✍ Kashif M
Trends

Friday, 20 October 2017

Kashif
Kashif, October 20, 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


Kashif
Kashif, October 20, 2017

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 see the ODI is ready for use to development




Congratulations you have installed ODI 12c.

Sunday, 15 October 2017

Kashif
Kashif, October 15, 2017

obiee 12c nqsserver.exe has stopped working


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




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%;%SystemRoot%\System32\Wbem



Start.cmd should look lke below:




obiee 12c nqsserver.exe has stopped working
obiee 12c nqsserver.exe has stopped working

Blog Archive