Oracle 11gR2 RAC 使用默认service实现负载均衡_oracle 11g rac 负载均衡连接配置-优快云博客

本文链接：https://blog.youkuaiyun.com/FightFourEggs/article/details/49100237

本文通过实验详细探讨了Oracle 11gR2 RAC如何使用默认service实现负载均衡。在空负载和负载情况下，展示了service的goodness如何影响连接分配，强调负载均衡基于service连接到数据库实例的负载，而非实例自身负载。测试结果显示，当通过特定service进行连接时，负载可以得到合理分布。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Oracle的很多load balance虽然号称load balance，但其实更确切的说是session balance

自定的service 可以使用 load balance advisory 实现均衡负载，而在RAC创建时的默认service(和数据库同名的那个)就可以实现load balance

1.实验环境

数据库环境

   
   
   
    
    
    
     
     
     [oracle@Rac1 ~]$ sqlplus / as sysdba
    
    
    
    
    
    
     
     
      
    
    
    
    
    
    
     
     
     SQL*Plus: Release 11.2.0.1.0 Production on Tue Oct 13 15:17:52 2015
    
    
    
    
    
    
     
     
      
    
    
    
    
    
    
     
     
     Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    
    
    
    
    
     
     
      
    
    
    
    
    
    
     
     
      
    
    
    
    
    
    
     
     
     Connected to:
    
    
    
    
    
    
     
     
     Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    
    
    
    
    
    
     
     
     With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
    
    
    
    
    
    
     
     
     Data Mining and Real Application Testing options
    
    
    
    
    
    
     
     
      
    
    
    
    
    
    
     
     
     SQL> select name from gv$database;
    
    
    
    
    
    
     
     
      
    
    
    
    
    
    
     
     
     NAME
    
    
    
    
    
    
     
     
     ---------
    
    
    
    
    
    
     
     
     RACDB
    
    
    
    
    
    
     
     
     RACDB
    
    
    
    
    
    
     
     
      
    
    
    
    
    
    
     
     
     SQL> select inst_id,instance_name,version from gv$instance;
    
    
    
    
    
    
     
     
      
    
    
    
    
    
    
     
     
        INST_ID INSTANCE_NAME    VERSION
    
    
    
    
    
    
     
     
     ---------- ---------------- -----------------
    
    
    
    
    
    
     
     
     	 1 racdb1	    11.2.0.1.0
    
    
    
    
    
    
     
     
     	 2 racdb2	    11.2.0.1.0
    
    
    
    
    
    
     
     
      
    
    
    
    
    
    
     
     
     SQL>

节点1的service

   
   
   
    
    
    
     
     
     LSNRCTL> service
    
    
    
    
    
    
     
     
     Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    
    
    
    
    
    
     
     
     Services Summary...
    
    
    
    
    
    
     
     
     Service "+ASM" has 1 instance(s).
    
    
    
    
    
    
     
     
       Instance "+ASM1", status READY, has 1 handler(s) for this service...
    
    
    
    
    
    
     
     
         Handler(s):
    
    
    
    
    
    
     
     
           "DEDICATED" established:0 refused:0 state:ready
    
    
    
    
    
    
     
     
              LOCAL SERVER
    
    
    
    
    
    
     
     
     Service "racdb" has 1 instance(s).
    
    
    
    
    
    
     
     
       Instance "racdb1", status READY, has 1 handler(s) for this service...
    
    
    
    
    
    
     
     
         Handler(s):
    
    
    
    
    
    
     
     
           "DEDICATED" established:897 refused:0 state:ready
    
    
    
    
    
    
     
     
              LOCAL SERVER
    
    
    
    
    
    
     
     
     Service "racdbXDB" has 1 instance(s).
    
    
    
    
    
    
     
     
       Instance "racdb1", status READY, has 1 handler(s) for this service...
    
    
    
    
    
    
     
     
         Handler(s):
    
    
    
    
    
    
     
     
           "D000" established:0 refused:0 current:0 max:1022 state:ready
    
    
    
    
    
    
     
     
              DISPATCHER <machine: Rac1, pid: 19223>
    
    
    
    
    
    
     
     
              (