Oracle服务和SID混用
特征
// 混用
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
// 错用
ORA-12514, TNS:listener does not currently know of service requested in conn
原因
服务名和SID混用,比如应该写服务名的地方写成了SID,反之亦然
也有可能是服务名根本就写错了,写Spring Boot的配置文件时一定要注意它的链接
解决
//sid写法(最后是:)
database.url=jdbc:oracle:thin:@ipaddr