Database Software

I am having problems with the deferred tranasactions. There were about 44,000 in the queue before. The dbms job was broken so I ran it and it was able to push half the tranactions from the 44,000 through.

However, only half. I am manually pushing the transactions through using OEM. But they do not seem to go through. Any ideas as to why they do not go through. Any alternatives to get all the deferred tranactions to being pushed?

Oracle 9.2.0.1 on W2k Svr.

The deferred tranaction queue had then incresed in size to 53,000 tranactions to be applied. I ran this query today, and get the following result.

SQL> SELECT SID, r.JOB, LOG_USER, r.THIS_DATE, r.THIS_SEC
2 FROM DBA_JOBS_RUNNING r, DBA_JOBS j
3 WHERE r.JOB = j.JOB;

SID JOB LOG_USER THIS_DATE THIS_SEC
---------- ---------- ------------------------------ --------- --------
54 8 REPADMIN 15-OCT-06 17:24:52

SQL>

Any ideas as to what to do with this information. I ran the query several times within an hour, but the ame result...any sggestions as to how to apply all the tranactions in teh deferred tranaction queue sucessfully across?

I executed the dbms jobs (which were broken) on all sites so that the DTQ empties. This was sucessfull on two of thethree master sites. However, on one of the master sites, it was only able to push half of the tranactions to one other site. This is what I am trying to resolve.

I try to manually push these transactiosn form OEM, but they do not seem to go through. Is there a way I could find wher the errors lay? I have checked all the alert logs and the trace files but no major errors.

W2K Ad Svr, Oracle 9i Release 2. and three Multimaster sites.

I even ran the following script, it executes, but does not push it through.

declare rc binary_integer; begin rc := sys.dbms_defer_sys.push(destination=>'DESTHOST.DOMAIN', stop_on_error=>FALSE, delay_seconds=>0, parallelism=>0); end;

Once again...in our Oracle 9.2.0.1 multimaster replication environmment on Windows 2000 server system containing three master sites is giving strange errors.

The transactions within defferred transaction queue at one of the sites are not being pushed at the other site. Last month, it was the other way around.

In the trace files, we can see that there are TNS connect error to the other master sites. However as soon as we restart the particular server, the transactions are pushed through.

This environment was working fine before and we were wondering as to what could be causing these errors all of a sudden.

These are only the transactions from the Deferrerd Transaction Queue which are yet to be applied to the other site. The error queue is quite constant and we are not facing much problems there.

In the trace files the errors are:

ORA-12012: error on auto execute of job 78
ORA-23324: error ORA-12535: TNS:operation timed out, while creating deferror entry at "globaldbname" with error -12535
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1716
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1804
ORA-06512: at line 1
*** 2006-11-07 22:05:42.000