OBIEE 11G Installation in Windows XP

In the OBIEE 11.1.1.6 Certification, I didn't see Windows 32-Bit as supporting Operating system. Still, I gave it a shot to see whether it will work or not.

It works!!!
Installation of OBIEE invloves 4 steps:
1) Installation of Loopback adopter
2) Installation of database
3) Installation of RCU (Repository Creation Utility)
4) Installation of OBIEE software
Installing a Loopback Adapter on Windows XP-32 Bit

My System configuration: Ram 8 GB and windows XP Installed on virtual machine

Open the Windows Control Panel.

1.      If you are in Category view switch to Classic view

2.      Double-click Add Hardware to start the Add Hardware wizard

3.      In the Welcome window, click next

4.      Follow the screen shots one by one

In the Properties dialog box, click Use the following IP address and do the following:

a. IP Address: Enter a non-routable IP for the loopback adapter. For instance:

i. 10.10.10.10

ii. 192.168.x.x (x is any value between 0 and 255)

b. Subnet mask: Enter 255.255.255.0.

c. Leave all other fields empty.

Click OK

Close Network Connections.

Restart the computer.

Add a line to the SYSTEM_DRIVE:\WINDOWS\system32\drivers\etc\hosts file with the following format, right after the localhost line:

IP_address hostname.domainname hostname

 where:

• IP_address is the non-routable IP address
• hostname is the name of the computer.
• domainname is the name of the domain.
•  Note : Domain name is optional. In the following screen shot. I just used my Computer Name.
• 

 Check the network configuration:

• Open System in the Control Panel, and select the Computer Name tab. In Full computer name, make sure you see the host name and the domain name, for example, sales.us.mycompany.com.
• Click Change. In Computer name, you should see the hostname, and in Full computer name, you should see the host name and domain name. Using the previous example, the host name would be sales and the domain would be us.mycompany.com.
• Click More. In Primary DNS suffix of this computer, you should see the domain name, for example, us.mycompany.com

• 

Source: www.oracle.com

Step 2:-
DATABASE INSTALLATION:


 




Step 3:-
RCU CREATION :

Please follow the screeshots one by one. (visit Part 1, Part 2, Part 4)

 
 




Step 4:-
OBIEE 11.1.1.6 Installation :                            
 

Connection Errors in 11 G

Connection Failed Error - Import Data(11g)

In OBIEE10g no need to copy tns file in BIHome.But in OBIEE11g you need to copy in BIHome also.If you not copy this tns file then you will get “The connection has failed” error while trying to import data from the database using OCI call interface" in RPD.

To resolve above error you need to perform the below steps.
1. Add the tnsnames.ora file in the BI Home DirectoryEnsure, you add all the data source tns entry details in the tnsnames.ora file
You need to copy same tnsnames.ora file from Oracle Home (Root directory: \App\User\Product\Network\Admin) and paste the file to the below location in OBIEE11g directory
1. \OBIEE11g\Oracle_BI1\network\admin and
2.\OBIEE11g\oracle_common\admin

2. Add the tnsnames file location path in User.cmd file
Add the tnsnames file location path from one of the above location in the user.cmd file. The user.cmd file is found in the below location
Root directory: \OBIEE11g\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup

  

 I hope it will works now.Otherwise close RPD and restart the services.Then it will works.Restarting of services are suggestable

RCU movement from one database to another database

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.