当你在Linux系统上遇到Oracle错误消息“the listener supports no services”时,这通常意味着Oracle Listener没有配置为支持任何数据库服务,或者数据库实例没有正确注册到Listener。以下是一些解决这个问题的步骤: 检查Oracle Listener是否正在运行: 你可以使用以下命令来检查Listener的状态: bash lsnrctl status 如果Listen...
Oracle启动监听报错:The listener supports no services或出现 unknown状态解决 1、查看$ORACLE_HOME/network/admin/listener.ora 文件中的host是否正确,能不能ping通 2、查看$ORACLE_HOME/network/admin/tnsnames.ora文件中的host是否与listener.ora中的一致 3、查看/etc/hosts文件中的127.0.0.1 是不是localhost,listen...
Listener completed notification to CRS on start TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE WARNING: Subscriptionfornode down event still pending 09-MAR-2023 09:37:22 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=txy)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SER...
方法/步骤 1 ---方案一---原因：数据库实例注册到listener---登录数据库$sqlplus / as sysdba--显示服务名SQL>show parameter service_names--强制注册服务SQL>alter system register;--查看监听状态$lsnrctl status 方法/步骤2 1 ---方案二---问题解决了在listener.ora里面添加了一行SID_LIST_LISTENER =(SID...
Thelistenersupports noservicesThe command completed successfully 如图所示: 这样启动后远程连接会报错: oracle ORA-12514:TNS:listener does not currently know of service requested in connect descriptor 问题原因:数据库实例没注册到listener 解决方法一:
The listener supports no services The command completed successfully 这样启动后远程连接会报错: oracle ORA-12514:TNS:listener does not currently know of service requested in connect descriptor 问题原因:数据库实例没注册到listener 解决方法一: 在listener.ora里面添加下面各行: ...
oracle 监听启动报错:the listener supports no services 问题原因:数据库实例没有注册到监听解决办法: 找到listener.ora文件:***/product/11.2.0/dbhome_1/network/admin/目录下 增加:SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (ORACLE_HOME= /data/oracle/app/oracle/product/11.2.0/dbhome_1 ...
报错提示: The listener supports no servicesThe command completed successfully 这样启动后远程连接会报错:oracle ORA-12514:TNS:listener does not currently know of service requested in connect descriptor问题原因:数据库实例没注册到listener 解决方法一:在listener.ora里面添加了一行 ...
Linux Error: 2: No such file or directory 提示没有监听服务 问题原因：数据库实例没注册到listener ...
/u01/app/oracle/diag/tnslsnr/<hostname>/listener/alert/log.xml 修改litener.ora # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = ...