Delphix Products

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?

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?

Yes, thanks!