记录今天因oracle监听不能启动，报错误问题

今天在公司将oracle装上，能够正常运行，但回到家开电脑却不能用数据库，一看OracleOraDb10g_home1TNSListener监听服务未启动，手动启动时报错；

纠结了半天，看到有帖子上说oracle安装时会绑定ip，ip更换之后有可能就出现这个问题，急忙去查看了下安装目录下：D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN

的listener.ora文件，发现listener的address为：

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = jwyde-PC.mshome.net)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

将其修改为

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