Oracle RAC server connection Load Balance)

The server Load balancer of the Oracle RAC server distributes new connection requests to the node with the smallest load based on the number of connection loads of each node in the RAC. When the database is running, the PMON process of each node in RAC updates the connection load of each node to service_register every three seconds. When any listener failure or unexpected failure occurs on the node, the PMON process checks whether the listener on the current node is restarted every second to obtain the latest load information and adjust the load balancing in time. This article mainly demonstrates server load balancing Under SUSE 10 + oracle 10g rac.

For more information about Server Load balancer on the client, see

Load Balance)
Configure RAC load balancing and Failover

For more information about the basics and concepts of Oracle network configuration, see:

Non-Default port listening configuration in oracle rac (listener. ora tnsnames. ora)

I. Server Load balancer Configuration

1. 1. Add the corresponding network service name for tnsnames. ora (configured for each node)
2. Oracle @ bo2dbp: ~> More $ ORACLE_HOME/network/admin/tnsnames. ora
3. # Tnsnames. ora Network Configuration File:/u01/oracle/db/network/admin/tnsnames. ora
4. # Generated by Oracle configuration tools.
6. Remote_lsnr_gobo4 =
7. (ADDRESS_LIST =
8. (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.7.61) (PORT = 1521 ))
9. (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.7.62) (PORT = 1521 ))
10. )
12. Local_lsnr_gobo4a =
13. (ADDRESS_LIST =
14. (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.7.61) (PORT = 1521 ))
15. )
17. Local_lsnr_gobo4b =
18. (ADDRESS_LIST =
19. (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.7.62) (PORT = 1521 ))
20. )
22. 2. Set the remote_listener parameter.
23. Alter system set remote_listener = '<net_service_name> 'scope = both sid = '*';
25. SQL> show parameter instance_name
27. NAME TYPE VALUE
28. -----------------------------------------------------------------------------
29. Instance_name string GOBO4A
30. SQL> show parameter listener
32. NAME TYPE VALUE
33. -----------------------------------------------------------------------------
34. Local_listener string
35. Remote_listener string
37. SQL> alter system set remote_listener = 'remote _ lsnr_gobo4 'scope = both sid = '*';
39. System altered.
41. 3. Configure the client tnsnames. ora
42. --> The client is suse 10.
43. SZDB :~ # Ifconfig eth1 | grep "inet addr" | cut-d ""-f12 | cut-d:-f2 # -- ip address of the client host
44. 192.168.7.2
45. SZDB :~ # Su-oracle
46. Oracle @ SZDB: ~> Tail-10 $ ORACLE_HOME/network/admin/tnsnames. ora
47. GOBO4 =
48. (DESCRIPTION =
49. (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.7.61) (PORT = 1521 ))
50. (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.7.62) (PORT = 1521 ))
51. (LOAD_BALANCE = off) # -- disable the client load balancing option because only the Server Load balancer is tested.
52. (CONNECT_DATA =
53. (SERVER = DEDICATED)
54. (SERVICE_NAME = GOBO4)
55. )
56. )
57. # Author: Robinson Cheng
58. # Blog: http://blog.csdn.net/robinson_0612
60. 4. Check the listener
61. Oracle @ bo2dbp: ~> Lsnrctl status
62. Listening Endpoints Summary...
63. (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 192.168.7.61) (PORT = 1521 )))
64. (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 192.168.7.51) (PORT = 1521 )))
65. Services Summary...
66. Service "+ ASM" has 1 instance (s ).
67. Instance "+ ASM1", status BLOCKED, has 1 handler (s) for this service...
68. Service "GOBO4" has 2 instance (s ).
69. Instance "GOBO4A", status READY, has 2 handler (s) for this service...
70. Instance "GOBO4B", status READY, has 1 handler (s) for this service ..
71. .......
73. Oracle @ bo2dbs: ~> Lsnrctl status
74. Listening Endpoints Summary...
75. (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 192.168.7.62) (PORT = 1521 )))
76. (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 192.168.7.52) (PORT = 1521 )))
77. Services Summary...
78. Service "+ ASM" has 1 instance (s ).
79. Instance "+ ASM2", status BLOCKED, has 1 handler (s) for this service...
80. Service "GOBO4" has 2 instance (s ).
81. Instance "GOBO4A", status READY, has 1 handler (s) for this service...
82. Instance "GOBO4B", status READY, has 2 handler (s) for this service...
83. ..........
85. # -- If the listener or database needs to be restarted, restart the listener or database.
86. # -- The following is a clear listener log to facilitate subsequent statistics on connection information.
87. Oracle @ bo2dbp:/u01/oracle/db/network/log> cat/dev/null> listener_bo2dbp.log
88. Oracle @ bo2dbs:/u01/oracle/db/network/log> cat/dev/null> listener_bo2dbs.log

1 2 Next Page