Wednesday, October 17, 2012

RCU movement from one database to another database

Due to various reasons we require to move RCU from one database to anotherdatabase.We can able to move RCU from one database to other database without impacting the installed OBIEE11g.For this activity you need to follow below steps
1)logon to WLS Admin console->services->click on datasources


Click on bip_datasource and click on connection pool
Click on “Lock & Edit” button




Provide the new database details like host name, instance and password .Do the same for all remaningfour data sources, save and activate changes.

Logon to Enterprise manager



 Business intelligence folder -> coreapplication –->deployment –>scheduler.
Provide the new database details, apply and activate the changes.
Restart the services and run the analytics.

Tuesday, October 16, 2012

Why RCU & Its Installation steps

If you want to install the OBIEE Server you have to create some schemas in the database which will keep the OBIEE repository. For working, OBIEE needs some schemas to be created. This work is dome automatically by using rcu  (Repository Creation Utility).
In order to create the OBIEE schemas with the RCU, you must have installed an Oracle database (11g).
You can change the RCU repository metadata from one database to another database without impacting the current installed OBIEE11g environment.

Installation steps:
1) Install the Oracle11.1.1.7 database with Microsoft Loopback adapter.
2)Once you downloaded the s/w you will get your s/w in below mentioned manner.Open RCUhome and extract files into same folder.(if you are unable to find RCUHome\BIN\RCU.bat file then again need to extract it.Remove existed files and folders before reextracting.


3)Goto RCUHome->BIN\RCU.bat(in propertied you will find like batch file),Execute or double click it

and follow as per below s.shots.
               

Provide the system credentials with system host name(m/c name), port and service name then click next
System will check the prerequisites, ignore this warning.

. You can create profile with your desired name.You will find prefix changes as per your profile names.And choose required components.then next
click on ok


Provide the password for the schemas created in the previous step.Try to use a single pwd every where.it will easy to remember.
click next
click ok

click ok

Click on create

if you found above screen on your sys then you are installed RCU successfully.Congrats!!!!!!!!!!!

Monday, October 15, 2012

Prerequasites for OBIEE11g installation

OBIEE 11.1.1.6 Installation Pre requisites on Windows 7 64bit OS
Before installation OBIEE 11.1.1.6 on Windows 7 64 bit Operating System, ensure the below requirements are taken care.
System Requirements
  • Disk Space  20GB or higher
  • Physical Memory 4GB
  • Temp Space 950MB
  • Swap Space 3GB
  • CPU & Processor: dual-core Intel 64 Bit, 2.10GHz or greater
  • Internet Explorer 8 or higher
Other Requirements
  • Environmental Variables (TEM to C:\ directory)
  • Install Loopback Adapter with specific IP Address
  • JDK 7 (64bit)
  • Adobe Flash Player 11
  • Oracle Database 11.1.0.7.0 or higher
  • RCU Installation

NOTE: If you install more than one time in case of any issues then you will get BI Domain faild error.So make sure to delete all files before reinstalling.If possible try to delete it from REGEDIT also.