"linux the listener supports no services"这个错误信息通常出现在尝试连接到一个服务时,但该服务并没有在服务器上监听任何端口。这个问题可能由多种原因引起,下面我将根据提供的tips来逐一分析并提供可能的解决方案: 确认错误信息的上下文和来源: 首先,需要明确这个错误是在什么操作或命令后出现的。例如,可能是在尝...
set current_listener“` ``是你为监听器指定的名称。 7. 创建监听器,使用以下命令: “`bash create listener “` 这将创建一个默认的监听器。 8. 将监听器与Oracle实例关联起来,使用以下命令: “`bash set current_listener“` 9. 检查监听器与Oracle实例的关联状态,使用以下命令: “`bash services “` 如...
Listener Log File /app1/oracle/diag/tnslsnr/hp2/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.8.12)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) The listener supports no services The command completed successfully ...
Instance "orcl", status READY, has 1 handler(s) for this service... The command completed successfully
如果能看到类似ora_smon_ORCL、ora_pmon_ORCL等进程,表示Oracle数据库正在运行。使用lsnrctl命令查看监听器的状态: lsnrctl status 复制代码如果能看到The listener supports no services或者类似的信息,表示监听器正在运行但没有监听任何服务;如果能看到监听的服务信息,表示Oracle数据库正在运行。
Listener Log File /u01/oracle/diag/tnslsnr/sonar/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sonar)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) The listener supports no services ...
9)lsnrctl start 时 The listener supports no services vi /u01/app/oracle/product/19.3/dbhome_1/network/admin/listener.ora # 添加 SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl) (SID_NAME = orcl) ) ) 10)解决乱码 ...
The listener supports no services The command completed successfully 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 需要额外注意的下面几项内容: 1. 监听程序参数文件 $ORACLE_HOME/network/admin/listener.ora ...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sonar)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Thelistenersupportsnoservices Thecommandcompletedsuccessfully [oracle@sonar~]$sqlplus/nolog SQL*Plus:Release11.2.0.4.0ProductiononSatJun2018:32:...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.161.120)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) The listener supports no services The command completed successfully sqlplus连接并启动: 代码语言:javascript 复制 [oracle@mv161p120 ~]$ sqlplus /nolog SQL*Plus: Release...