ORA-12230: TNS:Severe Network error occurred in making this connection
Cause: This error is reported by an interchange which fails to make contact with the destination due to a physical network error while calling a destination.
Action: Try again later when the network service may have been fixed or report the problem to your Network Administrator so that he may fix the problem.
ORA-12230: TNS:Severe Network error occurred in making this connection错误有以下几种常见的情况:
1.监听的主机和客户端之间的网络不通
2. 客户端的tnsnames.ora文件有配置错误
3. 监听的服务没有启动
4. 用户连接的用户名和密码错误
5. 有firewall或者杀毒软件,阻止了客户端的连接
ORA-12230: TNS: Severe Network error occurred in making this connection的官方解释是:
TNS-12230:在建立这个连接时发生了重大网络错误。
1. 确认客户端与服务器之间的网络连接是否正常,如果不正常,需要重新设置网络。
2. 检查客户端和服务器上的tnsnames.ora文件,确认它们是否设置正确。
3. 确认监听的服务是否已经启动,如果没有启动,则应该启动监听服务。
4. 检查用户的连接用户名和密码是否正确,确认这些信息是正确的。
5. 尝试禁用firewall或关闭杀毒软件,以尝试允许客户端的连接。