安装Oracle服务端后plsql连接时报错：ORA-12504:TNS:监听程序在CONNECT_DATA中未获得SERVICE_NAME

话不多说。直接上解决办法：

首先打开：文件一

E:\app\silence\product\11.2.0\client_1\network\admin\tnsnames.ora   -------------此为oracle客户端安装路径

文件里面内容如下：

192.168.1.26 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.26)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = yss)
    )
  )
接着打开：文件二

E:\app\silence\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora  ----------此为oracle服务端安装路径

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

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

最后：把文件一的内容复制到文件二。搞定！