Oracle 異常處理匯總

標籤：

Oracle 異常處理匯總1、plsql無法串連

安裝oracle，中間錄入密碼，使用者是：sys，pass: 錄入的密碼。

串連資料庫，建議建立新的使用者，最好別直接用sys

安裝完畢，則需要配置Net Configration Assistant，才能通過pl/sql串連

確保服務監聽服務已經啟動

2、遇到ORACLE錯誤12514

解決方案：

1) 找到監聽檔案

C:\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora

開啟：

# listener.ora Network Configuration File: C:\Oracle\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools.LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-L7MD6EPHO8Q.localdomain)(PORT = 1521))    )  )ADR_BASE_LISTENER = C:\Oracle

修改為：

# listener.ora Network Configuration File: C:\Oracle\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools.LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-L7MD6EPHO8Q.localdomain)(PORT = 1521))    )    (SID_DESC =       (GLOBAL_DBNAME = orcl)       (ORACLE_HOME = \product\11.2.0\dbhome_1)       (SID_NAME = orcl)     )   )ADR_BASE_LISTENER = C:\Oracle

ORACLE_HOME： oracle安裝目錄

GLOBAL_DBNAME: 執行個體名，預設為orcl

2) 重啟監聽器，當然可以在windows服務中重啟

開啟cmd，執行：

    lsnrctl stop   // 關閉    lsnrctl start  // 啟動

 

3、oracle 11g如果遇到這個問題12514

解決方案：

1、SID_NAME改為具體的執行個體名，如：orcl

2、刪除  (PROGRAM = extproc)

# listener.ora Network Configuration File: D:\oracle\product\11.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 = D:\oracle\product\11.2.0\dbhome_1)      (PROGRAM = extproc)      (ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")    )  )SID_LIST_ORCL =  (SID_LIST =    (SID_DESC =      (SID_NAME = CLRExtProc)      (ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)      (PROGRAM = extproc)      (ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")    )  )LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.134)(PORT = 1521))    )  )ADR_BASE_LISTENER = D:\oracle

 

4、imp還原資料庫時報錯：錯誤12514

IMP-00058: 遇到 ORACLE 錯誤 12514ORA-12514: TNS: 監聽程式當前無法識別串連描述符中請求的服務IMP-00000: 未成功終止匯入

 

 注意匯入的執行個體名是否正確，可參考上述解決方案。

 

Oracle 異常處理匯總