Changing the db_domain & ORA-02024: database link not found
508827Jul 26 2006 — edited Jul 27 2006Hi folks, I'm having trouble dropping public database links after changing the db_domain parameter. Here's what happened:
- When setting up the database initially, I chose not to have a db_domain. The database was simply named MYORADB.
- I recently found that this can cause problems when other oracle databases which have global_names=TRUE to link to our database
- So I used the DBCA templates feature to recreate the database with a db_domain parameter. Now the global name is MYORADB.COMPANY.COM
- Now I've found the DB links I had created on my database cannot be used (I get an ORA-02024 msg), and I cannot drop them (same msg).
- I did some googling and searching here and attempted many of the posted solutions, but none seem to be quite the same as they usually relate to someone having just changed part of the Global Name, and not the situation of never having a db_domain to begin with.
- The posted solutions were more or less running ALTER DATABASE RENAME GLOBAL_NAME TO "MYORADB" or UPDATE GLOBAL_NAMES SET GLOBAL_NAME="MYORADB" and dropping the link again. Neither of these had any effect.
Any ideas from anyone?