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中的...
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 = (S...
Thelistenersupports noservicesThe 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_LI...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) 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 解决方法一: 在lis...
报错提示: 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里面添加了一行 ...
问题描述:Oracle启动监听报错:The listener supports no services 解决办法:在listener.ora文件中添加 SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = DB202) (SID_NAME = DB202) ) ) 注意:DB202是数据库的SID,需要根据自己环境,来修改; ...
Service“oracle_XPT”has1instance(s). Instance“oracle”,statusREADY,has1handler(s)forthisservice… Thecommandcompletedsuccessfully 第二种. 修改LISTENER.ORA与TNSNAME.ORA文件. #listener.oraNetworkConfigurationFile:oracle/oracle/network/admin/listener.ora #tnsnames.oraNetworkConfigurationFile:/oracle/oracle...
Instance "orcl1", status READY, has 1 handler(s) for this service...The command completed ...
The listener supports no services The command completed successfully 如图所示: 这样启动后远程连接会报错:oracleORA-12514:TNS:listener does not currently know of service requested in connect descriptor问题原因:数据库实例没注册到listener解决方法:在listener.ora里面添加了一行 ...
注意到了没:The listener supports no services 3)、其基本的原理: 在到多少情况下,该消息表明的是数据库实例已经关闭,没有任何数据库服务可以用(可以用ps -ef | grep ora_)查看,如果这种情况下你只需要确保数据库的启动和服务名正确就行 把它修改为自己的实例:ewell(这个你不知道的话lsnrctl status就可以看到...