今天遇到了监听器启动问题,问题原因是原先机器装oracle的时候没有问题,后来更改机器名后,监听器就再无法启动了,问题定位是由于机器名所导致。解决办法其实很简单:
1、将自己的机器名改回来
2、将监听器里的配置文件改动一下。编辑%ORACLE_HOME\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora文件,找到下列HOST对应值administrator-PC,这个是机器名,将他改成你现在的机器名,如Tiwen-pc,然后重启oracle监听器,ok,搞定。
# listener.ora Network Configuration File: D:\Database\oracle\product\10.2.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:\Database\oracle\product\10.2.0\db_1) (PROGRAM = extproc) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = administrator-PC)(PORT = 1521)) ) )