Oracle Management Cloud

Introduction to Oracle Management Cloud We have been seeing so many products of Oracle off late. A new suite from Oracle named Oracle Manage...

Thursday, July 26, 2012

Autoconfig failed during bisdblrp.sql

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

Most Viewed Posts