Database - RAC/Scalability (MOSC)

MOSC Banner

Database links to RAC database

edited Feb 23, 2010 4:37AM in Database - RAC/Scalability (MOSC) 11 commentsAnswered
 We implement our first production RAC database last year, which is comprised of 2 instances, each on a separate node.  Originally, database links from other databases were allowed to connect to the RAC database through either instance, which was similar to any other client.  We experienced issues with these database links including connection (sporadic disconnects and connection failure) and locking (objects locked/blocked in distributed transaction) issues.  As part of troubleshooting, we decided to force the database links to connect to a single instance of the RAC configuration.  Afterward, the issues disappeared.

Obviously, our solution deminishes the redundancy value of RAC.  We'd like to allow the database link to connect to either instance.  But, we'd also like to avoid the issues we experienced when it did.

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