冷静、沉淀

关于数据库连接问题的一般解决方法

上一篇 / 下一篇 2004-10-23 00:00:00 / 个人分类：Oracle

关于数据库连接问题的一般解决方法

From Tim Gorman

一般步骤：

验证网络连接
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