转载自:http://www.ithao123.cn/content-2009271.html
本日正在用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:list]
今天在用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");
or
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@ localhost:1521:orcl","scott","tiger");
or
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@ localhost:1521:pdborcl","scott","tiger");
以上三种写法都会报错。
博主从网上找了很久,终于知道,这个是oracle 12c的版本问题,以下给出解决方案:
1,首先进入到oracle主目录下:..product12.1.0dbhome_1NETWORKADMIN
找到tnsnames.ora,并打开,在其中加入:
PDBORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PDBORCL)
)
)
2,修改以上的错误代码:
<span style="color: rgb(51, 51, 51);"><span style="color:#009900;">Connection conn = DriverManager.getConnection("</span><span style="color:#ff0000;"><span style="color:#ff0000;">jdbc:oracle:thin:@localhost:1521/pdborcl</span></span><span style="color:#333333;">","scott","tiger");</span></span>
这个是oracle 12c有别与其他版本的连接写法。端口1521后一定是“/”才能成功,否则报错ora-12505,无法识别sid;所以用eclipse的database是无法连接oracle12c的pdb的。
好了,测试下吧,应该能连上数据库了。
想深入了解oracle 12c jdbc的可以进入以下链接:
1,Oracle 12c jdbc connect string for PDB
参考资料:
https://community.oracle.com/message/11263323
https://community.oracle.com/thread/2566804?start=0&tstart=0