Tuesday, November 27, 2012

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
describe the image
2345678910
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
describe the image
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.
  • 13
 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
  • 14

Tuesday, November 20, 2012

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.