How to verify whether the connections are distributed between the 2 or more database instances by using ConnectDistributionCheck.sh script (Doc ID 1591610.1)

Last updated on NOVEMBER 26, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.6 to 12.1.0.1 [Release 9.2 to 12.1]
Information in this document applies to any platform.

Goal

In a 2 or more node RAC Database, one can check if connections are getting distributed between all the database instances by using the ConnectDistributionCheck.sh script.

For example in a 2 node RAC Database, when ConnectDistributionCheck.sh is run, it will give output like below and verify if the connections are getting distributed between the two nodes/instances.

[oracle@saurs1 tmp]$ sh ConnectDistributionCheck.sh
10/11/2013_05:57:10 PM : Trial # : ORCL1
10/11/2013_05:57:10 PM : Trial # 1 : ORCL2
10/11/2013_05:57:11 PM : Trial # 2 : ORCL1
10/11/2013_05:57:11 PM : Trial # 3 : ORCL2
10/11/2013_05:57:11 PM : Trial # 4 : ORCL1
10/11/2013_05:57:11 PM : Trial # 5 : ORCL2
10/11/2013_05:57:11 PM : Trial # 6 : ORCL1
10/11/2013_05:57:12 PM : Trial # 7 : ORCL2
10/11/2013_05:57:12 PM : Trial # 8 : ORCL1
10/11/2013_05:57:13 PM : Trial # 9 : ORCL2

When the connections are not getting distributed between the RAC database instances, then it will give output like below showing all connections going to one instance only.

[oracle@saurs1 tmp]$ sh ConnectDistributionCheck.sh
10/11/2013_06:14:05 PM : Trial # : ORCL1
10/11/2013_06:14:05 PM : Trial # 1 : ORCL1
10/11/2013_06:14:05 PM : Trial # 2 : ORCL1
10/11/2013_06:14:05 PM : Trial # 3 : ORCL1
10/11/2013_06:14:05 PM : Trial # 4 : ORCL1
10/11/2013_06:14:05 PM : Trial # 5 : ORCL1
10/11/2013_06:14:06 PM : Trial # 6 : ORCL1
10/11/2013_06:14:06 PM : Trial # 7 : ORCL1
10/11/2013_06:14:06 PM : Trial # 8 : ORCL1

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms