Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RECO issue

user4874781Jul 19 2009 — edited Jul 21 2009
I am transferring data from 1 db ( 7.3.4.1 ) to another db within the same Solaris box via a dblink.
Data is being moved and deleted from source database just fine.

But I keep getting this error in the alert log :

Errors in file /db01/oracle/ARK/DUMP/bdump/ark_reco_27548.trc:
ORA-02019: connection description for remote database not found

Also when I attempt to shutdown the target db I run into :

Sun Jul 19 06:55:44 2009
SHUTDOWN: waiting for detached processes to terminate.
Sun Jul 19 06:58:34 2009
Errors in file /db01/oracle/ARK/DUMP/bdump/ark_reco_7481.trc:
ORA-02019: connection description for remote database not found
Sun Jul 19 06:58:34 2009
Errors in file /db01/oracle/ARK/DUMP/bdump/ark_reco_7481.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 1 cannot be read at this time
ORA-01110: data file 1: '/db01/oracle/ARK/SYSTEM/SYSTEM_01.dbf'

And it will freeze at the dismount stage and I can see the RECO process being active.

The only way this shutsdown the instance for the db is if I shutdown the source db as well.

Any clues ?
SVRMGR> select * from dba_db_links;
OWNER                          DB_LINK                                                                          USERNAME
                  HOST                                                                             CREATED
------------------------------ -------------------------------------------------------------------------------- -------------
----------------- -------------------------------------------------------------------------------- ---------
ARCHIVE                        SDB.WORLD                                                                        WPP_LIVE
                  HR_LIVEC                                                                         13-JUL-09
1 row selected.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 18 2009
Added on Jul 19 2009
12 comments
1,400 views