Database Networking (MOSC)

MOSC Banner

19c RAC Database - using SID in tnsnames.ora file not working

in Database Networking (MOSC) 12 commentsAnswered

We have a 2 node RAC 19c database and clients are connecting to the database remotely using tnsnames.ora file

We noticed that when the clients use SERVICE_NAME to connect to the RAC database it works but when they use SID, it does not .

We were wondering if using SID not supported anymore or is this a case of us missing something? Is there anything special we need to do to make the remote connections using SID instead of SERVICE NAMES?

This is the tnsnames entry that is not working. IF we replace the SID with SERVICE_NAME it works

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