asp.net - ORA-12514：TNS 列表器当前不知道连接描述中请求的服务。我能够连接到 sqlplus 和 SQL Developer

Question

我能够使用 sqlDeveloper 和 SQL Plus 用户名：SYSTEM 密码：password 连接到 orcale 12c

但是当我使用 ASP.Net 编写 API 并尝试连接到 Oracle 时，我得到了

ORA-12514:TNS:listner 当前不知道连接描述中请求的服务。

# TNSNames.ora sample entry
#
# alias =
#  (DESCRIPTION =
#    (ADDRESS = (PROTOCOL = TCP)(HOST = myserver.mycompany.com)(PORT = 1521))
#    (CONNECT_DATA =
#      (SERVER = DEDICATED)
#      (SERVICE_NAME = ORCL)
#    )
#  )


#
# You can modify the entry below for your own database.
# <data source alias> = Name to use in the connection string Data Source
# <hostname or IP> = name or IP of the database server machine
# <port> = database server machine port to use
# <database service name> = name of the database service on the server

<data source alias> =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =myserver.mycompany.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )

标签： asp.netoracle