Loopback Adapter Installation

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

• 

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

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.

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!!!!!!!!!!!

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.