1. PL/SQL连接oracle出现ORA-12514错误
注意看图中画出的重点
2. java 连接的时候报错
连接URL
.option("url","jdbc:oracle:thin:@//47.97.11.138:1522/XE")
java.sql.SQLRecoverableException: 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:774)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:688)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)
这个 XE
可能不对,需要指定正确的信息