[oracle@SVR_3-111 ~]$ oerr tns 510
00510, 00000, "Internal limit restriction exceeded"
// *Cause: Too many files or sockets open simultaneously (or some other
// resource has been depleted).
// *Action: For further details, trace the operation for protocol
// details.
[oracle@SVR_3-111 ~]$ oerr tns 12540
12540, 00000, "TNS:internal limit restriction exceeded"
// *Cause: Too many TNS connections open simultaneously.
// *Action: Wait for connections to close and re-try.
在sqlnet.log日志文件里面提示的是:
VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.0.1.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.0.1.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.0.1.1.0 - Production
Time: 18-11月-2011 10:25:42
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12540
TNS-12540: TNS:超出内部极限限制
ns secondary err code: 12560
nt main err code: 510
TNS-00510: 超出内部极限限制
nt secondary err code: 8
nt OS err code: 0
以下仅供参考。
解决方法为:去掉cdc功能。
操作为:
DROP TRIGGER sys.cdc_alter_ctable_before;
DROP TRIGGER sys.cdc_create_ctable_after;
DROP TRIGGER sys.cdc_create_ctable_before ;
DROP TRIGGER sys.cdc_drop_ctable_before;
CALL sys.dbms_java.dropjava('-s rdbms/jlib/CDC.jar');