[Oracle] ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

문제 상황

Oracle 연동 중에 connect 에러 발생.

tomcat 구동 시 저런 에러가 콘솔 창에 찍힌다.

무슨 ora 파일 변경은 하지 않았다.

에러 코드

java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
 
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
	at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:553)
	at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:254)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
	at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
	...

Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
 
	at oracle.net.ns.NSProtocol.connect(NSProtocol.java:399)
	at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)
	... 83 more

문제 해결

connect 문제는 database url에 문제가 있을때 발생하는 것 같다.

url을 정상적으로 입력하니 해결.

database.driver=oracle.jdbc.driver.OracleDriver
database.url=jdbc:oracle:thin:@//127.0.0.1:1521/testdb/testdb2?characterEncoding=UTF8

를 아래로 변경.

MySQL과 oracle이 헷갈려서, database.url 값이 정상적이지 않다.

database.driver=oracle.jdbc.driver.OracleDriver
database.url=jdbc:oracle:thin:@//127.0.0.1:1521/testdb