Autoconfig failed during bisdblrp.sql
Issue: Found Ora-600 error in alert log while dropping a database link.
Error Message :
ORA-00600: internal error code, arguments: [16500], [kqdDBLinkUpdate], [3], [2], [EDW_APPS_TO_WH.WORLD], [], [], [], [], [], [], []
Current SQL from trace file:
drop database link EDW_APPS_TO_WH.WORLD;
Reason:
There are 2 database links in the database with same name.
SQL> select * from dba_db_links where db_link='EDW_APPS_TO_WH.WORLD';
APPS EDW_APPS_TO_WH.WORLD APPS TEST 24-JUL-12
APPS EDW_APPS_TO_WH.WORLD APPS TEST 25-JUL-12
Solution:
Drop the database links from SYS.LINK$ table using below command:
SQL> delete from sys.link$
2 where NAME='EDW_APPS_TO_WH.WORLD';
No comments:
Post a Comment