oracle 12c之jdbc连接可拔插数据库pdb的问题

待我称王封你为后i 2022-08-12 00:24 189阅读 0赞

今天在用jdbc连接oracle 12c数据库时遇到以下错误：

java.sql.SQLException: ORA-01017: invalid username/password; logon denied

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

连接的代码是这样的：

Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@ localhost:1521/orcl","scott","tiger");

Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@ localhost:1521:orcl","scott","tiger");

Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@ localhost:1521:pdborcl","scott","tiger");

以上三种写法都会报错。

博主从网上找了很久，终于知道，这个是oracle 12c的版本问题，以下给出解决方案：

1，首先进入到oracle主目录下：..\\product\\12.1.0\\dbhome\_1\\NETWORK\\ADMIN

找到tnsnames.ora，并打开，在其中加入：

PDBORCL =  
  (DESCRIPTION =  
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))  
    (CONNECT\_DATA =  
      (SERVER = DEDICATED)  
      (SERVICE\_NAME = PDBORCL)  
    )  
  )

2,修改以上的错误代码：

<span style="color:#009900;">Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@ localhost:1521/pdborcl","scott","tiger");</span>

这个是oracle 12c有别与其他版本的连接写法。

好了，测试下吧，应该能连上数据库了。

想深入了解oracle 12c jdbc的可以进入以下链接：

1，[Oracle 12c jdbc connect string for PDB][]

参考资料：

[https://community.oracle.com/message/11263323][https_community.oracle.com_message_11263323]

[https://community.oracle.com/thread/2566804?start=0&tstart=0][https_community.oracle.com_thread_2566804_start_0_tstart_0]

[Oracle 12c jdbc connect string for PDB]: http://joinxin.blogspot.com/2013/10/oracle-12c-jdbc-connect-string-for-pdb.html
[https_community.oracle.com_message_11263323]: https://community.oracle.com/message/11263323
[https_community.oracle.com_thread_2566804_start_0_tstart_0]: https://community.oracle.com/thread/2566804?start=0&tstart=0