[20211020]奇怪lsnrctl status显示.txt

--//这几天一直在收尾同事配置dg的问题。生产系统安全问题比较复杂，通过测试环境演示该问题。

SYS@book> alter system register;
System altered.

$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-OCT-2021 10:10:00
Copyright (c) 1991, 2013, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                20-OCT-2021 10:09:07
Uptime                    0 days 0 hr. 0 min. 52 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 "booK" has 1 instance(s).
  Instance "book", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

SYS@book> alter system register;
System altered.

--//lsnrctl status 状态仅仅显示一个booK服务，而且是静态注册的。
--//我在listener.ora配置如下：
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SDU = 32767)
      (GLOBAL_DBNAME = booK)
      (ARGV0 = myapp0)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1)
      (SID_NAME = book)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

--//简单说明一下ARGV0 = myapp0，GLOBAL_DBNAME = booK(大小写混用也是测试目的)，以前的测试我都忘了。
$ rlsql scott/book@127.0.0.1:1521/boOK
SCOTT@127.0.0.1:1521/boOK> @ spid
       SID    SERIAL# PROCESS                  SERVER    SPID       PID  P_SERIAL# C50
---------- ---------- ------------------------ --------- ------ ------- ---------- --------------------------------------------------
        44       4465 42539                    DEDICATED 42541       27        177 alter system kill session '44,4465' immediate;

sqlplus scott/book@192.168.100.78:1521/Book
sqlplus scott/book
--//获取进程号略。

$ ps -fp 42541,42556,42549
UID        PID  PPID  C STIME TTY          TIME CMD
oracle   42541     1  0 10:15 ?        00:00:00 myapp0 (DESCRIPTION=(LOCAL=NO)(SDU=32767))
oracle   42549     1  0 10:17 ?        00:00:00 myapp0 (DESCRIPTION=(LOCAL=NO)(SDU=32767))
oracle   42556 42555  0 10:17 ?        00:00:00 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
--//相当于这时无论我本地或者远程通过网络登录，使用的都是静态服务。里面的ARGV0 = myapp0相当于改了参数0.

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

--//同时共享服务名也没有显示。

# netstat -tnlp | grep -v sshd
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address               Foreign Address             State       PID/Program name
tcp        0      0 0.0.0.0:1521                0.0.0.0:*                   LISTEN      42335/tnslsnr
tcp        0      0 0.0.0.0:514                 0.0.0.0:*                   LISTEN      9290/rsyslogd
tcp        0      0 0.0.0.0:963                 0.0.0.0:*                   LISTEN      4173/rpc.statd
tcp        0      0 0.0.0.0:111                 0.0.0.0:*                   LISTEN      4136/portmap
tcp        0      0 :::11794                    :::*                        LISTEN      57352/ora_d000_book
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
tcp        0      0 :::514                      :::*                        LISTEN      9290/rsyslogd
--//ora_d000_book存在。
--//后面检查发现在/etc/hostse文件中没有配置主机名。

# grep 78  /etc/hosts
# 192.168.100.78   xxxxdg4.com xxxxdg4

--//取消注解后
SCOTT@127.0.0.1:1521/boOK> alter system register;
System altered.

$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-OCT-2021 10:31:04
Copyright (c) 1991, 2013, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                20-OCT-2021 10:28:22
Uptime                    0 days 0 hr. 2 min. 41 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...
Service "bookXDB" has 1 instance(s).
  Instance "book", status READY, has 1 handler(s) for this service...
The command completed successfully

--//问题解决。很奇怪新版本使用centos 7.9 ， 新的hostnamectl命令并不会修改/etc/hosts文件。

$ sqlplus scott/book@192.168.100.78:1521/book
       SID    SERIAL# PROCESS                  SERVER    SPID                     PID  P_SERIAL# C50
---------- ---------- ------------------------ --------- -------------------- ------- ---------- --------------------------------------------------
        30       2327 6268:4120                DEDICATED 43112                     26         76 alter system kill session '30,2327' immediate;

# ps -fp 43112
UID        PID  PPID  C STIME TTY          TIME CMD
oracle   43112     1  0 11:13 ?        00:00:00 oraclebook (LOCAL=NO)
--//可以发现在动态，静态服务注册的情况下，优先使用注册的动态服务名。怎么能在这种情况下使用静态的服务名呢？

$ sqlplus  scott/book@"(DESCRIPTION=(ARGV0=xxxxxx)(ENABLE=BROKEN)(CONNECT_DATA=(ARGV0=yyyyy)(SERVICE_NAME=book)(SERVER = DEDICATED))(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.78)(PORT=1521)))"
SCOTT@book> @ spid
       SID    SERIAL# PROCESS                  SERVER    SPID                     PID  P_SERIAL# C50
---------- ---------- ------------------------ --------- -------------------- ------- ---------- --------------------------------------------------
        30       2329 4108:7656                DEDICATED 43120                     26         77 alter system kill session '30,2329' immediate;

# ps -fp 43120
UID        PID  PPID  C STIME TTY          TIME CMD
oracle   43120     1  0 11:14 ?        00:00:00 oraclebook (LOCAL=NO)
        
--//不行，放弃!!