1. 首页
  2. IT资讯

[20200115]监听中没有xdb服务.txt

[20200115]监听中没有xdb服务.txt

–//链接http://www.itpub.net/thread-2123866-1-1.html的问题,查看监听状态发现没有XDB的服务。
–//问题的原因是对方没有配置shared_servers=0.通过测试说明:

1.环境:
SYS@book> @ ver1
PORT_STRING                    VERSION        BANNER
—————————— ————– ——————————————————————————–
x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production

SYS@book> show parameter dispatchers
NAME            TYPE    VALUE
————— ——- ————————————-
dispatchers     string  (PROTOCOL=TCP) (SERVICE=book,bookXDB)
max_dispatchers integer

–//执行lsnrctl status,可以发现bookXDB存在。这步略。

Service "bookXDB" has 1 instance(s).
  Instance "book", status READY, has 1 handler(s) for this service…
The command completed successfully

2.测试:

SYS@book> alter system set shared_servers=0;
System altered.

SYS@book> shutdown immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@book> startup
ORACLE instance started.
Total System Global Area  643084288 bytes
Fixed Size                  2255872 bytes
Variable Size             205521920 bytes
Database Buffers          427819008 bytes
Redo Buffers                7487488 bytes
Database mounted.
Database opened.

SYS@book> alter system register ;
System altered.

$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 – Production on 15-JAN-2020 11:14:20
Copyright (c) 1991, 2013, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(ARGV0=LLLLLL)(HOST=0.0.0.0)(PORT=1521)(ARGV0=KKKKK)))
STATUS of the LISTENER
————————
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 – Production
Start Date                23-DEC-2019 15:52:01
Uptime                    22 days 19 hr. 22 min. 19 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/11.2.0.4/dbhome_1/network/log/listener.log
Listening Endpoints Summary…
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary…
Service "BOOKSHARE" has 1 instance(s).
  Instance "book", status READY, has 1 handler(s) for this service…
Service "booK" has 2 instance(s).
  Instance "book", status UNKNOWN, has 1 handler(s) for this service…
  Instance "book", status READY, has 1 handler(s) for this service…
The command completed successfully

–//可以发现bookXDB服务名不存在。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/267265/viewspace-2673426/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:深沉的少年,转转请注明出处:http://www.cxybcw.com/183086.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code