listener rate_limit限制tns连接

admin

How To Control the Amount of Connections Handled by the TNS Listener (Doc ID 443744.1)

Oracle网络侦听器中的连接速率限制器特性使数据库管理员能够限制由该侦听器处理的新连接的数量。启用此功能后，Oracle Net监听器会对监听器每秒钟处理的新连接数量施加一个用户指定的最大限制。根据配置的不同，速率可以应用于端点集合或特定端点。

1.listener参数配置

1. LISTENER =
   
2.   (DESCRIPTION_LIST =
   
3.     (DESCRIPTION =
   
4.       (ADDRESS = (PROTOCOL = TCP)(HOST = vm1)(PORT = 1521)(RATE_LIMIT=5))
   
5.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)(RATE_LIMIT=5))
   
6.     )
   
7.   )
   

复制代码

或者

1. LISTENER =
   
2.   (DESCRIPTION_LIST =
   
3.     (DESCRIPTION =
   
4.       (ADDRESS = (PROTOCOL = TCP)(HOST = vm1)(PORT = 1521)(RATE_LIMIT=5))
   
5.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)(RATE_LIMIT=5))
   
6.     )
   
7.   )
   
8.   
   
9. CONNECTION_RATE_LISTENER=10

复制代码

2.重启listener
3.模拟连接风暴

1. for ((i=1; i<=1000; i++))
   
2. do
   
3. sqlplus -S zhyu/zhyu@192.168.56.101:1521/ora19 << EOF &
   
4. select to_char(sysdate,'yyyymmdd hh24:mi:ss') as current_time from dual;
   
5. EOF
   
6. done

复制代码

4.分析监听日志连接情况

1. [oracle@vm1 trace]$ fgrep "11-DEC-2023 11:36" listener.log  |fgrep "establish" |awk '{print $1 " " $2}' |awk -F: '{print $1 ":" $2 ":" $3 }' |sort |uniq -c|sort -k 3
   
2.       6 11-DEC-2023 11:36:00
   
3.       5 11-DEC-2023 11:36:01
   
4.       5 11-DEC-2023 11:36:02
   
5.       5 11-DEC-2023 11:36:03
   
6.       5 11-DEC-2023 11:36:04
   
7.       6 11-DEC-2023 11:36:05
   
8.       5 11-DEC-2023 11:36:06
   
9.       5 11-DEC-2023 11:36:07
   
10.       5 11-DEC-2023 11:36:08
    
11.       6 11-DEC-2023 11:36:09
    
12.       6 11-DEC-2023 11:36:10
    
13.       6 11-DEC-2023 11:36:11
    
14.       5 11-DEC-2023 11:36:12
    
15.       6 11-DEC-2023 11:36:13
    
16.       5 11-DEC-2023 11:36:14
    
17.       5 11-DEC-2023 11:36:15
    
18.       5 11-DEC-2023 11:36:16
    
19.       6 11-DEC-2023 11:36:17
    
20.       5 11-DEC-2023 11:36:18
    
21.       6 11-DEC-2023 11:36:19
    
22.       6 11-DEC-2023 11:36:20
    
23.       5 11-DEC-2023 11:36:21
    
24.       5 11-DEC-2023 11:36:22
    
25.       5 11-DEC-2023 11:36:23
    
26.       6 11-DEC-2023 11:36:24
    
27.       6 11-DEC-2023 11:36:25
    
28.       6 11-DEC-2023 11:36:26
    
29.       5 11-DEC-2023 11:36:27
    
30.       5 11-DEC-2023 11:36:28
    
31.       5 11-DEC-2023 11:36:29
    
32.       6 11-DEC-2023 11:36:30
    
33.       6 11-DEC-2023 11:36:31
    
34.       6 11-DEC-2023 11:36:32
    
35.       6 11-DEC-2023 11:36:33
    
36.       5 11-DEC-2023 11:36:34
    
37.       5 11-DEC-2023 11:36:35
    
38.       5 11-DEC-2023 11:36:36
    
39.       5 11-DEC-2023 11:36:37
    
40.       5 11-DEC-2023 11:36:38
    
41.       5 11-DEC-2023 11:36:39
    
42.       6 11-DEC-2023 11:36:40
    
43.       5 11-DEC-2023 11:36:41
    
44.       5 11-DEC-2023 11:36:42
    
45.       5 11-DEC-2023 11:36:43
    
46.       5 11-DEC-2023 11:36:44
    
47.       6 11-DEC-2023 11:36:45
    
48.       5 11-DEC-2023 11:36:46
    
49.       5 11-DEC-2023 11:36:47

复制代码

admin

rac环境下测试

1.连个节点的listener.ora配置不一致

2.客户端发起连接，tns是scan

1. for ((i=1; i<=1000; i++))
   
2. do
   
3. sqlplus -S zhyu/zhyu@192.168.56.25:1521/pdb1 << EOF &
   
4. select to_char(sysdate,'yyyymmdd hh24:mi:ss') as current_time from dual;
   
5. EOF
   
6. done

复制代码

3.两个节点的监听情况为

admin

rac环境下测试

1.两个节点都配置scan_listener

2.客户端发起连接

1. for ((i=1; i<=1000; i++))
   
2. do
   
3. sqlplus -S zhyu/zhyu@192.168.56.25:1521/pdb1 << EOF &
   
4. select to_char(sysdate,'yyyymmdd hh24:mi:ss') as current_time from dual;
   
5. EOF
   
6. done

复制代码

3.两个节点的监听情况