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))

? ? )

? )

?

?