Shulou(Shulou.com)06/01 Report--

The following brings you how to connect Oracle 12c applications to VIP rotation load balancing, hoping to bring some help to you in practical application. Load balancing involves more things, there are not many theories, and there are many books on the Internet. Today, we will use the accumulated experience in the industry to do an answer.

At present, many production databases are two-node RAC, and the database connected by the application usually connects to SCAN IP or VIP. Here we do a small experiment if we use VIP to connect.

How to configure our client and whether load balancing is strictly a rotational training mechanism can only be answered through our own tests.

Tnsnames.ora configuration

$less tnsnames.ora

# tnsnames.ora Network Configuration File: / u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

Orcl =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = rac-scan) (PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

Vip =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.203) (PORT = 1521))

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.204) (PORT = 1521))

(LOAD_BALANCE = yes)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

two。 The test script is as follows

$

$less load_balance.sh

#! / bin/bash

For i in {1..100}

Do

Echo $I

Sqlplus-S system/oracle@vip

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.