oracle - 18c PDB 服务未在 lsnrctl stat 或 services 中列出
问题描述
视图 v$active_services 和 dba_services 和 cdb_services 显示 PDB 服务。但是侦听器没有启动或列出 PDB 服务。会是什么问题?
重新启动侦听器,db,但问题未修复。PDB 是 dropme2 和 servicetest
SERVICE_ID NAME NETWORK_NAME CON_NAME
1 SYS$BACKGROUND CDB$ROOT
2 SYS$USERS CDB$ROOT
3 host_prim_wfscdb host_prim_wfscdb CDB$ROOT
4 WFSCDB_CFG WFSCDB_CFG CDB$ROOT
6 host_prim_wfscdb_DGB host_prim_wfscdb_DGB CDB$ROOT
12 dropme2 dropme2 DROPME2
14 servicetest servicetest SERVICETEST
oracle@host_prim:~$ lsnrctl stat
LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 26-FEB-2020 17:19:20
Copyright (c) 1991, 2018, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host_prim)(PORT=1529)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 18.0.0.0.0 - Production
Start Date 26-FEB-2020 16:49:55
Uptime 0 days 0 hr. 29 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/app/oracle/product/18.0.0/network/admin/listener.ora
Listener Log File /opt/oracle/app/oracle/product/18.0.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host_prim)(PORT=1529)))
Services Summary...
Service "WFSCDB" has 1 instance(s).
Instance "WFSCDB", status UNKNOWN, has 1 handler(s) for this service...
Service "host_prim_wfscdb_DGMGRL" has 1 instance(s).
Instance "WFSCDB", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
oracle@host_prim:~$ lsnrctl services
LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 26-FEB-2020 17:22:57
Copyright (c) 1991, 2018, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host_prim)(PORT=1529)))
Services Summary...
Service "WFSCDB" has 1 instance(s).
Instance "WFSCDB", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1 refused:0
LOCAL SERVER
Service "host_prim_wfscdb_DGMGRL" has 1 instance(s).
Instance "WFSCDB", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully```
解决方案
发现问题。local_listener init.ora 参数有错字。修正了错字和缺失的服务现在出现了!!
推荐阅读
- java - @Autowired 在 StepDef 文件中抛出空指针
- discord.py - 如何检查特定用户是否自聋
- android - 如何在 Android 中创建类似 Gmail 的滑动抽屉
- mongodb - 从损坏的 Mongodb 中检索数据
- php - Mac Catalina (10.15.4) Postfix -- 无法从命令行发送电子邮件并且 mail.log 不存在
- python - Python:在excel的特定列中重新排列日期
- spring - 在 ant 测试期间禁用某些方面
- php - 在 SQL 中使用 INT 值验证用户
- .net-core - 在项目参考中包含构建时功能
- c# - 在c#中向现有文件添加新的文本行