Connenection Has faild error in OBIEE 11g

961614

Hi All,

I am trying to create new connection in OBI rpd but I am getting the connection failed error while importing metadata.

Here I have created same connection  in SQL Developer and  it is working fine. And I am getting replay, If I ping IP address.

Please let me know is there any other ways to trace this issue.

Thanks,

Ramesh

asim cholas

Hello Ramesh,

Do you have the TNS  file in the server?

anyway check the connection by pasting your tns etnry in the TNS Name like below ( Complete entry like below)

(DESCRIPTION=

    (ADDRESS=

      (PROTOCOL=TCP)

      (HOST=yourdbIP)

      (PORT=1521)

    )

    (CONNECT_DATA=

      (SERVER=dedicated)

      (SERVICE_NAME=yourservice name)

    )

  )

961614

Hi Asim,

I have added tns details in tnsnames.ora file and I am able to ping TNSNAME and it is getting connect. In RPD level I have called this TNSNAME as   DSN name in connection pool. And I have added entire tns name as DSN name but it is not working.

Thanks,

Ramesh

asim cholas

There are many articles explaining the issues related to connection pool, also, if you search in OTN you will find n number of threads with solution.

https://businessintelligence.technology/2014/09/07/the-connection-has-failed-error-when-trying-to-import-metadata-into-obiee/

http://onestep4obiee11g.blogspot.com/2014/10/connection-failed-unable-to-import. html

https://santoshbidw.wordpress.com/2012/05/12/obiee11g-import-data-connection-failed-error-2/

Gianni Ceresa

Always keep in mind a little detail: your desktop isn't the BI server, you able to connect using a TNS name from your desktop doesn't mean OBIEE know what that TNS is, and doesn't mean the BI server can connect to the DB.

There are ways (locations) where to tell OBIEE about your TNS.