racle 的Developer連接不上報錯:listener does not currently know of SID given in connect descriptor
解決辦法:
在 D:/app/Administrator/product/../dbhome_/NETWORK/ADMIN中找到listener.ora文件,修改后的文件在“下面”中,復制并覆蓋就ok了。
# listener.ora Network Configuration File: D:/app/Administrator/product/../dbhome_/network/admin/listener.ora
# Generated by Oracle configuration tools.
把listener.ora中的配置改成如下即可:
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:/app/Administrator/product/../dbhome_) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:/app/Administrator/product/../dbhome_/bin/oraclr.dll") ) (SID_DESC = (GLOBAL_DBNAME = orcl) (ORACLE_HOME = D:/app/Administrator/product/../dbhome_) (SID_NAME = orcl) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = )) ) ) ADR_BASE_LISTENER = D:/app/Administrator
如按照以上操作還是連接不上,可能是你的SID錯誤!
解決方法:http://m.survivalescaperooms.com/article/73178.htm
新聞熱點
疑難解答