时间戳

首页 > 解决方案 > 使用 TnsNames Alias 连接到 oracle DB

c# - 使用 TnsNames Alias 连接到 oracle DB

问题描述

在我的 TnsNamesOra 我有

TEST11.12.13.14 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 11.12.13.14)(PORT = 1234))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = TESTNAME)
    )
  )

如果我的连接字符串如下所示：

Data Source = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 11.12.13.14)(PORT = 1234)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = TEST))); User Id = admin; Password = admin ; DBA Privilege = SYSDBA ; Pooling = false; Connection Timeout = 30" providerName="Oracle.DataAccess.Client

一切正常。

但我想做这样的事情：

Data Source = TEST11.12.13.14; User Id = admin; Password = admin ; DBA Privilege = SYSDBA ; Pooling = false; Connection Timeout = 30" providerName="Oracle.DataAccess.Client

但是出现错误

ORA-12154: TNS: 无法解析指定的连接标识符

标签： c#databaseoracleconnection-stringtnsnames

解决方案

推荐阅读