When I try to connect to my Oracle RAC test environment via SCAN name with SQL Developer, I got the error “ORA-12505, TNS:listener does not currently know of SID given in connect descriptor” .
RAC1 is my ORACLE_SID name. SQL Developer version is 3.2
If I use the same string connect from SQLplus, it works fine as screenshot below:
After googling, I found the solution in SQL Developer by using the JDBC connection string:
Not sure why the SQL developer behavior this way, but at least I have the solution. I will update the post if I found more information.