Q
Problem solve Get help with specific problems with your technologies, process and projects.

Setting GLOBAL_NAMES to false to use dblink

I am trying to connect to a remote database with dblink. I am getting following error: ORA-02085: database link DVOA002.WORLD connects to PROA002.WORLD. The solution that I found is: There is a parameter in init.ora called GLOBAL_NAMES. If you change it to false, you can do your database link and it will work. Are there any other solutions? What if the GLOBAL_NAMES need to be set to true?

If the GLOBAL_NAMES need to be set to true, then you must create a database link with the same name as the database to which it connects.

For More Information


Dig Deeper on Oracle and SQL

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close