Error: Connection has failed While importing data into RPD - The connection has failed

Error Message: Connection has failed While importing data into RPD

Solution: copy Admin folder from oracle installaed location
1. G:\app\localhost\product\11.2.0\dbhome_1\NETWORK into
2. Paste the folder into below location

    G:\Middleware\Oracle_BI1\network
    G:\OBIEE11g\oracle_common\admin
3. Add the tnsnames file location path in User.cmd file.
4. User.cmd path C:\OBIEE11g\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup

5. Close your RPD and restart all the services.
6. After doing this we are able to import the data from oracle database.