Oracle ORA-12541:TNS:no listener

前天装好的Ｏｒａｃｌｅ，昨天突然不好用了，从Oracle的错误提示来看,是说TNS:no listener ，估计是某种服务没有启动，打开windows管理工具->服务，一看，有一个OracleOraHome90TNSListener这样的服务，和错误信息题是一致，基本就可以肯定是这个服务所引发的问题。再一看，该服务没有启动，遂手工启动，刷新后一看，该服务居然马上就自动关闭了。重试N次，结果一样。到Google搜索看看，没想到这还是一个普遍的问题，有一个人提出，把安装目录下的listener.ora打开察看。如：d:\oracle\ora90\network\admin\listener.ora。
打开该配置文件后发现如下一段配置信息：
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = IBMThinkPad)(PORT = 1521))
      )
    )
  )
 
    当看到这一行HOST=IBMThinkPad的时候，问题解决了。原来是由于几天装好Oracle后，又改了Windows的计算机名，而这个配置文件中记录的监听主机名还是原来的名称，这也就怪不得，OracleOraHome90TNSListener服务无法启动了，马上修改为现在的计算机名，再次启动OracleOraHome90TNSListener服务成功，PL/SQL Developer连接Oracle数据库成功，不能登陆故障排除
+++++++++++++++++++++++++++++++++++++++++++
我自己的特殊情况是既要连本机(笔记本sham0364)上的Oracle,有时又要连远程(shant130)的Oracle，我的listener.ora的配置:
============================================

# LISTENER.ORA Network Configuration File: D:\oracle\ora92\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sham0364)(PORT = 1521))
    )
    #(DESCRIPTION =
    #  (ADDRESS = (PROTOCOL = TCP)(HOST = shant130)(PORT = 1521))
    #)
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\ora92)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = orapw)
      (ORACLE_HOME = D:\oracle\ora92)
      (SID_NAME = orapw)
    )
  )

 +++++++++++++++++++++
注释掉连远程的那段就好了
+++++++++++++++++
后来我用的是：（这样就可以有时连本机，有时连远程--有时无缘无故不能连本机了，就重起本机。）

# LISTENER.ORA Network Configuration File: D:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = sham0364)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\ora92)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = orapw)
      (ORACLE_HOME = D:\oracle\ora92)
      (SID_NAME = orapw)
    )
  )