[20170120]监听重启问题2.txt

[20170120]监听重启问题2.txt

--今天重启一台容灾的服务器的监听,想都没想直接lsnrctl stop,lsnrctl start.结果用户连接出现问题.

--只要不清楚这套系统的工作机制,自己在测试环境做一个测试,主要问题是监听配置修改了监听的别名.

1.环境:

SYS@book> @ &r/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

2.一般监听的配置如下:

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

#SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF

SID_LIST_LISTENER =

   (SID_LIST =

    (SID_DESC =

      (SDU=32767)

      (GLOBAL_DBNAME = book)

      (ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1)

      (SID_NAME = book)

      )

    )

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)(RATE_LIMIT=YES))

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.78)(PORT = 1521)(RATE_LIMIT=YES))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

  )

ADR_BASE_LISTENER = /u01/app/oracle

DIAG_ADR_ENABLED_LISTENER=OFF

USE_NS_PROBES_FOR_DCD=true

#DYNAMIC_REGISTRATION_LISTENER = off

INBOUND_CONNECT_TIMEOUT_LISTENER=100

CONNECTION_RATE_LISTENER=5

--//监听的别名是缺省LISTENER,这个是大部分单机数据库的配置.

3.而我们容灾的数据库使用别名,修改如下:

#SID_LIST_LISTENER =

SID_LIST_AAAA =

#LISTENER =

AAAA =

4.现在重启监听:

--如果按照平时的操作,我习惯执行如下:

$ lsnrctl stop;sleep 1;lsnrctl start

$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-JAN-2017 11:35:26

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date                20-JAN-2017 11:34:38

Uptime                    0 days 0 hr. 0 min. 48 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=gxqyydg4)(PORT=1521)))

The listener supports no services

The command completed successfully

SYS@book> alter system register ;

System altered.

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-JAN-2017 11:35:49

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Uptime                    0 days 0 hr. 1 min. 11 sec

Services Summary...

Service "book" has 1 instance(s).

  Instance "book", status READY, has 2 handler(s) for this service...

Service "bookXDB" has 1 instance(s).

  Instance "book", status READY, has 1 handler(s) for this service...

--//注意看~~,别名是LISTENER,静态注册的监听不存在,我现在还搞不懂为什么会影响这套容灾系统.仅仅不存在静态注册的监听.

5.正确的启动方式:

lsnrctl stop;sleep 1;lsnrctl start aAAA

--//注:AAAA大小写一样,都没有问题

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-JAN-2017 11:40:26

Alias                     aAAA

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Start Date                20-JAN-2017 11:40:11

Uptime                    0 days 0 hr. 0 min. 14 sec

Listener Log File         /u01/app/oracle/diag/tnslsnr/gxqyydg4/aaaa/alert/log.xml

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.78)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Service "book" has 2 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--//注意看~~.别名现在是aAAA. 静态监听也注册了.

$ ps -ef | grep tnslsn[r]

oracle   59355     1  0 11:40 ?        00:00:00 /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/tnslsnr aAAA -inherit

--而如果执行前面的lsnrctl stop;sleep 1;lsnrctl start

oracle   59385     1  4 11:44 ?        00:00:00 /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/tnslsnr LISTENER -inherit

6.总结:

--//重点问题不了解这套系统的工作机制.以后注意这些细节.缺少必要的文档,或者我根本没看这方面的文档.