ORA-03114 PLSQL process compilation disconnection Error

Oracledata database objects are ineffective, through plsqldev.exe program for package compilation; Reported ORA-03114: database connection failure error.

Oracle DB version: 9.2.0.1

Cause of failure: the PLSQLDev.exe program conflicts with the CDC function of the Oracle database. Other client tools such as TOAD and OEM do not have the above situation.

Troubleshooting:

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 Introduction

CDC (Change Data Capture) is an incremental extraction solution implemented by oracle at the database level. In the general ETL process, for incremental extraction,

It is nothing more than adding time truncation, full record comparison, keyword segment comparison, log analysis and extraction methods to the data, or you need to modify the original table structure,

A large number of algorithms or third-party tools are required. The CDC feature introduced by Oracle from 9i,

This gives you the opportunity to directly implement the incremental extraction function at the database level. In terms of performance, the direct integration with the database engine should have some advantages over third-party tools.

CDC has two modes: synchronous and asynchronous. The implementation mechanisms of the two modes are completely different. Synchronization of CDC mainly uses triggers to record new data, which can basically achieve real-time incremental extraction.

Asynchronous CDC obtains incremental data information by analyzing the logs that have already been committed. It has a certain time delay and provides an interface to Oracle Streams.

Synchronous CDC can be used in both the Enterprise Edition and Standard Edition, while asynchronous CDC is only included in the Enterprise Edition. Note that the CDC has changed a lot in 9i and 10g,

Asynchronous CDC mainly uses the same technology as Streams.

CDC divides the system into two roles: publisher and subscriber. The publisher is mainly responsible for capturing incremental data, and the subscriber transfers the incremental data to the actual application.

These tasks can be implemented through the PL/SQL package provided by oracle.

The following is Oracle information:

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 cocould 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