Tuesday, November 24, 2015

Oracle BI Administration Tool: Connection has failed

Oracle BI Administration Tool: Connection has failed

Import metadata error message:

The connection has failed.
[nQSError: 17014] Could not connect to Oracle Database.
[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154:
TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach.

Solution:

Oracle Instant Client must be installed in your machine and set environment variable TNS_ADMIN pointing to network admin folder of oracle instant client.








Click ok to close window

Start the OBIEE Administration Tool and import metadata again.




1 comment:

hasan_571 said...

Thanks...

Hasan Ali Özaslan