Database - RAC/Scalability (MOSC)

MOSC Banner

RAC services in 19c

in Database - RAC/Scalability (MOSC) 2 commentsAnswered

Hi

we have a question on the 19c RAC DB services

If we create a service for a 2 node 19c RAC DB like below

srvctl add service -d testdb -s testapp -r node1,node2 -P BASIC -e SELECT -m BASIC -z 15 -w 5 -j LONG

The application once started would create connection on both nodes. Correct?

Now if one of the nodes, lets say node1 goes down, all the existing connection will fail over to node0 and any new connection will connect to node0 as well. Correct?

Once node1 comes back online, it seems that the new connections once again would start to connect to both nodes but the existing connections would remain on node0. Correct? If yes, what options we would have to re-balance the connections to both nodes in that scenario?

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