监听异常:The listener supports no services

数据库版本:单机环境19c

实例是正常的


[oracle@sit19c admin]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Mar 1 16:39:16 2023
Version 19.7.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.7.0.0.0

SQL> SELECT STATUS,INSTANCE_NAME FROM V$INSTANCE;

STATUS
------------------------------------
INSTANCE_NAME
------------------------------------------------
OPEN
sit19c

SQL> SHOW PARAMETER SERVICE;

NAME				     TYPE			       VALUE
------------------------------------ --------------------------------- ------------------------------
service_names			     string			       sit19c


可监听就是没服务


[oracle@sit19c admin]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 01-MAR-2023 16:42:18

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sit19c)(PORT=1521)))
TNS-12543: TNS:destination host unreachable
 TNS-12560: TNS:protocol adapter error
  TNS-00513: Destination host unreachable
   Linux Error: 101: Network is unreachable
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                01-MAR-2023 16:23:29
Uptime                    0 days 0 hr. 18 min. 49 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/app/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File         /oracle/app/oracle/diag/tnslsnr/sit19c/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sit19c)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully

应该是网络的问题,ping不通主机名

[root@sit19c ~]# ping sit19c
connect: Network is unreachable

经检查是hosts文件中,主机配置的网段配置错了

posted on 2023-03-01 18:12  兔哥DB  阅读(254)  评论(0编辑  收藏  举报

导航