这是一个创建于 1688 天前的主题，其中的信息可能已经有所发展或是发生改变。
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 两种状态同时存在，是异常吗，应该如何解决？
首次安装好 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 两种状态同时存在，是异常吗，应该如何解决？
目前尚无回复
Select Language