Database Networking (MOSC)

MOSC Banner

Load Balancing in TNSNAMES.ORA

edited Jun 24, 2010 9:53AM in Database Networking (MOSC) 4 commentsAnswered
 I have two nodes on a 10.2.0.4 RAC, using Solaris 10. While configuring the new instances, we took one database & listener down, the entire server actually, and the developers were still hitting the single instance of the database throught the cluster (dbname) in the tnsnames.ora. The wait time grew from 10ms to 103s.

We have load balancing turned on in the tnsnames.ora as

RAC

server 1

server 2

load balance = yes

RAC1

server 1

RAC 2

server 2

So, I am not sure why the time would shoot up so dramatically? I started reading about trying to configure the load balancing through TAF and using FAILOVER but I'm wondering if I'm making the problem more complex than it needs to be. Can anyone give me a little bit of direction to see if there is a simpler place I should be starting?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center