ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
[INFO] ------------------------------------------------------------------------
[ERROR] ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
[ERROR] -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
注:
jdbc连接数据库的时候,需要使用数据库的sid_name,而不是数据库的services_name.
而使用plsql连接数据库的时候,只需要数据库的services_name即可,所以修改连接字符串中的services_name 为sid_name.
查询sid_name的方法:
select INSTANCE_NAME from v$instance;