真心求教：oracle ora-12504:tns 监听程序在connect_data中未获得service _name

[Infinite_M]

搞了好久了，都快烦死了！！！
总是出现oracle ora-12504:tns 监听程序在connect_data中未获得service _name

sqlplus能正常使用oracle，而且各种服务都已开。
win7 64位使用plsql，64位的服务端（G:\program\database\oracle11g\product\11.2.0\dbhome_1），32位的客户端（G:\program\database\oracle11g\product\instantclient_11_2）
环境变量： TNS_ADMIN=G:\program\database\oracle11g\product\instantclient_11_2;
NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
path中包含有G:\program\database\oracle11g\product\instantclient_11_2;G:\program\database\oracle11g\product\11.2.0\dbhome_1\bin;

# listener.ora Network Configuration File: G:\program\database\oracle11g\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = G:\program\database\oracle11g\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:G:\program\database\oracle11g\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = G:\program\database\oracle11g

# tnsnames.ora Network Configuration File: G:\program\database\oracle11g\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

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.16.1.149)
    )
  )

[CT_LXL]

lsnrctl status; 看看orcl.16.1.149有这个服务吗？

[请叫我-雷人]

HOST = localhost 自己的计算机名 SERVICE_NAME = orcl.16.1.149 自己数据库的名

[zhanglihui032]

客户端安装了两次，home目录不一致，.net不知道监听哪一个，卸载掉，用自定义安装，oracle也是个坑；