Oracle连接关闭分析 Diagnosing the ORA-12537: TNS: connection
原文出自:
http://www.dba-oracle.com/t_ora_12537_tns_error.htm
Question: I'm trying to connect to Oracle and I get the ORA-12537: TNS: connection closed error. How do I fix an ORA-12537? Answer:The ORA-12537 is an informational error,and the "real" error is the secondary error message.
The ORA-12537 error sometimes relates configuration issues in the sqlnet.ora,protocol.ora and listener.ora files. Verify that you service names match between your listener and remote client connect strings. This ORA-12537 can also happen if your firewall has disconnected idle connections.
这里专家说了,检查 1. client连接的service name与服务器上是否一致. 2.服务器是否有防火墙过滤. 排除这两种情况后会有以下场景.
Also,the ORA-12537 sometimes happens in these cases: 1. You have a path name that is too long for the Oracle TNS client. See MOSC note:263489.1.
2. Bug:1566794: CONNECTIONS FAIL WITH ORA-12537 WHEN USE_SHARED_SOCKET IS SET IN 8.1.7. Resolution is to set USE_SHARED_SOCKET to FALSE.
设置USE_SHARED_SOCKET 但搜了下,博文里又说要设为true http://blog.csdn.net/bisal/article/details/36424093 3. Tnsping Net Service Name fails with TNS-12537: TNS:connection closed or Sqlplus connection errors out with Ora-12537
4. For ORA-12537 relating from inter-version connections. You can get the ORA-12537 error if you listed 10g database SID with 9i listener. 这个太奇怪,为什么listener会不是Oracle最新的版本的呢?... 5. In Oracle Apps 11i,you can get the ORA-12537because of an eBusiness Suite security feature (See MOSC note 291897.1). The fix is to edit your sqlnet.ora file to include the client IP address in the tcp.invited_nodes = (x.x.x.x,hostname,...).
还是加可信IP (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |