OBIEE 11g RPD is not connecting to Database to import metadata

After installing OBIEE 11g first time we will face this issue, we are unable to connect to DB or we re unable to view data from RPD.

Follow below steps to overcome this issue:

Just Copy your TNS file from your database and copy to below mentioned BI locations.

1) %MiddleWare_Home%\oracle_common\network\admin

2) %MiddleWare_Home%\Oracle_BI1\network\admin

If admin folder is not there .......just create admin folder and copy the TNS file.


Regarding BI Client Tool you can see my previous post.
OBIEE client tool is not connecting to Database : Error: Connection has failed

OBIEE client tool is not connecting to Database : Error: Connection has failed

I have an OBIEE 11g Client,through which I have opened an RPD.

When I am trying to import data from database it was giving the error like Connection has failed .

Follow below steps to overcome this issue.

Go to below location and search for  bi_init file.

C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orahome\bifoundation\server\
 

 Open bi_init file in edit mode





Please add TNS_ADMIN entry to the bi_init.bat file to point to your Oracle client tnsnames.ora home directory path as shown in above screen shot.

Now OBIEE client tool will connect to database.