Ora-03114解决办法

张兴康

使用pl/sql developer的时候老是报错 ora-03114。

这是我们使用的客户端工具 Pl/Sql developer 和数据库的cdc产生冲突，如果使用TOAD等其他客户端工具则不会有这种情况

解决方法为：去掉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');

以下是oracle的信息： ORA-03114 not connected to ORACLE Cause: A call to Oracle was attempted when no connection was established. Usually this happens because a user-written program has not logged on. It may happen if communication trouble causes a disconnection. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier because, in those cases, the client's connection to the database is terminated without waiting for the client to issue a request. Action: Try again. If the message recurs and the program is user written, check the program

张兴康

fteair