使用oracle的过程中,oracle自动关闭DB,发出ora-03114的错误。

这是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.

解决方法是:

SQL> drop trigger sys.cdc_alter_ctable_before; 触发器已删除。 SQL> drop trigger sys.cdc_create_ctable_after; 触发器已删除。 SQL> drop trigger sys.cdc_create_ctable_before; 触发器已删除。 SQL> drop trigger sys.cdc_drop_ctable_before; 触发器已删除。 SQL> call sys.dbms_java.dropjava('-s rdbms/jlib/cdc.jar'); 调用完成。 SQL>

Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐