今晚解决了自己电脑上Oracle数据库登录“无监听程序”的错误。
刚开始,我去Windows服务里去启动监听服务,可是怎么启动也启动不了这服务,当然,结果就是我用我的QIAN数据库标识符去登录,提示“无监听程序”,很纳闷(第一次遇到这问题),很纳闷,于是就上网查了些资料,发现时我的listener.ora文件内
代码
# listener.ora Network Configuration File: G:\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 = G:\oracle\product\ 10.2 . 0 \db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 59.77.23.140 )(PORT = 1521 ))
)
)
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = G:\oracle\product\ 10.2 . 0 \db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 59.77.23.140 )(PORT = 1521 ))
)
)
而我当前IP地址为59.77.23.140,主机IP地址与当前IP地址不相符。于是就把IP地址改了回来,重新去启动监听服务,结果服务成功启动了,我以为大功告成了,结果还是继续提示“无监听程序”,这就相当郁闷了。于是继续网上查资料,最后发现,tnsnames.ora文件内的对应的主机IP地址依旧是旧的IP地址,于是就赶快把IP改了回来,为了防止意外,我还把已经启动的监听服务重启了,怀着憧憬的心情试着去登陆我的QIAN标识符标识的数据库,结果成功登录Oracle数据库了。。。。。。
哈!终于登录进去了。我真是太菜了。