oracle因为改变电脑名监听无效的解决办法

1、找到oracle的安装目录:如 D:\Oracle\product\10.2.0\db_2\network\ADMIN


oracle因为改变电脑名监听无效的解决办法
 
2、找到network文件夹下的ADMIN文件夹
3、打开listener.ora文件
4.修改listener.ora文件

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

    )

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = mycomputer(自己的电脑名))(PORT = 1521))

    )

  )