ora 2063 while retrieving data from another database

[kerath]

Hi, hope anyone can help me.

i have 3 databases and 1 should hold backups from the other 2 DB's. To do this I have written a scheduler to start a task, which executes a procedure.
The procedure copies the data via dblink in following format:

Insert into table tablename select (...) from table@dblink!

For one Database this works fine. The Task runs when no users are working normally at 20:00 pm.
But the other fails with different behaviors. Mostly an 2063 occur after 56 from 58 tables (often at empty tables).
Sometimes a 3113 or 3114 occurs.

The thing is that if ora 2063 occurs, no errormessage from the gateway is included so that i not know what the problem is.

I have tried different things like monitoring the router and network traffic while copying, creating a large RollBackSegment for this Transaction (Ca. 500.000 lines before commiting the Transaction), checking the Tracefiles on the Remote Machine.

When I comment some tables with a large amount of lines sometimes the procedure succeed, but not ever.

In several cases the task crashes without error and I have to restart the programm, but the problem in this case is that the last accessed table is locked and by copying again a get: try whith NOWAIT - Resource is busy (I have forgotten the Nr.)

Is there anybody who can Help identifying or fixing the problem?

Thanks

 

[sem]

I'd suggest you to find the difference between those databases: OS, patch levels, other software.

Regards, Dima

 

[kerath]

Hello Dima,

The two databases have the same environment. The only differences are that one is new build with NTSP6, ora8.1.7
and the other not because it is a Backup Domain Controller. There are more Programs i.e SNA Server running.

The Databases are migrated from 8.0.5 and the one who works is completely new. Therefore it could be that the other is to fragmented, but the thing is, why I d'ont get an describing errormessage from the Gateway, in other cases like 3113 I get it from the other side i.e.

I log errors to a table using when_other exception
In the Exception I create a string reading SQLCode, SQLErrTxt

First error the when_others from my Procedure
Than from my DB saying error from DB-link
Than the Gateway-Message 3113 from the Remote
Than Error in Procedure ... Zeile 1 from here