I can use both in the CONNECT command in sqlplus.
node1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = eiger.reksoft.ru)(PORT = 1522)) (CONNECT_DATA = (SERVICE_NAME = PPB) ) ) node2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = RAC.localdomain) ) )
Not very informative, so I attached a java debugger and set breakpoints on SQLException constructors.
CONNECT scott/tiger@node1 Connected ... CONNECT scott/tiger@node2 Error starting at line 2 in command: CONNECT scott/tiger@node2 Error report: Connection Failed Commit
I think sqldeveloper is trying to connect using SID instead of SERVICE_NAME.
"Listener refused the connection with the following error:\nORA-12505, TNS:listener does not currently know of SID given in connect descriptor\n " 66000 12505