Why is there an underscore in the generated DB Unique name and DB Name

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I'm curious as to why the automatic values generated for a VDB during provisioning have the underscore character in the DB Unique Name and DB Name but not in the SID field. I'm hoping there's a good reason, possibly related to the renaming of VDB process, or RAC, 12c Multitenant or some other configuration we don't use?
Photo of Thom T

Thom T

  • 838 Points 500 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Sean Nothdurft

Sean Nothdurft, Technical Support

  • 1,000 Points 1k badge 2x thumb
Official Response
Hi Thom-

In Oracle documentation, a database name (dbname) and database unique name (db_unique_name) can have underscore () as one of its characters. But underscore is not a valid character in SID (the one that registers with listeners) before Oracle 12c. The main reason we use _ is to distinguish Delphix generated db names from customer's own databases, because _ is not widely used by Oracle customers. There is no requirement that we have to use _. It is just a convention. We don't regard making db names and SID the same as a high priority: first, the maximum number of characters are different; Second, in RAC databases, each instance has different SID anyway.

Typically we don't see customers using the default random VDB names anyway, so this doesn't end up being a concern in normal operations.

Does this answer your question?