今天打開eclipse,一連接數(shù)據(jù)庫結(jié)果就報錯,錯誤如下:
Could not obtain connection metadata
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
The Connection descriptor used by the client was:
localhost:1521:orcl
奇怪了,我就換了一個jdk版本啊....到處找毛病,怎么都沒解決掉...結(jié)果當(dāng)我打開plsql,結(jié)果才發(fā)現(xiàn)plsql也連接不上,提示oracle 監(jiān)聽程序無法識別連接描述中請求的服務(wù)..
于是在google的到處尋找問題所在,終于讓我給解決了,解決方法如下:
打開network/admin/listener.ora文件,把下面這段話加進(jìn)去:
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL)
)
加進(jìn)去后完整的如下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL)
)
)
保存,再重新啟動監(jiān)聽器,OK,一切OK....但是到現(xiàn)在我也不知道用的好好的oracle突然間出問題了...