Oracle ORA-12541,ORA-12514錯誤

標籤：固定   重啟   rod   效果   安裝   clr   global   user   file   

1.昨天發布tomcat 成功，但登入後報錯，無法開啟hibernate session，檢查後探索資料庫無法串連

2.用PL/SQL登入資料庫，報 ora-12541，TNS 無監聽程式，百度發現需要配置監聽，不得其解，因為我也沒動過資料庫，就嘗試按照方法配置一遍

 

可以參考 http://www.cnblogs.com/Venom/p/3953025.html 

然後不停重啟

 3.還是不行，又查到說在安裝目錄下變更檔配置，私以為兩者應該效果一樣。還是找到目錄下檔案開啟瞅瞅

我的目錄是：E:\app\albertfg\product\11.2.0\dbhome_1\NETWORK\ADMIN

在該目錄下有3個檔案：listener.ora；sqlnet.ora；tnsnames.ora；

4.第一個檔案：

 

# listener.ora Network Configuration File: E:\app\username\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =    (GLOBAL_DBNAME = ORCL)      (ORACLE_HOME = E:\app\username\product\11.2.0\dbhome_1)    (SID_NAME = ORCL)    )    (SID_DESC =             (SID_NAME = CLRExtProc)      (ORACLE_HOME = E:\app\albertfg\product\11.2.0\dbhome_1)      (PROGRAM = extproc)      (ENVS = "EXTPROC_DLLS=ONLY:E:\app\username\product\11.2.0\dbhome_1\bin\oraclr11.dll")    )  )LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))    )  )ADR_BASE_LISTENER = E:\app\username

5：第三個檔案：

# tnsnames.ora Network Configuration File: E:\app\username\product\11.2.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORACLR_CONNECTION_DATA =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))    )    (CONNECT_DATA =      (SID = CLRExtProc)      (PRESENTATION = RO)    )  )LISTENER_ORCL =  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))ORCL =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = ORCL)    )  )

6.這樣改完仍沒用，報ora-12514

 

後來又百度發現重啟oracle伺服器，無奈，重啟了一下電腦，恢複正常了。

7.小結：後來回想，主要是區域網路內IP地址動態分配的，雖然我給了伺服器固定ip，但昨天由於回來遲了，室友先開了機，恰巧又分配了伺服器的ip地址

導致我的配置失效。記得以前也出現過一次，可惜沒長記性，所以還是寫點簡單的記錄吧。

 

Oracle ORA-12541,ORA-12514錯誤