OBIEE 12c: ORA-12154 Error While Importing Metadata From an Oracle Database (Doc ID 2119009.1)

Last updated on JUNE 07, 2016

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

You have installed the Administration Tool, when attempting to import the metadata from an Oracle data source the following error occurs.

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms