Error in importing metadata in OBIEE 11G

I was working with the an rpd where the database was in another machine.

When I do an import of data using the import metadata method

Tool > File > Import > from Database

I am getting an error “Connection failed”

In my earlier blogs I had mentioned that if we are using Oracle Database we have to choose OCI method. (For more information click on the link OCI connection information).

Well here I used the OCI method and I created a new tns connection and placed it in the tnsname.ora

OBIEEHOME\Oracle_BI1\network\admin.

Then when I tried connecting it still shows connection issue.

If I connect to my local orcl connection it works perfectly with this OCI method but when I try accessing another database it dosnt work.

Solution

OBIEE HOME\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup.

In this file location there is a user.cmd file.

Right click on it and edit the file and give in the location of the tns.ora. After adding this information save it and if required restart the services.