TNS:无法解析OCI调用OCIServerAttach中指定的连接标识符

Question

我正在研究OBIEE-12c。我的数据库也是Oracle-12c。在存储库创建过程中，我得到了以下错误。

[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.

​

​

Answer 1

您是否尝试过写入tnsnames.ora文件中显示的完整连接字符串，而不仅仅是名称？？

不是写pdborcl write：

(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = pdborcl))
  )

或者你的连接字符串看起来像什么。

我不确定为什么会发生这种情况，但在我做到这一点之前，我无法完成我的工作。

Answer 2

要解决此问题，请尝试以下操作

(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = <what ever SID you specified>)))
log : anonymous
P/w : < the password you specified when creating the Database>