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.