king1688888888
V2EX  ›  Oracle

请教 Oracle 监听异常的问题

  •  
  •   king1688888888 · Apr 2, 2020 · 2478 views
    This topic created in 2262 days ago, the information mentioned may be changed or developed.
    Oracle 版本:11.2.0.4.0,初次安装,很多不懂,请大佬解惑。

    首次安装好 Oracle 后,使用 lsnrctl status 查看监听和实例,正常。

    Service "orcl" has 1 instance(s).
    Instance "orcl", status READY, has 1 handler(s) for this service...
    The command completed successfully

    后来我本机变更了 IP 地址和主机名,已改 hosts 表。通过 netmgr 这个工具修改了监听信息,发现实例无法启动,lsnrctl status 显示 The listener supports no services,接着参考网上帖子,手动修改了 listener.ora ,实例可以启动了,但状态变成了 UNKNOWN,lsnrctl status 如下:

    Service "orcl" has 1 instance(s).
    Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully

    继续参考别的帖子,尝试了强制注册,手动注册等等方法,lsnrctl status 最终变成了如下:

    Service "orcl" has 2 instance(s).
    Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
    Instance "orcl", status READY, has 1 handler(s) for this service...
    The command completed successfully

    请问这个 UNKNOWN 和 READY 两种状态同时存在,是异常吗,应该如何解决?
    No Comments Yet
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   1114 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 28ms · UTC 18:12 · PVG 02:12 · LAX 11:12 · JFK 14:12
    ♥ Do have faith in what you're doing.