1. 解释"oracle the listener supports no services"的含义 "Oracle the listener supports no services" 错误信息表明 Oracle 数据库监听器(Listener)当前没有注册或支持任何数据库服务。监听器是 Oracle 数据库的一部分,负责监听客户端连接请求,并将这些请求转发到适当的数据库服务。如果监听器没有配置或无法识别任何...
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,listener.ora中host跟这里的是否一样 4、登录数据库,查看服务名是否与tnsnames中的...
一、问题描述 启动oracle监听程序时报如下错误,The listener supports no services 二、原因分析 数据库实例没注册到listener 三、处理过程 在listener.ora里面添加了红色标记的代码,具体如下: [oracle@oracle11g admin]$catlistener.ora # listener.ora Network Configuration File:/u01/app/oracle/product/11.2.0/db_...
Oracle Net Services - Version 11.2.0.1 and laterInformation in this document applies to any platform.Symptoms11.2 RAC listener shows no services registered. Command lsnrctl services reportsChangesCauseSign In To view full details, sign in with your My Oracle Support account. Register Don't have...
Thelistenersupports noservicesThe command completed successfully 如图所示: 这样启动后远程连接会报错: oracle ORA-12514:TNS:listener does not currently know of service requested in connect descriptor 问题原因:数据库实例没注册到listener 解决方法一:
snrctl start提示:The listener supports no servicesThe command completed successfully这样启动后远程连接会造成OracleORA-12514:TNS:listener does not currently know of service requested in connect descriptor 方法/步骤 1 ---方案一---原因：数据库实例注册到listener---登录数据库$sqlplus / as sysdba--显示...
报错提示: 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里面添加了一行 ...
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = globe) (SID_NAME = globe) ))此外，还可以使用Oracle的Net Manager来配置监听的SID及ORACLE_HOME。具体步骤如下：1. 在Net Manager中选择Listeners->Database Services。2. 配置要监听的SID及ORACLE_HOME。3. 保存并退出。在...
Oracle 11gR2 x86_x64 问题描述:Oracle启动监听报错:The listener supports no services 解决办法:在listener.ora文件中添加 SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = DB202) (SID_NAME = DB202) ) ) 注意:DB202是数据库的SID,需要根据自己环境,来修改; ...
The listener supports no servicesThe command completed successfully:这样启动后远程连接会报错: oracleORA-12514:TNS:listener does not currently know of service requested in connect descriptor 问题原因: 数据库实例没注册到listener 解决方法一:在listener.ora里面添加了一行SID_LIST_LISTENER = (SID_LIST = (...