MetaLink article on GLOBAL_NAMES

Oracle 10.2

Doing a little reading on the fine points of GLOBAL_NAMES.

We typically have the init parm DB_DOMAIN not set, and GLOBAL_NAMES = FALSE. I notice when we create a db_link, we get the given link name appended with REGRESS.RDBMS.DEV.US.ORACLE.COM, so I went looking for where that particular value comes from. Found MetaLink note 395896.1

Now it gets really interesting -- not where the assigned domain name came from, but the MetaLink note itself. The subject is "What Determines the Suffix used when Creating a DBlink". I don't want to risk violating my usage agreement by quoting too heavily, but it states that the "goal" of the article is "to explain why does the database link have a suffix like REGRESS.RDBMS.DEV.US.ORACLE.COM"

But then it doesn't. It just goes straight to the "Solution" section, explaining how to change the value after the fact. Solution? I didn't know there was a problem. I just wanted to find out the "why" of a bit of arcane information in the bowels of the database.

So, since the MetaLink article doesn't really "explain why does the database link have a suffix like REGRESS.RDBMS.DEV.US.ORACLE.COM", can someone else? I'm not looking for why db_links and global names might have a suffix. I'm curious about why Oracle would force one (and that value in particular) in the absence of a DBA supplied value.

OK, it's a slow day here, and I'm at a dead-end waiting for Unix Admin and Storage Admin what to do now that they've built me two database servers without any disk space for the database. Received on Fri Dec 08 2006 - 08:41:50 CST