Database - RAC/Scalability (MOSC)

MOSC Banner

RAC connection credential using sql developer

edited Sep 28, 2016 2:52PM in Database - RAC/Scalability (MOSC) 6 commentsAnswered ✓

RAC database version 12.1.0.2

This is my very first time ever touching RAC and I have never work with RAC before.

I have created database using dbca with asm for this RAC. The global_dbname is PROD and it created PROD1 on node0 and PROD2 on node1.

I am trying to connect to this RAC db from sql developer.

I used the cluster VIP ip address as host name with the correct port and if I enter the global_dbname PROD, it would not connect and it will say ora-12505 TNS listener does not currently know of the SID. But if I tried to user PROD1, it connects with no issue. My question is why can it use the actual db name?

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