ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

[INFO] ------------------------------------------------------------------------


[ERROR] Failed to execute goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.2:generate (default-cli) on project MyTestMavenMvcProject: Listener refused the connection with the following error:
[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

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

注:

jdbc连接数据库的时候,需要使用数据库的sid_name,而不是数据库的services_name.

而使用plsql连接数据库的时候,只需要数据库的services_name即可,所以修改连接字符串中的services_name 为sid_name.


查询sid_name的方法:
select INSTANCE_NAME from v$instance;

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor