当你在Linux系统上遇到Oracle错误消息“the listener supports no services”时,这通常意味着Oracle Listener没有配置为支持任何数据库服务,或者数据库实例没有正确注册到Listener。以下是一些解决这个问题的步骤: 检查Oracle Listener是否正在运行: 你可以使用以下命令来检查Listener的状态: bash lsnrctl status 如果Listen...
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 ...
set current_listener“` ``是你为监听器指定的名称。 7. 创建监听器,使用以下命令: “`bash create listener “` 这将创建一个默认的监听器。 8. 将监听器与Oracle实例关联起来,使用以下命令: “`bash set current_listener“` 9. 检查监听器与Oracle实例的关联状态,使用以下命令: “`bash services “` 如...
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 ...
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 ...
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)解决乱码 ...
(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:...
...启动lsnrctl监听 首先以oracle用户登录系统 进入数据库目录 $ cd /home/oracle/app/oracle/product/12.2.0/dbhome_1/bin 查看监听状态 $...Error: 111: Connection refused 启动监听 # 启动监听 $ ...PROTOCOL=ipc)(KEY=EXTPROC1521))) The listener supports no services The command completed successfully...