ORA-12504: TNS: 监听程序在CONNECT_DATA 中未获得SERVICE_NA

Question

vs2015客户端C#连接服务器的Oracle数据库，提示ORA-12504: TNS: 监听程序在CONNECT_DATA 中未获得SERVICE_NA

listener.ora文件内容：
tnsnames.ora文件内容：

Answer 1

先在system用户下查一下你的数据库实例名是否为“orcl”？：

select value$ from sys.props$ where name='GLOBAL_DB_NAME';

listener.ora文件内容改成如下:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\app\Administrator\product\11.1.0\db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = D:\app\Administrator\product\11.1.0\db_1)
      (SID_NAME = ORCL)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.90)(PORT = 1521))
    )
  )


--tnsnames.ora内容:
LISTENERBOB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.90)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
    )
  )