解释“lsnrctl status显示the listener supports no services”的含义 当使用lsnrctl status命令检查Oracle Listener的状态时,如果输出中包含“the listener supports no services”,这意味着Oracle Listener当前没有配置为支持任何数据库服务,或者数据库实例没有正确注册到Listener。简单来说,Listener无法识别或连接到任何数据...
启动报错:The listener supports no services The command completed successfully 原因:数据库实例没注册到listener 解决办法: 方法一(我所使用的方法): 1、登录到数据库: sqlplus / as sysdba startup 2、显示服务名: show parameter service 3、强制注册服务: alter system register; 注册后退出:quit 4、查看监听...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=redhat4.7)(PORT=1521))) The listener supports no services The command completed successfully
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=redhat4.7)(PORT=1521))) The listener supports no services The command completed successfully
The listener supports no services The command completed successfully 从显示信息可以看出这种情况下动态注册监听和静态注册监听都失败 等待片刻(1min)。。。 Service "orcl" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Service...
Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully rac1-> crs_stat -t Name Type Target State Host --- ora...XFF.cs application ONLINE ONLINE rac1 ora...db1.srv ...
Listener Log File /opt/oracle/app/diag/tnslsnr/oracle11/listener/alert/log.xml Listening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle11)(PORT=1521)))The listener supports no services ...
操作: LSNRCTL> set current_listener ANDYCDB_TEST Current Listener is ANDYCDB_TEST LSNRCTL> start Starting.../home/oracle/app/oracle/product/12.2.0/dbhome_1/bin/tnslsnr: please wait...=tcp)(HOST=12c01)(PORT=1522))) The listener supports no services The command completed successfully LSNRCTL...
The listener supports no services The command completed successfully 编辑listener.ora 之后,reload 操作: oracle@rac1:/opt/oracle/11.2.0/yangdb/network/admin>lsnrctl reload LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 13-SEP-2011 14:22:44 ...
这个是正常的，当数据库实例没有启动的时候，监听到的实例为零，只有启动了数据库实例后，才能监听到实例。