這是報錯框
這是listener.ora的全部內容{
# listener.ora Network Configuration File: E:\app\orcl\product\12.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = E:\app\orcl\product\12.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\app\orcl\product\12.2.0\dbhome_1\bin\oraclr12.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.124.2)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
}
這是tnsnames.ora的全部內容{
# tnsnames.ora Network Configuration File: E:\app\orcl\product\12.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 194.168.124.2)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.124.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
}
別的東西我都沒動過 ,這兩個檔案的host值原來是localhost我改成了我的主機名。我是java初學者 今天剛學到oracle， 本來好好的可以用 ， 到了要用DESC讀取表格的時候就怎么也讀不出來（寫出來的表格是正常的）。后來DQL Developer程式就卡住了 。我強退了一下再進就這樣了，求指教， 謝謝。
uj5u.com熱心網友回復：
LISTENER_ORCL =(ADDRESS = (PROTOCOL = TCP)(HOST = 194.168.124.2)(PORT = 1521))
這個配置是錯誤的，缺少DESCRIPTION = 。。。。很多資訊。
你把它洗掉后，看下能不能登錄。
uj5u.com熱心網友回復：
我試了，還是不行，報一樣的錯。DESCRIPTION = 。。。。下面不是都有嗎？
uj5u.com熱心網友回復：
主機名改成 localhost或者127.0.0.1轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/38322.html
標籤：基礎和管理