Ora-03114:未连接数据库

author:skate
time:2009/10/14

---

 

Ora-03114:未连接数据库

 

现象： 在使用pl/sql developer编译时总是报 Ora-03114:未连接数据库。

 

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

 

-----------------------------------------------------------------------------------------------

 

官方文档说明：
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----