ORA-12505，TNS：監(jiān)聽(tīng)器當(dāng)前不知道連接描述符中給出的SID我在Windows 7 64位操作系統(tǒng)中安裝了Oracle 11g Express Edition Release 2并試圖執(zhí)行JDBC程序，然后出現(xiàn)以下錯(cuò)誤：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
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.jlcindia.jdbc.JDBCUtil.geOracleConnection(JDBCUtil.java:28)
at Lab3O.main(Lab3O.java:15)Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:385)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
... 8 more
3 回答
心有法竹
TA貢獻(xiàn)1866條經(jīng)驗(yàn) 獲得超5個(gè)贊
我通過(guò)糾正我的jdbc字符串修復(fù)了這個(gè)問(wèn)題。
例如，正確的jdbc字符串應(yīng)該是......
jdbc:oracle:thin:@myserver:1521/XE
但是我使用的jdbs字符串是......
jdbc:oracle:thin:@myserver:1521:XE
（注意：之間1521和XE應(yīng)該是/）
這個(gè)錯(cuò)誤的jdbc字符串也給我一個(gè)ORA-12505錯(cuò)誤。
呼如林
TA貢獻(xiàn)1798條經(jīng)驗(yàn) 獲得超3個(gè)贊
我也得到了同樣的錯(cuò)誤但是當(dāng)他們嘗試了所有這三個(gè)失敗時(shí)。如果以上三個(gè)失敗。如果你發(fā)現(xiàn)服務(wù)（我的情況下是XE）丟失，請(qǐng)嘗試LSNRCTL狀態(tài)試試這個(gè) 現(xiàn)在你可以看到服務(wù) 即使看不到嘗試這個(gè)sqlplus /nolog
conn system ... password ...
connected.
alter system register;
exit
lsnrctl stat
...sqlplus /nolog
conn system
... password ... connected.
alter system set local_listener = '(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))' scope = both;
... system altered ...
alter system register;
exit
lsnrctl stat
這應(yīng)該可行......
- 3 回答
- 0 關(guān)注
- 5673 瀏覽
添加回答
舉報(bào)
0/150
提交
取消