Sunday, September 4, 2016

OBIEE12c : Important commands to start/stop OBIEE 12c


After installation OBIEE12c i was confused how to up OBIEE12c. Then i cross verified oracle tutorial and came to know about below path. This is easy but important for new people[Like me]
 
PATH : C:\Rakesh\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\bitools\bin
Start.cmd for start services
Stop.cmd for stop services
Status.cmd for Status of the services
Admintool.cmd  for  BI Administartor 

Note : Path is depend on your OBIEE installation but this last part will be same : Oracle_Home\user_projects\domains\bi\bitools\bin

Thanks and Regards 
Rp
rakeshpatil002@gmail.com
 

OBIEE12c Error : No ODBC system data source is defined for Oracle BI Serves


Hello All,
After installation of OBIEE12. I got below error when i was opening RPD 1st time.











This issue occurs due to ODBC BI server configuration. Here are few steps to configured
Go to Control Panel -->System and Security-->Administrative Tools
Open the Data Sources (ODBC) and Click on System DSN
In System DSN, Click on Add Select Oracle BI Server and add below details
Name – You can give any name
Server – Localhost or server name












Click on Next 
Here you need to add 3 things 













Check changes default subject area to sample sales lite and click on finish











Now closed your RPD and reopen, you will not see this issue going forward.

Thanks and Regards
Rp
rakeshpatil002@gmail.com

Friday, May 27, 2016

ODI 12C

Hi All, 

It was good experience to learn new technology, if your working on OBIEE, You should know ODI or Informatica. because most of companies are using ODI and informatica for data warehouse design.Below are few ODI 12c tutorial which help you. 

ODI 12c : Installation and setup of Oracle Data Integrator (ODI) 12c on Windows with Weblogic
ODI 12c : File to Table
ODI 12 : Integrating with Big Data
ODI 12c : Install and Configure Oracle Data Integrator 12c on Non-GUI Platforms
ODI 12c : Creating and Connecting to ODI Master and Work Repositories
ODI 12c : Creating Procedures and Scenarios
ODI 12c : Creating a Collocated Agent
ODI 12c : Creating a Standalone Agent
ODI 12C : New Features of Version 12.1.3

Thanks
Rakesh Patil
rakeshpatil002@gmail.com

Friday, May 13, 2016

OBIEE 12c File Path, URL and Server Details

As per the file location OBIEE 12c completely diffrenect from OBIEE11g
Here the file location

Installation of OBIEE and Weblogic under:
“C:\Rakesh\Oracle\Middleware\Oracle_Home”  Here  Oracle_Home is the installation Directory.

DOMAIN_HOME [In 11g BI_Domain]: 
C:\Rakesh\Oracle\Middleware\Oracle_Home\user_projects\domains\bi

CATALOG: C:\Rakesh\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\bidata\service_instances\ssi\metadata\content\catalog

RPD: C:\Rakesh\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\bidata\service_instances\ssi\metadata\datamodel\customizations

BI ADMINISTATORT TOOLC:\Rakesh\Oracle\Middleware\Oracle_Home\user_projects\domains\OBIEE12\bitools\bin\admintoo.CMD

BI SERVER START AND STOPC:\Rakesh\Oracle\Middleware\Oracle_Home\user_projects\domains\OBIEE12\bitools\bin

INSTANCECONFIG [instaceconfig.xml]:C:\Rakesh\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\config\fmwconfig\biconfig\OBIPS

NQSCONF.INIC:\Rakesh\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\config\fmwconfig\biconfig\OBIS

LOG FILE:
C:\Rakesh\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\servers\obips1\logs

OBIEE 12c URL : As per my installation below are the URL.
Note: Rakesh-PC is my computer name, you have to change based on your pc name.
WebLogic Console : http://Rakesh-PC:9500/console
Fusion Middleware Control : http://Rakesh-PC:9500/em
BI Publisher : http://Rakesh-PC:9502/xmlpserver
BI Analytics : http://Rakesh-PC:9502/analytics

Thanks and Regards
RP
-rakeshpatil002@gmail.com

Tuesday, May 3, 2016

OBIEE 12c Installation

Hello All,

Sorry, Could not find time to update OBIEE blog. Today I will explain how to installed OBIEE 12c on Windows 7. Yes-day i did installation on my PC[Windows 7]

Before installation download below software from oracle website.
JDK -8
Oracle DB 12c
Weblogic
OBIEE 12c Software

Here are my files 











There are total 7 steps you need to follow in order:

Step 1st: Microsoft Loopback Adapter Installation  - http://rakeshpatil002.blogspot.in/2014/06/obiee-11117-installation.html
Step 2nd : JDK 8 Installation 
Step 3rd :  Oracle 12C Database Installation, In case if you don’t know DB installation check below video link.
Step 4th: Weblogic server and setup_bi_platform-12.2.1.0.0_win64 installation : Follow below steps.
Go to CMD (Rus as Administrator) and follow below steps and click on next[Here i am giving olny half screen shots] 
 





























 Similar to Weblogic Server you have to installed setup_bi_platform-12.2.1.0.0_win64
Step 5th: RCU installation : Execute Oracle_Home\oracle_common\bin\RCU.bat
 You need click on Next and configure details as per screen shots.




































Step 6th: Set Variable : Set below environment variable 

BI_PRODUCT_HOME= C:\Oracle\Middleware\Oracle_Home\bi

Step 7th: OBIEE12c Installation :Go To D:\OBIEE12C\Middleware\Oracle_Home\bi\bin
and click on Config.sh.






































After installation you will see you 100 % completed.