oracle 10.2.0 在不插網線安裝時，網絡由用戶驗證，安裝完畢后重啟機子，插網線啟動oracle服務時，總是出現監聽失敗，這時可進行如下修改：打開oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
將
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\soft\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
中紅色標識的localhost改為機器名，如：mycoputer