今天电脑拿回家,启动oracle数据库的监听服务时发现无法启动。给出的错误提示是说,这个服务启动了又停止了,不知道是为什么。因为在学校的时候用是没有问题的。我想应该是因为ip的是问题。在网上查了一下:你是否修改你的机器名或IP地址,如果有修改,把ORACLE\ora81\network\admin\listener.ora文件中的host修改为新机器名或IP。我用的是oracle 10g,listener.ora的目录在D:\oracle\product\10.1.0\db_1\NETWORK\ADMIN下。listener.ora文件的内容如下:
# listener.ora Network Configuration File: d:\oracle\product\10.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.5)(PORT = 1521))
)
)
)
修改为:
# listener.ora Network Configuration File: d:\oracle\product\10.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))