我这边用11.2.0.4的数据库测试了一下
在修改sqlnet.ora 做lsnrctl reload之前的连接并不会受影响,这个命令本身就是让用户不停止监听的情况下,改变监听的配置。依然可以连接或者查询的。但是在reload之后,pmon注册实例监听之前,产生的新的连接是会连接不上。
SQL*Plus: Release 11.2.0.4.0 Production on Sun Mar 1 20:21:52 2020
Copyright © 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-12541: TNS:no listener
这个过程中如果有新的连接会连接不进来,不过重新注册之后就可以了,如果注册的时间比较慢,可以手动注册一下的。
alter system register;
官方对lsnrctl reload解释是:
Use the RELOAD command to reread the listener.ora file. This command enables you to add or change statically configured services without actually stopping the listener.
In addition, the database services, instances, service handlers, and listening endpoints that were dynamically registered with the listener will be unregistered and
subsequently registered again.