ORA-12505, TNS:listener does not currently know of SID given in connect descript

在项目中连接数据库是出现以下问题

TrpasCon() error2:Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
10.61.1.11:1521:snxxdb

看提示应该是SID错误，但在tnsnames中配置的SID确实是snxxdb

后来用

select instance_name,host_name from v$instance;

INSTANCE_NAME
----------------------------------------------------------------
snxxdb1
原来是集群数据库，把10.61.1.11:1521:snxxdb改成10.61.1.11:1521:snxxdb1就ok了