[转载]ora-03114:未连接数据库
Ora-03114:未连接数据库
现象: 在使用pl/sql developer编译时总是报 Ora-03114:未连接数据库。
解决方法:
故障原因:PLSQLDev.exe程序和Oracle数据库的CDC功能产生冲突;使用TOAD,OEM等其他客户端工具则不会有以上情况。
操作为:
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 CDC简介
官方文档说明:
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.
----end----
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步