While looking at BI Applications 7.9.6.3 on OBIEE 11g we encountered an issue trying to import metadata into an OBIEE repository. As can be seen below the only error you are given is “The connection had failed”!
We checked that the connection was defined correctly in the tnsnames.ora in the Oracle client installation. This was tested with a tnsping and also connecting via SQL*Plus, etc.
After various searches on the net it was found that OBIEE 11g comes with it’s own copy of the client software, so the solution is to make sure you have a copy of the relevant entry in the tnsnames.ora file under the 11g install. This will be {Oracle_BI1}\network\admin(e.g. C:\FMW11115\Oracle_BI1\network\admin).
Once the tnsnames.ora file was put into that directory the client tool could connect fine.
