Oracle 9i数据库是本地的,程序也是本地的,程序一开始运行很正常。但是过了一个小时后出错,错误信息是:ORA-03114: 未连接到 ORALCE
开发工具是VC6.0+msado15.dll
操作系统:Windows xp sp3。
出现次情况时有SQL Plus可以连接到数据库。请问一下这是什么问题,该如何解决?
开发工具是VC6.0+msado15.dll
操作系统:Windows xp sp3。
出现次情况时有SQL Plus可以连接到数据库。请问一下这是什么问题,该如何解决?
解决方法为:去掉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');
在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
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.