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 1^st 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

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

https://www.youtube.com/watch?v=cogr-C4URs0

ODI 12c : File to Table

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_12c/odi12c_exp_flat_2_tbl/odi12c_exp_flat_2_tbl.html

ODI 12 : Integrating with Big Data

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_12c/odi12c_newfeatures/bigdata.html#section2s2

ODI 12c : Install and Configure Oracle Data Integrator 12c on Non-GUI Platforms

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_12c/odi_12c_silent_install/index.htmleatures/bigdata.html

ODI 12c : Creating and Connecting to ODI Master and Work Repositories

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_12c/odi12c_mst_wrk_repos/odi12c_mst_wrk_repos.html

ODI 12c : Creating Procedures and Scenarios

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_12c/odi12c_proc_scenario/odi12c_proc_scenario.html

ODI 12c : Creating a Collocated Agent

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_12c/odi12c_agent_collocated/index.html

ODI 12c : Creating a Standalone Agent

https://apexapps.oracle.com/pls/apex/f?p=44785:112:::::P112_CONTENT_ID:7949

ODI 12C : New Features of Version 12.1.3

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_12c/odi_12.1.3_nf/presentation_html5.html

Thanks
Rakesh Patil
rakeshpatil002@gmail.com

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

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.

https://www.youtube.com/watch?v=juLD9T5GAck

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.

Finally here is my OBIEE 12c Login page

Byee See you Soon, Take Care.Thanks and Regards Rakesh Patil