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

ORA-12505错误

sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

tnsnames.ora里设置的service_name是orcl_db，结果查询出来的sid对应的是orcldb，没有下划线。

	(DESCRIPTION = 
		(ADDRESS_LIST = 
			(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
		)
		(CONNECT_DATA =
			(SERVICE_NAME = orcl_db)
		)
	)

查看你的SID,win+R，输入sqlplus / as sysdba，然后输入show parameter instance_name;(别忘记分号)。在连接时，填入正确的SID。