oracle 監聽無法啟動
linster.ora如下
LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xin)(PORT = 1521))
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
ADR_BASE_LISTENER = G:\app\zhangsan\product\12.1.0\dbhome_1\log
使用127.0.0.1 和 主機名都不可以
命令列手動啟動 監聽服務 也不行 如圖：
tnsnames.ora 如下
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
奇怪的是 使用sql plus 可以登錄用戶
求助大神
uj5u.com熱心網友回復：
tnsnames是客戶端配置，listener.ora是服務器端配置，你后面sqlplus能連到資料庫，是因為你這種連接方式已經繞過了監聽，也就服務器上能這么搞搞了。其實你把那個監聽組態檔listener.ora給刪了，我估計你的問題就解決了
uj5u.com熱心網友回復：
你搞個靜態監聽，把LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xin)(PORT = 1521))
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
刪掉
用
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(SID_NAME = orcl)
(ORACLE_HOME = D:\Oracle_12C\Administrator\product\12.2.0\dbhome_1)
)
GLOBAL_DBNAME 資料庫名，SID_NAME 實體名 ORACLE_HOME 路徑
然后你看你的系統環境變數里面有木有 Oracle_home
基本上應該這些就沒啥問題了
uj5u.com熱心網友回復：
你首先開開Oracle服務器有沒有打開，確定打開后再查詢組態檔夾問題；建議你搞個靜態監聽：# listener.ora Network Configuration File: D:\app\admin\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\admin\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\admin\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\app\admin
uj5u.com熱心網友回復：
我也是同樣的問題 搞了一上午沒解決按照樓上3中方法都試過了，沒用
現在還沒解決 樓主問題是解決了嗎
uj5u.com熱心網友回復：
服務器上是不是同時存在幾個不同的oracle資料庫版本，或是同時存在oracle服務端和客戶端，是的話可以檢查下path設定的對嗎uj5u.com熱心網友回復：
使用 netca 這個命令列，重新配置一下。uj5u.com熱心網友回復：
你試試在你的任務管理器打開轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/53985.html
標籤：開發
上一篇：oracle優化問題