oracle listener 服务启动后停止

oracle 版本 10.2.0.1.0

在 计算机管理中 启动OracleOraDb10g_home1TNSListener 监听服务提示服务启动后又停止

 

打开listener 文件目录 

D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN (本机目录)

 

修改Listener.ora 文件

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

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

      (ADDRESS = (PROTOCOL = TCP)(HOST =r-43oqn22s9aowx)(PORT = 1521))

    )

  )

将HOST 修改为本机使用IP 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

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

      (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.19)(PORT = 1521))

    )

  )