springboot连接oracle报错：listener does not currently know of SID given in connect descriptor

部门报错截图如下

[main] [com.zaxxer.hikari.pool.HikariPool]-[DEBUG] HikariPool-1 - Cannot acquire connection from data source
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
 
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:774)
	at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:688)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136)
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369)
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198)

分析发现applcation.yml的oracle配置项有误

spring:
  datasource:
    driver-class-name: oracle.jdbc.OracleDriver
    username: system
    password: system
    url: jdbc:oracle:thin:@IP:1521:orcl

IP换成oracle的服务IP，后面的orcl要配置成服务名称

 像楼主这种情况，url正确配置

jdbc:oracle:thin:@你的服务IP:1521:helowin

问题解决 可以正常操作orale数据库