ora-12541

zengqianglxz

大家好：
     我在linux7。3上安装了oracle817，在linux可以用sqlplus aa/kmcdata@dd连上数据库，但在windowns上却连不上，提示ora－12541，用tnsping却提示成功，

listener.ora
# LISTENER.ORA Network Configuration File: /home/oracle/product/8.1.7/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = kmcdata)
      (ORACLE_HOME = /home/oracle/product/8.1.7)
      (PROGRAM = extproc)
    )
  )


tnsames.ora

KMCDATA.LOCALDOMAIN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = kmcdata)
    )
  )

如将listener.ora和tnsnames.ora中的host改为Ip地址，sqlplus连接时提示ora-03113错误，不知各位有何办法？谢谢了！