關於資料庫連線問題的一般解決方法

關於資料庫連線問題的一般解決方法

 

一般步驟：

驗證網路連線
 ping IP-Address
驗證網路名稱解析
 ping symbolic-hostname
驗證net8連線和名稱解析
 tnsping connect-string
驗證資料庫例項可用性
 SQL*Plus
常見問題：
 
TNS-12154 "TNS:could not resolve service name"
TNS-12545 "TNS:name lookup failure"
TNS-12203 "TNS:unable to connect to destination"
ORA-03113 "end-of-file on communication channel"
Solution : either the specified HOST, the Oracle database instance, or your particular Oracle server process terminated
abnormally after connection established
either the specified HOST machine is 'down' or the SQL*Net listener at the specified HOST and PORT is not running
not a valid network hostname; either 'typo' or a network DNS failure (try using only IP address instead)
connect string you specified is not in TNSNAMES.ORA
HOST specified the SQL*Net