Database Administration (MOSC)

MOSC Banner

Want to connect with Local Instance Name of particular Node in Oracle RAC Database

edited Oct 27, 2016 6:03AM in Database Administration (MOSC) 7 commentsAnswered

Hello,

I have Oracle Cluster environment of 2 Nodes.

Software installed

1. Oracle Clusterware 11g R2

2. Oracle RAC Database 11g R2


Two nodes of N1 and N2 and having SCAN name S-Cluster with 2 SCAN ip address.

and N1 has Local Instance ORCL1

N2 has Local Instance ORCL2

Global Instance is ORCL

Now as my application needs that i want to connect to N1 and N2 with ORCL1 and ORCL2 respectively without using SCAN name.

Specifically i want to connect through Only N1 node and for some connection i want to connect with N2 node. I don't want Load Balancing at that time.

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